MySQL question

[poe]

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!

[poe]

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

[i-Affiliate_com]

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

[poe]

wow, that was easy

thanks dude!

[poe]

another question:

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

[poe]

figured it out!