ok, maybe i very bad am explaining my problem, but i trying
for example i send to mysql DB some sql, and when this sql try to return to me some results i dont want to wate..
i want that i can observe each line from sql. result
thanks
As far as I know, the database builds the complete result set first, then it returns the set to you.
I don't know of a way to have it return some rows first, before it has built the complete set.
so you want to see exactly what lines are returned from the sql query?
do this:
while($row = mysql_fetch_row($sql)){ echo "value of field 1: " . $row[0] ; echo "value of field 2: " . $row[1] ; .... }
link: http://www.php.net/manual/en/function.mysql-fetch-row.php
Instanceouly, I can not supply you with exact code, but I can say: Built on tomhath reply You should follow another logic to extract data from the data base, i.e use another technique for looping inside the data base record else while, you can use for example "for" and inside this loop you can insert a conditional statement to check if the record is completely available or not? and inside this condition( if it's true) you can put the statement of print out like "echo". i.e the process will be like the making of alternating table rows background colors. You should note that to be able to feel this work, your data base must be so large enough and a complicated process must be carried out on it. I hope This may help.🙁
