a Variable seems to be empty after using it one time

[rbeemsterboer]

Hi,

I'm building a page where the same SQL query is used several times.
I'm now using "Country" as an example, but my problem is also present with other subjects/query's.

a SQL command fetches all the Countries from a table and loads them into an array called $Country

before the script reaches this part below.(with TR)
$Country is also being used for some other purpose on that page.
When $Country is being used for the 1st time. it works great.

Futhermore:
Imagine that i also want a <TR></TR>to be repeated on the same page till a certain db table is empty.
in each row 5 <TD></TD> excist.
in 3 of the 5 <TD>'s a new loop is started using $Country e.g. as==> while ($row = $country)
When $Country is being used for the 1st time it works great.

It doesn't matter if the first fetch is in/outside the loop.
For the 2nd, 3rd and so on the $Country array seems to be empty and no results appear on my page execpt the first time.

Does anymore know why this happens.
Can a array only be used once (when it is used in a while loop???)

I hope someone can give me some advice on this.

Best Regards,
Rick Beemsterboer
Netherlands
[e-mail]

[bastien]

Note that you should not change variables in midstream ( use $country as a vairable to hold an array of records and then use $country to as a variable to hold ONE of the ARRAYs values) as the new variable will overwrite the old.

If you're not Dutch, you're not much 😃

hth

[rbeemsterboer]

Thank you for your post,

But i am heaving difficulties understanding some parts of it 🙂
the word "midstream" really doesn't say anything to me.

So:

$Country = mysql_query("SELECT c.CountryId, CASE c.CountryShort WHEN c.CountryShort <> '' THEN c.CountryLong ELSE c.CountryShort END AS Country FROM Country AS c ORDER BY Country ASC", $ExtraConn) or die(mysql_error());

<TR>
<TD>
<SELECT>
<? while ($row = mysql_fetch_array($country)) { ?> <option value="<?php echo $row['CountryId']?>"><?php echo $row['Country']?></option><? } ?>
</SELECT>
</TD>
</TR>

is what i got...

what do i need to do now because i aint still understandig it :mad:
overwrite $country by doing ???
$country = mysql_query ("select * from ... ", $Conn);
$countrynew = $country

???

Perhaps you explain in more details (because i'm dutch and don't understand much :-) )

[tomhath]

Is $Country being set from mysql_query() or from mysql_fetch_row()?

The first returns a php Resource, the second returns an array.

[rbeemsterboer]

I'm sorry
wasn't paying attention a few seconds ago.

I have now altered my previous post so others can now understand it right away.

[vjcoppola]

Once you loop thru an array the current elemement is the last one. Use reset(array) just before you want to use it again. This function returns the first element and makes it current.

Originally posted by rbeemsterboer
Hi,

I'm building a page where the same SQL query is used several times.
I'm now using "Country" as an example, but my problem is also present with other subjects/query's.

a SQL command fetches all the Countries from a table and loads them into an array called $Country

before the script reaches this part below.(with TR)
$Country is also being used for some other purpose on that page.
When $Country is being used for the 1st time. it works great.

Futhermore:
Imagine that i also want a <TR></TR>to be repeated on the same page till a certain db table is empty.
in each row 5 <TD></TD> excist.
in 3 of the 5 <TD>'s a new loop is started using $Country e.g. as==> while ($row = $country)
When $Country is being used for the 1st time it works great.

It doesn't matter if the first fetch is in/outside the loop.
For the 2nd, 3rd and so on the $Country array seems to be empty and no results appear on my page execpt the first time.

Does anymore know why this happens.
Can a array only be used once (when it is used in a while loop???)

I hope someone can give me some advice on this.

Best Regards,
Rick Beemsterboer
Netherlands
[e-mail]

[bastien]

😃