MySQL question
 

i am displaying the contents of a database on my site..

now i would like to tell my script to only display data if the value of one of the rows is 1, and not 0.

is that doable?

thanks! :thumbsup

to only display that entry if the value in the "approve" row is 1

select [fieldlist] from [tablename] where fieldname = 1

wow, that was easy :)

thanks dude!

another question:

how do i display the total number of entries in a table? (e.g. 340)

figured it out!