Selection problem with table

[thefreebielife]

<?php	else 
	$sql="select * from users where site=Cash order by uId";
}
$result = mysql_query($sql)
or die(mysql_error()); 
$i = 0;
//grab all the content
while($r=mysql_fetch_array($result))
{	?>

 

That code displays nothing, I assume there is a problem with the "where" because i get this error

 

"Unknown column 'Cash' in 'where clause'"

 

Thanks,

Jared

[Jessica]

You need to put quotes around a string.

site='Cash'.

[thefreebielife]

Now it doesn't display the error, but it doesn't display the info as well.