looping in php

**Erwin Moller** · Apr 17 '06, 11:15 AM

Re: looping in php

Jim, Just a little advise on posting if I may:

You posted a big piece of VB code, which is ment to run in an application.
Things like:
MsgBox "AN AFTER UPDATE ERROR OCCURRED"
Resume

are nonsense in PHP. No such thing as a messagebox on the server (I hope).

And also: Maybe somebody is friendly enough to go through all the code, but
most, like me, are a bit too lazy for that and expect a to-the-point
question concerning PHP instead of a puzzle in a 'strange' language.

You are of course your own man, and can choose to post like this, but keep
in mind that you'll get quicker and more responses if you keep your
questions clear and to the point (PHP).
(No offense intended, just a friendly advise)

Regards,
Erwin Moller

**Jim Whitaker** · Apr 17 '06, 09:35 PM

Re: looping in php

If you look at the part above the code, I asked the to the point question.
The code was included, because some people insist on seeing code. You
forget, there may be someone else on this newsproup that also has programmed
in visual basic that can help me convert this to PHP. I don't care about
the stupid message box, I WANT TO KNOW HOW TO LOOP THROUGH RECORDS AND PLUCK
INFORMATION FROM THEM. Now, that is to the point.

"Erwin Moller"
<since_humans_r ead_this_I_am_s pammed_too_much @spamyourself.c om> wrote in
message news:44437594$0 $31653$e4fe514c @news.xs4all.nl ...[color=blue]
> Jim, Just a little advise on posting if I may:
>
> You posted a big piece of VB code, which is ment to run in an application.
> Things like:
> MsgBox "AN AFTER UPDATE ERROR OCCURRED"
> Resume
>
> are nonsense in PHP. No such thing as a messagebox on the server (I hope).
>
> And also: Maybe somebody is friendly enough to go through all the code,[/color]
but[color=blue]
> most, like me, are a bit too lazy for that and expect a to-the-point
> question concerning PHP instead of a puzzle in a 'strange' language.
>
> You are of course your own man, and can choose to post like this, but keep
> in mind that you'll get quicker and more responses if you keep your
> questions clear and to the point (PHP).
> (No offense intended, just a friendly advise)
>
> Regards,
> Erwin Moller
>[/color]

**Rik** · Apr 18 '06, 06:45 AM

Re: looping in php

Jim Whitaker wrote:[color=blue]
> I WANT TO KNOW HOW
> TO LOOP THROUGH RECORDS AND PLUCK INFORMATION FROM THEM. Now, that
> is to the point.[/color]

$result = mysql_query(som e_query);
while(mysql_fet ch_array($resul t,MYSQL_ASSOC){
//do stuff with it
}

**milahu** · Apr 18 '06, 01:05 PM

Re: looping in php

Rik, where is you `stuff'? ;)

$res = mysql_query('se lect * from foo') or die(mysql_error ());
while ($row = mysql_fetch_ass oc($res))
print($row['colname']);
mysql_free_resu lt($res);

**no-1** · Apr 18 '06, 02:05 PM

Re: looping in php

I would say that it is up to the OP to fill in the 'stuff'. If they
want to hire us to do their job for them, then a request should be made
to that effect. As a rule, **I** will answer questions but not write
the entire code segment. If I have something similar where I can
cut/paste, then that is one thing - writing it from scratch, testing it
etc.. - well that is up to the OP.

**Erwin Moller** · Apr 18 '06, 04:05 PM

Re: looping in php

no-1 wrote:
[color=blue]
> I would say that it is up to the OP to fill in the 'stuff'. If they
> want to hire us to do their job for them, then a request should be made
> to that effect. As a rule, **I** will answer questions but not write
> the entire code segment. If I have something similar where I can
> cut/paste, then that is one thing - writing it from scratch, testing it
> etc.. - well that is up to the OP.[/color]

Hey No-1,

:-)
Agree, and I also kinda lost my appetite to help the OP in the right
direction.

/me think I quit giving friendly advise, some people don't get it.
Maybe I should add more sugar on top.
;-)

Regards,
Erwin Moller

**Jim Whitaker** · Apr 18 '06, 09:25 PM

Re: looping in php

In the below, say I did whatever I wanted to do to with this record, ie.,
retrived a city to a temp variable. How do I move or goto the next record?
Example in english of what I am asking:
Say the result set is as follows:
ID FROMCITY
23 CLEVELAND
24 DETROIT

I want to goto record with ID of 23 first, and store CLEVELAND in a tempvar,
so temppvar = FROMCITY.
Now, I want to move to ID 24 and store DETROIT like this:
tempvar = tempvar + " / " + FROMCITY
At this point tempvar would be CLEVELAND / DETROIT.
This is what I'm after, loop through a recordset. I mean in the background
in code, not manually do this.
You can't tell me you can't loop through a recordset using php.
[color=blue]
> $result = mysql_query(som e_query);
> while(mysql_fet ch_array($resul t,MYSQL_ASSOC){
> //do stuff with it
> }
>
>[/color]

**william.clarke@gmail.com** · Apr 19 '06, 10:15 PM

Re: looping in php

As milahu and Rik said this is PHP looping through a result
set...(maybe not in the VB sense). There isn't a direct equivalent to
the VB6 recordset, but you don't need one.

//executes the query
$res = mysql_query('se lect * from foo') or die(mysql_error ());

//loops until the end of the result set.
while ($row = mysql_fetch_ass oc($res))

//Your tempvar thingy could go in here...
$tempvar = $tempvar . " / " . $row['colname']

//releases the result set reference.
mysql_free_resu lt($res);

**william.clarke@gmail.com** · Apr 19 '06, 10:15 PM

Re: looping in php

Obviously that should have been:

//executes the query
$res = mysql_query('se lect * from foo') or die(mysql_error ());

//loops until the end of the result set.
while ($row = mysql_fetch_ass oc($res))

//Your tempvar thingy could go in here...
$tempvar = $tempvar . " / " . $row['colname'];

//releases the result set reference.
mysql_free_resu lt($res);

**Rik** · Apr 20 '06, 09:05 AM

Re: looping in php

william.clarke@ gmail.com wrote:[color=blue][color=green][color=darkred]
>>> $result = mysql_query(som e_query);
>>> while(mysql_fet ch_array($resul t,MYSQL_ASSOC){
>>> //do stuff with it
>>> }[/color]
>> In the below, say I did whatever I wanted to do to with this record, ie.,
>> retrived a city to a temp variable. How do I move or goto the next[/color][/color]
record?

That's what you do with mysql_fetch_arr ay().
[color=blue]
> As milahu and Rik said this is PHP looping through a result
> set...(maybe not in the VB sense). There isn't a direct equivalent to
> the VB6 recordset, but you don't need one.[/color]

Don't know much about VB, but if you want to handle it as a complete
recordset: instead of processing the rows one by one:

$myrecordset = array();
while($row = mysql_fetch_arr ay($result,MYSQ L_ASSOC){

$myrecordset[] = $row;
}

Et voilà, a multidimensiona l array to abuse as you which.

Grtz,
--
Rik Wasmus

**Jim Whitaker** · Apr 22 '06, 04:15 AM

Re: looping in php

Thanks for all replies, I finally figured out looping in php.
"Rik" <luiheidsgoeroe @hotmail.com> wrote in message
news:e27hua$i4k $1@netlx020.civ .utwente.nl...[color=blue]
> william.clarke@ gmail.com wrote:[color=green][color=darkred]
> >>> $result = mysql_query(som e_query);
> >>> while(mysql_fet ch_array($resul t,MYSQL_ASSOC){
> >>> //do stuff with it
> >>> }
> >> In the below, say I did whatever I wanted to do to with this record,[/color][/color][/color]
ie.,[color=blue][color=green][color=darkred]
> >> retrived a city to a temp variable. How do I move or goto the next[/color][/color]
> record?
>
> That's what you do with mysql_fetch_arr ay().
>[color=green]
> > As milahu and Rik said this is PHP looping through a result
> > set...(maybe not in the VB sense). There isn't a direct equivalent to
> > the VB6 recordset, but you don't need one.[/color]
>
>
> Don't know much about VB, but if you want to handle it as a complete
> recordset: instead of processing the rows one by one:
>
> $myrecordset = array();
> while($row = mysql_fetch_arr ay($result,MYSQ L_ASSOC){
>
> $myrecordset[] = $row;
> }
>
> Et voilà, a multidimensiona l array to abuse as you which.
>
> Grtz,
> --
> Rik Wasmus
>
>
>[/color]

looping in php

looping in php

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment