master82 Posted June 20, 2007 Share Posted June 20, 2007 Here is the code I am attempting to use, I have checked all the tables names, fieldnames and have even looked to see if they contained data... <?php $ud=mysql_query("SELECT `users`.`usersNAME`, `worth`.`worthMONEY FROM `users` WHERE `users`.`usersID` = '{$userid}' INNER JOIN `worth` ON `users`.`usersID` = `worth`.`worthID`") or die(mysql_error()); $u=mysql_fetch_assoc($ud); ?> However, I get the following output: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' AS `users` WHERE `users`.`usersID` = '1' INNER JOIN `worth` ON `users`.`usersID' at line 1 Any ideas as to where im going wrong? Link to comment https://forums.phpfreaks.com/topic/56420-inner-join-error/ Share on other sites More sharing options...
pikemsu28 Posted June 20, 2007 Share Posted June 20, 2007 move your inner join before your where statement $ud=mysql_query("SELECT `users`.`usersNAME`, `worth`.`worthMONEY FROM `users` INNER JOIN `worth` ON `users`.`usersID` = `worth`.`worthID` WHERE `users`.`usersID` = '{$userid}'") or die(mysql_error()); Link to comment https://forums.phpfreaks.com/topic/56420-inner-join-error/#findComment-278741 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.