I have been messing with this simple problem too long.
$query = mysql_query("SELECT * FROM boats, dealers
INNER JOIN dealers ON boats.code = dealers.code
WHERE make LIKE '%$make%' AND size LIKE '%$size%'");
always fails when I add the join in. The two tables are boats and dealers, both have the field code which is the dealer code and the field I am trying to join on. I only want to pull the dealer name out of the database for each listing, it shouldn't be that hard~
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/boatdi2/public_html/listings/search2.php on line 55