Ok, i must admit to being quite annoyed (for want of a stonger word) that this simple thing just refuses to work...but at 2am i find not many things do :]
Cutting to the chase, im basically wanting to pull out info from a database that has the value "YES" in the "ver" field...
<?php
mysql_connect("localhost", "username", "password");
mysql_select_db (dbname);
$result = mysql_query ("
SELECT *
FROM tablename
WHERE ver=YES;
");
while($row = mysql_fetch_array($result)) {
echo"$row[etcetcetc]<br>";
}
?>
Simple as that, yet it kicks up a Unknown resourse error, im guessing it thinks YES is the name of the column....but
Any help totally appreciated, new at this lark as you may guess, but still ive managed session handling and to get stuck on this is really quite embarresing!
Redards
Ste
