returns 0 rows.
-Sheeri
On 11/24/05, fa so [EMAIL PROTECTED] wrote:
Dear All
I have a problem with mysql_num_rows
if I execute it on a result returned by mysql_query,,, and that
result is empty then I will get an error saying that this result is not a
valid mysql result
I am using
Dear All
I have a problem with mysql_num_rows
if I execute it on a result returned by mysql_query,,, and that
result is empty then I will get an error saying that this result is not a
valid mysql result
I am using count(*) and checking if my SQL statements will return
more than
Dear All
I have a problem with mysql_num_rows
if I execute it on a result returned by mysql_query,,, and that result is
empty then I will get an error saying that this result is not a valid mysql
result,,, but i think it should return ZERO!
I am using count(*) and checking if my
Has anyone ran into problems where mysql_num_rows() return 0 when the result
set clearly contains a certain number of rows? My C code looks something
like this:
mysql_query(conn, show databases);
result = mysql_store_result (conn);
numRows = mysql_num_rows (result);
On an HP 11.11 machine
I am attempting to use mysql_num_rows() after mysql_store_result(), but the
return value is always 0. The documentation says that it will not work if I
use it after mysql_use_result() without doing a fetch first, but I am doing
a mysql_store_result() instead, which should work right away
At 11:03 -0800 3/13/03, Hebron Mak wrote:
I am attempting to use mysql_num_rows() after mysql_store_result(), but the
return value is always 0. The documentation says that it will not work if I
use it after mysql_use_result() without doing a fetch first, but I am doing
a mysql_store_result
I am writing an Apache module that has to perform some queries against a
MySQL database. For the most part, it is working properly. However, when I
get an empty result set for my query (that is, the select returns no rows) I
get a segmentation fault when trying to call mysql_num_rows.
Here
running MySQL 3.23.33 with Apache 1.3.19 and PHP 4.0.4PL1 on
a DELL Latitude C600 Laptop developing a project. However every time i try
to use mysql_num_rows it tells me that this is not a valid mysql result
resource. I've tried all kinds of differnt tricks to try to fix the
problem but to no avail
Hello -
I am running MySQL 3.23.33 with Apache 1.3.19 and PHP 4.0.4PL1 on
a DELL Latitude C600 Laptop developing a project. However every time i try
to use mysql_num_rows it tells me that this is not a valid mysql result
resource. I've tried all kinds of differnt tricks to try to fix
the front end generates an INSERT query to put a new record
into the main table
of the database. In another bit of the code it does a check to see if a
particular record
exists (SELECT query on the primary key followed by a mysql_num_rows on the
result) before trying to update
the record.
Now
He wants to know the maximum, like on a search for mysql at google it says
Results 1 - 10 of about 2,580,000. He wants to know that 2,580,000 number
without doing another query. I don't think that's possible.
Of course it is. That's what I do all the time. That's what I was
talking about. I
He wants to know the maximum, like on a search for mysql at
google it says Results 1 - 10 of about 2,580,000. He wants
to know that 2,580,000 number without doing another query.
I don't think that's possible.
Of course it is. That's what I do all the time. That's what I was
talking
I said without doing another query :-) Sure you can do count(*)
beforehand...
Oh, sure, sorry! Too late, I guess.
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 ยท Fax
Hello,
I want to know if there is some way to return the number of rows in a query,
the complete query,
while using a LIMIT $start, $end command.
Unfortunately, so far, using
$result = mysql_query($SELECT);
$qct = mysql_num_rows($result);
Results in $qct being equal to $end, which I
Hello,
I want to know if there is some way to return the number of rows in a query,
the complete query,
while using a LIMIT $start, $end command.
Unfortunately, so far, using
$result = mysql_query($SELECT);
$qct = mysql_num_rows($result);
Results in $qct being equal to $end, which I
15 matches
Mail list logo