durins_day Posted March 18, 2008 Share Posted March 18, 2008 Ok lads, heres the deal: I'm pretty new to PHP and SQl (both of which I've found myself addicted to) but I'm having a hard time with what is (for most) simple stuff. I'm trying to print the value of table 'logins' to the screen, but I'm not having any luck Ive been at this for well over 6 hours and cant seem to make it work! I'm using MySQL 5.0.45 and PHP 5.2.5. $sql = 'SELECT `logins` FROM `sf_users` WHERE `logins`'; $result = mysql_query($sql); print_r($result); Ideas? Thanks in advance, Ben Quote Link to comment https://forums.phpfreaks.com/topic/96798-cant-return-table-values-help/ Share on other sites More sharing options...
treehugger88 Posted March 18, 2008 Share Posted March 18, 2008 You want all the results from sf_users? Drop the WHERE statement. 'SELECT `logins` FROM `sf_users` Quote Link to comment https://forums.phpfreaks.com/topic/96798-cant-return-table-values-help/#findComment-495352 Share on other sites More sharing options...
defeated Posted March 19, 2008 Share Posted March 19, 2008 How about this?? <?php $result=mysql_query("SELECT * FROM sf_users ORDER BY logins") or die(mysql_error()); while($row=mysql_fetch_array($results)){ echo $row[logins] ; } ?> Quote Link to comment https://forums.phpfreaks.com/topic/96798-cant-return-table-values-help/#findComment-495793 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.