Quick existance check

[lucasmeloch]

I get the user to enter a number to identify a record by in my database. I would like to no any quick SQL queries to check if that key field value exists.

Thanks

Lucas

[Weedpacket]

Check your local database documentation on the use of the COUNT() function in SELECT statements. SELECT COUNT(*) WHERE blahblah will give you a result containing the number of rows that satisfy whatever condition blahblah is.