HighDots Forums  

Another Database Array Question

Macromedia Dreamweaver Macromedia Dreamweaver Discussions (macromedia.dreamweaver)


Discuss Another Database Array Question in the Macromedia Dreamweaver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
DavidB
 
Posts: n/a

Default 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);
?>

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.