Another Database Array Question -
10-26-2005
, 06:45 AM
I just discovered that the script I pasted below produces a proper
array, which looks like this:
Array ( [0] => apple [1] => bear [2] => candy )
The only problem is that it displays the array four times, once for
every value returned from my database.
<?php
$result = mysql_query("Select count(*) from gwecoareasexp as GWEAX");
if (($result) && (mysql_result ($result , 0) > 0)) {
} else {
die('Invalid query: ' . mysql_error());
}
{
$Isle = mysql_query("SELECT * FROM gwecoareasexp as GWEAX
LEFT JOIN geog101exp AS GEOG ON GEOG.ID101 = GWEAX.Geog2
WHERE IDX = 'IM0122' OR IDX = 'IM0123' OR IDX = 'IM0120' OR IDX = 'NA0412'
OR IDX = 'NT0120' OR IDX = 'NT0213' OR IDX = 'IM0171' OR IDX = 'IM0172'
OR IDX = 'IM0150'
GROUP BY GWEAX.Geog2");
if ( mysql_errno() > 0 ) {
echo mysql_error();
exit;
}
else {
{
while ( $row = mysql_fetch_array( $Isle ) ) {
echo <<<EOD
{$row["Name101"]},
EOD;
$var = "apple, bear, candy";
$var = explode(", ", $var);
print_r($var);
?>
But if I modify my script to form an array from database variables, as
below, I get an array that looks like this:
Cuba,Array ( [0] => Cuba ) mainland,Array ( [0] => mainland )
Philippines,Array ( [0] => Philippines ) Taiwan,Array ( [0] => Taiwan )
It looks like I'm moving in the right direction, but I'm making some
simple mistake. How can I fix it?
Thanks.
<?php
$result = mysql_query("Select count(*) from gwecoareasexp as GWEAX");
if (($result) && (mysql_result ($result , 0) > 0)) {
} else {
die('Invalid query: ' . mysql_error());
}
{
$Isle = mysql_query("SELECT * FROM gwecoareasexp as GWEAX
LEFT JOIN geog101exp AS GEOG ON GEOG.ID101 = GWEAX.Geog2
WHERE IDX = 'IM0122' OR IDX = 'IM0123' OR IDX = 'IM0120' OR IDX = 'NA0412'
OR IDX = 'NT0120' OR IDX = 'NT0213' OR IDX = 'IM0171' OR IDX = 'IM0172'
OR IDX = 'IM0150'
GROUP BY GWEAX.Geog2");
if ( mysql_errno() > 0 ) {
echo mysql_error();
exit;
}
else {
{
while ( $row = mysql_fetch_array( $Isle ) ) {
echo <<<EOD
{$row["Name101"]},
EOD;
$var = $row["Name101"];
$var = explode(", ", $var);
print_r($var);
?> |