In message <[EMAIL PROTECTED]>
, Christopher E <[EMAIL PROTECTED]> writes
>>You put *text* into $query_is!
>what do you mean I put text into $query_is?
Yes, in your example, $query_is is a string, which begins with the word
"INSERT...
>
>
>> $result_is = mysql_query($query_is);
>>
>> if (mysql_num_rows($result_is))
>> {
>> echo "The record matched the criteria,
>I had to change it to mysql_query() instead as its a insert / select
>statement and with insert you can not use mysql_num_rows from my
>understanding
mysql_query()
can be used for insert, select, and update.
mysql_num_rows() returns the number of rows which were returned. I think
that I assumed that you were SELECTing, and looking back, it looks like
you were INSERTing.
I think I should have suggested
mysql_affected_rows($result_is)
which shows the number of rows affected by an UPDATE or INSERT.
--
Pete Clark
Sunny Andalucia
http://hotcosta.com/Andalucia.Spain
