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
>
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 a
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 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. This
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 is
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
prob
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 fi
point 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
> 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
> > 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
>
> 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.
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.
> I'm not sure if I understand your problem. You should get exactly
> $end results if
ly, so far, using
> $result = mysql_query("$SELECT");
> $qct = mysql_num_rows($result);
> Results in $qct being equal to $end, which I already knew.
> Is it possible to get this figure without doing a separate q
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 $en
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 $en
17 matches
Mail list logo
