trouble creating array

Tachyon · June 27th, 2004, 06:37 PM

I'm getting a result set from a MySQL query but I'm having trouble dropping that into an array.

Code:

    $countryquery = "SELECT * FROM count_list";
    $countryresult = mysql_query($countryquery) or die(mysql_error());

while ($querydata = mysql_fetch_array($countryresult)){
    extract($querydata);
    $c[] = array ($count_name);
}
foreach ($c as $cp){
    echo ("$cp<br>");
}

This gets me "Array" printed many times.

When I try this:

Code:

while ($querydata = mysql_fetch_array($countryresult)){
    extract($querydata);
    $c = array ($count_name);
}
foreach ($c as $cp){
    echo ("$cp<br>");
}

I get the last item in the array displayed but nothing else. I'm assuming PHP is copying over the same variable again and again until it hits the last value and displays that on the screen.

Can anyone offer suggestions on how to change this code to create the array I need?

sami · June 27th, 2004, 07:53 PM

Try this:

$countryquery = mysql_query("SELECT * FROM count_list");
while ($allcountries = mysql_fetch_array($countryquery))
{
echo $allcountries['country'];
}

assuming you have a field named ['country'] you would like to echo out. If not just change ['country'] to the field you would like to echo out, like ['nameoffieldoutofdb'].

Hope this helps
Sami

Tachyon · June 27th, 2004, 11:34 PM

Thanks for the tip. Now I've found a way to print the information I want from the result set on my screen but what I'd really like to do is get the info from the result set and read it into an array. Then I can use the array several time in the program.

My result set gets count_num and count_name. I just want to put all the count_name values into an array. From there I'm good to go.

Tachyon · June 28th, 2004, 11:25 AM

Woo hoo! I found the answer.

Quote:

quote:<?php
while ($querydata = mysql_fetch_array($countryresult)){
    extract($querydata);
    $temp1[] = $count_name;
    $temp2 = array("Canada", "USA");
    $c = array_diff($temp1, $temp2);
}
foreach ($c as $cp){
    echo ("$cp<br>");
}
?>

This grabs the list of countries out of my database, knocks out U.S. and Canada and makes an array I can use for listing "other countries" when people are filling out their addresses.