In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Dennis Gearon)
wrote:
> I would like to return ONE ROW if possible from a query that would tell
> me
> whether a value exists in a table.
If the query could result in more than one record, but you only want to see
one, 'limit 1' is helpful.
> SELECT FieldValueIn, COUNT(*) FROM TableOfInterest WHERE
> FieldValueIn=ValueOfInterest GROUP BY FieldValueIn;
>
> I can't seem to figure out how to test the return results to see if
> there is no rows with that value.
http://www.php.net/mysql-num-rows
--
CC
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
