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 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` 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] ; } ?> 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
Archived
This topic is now archived and is closed to further replies.