phpisawesome Posted December 20, 2009 Share Posted December 20, 2009 do you guys know what's wrong with this syntax? $query_2 = "SELECT * FROM db WHERE id = " . $_SESSION[id]; Link to comment https://forums.phpfreaks.com/topic/185750-quick-syntax-help/ Share on other sites More sharing options...
nafetski Posted December 20, 2009 Share Posted December 20, 2009 $query_2 = "SELECT * FROM db WHERE id = " . $_SESSION['id']; Forgot the single quotes around id Link to comment https://forums.phpfreaks.com/topic/185750-quick-syntax-help/#findComment-980806 Share on other sites More sharing options...
phpisawesome Posted December 20, 2009 Author Share Posted December 20, 2009 You positive? Did that and still syntax error. Link to comment https://forums.phpfreaks.com/topic/185750-quick-syntax-help/#findComment-980809 Share on other sites More sharing options...
PFMaBiSmAd Posted December 20, 2009 Share Posted December 20, 2009 Until you post the actual error, no one can help you with what is causing it. Link to comment https://forums.phpfreaks.com/topic/185750-quick-syntax-help/#findComment-980810 Share on other sites More sharing options...
phpisawesome Posted December 20, 2009 Author Share Posted December 20, 2009 The site just say's mysql error...i commented everything else out to break down the problem and it's that query... Link to comment https://forums.phpfreaks.com/topic/185750-quick-syntax-help/#findComment-980812 Share on other sites More sharing options...
trq Posted December 20, 2009 Share Posted December 20, 2009 The site just say's mysql error... mysql errors don't just simply state 'mysql error', you need to echo mysql_error to get more details about your error. Link to comment https://forums.phpfreaks.com/topic/185750-quick-syntax-help/#findComment-980814 Share on other sites More sharing options...
phpisawesome Posted December 20, 2009 Author Share Posted December 20, 2009 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 '' at line 2 this is what i have currently... $query_2 = "SELECT * FROM db WHERE id = " . $_SESSION['id']; $results = mysql_query($query_2) or die (mysql_error()); Link to comment https://forums.phpfreaks.com/topic/185750-quick-syntax-help/#findComment-980818 Share on other sites More sharing options...
trq Posted December 20, 2009 Share Posted December 20, 2009 What does $_SESSION['id'] contain? Link to comment https://forums.phpfreaks.com/topic/185750-quick-syntax-help/#findComment-980820 Share on other sites More sharing options...
phpisawesome Posted December 20, 2009 Author Share Posted December 20, 2009 a number, basically corresponding to the person's id Link to comment https://forums.phpfreaks.com/topic/185750-quick-syntax-help/#findComment-980821 Share on other sites More sharing options...
trq Posted December 20, 2009 Share Posted December 20, 2009 echo $_SESSION['id'], it would appear it may contain some unwanted quotes. Link to comment https://forums.phpfreaks.com/topic/185750-quick-syntax-help/#findComment-980822 Share on other sites More sharing options...
phpisawesome Posted December 20, 2009 Author Share Posted December 20, 2009 I did, it's just a number...are you sure that query is the right format? Link to comment https://forums.phpfreaks.com/topic/185750-quick-syntax-help/#findComment-980824 Share on other sites More sharing options...
trq Posted December 20, 2009 Share Posted December 20, 2009 Yep, nothing wrong with the query. Can you echo $query_2 and show us the results? Link to comment https://forums.phpfreaks.com/topic/185750-quick-syntax-help/#findComment-980826 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.