Can't return table values... Help!

[durins_day]

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

[treehugger88]

You want all the results from sf_users? Drop the WHERE statement.

 

'SELECT `logins` FROM `sf_users`

[defeated]

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] ;
}
?>