I dont know what im doing wrong could you help me and explane it i have never done an INNER JOIN before
Here is what i have
<?php
/* Table names
nav_bar
pages
DB names
don_nav
don_pages
*/
$con = mysql_connect("localhost","********","******");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("don_nav,don_pages", $con);
$result = mysql_query"SELECT id FROM nav_bar INNER JOIN pages ON page.name=nav_bar.name";
while($row = mysql_fetch_array($result))
{
echo $row['name'];
echo "<br />";
}
?>
the coulomb name is "name"
Here is what i have
<?php
/* Table names
nav_bar
pages
DB names
don_nav
don_pages
*/
$con = mysql_connect("localhost","********","******");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("don_nav,don_pages", $con);
$result = mysql_query"SELECT id FROM nav_bar INNER JOIN pages ON page.name=nav_bar.name";
while($row = mysql_fetch_array($result))
{
echo $row['name'];
echo "<br />";
}
?>
the coulomb name is "name"