Re: Can't fetch result twice in a PHP script

2007-09-15 Thread Néstor
mysql_num_rows() http://www.php.net/manual/en/ref.mysql.php :-) On 9/15/07, Chris W <[EMAIL PROTECTED]> wrote: > Mahmoud Badreddine wrote: > > it is more of a PHP question , I admit. > > I tried mysql_fetch_array, mysql_data_seek, mysql_result . Same result. > > And I am sure there's more than z

Re: Can't fetch result twice in a PHP script

2007-09-15 Thread Chris W
Mahmoud Badreddine wrote: it is more of a PHP question , I admit. I tried mysql_fetch_array, mysql_data_seek, mysql_result . Same result. And I am sure there's more than zero rows to be fetched, because it works in the first call, but not the second. That just means there is one row in the r

Re: Can't fetch result twice in a PHP script

2007-09-15 Thread Kevin Waterson
This one time, at band camp, "Mahmoud Badreddine" <[EMAIL PROTECTED]> wrote: > I have something like > while($someArr=mysql_fetch_row($result)) > { > ...some code. > } > > The first time I call mysql_fetch_row , the code inside the while loop gets > executed, but not the second time. What is the

Re: Can't fetch result twice in a PHP script

2007-09-15 Thread Mahmoud Badreddine
it is more of a PHP question , I admit. I tried mysql_fetch_array, mysql_data_seek, mysql_result . Same result. And I am sure there's more than zero rows to be fetched, because it works in the first call, but not the second. On 9/15/07, Chris Sansom <[EMAIL PROTECTED]> wrote: > > At 16:35 -0500 15

Re: Can't fetch result twice in a PHP script

2007-09-15 Thread Chris Sansom
At 16:35 -0500 15/9/07, Mahmoud Badreddine wrote: In one of my php scripts I make 2 successive calls of mysql_fetch_row using the same Mysql Result. In the first call the desired result is achieved, but in the second one it isn't. I have something like while($someArr=mysql_fetch_row($result)) {