On Thursday 23 January 2003 06:04, Shahar Tal wrote:
> Hello all!
>
> I got one page, with this code:
>
> <?php
> echo insert_results();
> ?>
>
> Which grabs the data I send from another page, on that function.
> Here is the important part of the function while code:
>
> while ($row = mysql_fetch_array($result)){
> function insert_results () {
> extract($row);
> echo "bla";
> }
> }
>
> Ok, this is the problem.
> As you can see, it takes the data from the dattabase, sticks it into the
> function, and then the second page displays it.
> don't get me wrong, this is working PERFECTLY and just the way I want it,
> and then comes my problem.
> It works only with one row. it displays only one row, even when I know
> there are more. no matter how many rows are in the database,
> it will always output one "bla".
>
> I need to move on and display all the rows, just like 'while' should work,
> I don't know why it's not working.
> Maybe I should stick it into a function array? but that's a bit strange as
> the 'while' command should do it automaticlly.
Why have you defined your function insert_results() inside your while-loop?
You be doing something like this instead:
function insert_results($row) {
do_insert_row;
}
while ($row = mysql_fetch_array($result)) {
insert_results($row);
}
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Joe's sister puts spaghetti in her shoes!
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
