PHP mysql INNER JOIN help?

Kelly H

New member
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"
 
Back
Top