HI all, Im trying to preform a test using a php script to test if a result set is empty or not. Ive sent the query but i need a test so that i can write either the results if any or a message stating that the query returned no results or in this case the database is empty. Thanks

in this case the database is empty. query result or database? if it's a query result and since you're asking to "test" a result, I assume you know how to query. To test, just do a: $returned_rows = mysql_num_rows ($theQuery); where $theQuery is your resource link identifier, like: $theQuery = mysql_query("SELECT blah FROM blah"); then do a: if ($returned_rows == 0){ echo 'do whatever when no rows returned here'; }else{ echo 'do whatever when ' . $returned_rows . 'rows returned here'; } mysql_num_rows()

Thats great thanks! does just what i need. As u might have guessed im a beghiner.