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/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))
> >{
> >...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 reason behind that.
>
> Sounds more like a PHP question really, but have you thought about
> trying mysql_fetch_array() instead? I can't see why it should be any
> different, but it might be worth a shot - always works for me anyway.
> :-)
>
> But also: are you confident there's more than one row to be fetched?
>
> --
> Cheers... Chris
> Highway 57 Web Development -- http://highway57.co.uk/
>
> He who slings mud, usually loses ground.
> -- Adlai Stevenson
>
--
-Mahmoud Badreddine
http://www.spreadfirefox.com/
