$sql=mysql_query("SELECT * FROM photos WHERE default='0'");

I keep getting a MySQL error!!! I dont know why, because in my table 'photos', I have a field called 'default', and each row for it has a value of either 0 or 1.

"default" is a reserved word (see http://dev.mysql.com/doc/refman/5.1/...ved-words.html )

When posting error messages, you really ought to include the message itself.

Try this instead:

$sql=mysql_query("SELECT * FROM `photos` WHERE `default`=0");

or, if you have the default field as char instead of tinyint, then

$sql=mysql_query("SELECT * FROM `photos` WHERE `default`='0'");

ahhh thanks!

Always the simple thing