[RESOLVED] Outputting all database data in seperate rows

Dada78

I need to output certain information in the database on this page.

http://mesquitechristmas.com/local/browse.php

To look like it does on this page.

http://mesquitechristmas.com/local/example.php

Here is the code I am using for the entire page. Now I can output data onto this page but the data is the same data for every table row, I.E. the first row of the table. I need each table row to be different like it is in the above example. I am thinking their is something I need to add to the echo or something maybe with the ID of each row? I just can not find anything on it. If anyone can help me with this that would be great?

<?php

include ('db_connect.php');

if (isset($_GET['id'])) {
  $id = mysql_real_escape_string($_GET['id']);
  $sql = "SELECT * FROM users WHERE id = $id;";
  if ($result = mysql_query($sql)) {
    if (mysql_num_rows($result)) {
      $row = mysql_fetch_array($result);
      $address = $row["address"];
      $city = $row["city"];
      $state = $row["state"]; 
      $postal = $row["postal"];
      $country = $row["country"];
    } else {
      die("No user found");
    }
  } else {
    die(mysql_error());
  }
}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="description" content="Mesquite Texas Country Christmas" />
<meta name="keywords" content="Mesquite, Texas, Country Christmas" />
<meta name="author" content="NA" />
<link rel="stylesheet" type="text/css" href="/stylesheet.css" media="screen" title="FBC" />
<script type="text/javascript" src="drop_down.js"></script>
<title>A Mesquite Country Christmas</title>
</head>
<body>

 <div id="wrap">

<a href="/index.html">
<img id="frontphoto" src="/images/header.png" width="760" height="237" alt="Mesquite Country Christmas" border="0"></a>

<div id="menu">

<h2 class="hide">Menu:</h2>

<ul id="avmenu">
<li><a href="/index.html">Home</a></li>
<li><a href="/christmasstory.html">The Christmas Story</a></li>
<li><a href="/directions.html">Directions</a></li>
<li><a href="#">Information</a><ul>
      <li><a href="/information.html">Display Facts & Info</a></li>
      <li><a href="/faq.html">FAQ</a></li>
      <li><a href="/playlist.html">2008 Playlist</a></li>
      <li><a href="#">Christmas History</a></li>
  </ul></li>
<li><a href="#">Photos</a>
  <ul>
      <li><a href="/2007photos.html">2007</a></li>
  </ul></li>
<li><a href="#">Videos</a>
  <ul>
      <li><a href="/2007videos.html">2007</a></li>
  </ul></li>
<li><a href="/guestbook.php">Guestbook</a></li>
<li><a href="/webcam.html">Web Cam</a></li>
<li><a href="/webradio.html">Internet Radio</a></li>
<li><a href="http://www.noradsanta.org/" TARGET="_blank">Track Santa</a></li>
<li><a href="/projects.html">Projects & How Tos</a></li>
<li><a href="/links.html">Links</a></li>
<li><a href="/contact_us.html">Contact Us</a></li>
</ul>

<center><img src="images/toys_for_tots.jpg" border="0" width="110" height="153" vspace="10"><a href="http://www.toysfortots.org/" TARGET="_blank"></a></center>

<center><a href="http://christmas.bronners.com/2007/house/534.html"><img src="http://christmas.bronners.com/voteforme/vote.jpg" border="0" width="110" height="153" alt="christmas decorations" vspace="10"></a></center>

</div>

<div id="content">

 <div class="fadebox">

<h2>Mesquite Christmas Display Finder</h2>

<hr />

<p> Do you drive around aimlessly looking for Christmas lights every year? We are here to help make that tradition better by allowing you to search for local displays in Mesquite and get directions to them. And if you have a display of your own, you can add it to our database for others to find and enjoy!</p>


<p><span class="title">Current Displays In Mesquite</span><br /><table style="border-top: 1px solid rgb(51, 102, 51);" border="0" cellpadding="4" cellspacing="0" width="100%"><tbody><tr><td class="bg2" width="110">IMAGE</td><td class="bg2"><? echo $row['address']; ?><br><? echo $row['city']. "," . $row['state']. " " . $row['postal']; ?><br><? echo $row['country']; ?></td><td class="bg2" style="vertical-align: middle;">&gt; <a href="displays.php?id=<?php echo $row['id']; ?>"><b>Learn more about Display</b></a><br><br>> <a href="http://www.mapquest.com/maps/map.adp?searchtype=address&amp;formtype=search&amp;countryid=US&amp;addtohistory=&amp;country=US&amp;address=<? echo $row['address']; ?>&amp;city=<? echo $row['city']; ?>&amp;zipcode=<? echo $row['postal']; ?>&amp;historyid=&amp;submit=Get+Map" target="_NEW"><b>Get Directions</b></a><br /><br /></td></tr>
<tr><td class="bg1" width="110">IMAGE</td><td class="bg1"><? echo $row['address']; ?><br><? echo $row['city']. "," . $row['state']. " " . $row['postal']; ?><br><? echo $row['country']; ?></td><td class="bg1" style="vertical-align: middle;">&gt; <a href="displays.php?id=<?php echo $row['id']; ?>"><b>Learn more about Display</b></a><br><br>> <a href="http://www.mapquest.com/maps/map.adp?searchtype=address&amp;formtype=search&amp;countryid=US&amp;addtohistory=&amp;country=US&amp;address=<? echo $row['address']; ?>&amp;city=<? echo $row['city']; ?>&amp;zipcode=<? echo $row['postal']; ?>&amp;historyid=&amp;submit=Get+Map" target="_NEW"><b>Get Directions</b></a><br /><br /></td></tr></tbody></table></p>

</div>



   </div>
 </div>

<div id="footer">
&copy; 2007 Mesquite Country Christmas

<br />
<br />

<script type="text/javascript"><!--
google_ad_client = "pub-8048181801684156";
//468x60, created 1/8/08
google_ad_slot = "0360766123";
google_ad_width = 468;
google_ad_height = 60;
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>


</div>

</div>
</body>
</html>

-Thanks

reddrum

If you want to see all the rows in the table then you could do somthing like this:

$address = array();
$city = array();
$state = array();
$postal = array();
$country = array();
$id = mysql_real_escape_string($_GET['id']);
if (isset($id)) {
  $sql = "SELECT * FROM users";
  if($result = mysql_query($sql)) {
     while ($row = mysql_fetch_array ($result)) {
       $address[$i] = $row["address"];
       $city[$i] = $row["city"];
       $state[$i] = $row["state"];
       $postal[$i] = $row["postal"];
       $country[$i] = $row["country"];
       ++$i
     }
   }
}

Dada78

Thanks for your response I tried that and I get this error

Parse error: syntax error, unexpected '}' in /home/mesquit1/public_html/local/browse.php on line 21

so I remove it and I keep getting an error for each } so I remove the last three } then I get this error.

Parse error: syntax error, unexpected $end in /home/mesquit1/public_html/local/browse.php on line 122

So then I added this to the end of the code thinking it is not closed properly like this

<?php
}
?>

and the error is this:

Parse error: syntax error, unexpected $end in /home/mesquit1/public_html/local/browse.php on line 125

Here is the code for the entire file.

Is their something I left out or missing some where?

Thanks

<?php

include ('db_connect.php');

 $address = array();
$city = array();
$state = array();
$postal = array();
$country = array();
$id = mysql_real_escape_string($_GET['id']);
if (isset($id)) {
  $sql = "SELECT * FROM users";
  if($result = mysql_query($sql)) {
     while ($row = mysql_fetch_array ($result)) {
       $address[$i] = $row["address"];
       $city[$i] = $row["city"];
       $state[$i] = $row["state"];
       $postal[$i] = $row["postal"];
       $country[$i] = $row["country"];
       ++$i

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="description" content="Mesquite Texas Country Christmas" />
<meta name="keywords" content="Mesquite, Texas, Country Christmas" />
<meta name="author" content="NA" />
<link rel="stylesheet" type="text/css" href="/stylesheet.css" media="screen" title="FBC" />
<script type="text/javascript" src="drop_down.js"></script>
<title>A Mesquite Country Christmas</title>
</head>
<body>

 <div id="wrap">

<a href="/index.html">
<img id="frontphoto" src="/images/header.png" width="760" height="237" alt="Mesquite Country Christmas" border="0"></a>

<div id="menu">

<h2 class="hide">Menu:</h2>

<ul id="avmenu">
<li><a href="/index.html">Home</a></li>
<li><a href="/christmasstory.html">The Christmas Story</a></li>
<li><a href="/directions.html">Directions</a></li>
<li><a href="#">Information</a><ul>
      <li><a href="/information.html">Display Facts & Info</a></li>
      <li><a href="/faq.html">FAQ</a></li>
      <li><a href="/playlist.html">2008 Playlist</a></li>
      <li><a href="#">Christmas History</a></li>
  </ul></li>
<li><a href="#">Photos</a>
  <ul>
      <li><a href="/2007photos.html">2007</a></li>
  </ul></li>
<li><a href="#">Videos</a>
  <ul>
      <li><a href="/2007videos.html">2007</a></li>
  </ul></li>
<li><a href="/guestbook.php">Guestbook</a></li>
<li><a href="/webcam.html">Web Cam</a></li>
<li><a href="/webradio.html">Internet Radio</a></li>
<li><a href="http://www.noradsanta.org/" TARGET="_blank">Track Santa</a></li>
<li><a href="/projects.html">Projects & How Tos</a></li>
<li><a href="/links.html">Links</a></li>
<li><a href="/contact_us.html">Contact Us</a></li>
</ul>

<center><a href="http://www.toysfortots.org/" TARGET="_blank"><img src="/images/toys_for_tots.jpg" border="0" width="110" height="153" vspace="10"></a></center>

<center><a href="http://christmas.bronners.com/2007/house/534.html"><img src="http://christmas.bronners.com/voteforme/vote.jpg" border="0" width="110" height="153" alt="christmas decorations" vspace="10"></a></center>

</div>

<div id="content">

 <div class="fadebox">

<h2>Mesquite Christmas Display Finder</h2>

<hr />

<p> Do you drive around aimlessly looking for Christmas lights every year? We are here to help make that tradition better by allowing you to search for local displays in Mesquite and get directions to them. And if you have a display of your own, you can add it to our database for others to find and enjoy!</p>


<p><span class="title">Current Displays In Mesquite</span><br /><table style="border-top: 1px solid rgb(51, 102, 51);" border="0" cellpadding="4" cellspacing="0" width="100%"><tbody><tr><td class="bg2" width="110">IMAGE</td><td class="bg2"><? echo $row['address']; ?><br><? echo $row['city']. "," . $row['state']. " " . $row['postal']; ?><br><? echo $row['country']; ?></td><td class="bg2" style="vertical-align: middle;">&gt; <a href="displays.php?id=<?php echo $row['id']; ?>"><b>Learn more about Display</b></a><br><br>> <a href="http://www.mapquest.com/maps/map.adp?searchtype=address&amp;formtype=search&amp;countryid=US&amp;addtohistory=&amp;country=US&amp;address=<? echo $row['address']; ?>&amp;city=<? echo $row['city']; ?>&amp;zipcode=<? echo $row['postal']; ?>&amp;historyid=&amp;submit=Get+Map" target="_NEW"><b>Get Directions</b></a><br /><br /></td></tr>
<tr><td class="bg1" width="110">IMAGE</td><td class="bg1"><? echo $row['address']; ?><br><? echo $row['city']. "," . $row['state']. " " . $row['postal']; ?><br><? echo $row['country']; ?></td><td class="bg1" style="vertical-align: middle;">&gt; <a href="displays.php?id=<?php echo $row['id']; ?>"><b>Learn more about Display</b></a><br><br>> <a href="http://www.mapquest.com/maps/map.adp?searchtype=address&amp;formtype=search&amp;countryid=US&amp;addtohistory=&amp;country=US&amp;address=<? echo $row['address']; ?>&amp;city=<? echo $row['city']; ?>&amp;zipcode=<? echo $row['postal']; ?>&amp;historyid=&amp;submit=Get+Map" target="_NEW"><b>Get Directions</b></a><br /><br /></td></tr></tbody></table></p>

</div>



   </div>
 </div>

<div id="footer">
&copy; 2007 Mesquite Country Christmas

<br />
<br />

<script type="text/javascript"><!--
google_ad_client = "pub-8048181801684156";
//468x60, created 1/8/08
google_ad_slot = "0360766123";
google_ad_width = 468;
google_ad_height = 60;
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>


</div>

</div>
</body>
</html>
<?php
}
?>

reddrum

include ('db_connect.php');

$address = array();
$city = array();
$state = array();
$postal = array();
$country = array();
$id = mysql_real_escape_string($_GET['id']);
$i=0;
if (isset($id)) {
  $sql = "SELECT * FROM users";
  if($result = mysql_query($sql)) {
     while ($row = mysql_fetch_array ($result)) {
       $address[$i] = $row["address"];
       $city[$i] = $row["city"];
       $state[$i] = $row["state"];
       $postal[$i] = $row["postal"];
       $country[$i] = $row["country"];
       ++$i
     }
   }
}

That should work

reddrum

I added $i=0 to set the array.

Dada78

I am still getting this error.

Parse error: syntax error, unexpected '}' in /home/mesquit1/public_html/local/browse.php on line 22

Which makes it the first closing bracket.

<?php

include ('db_connect.php');

$address = array();
$city = array();
$state = array();
$postal = array();
$country = array();
$id = mysql_real_escape_string($_GET['id']);
$i=0;
if (isset($id)) {
  $sql = "SELECT * FROM users";
  if($result = mysql_query($sql)) {
     while ($row = mysql_fetch_array ($result)) {
       $address[$i] = $row["address"];
       $city[$i] = $row["city"];
       $state[$i] = $row["state"];
       $postal[$i] = $row["postal"];
       $country[$i] = $row["country"];
       ++$i
     }
   }
} 

?>

reddrum

Dada78 wrote:

I am still getting this error.

Parse error: syntax error, unexpected '}' in /home/mesquit1/public_html/local/browse.php on line 22

Which makes it the first closing bracket.

<?php

include ('db_connect.php');

$address = array();
$city = array();
$state = array();
$postal = array();
$country = array();
$id = mysql_real_escape_string($_GET['id']);
$i=0;
if (isset($id)) {
  $sql = "SELECT * FROM users";
  if($result = mysql_query($sql)) {
     while ($row = mysql_fetch_array ($result)) {
       $address[$i] = $row["address"];
       $city[$i] = $row["city"];
       $state[$i] = $row["state"];
       $postal[$i] = $row["postal"];
       $country[$i] = $row["country"];
       ++$i;
     }
   }
} 

?>

Just needed a ; after the ++$i, hope that gets it.

Dada78

Thanks, that fixed the error but nothing is being displayed from the DB

You can see what I mean below

http://mesquitechristmas.com/local/browse.php

<?php

include ('db_connect.php');

$address = array();
$city = array();
$state = array();
$postal = array();
$country = array();
$id = mysql_real_escape_string($_GET['id']);
$i=0;
if (isset($id)) {
  $sql = "SELECT * FROM users";
  if($result = mysql_query($sql)) {
     while ($row = mysql_fetch_array ($result)) {
       $address[$i] = $row["address"];
       $city[$i] = $row["city"];
       $state[$i] = $row["state"];
       $postal[$i] = $row["postal"];
       $country[$i] = $row["country"];
       ++$i;
     }
   }
} 

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="description" content="Mesquite Texas Country Christmas" />
<meta name="keywords" content="Mesquite, Texas, Country Christmas" />
<meta name="author" content="NA" />
<link rel="stylesheet" type="text/css" href="/stylesheet.css" media="screen" title="FBC" />
<script type="text/javascript" src="drop_down.js"></script>
<title>A Mesquite Country Christmas</title>
</head>
<body>

 <div id="wrap">

<a href="/index.html">
<img id="frontphoto" src="/images/header.png" width="760" height="237" alt="Mesquite Country Christmas" border="0"></a>

<div id="menu">

<h2 class="hide">Menu:</h2>

<ul id="avmenu">
<li><a href="/index.html">Home</a></li>
<li><a href="/christmasstory.html">The Christmas Story</a></li>
<li><a href="/directions.html">Directions</a></li>
<li><a href="#">Information</a><ul>
      <li><a href="/information.html">Display Facts & Info</a></li>
      <li><a href="/faq.html">FAQ</a></li>
      <li><a href="/playlist.html">2008 Playlist</a></li>
      <li><a href="#">Christmas History</a></li>
  </ul></li>
<li><a href="#">Photos</a>
  <ul>
      <li><a href="/2007photos.html">2007</a></li>
  </ul></li>
<li><a href="#">Videos</a>
  <ul>
      <li><a href="/2007videos.html">2007</a></li>
  </ul></li>
<li><a href="/guestbook.php">Guestbook</a></li>
<li><a href="/webcam.html">Web Cam</a></li>
<li><a href="/webradio.html">Internet Radio</a></li>
<li><a href="http://www.noradsanta.org/" TARGET="_blank">Track Santa</a></li>
<li><a href="/projects.html">Projects & How Tos</a></li>
<li><a href="/links.html">Links</a></li>
<li><a href="/contact_us.html">Contact Us</a></li>
</ul>

<center><a href="http://www.toysfortots.org/" TARGET="_blank"><img src="/images/toys_for_tots.jpg" border="0" width="110" height="153" vspace="10"></a></center>

<center><a href="http://christmas.bronners.com/2007/house/534.html"><img src="http://christmas.bronners.com/voteforme/vote.jpg" border="0" width="110" height="153" alt="christmas decorations" vspace="10"></a></center>

</div>

<div id="content">

 <div class="fadebox">

<h2>Mesquite Christmas Display Finder</h2>

<hr />

<p> Do you drive around aimlessly looking for Christmas lights every year? We are here to help make that tradition better by allowing you to search for local displays in Mesquite and get directions to them. And if you have a display of your own, you can add it to our database for others to find and enjoy!</p>


<p><span class="title">Current Displays In Mesquite</span><br /><table style="border-top: 1px solid rgb(51, 102, 51);" border="0" cellpadding="4" cellspacing="0" width="100%"><tbody><tr><td class="bg2" width="110">IMAGE</td><td class="bg2"><? echo $row['address']; ?><br><? echo $row['city']. "," . $row['state']. " " . $row['postal']; ?><br><? echo $row['country']; ?></td><td class="bg2" style="vertical-align: middle;">&gt; <a href="displays.php?id=<?php echo $row['id']; ?>"><b>Learn more about Display</b></a><br><br>> <a href="http://www.mapquest.com/maps/map.adp?searchtype=address&amp;formtype=search&amp;countryid=US&amp;addtohistory=&amp;country=US&amp;address=<? echo $row['address']; ?>&amp;city=<? echo $row['city']; ?>&amp;zipcode=<? echo $row['postal']; ?>&amp;historyid=&amp;submit=Get+Map" target="_NEW"><b>Get Directions</b></a><br /><br /></td></tr>
<tr><td class="bg1" width="110">IMAGE</td><td class="bg1"><? echo $row['address']; ?><br><? echo $row['city']. "," . $row['state']. " " . $row['postal']; ?><br><? echo $row['country']; ?></td><td class="bg1" style="vertical-align: middle;">&gt; <a href="displays.php?id=<?php echo $row['id']; ?>"><b>Learn more about Display</b></a><br><br>> <a href="http://www.mapquest.com/maps/map.adp?searchtype=address&amp;formtype=search&amp;countryid=US&amp;addtohistory=&amp;country=US&amp;address=<? echo $row['address']; ?>&amp;city=<? echo $row['city']; ?>&amp;zipcode=<? echo $row['postal']; ?>&amp;historyid=&amp;submit=Get+Map" target="_NEW"><b>Get Directions</b></a><br /><br /></td></tr></tbody></table></p>

</div>



   </div>
 </div>

<div id="footer">
&copy; 2007 Mesquite Country Christmas

<br />
<br />

<script type="text/javascript"><!--
google_ad_client = "pub-8048181801684156";
//468x60, created 1/8/08
google_ad_slot = "0360766123";
google_ad_width = 468;
google_ad_height = 60;
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>


</div>

</div>
</body>
</html>

reddrum

I made this into a function you just call it in your markup where the data will be

<?php
   show_data();
?>

<?php

include ('db_connect.php');
function show_data(){
   $address = array();
   $city = array();
   $state = array();
   $postal = array();
   $country = array();
   $id = mysql_real_escape_string($_GET['id']);
   $i=0;
   if (isset($id)) {
      $sql = "SELECT * FROM users";
      if($result = mysql_query($sql)) {
         while ($row = mysql_fetch_array ($result)) {
            $address[$i] = $row["address"];
            $city[$i] = $row["city"];
            $state[$i] = $row["state"];
            $postal[$i] = $row["postal"];
            $country[$i] = $row["country"];
            print"<tr><td>";
            print"$address[$i] ";
            print"$city[$i] ";
            print"$state[$i] ";
            print"$postal[$i] ";
            print"$country[$i]";
            prrint"</td></tr>";
            ++$i;
         }
      }
   }
}
?>

Dada78

Thank you for your help. I tried what you posted above and while it works it outputs the data all together. So I went back to what was working so I can work from there. I need the information to be displayed a certain way though. You can see what I am talking about on the link below. It is actually showing the information from the DB, but as you can see it is showing the same info as the first where it should be different for each table row.

So how do I get each one to show a different entry? Is this something where I am going to have to embed the php logic into the HTML?

http://mesquitechristmas.com/local/browse.php

This is the code I am using to display the info from the DB. The php query is at the top.

<?php

include ('db_connect.php');

$result = mysql_query("SELECT * FROM users");

while($row = mysql_fetch_array($result))
  {
      $id = $row["id"];
      $address = $row["address"];
      $city = $row["city"];
      $state = $row["state"]; 
      $postal = $row["postal"];
      $country = $row["country"];
      $imgurl = $row["imgurl"];

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="description" content="Mesquite Texas Country Christmas" />
<meta name="keywords" content="Mesquite, Texas, Country Christmas" />
<meta name="author" content="NA" />
<link rel="stylesheet" type="text/css" href="/stylesheet.css" media="screen" title="FBC" />
<script type="text/javascript" src="drop_down.js"></script>
<title>A Mesquite Country Christmas</title>
</head>
<body>

 <div id="wrap">

<a href="/index.html">
<img id="frontphoto" src="/images/header.png" width="760" height="237" alt="Mesquite Country Christmas" border="0"></a>

<div id="menu">

<h2 class="hide">Menu:</h2>

<ul id="avmenu">
<li><a href="/index.html">Home</a></li>
<li><a href="/christmasstory.html">The Christmas Story</a></li>
<li><a href="/directions.html">Directions</a></li>
<li><a href="#">Information</a><ul>
      <li><a href="/information.html">Display Facts & Info</a></li>
      <li><a href="/faq.html">FAQ</a></li>
      <li><a href="/playlist.html">2008 Playlist</a></li>
      <li><a href="#">Christmas History</a></li>
  </ul></li>
<li><a href="#">Photos</a>
  <ul>
      <li><a href="/2007photos.html">2007</a></li>
  </ul></li>
<li><a href="#">Videos</a>
  <ul>
      <li><a href="/2007videos.html">2007</a></li>
  </ul></li>
<li><a href="/guestbook.php">Guestbook</a></li>
<li><a href="/webcam.html">Web Cam</a></li>
<li><a href="/webradio.html">Internet Radio</a></li>
<li><a href="http://www.noradsanta.org/" TARGET="_blank">Track Santa</a></li>
<li><a href="/projects.html">Projects & How Tos</a></li>
<li><a href="/links.html">Links</a></li>
<li><a href="/contact_us.html">Contact Us</a></li>
</ul>

<center><a href="http://www.toysfortots.org/" TARGET="_blank"><img src="/images/toys_for_tots.jpg" border="0" width="110" height="153" vspace="10"></a></center>

<center><a href="http://christmas.bronners.com/2007/house/534.html"><img src="http://christmas.bronners.com/voteforme/vote.jpg" border="0" width="110" height="153" alt="christmas decorations" vspace="10"></a></center>

</div>

<div id="content">

 <div class="fadebox">

<h2>Mesquite Christmas Display Finder</h2>

<hr />

<p> Do you drive around aimlessly looking for Christmas lights every year? We are here to help make that tradition better by allowing you to search for local displays in Mesquite and get directions to them. And if you have a display of your own, you can add it to our database for others to find and enjoy!</p>

<p><span class="title">Current Displays In Mesquite</span><br /><table border=0 cellspacing=0 cellpadding=4 width=100% style="border-top: 1px solid #336633"><tr><td class="bg2" width=110><a href="/displays.php?id=<?php echo $row['id']; ?>"><img src="<? echo $row['imgurl']; ?>" class="border" height"75" width="100"></a></td><td class="bg2"><? echo $row['address']; ?><br><? echo $row['city']. "," . $row['state']. " " . $row['postal']; ?><br><? echo $row['country']; ?></td><td class="bg2" style="vertical-align: middle">> <a href="displays.php?id=<?php echo $row['id']; ?>"><b>Learn more about Display</b></a><br><br>> <a href="http://www.mapquest.com/maps/map.adp?searchtype=address&amp;formtype=search&amp;countryid=US&amp;addtohistory=&amp;country=US&amp;address=<? echo $row['address']; ?>&amp;city=<? echo $row['city']; ?>&amp;zipcode=<? echo $row['postal']; ?>&amp;historyid=&amp;submit=Get+Map" target="_NEW"><b>Get Directions</b></a></td></tr>

<tr><td class="bg1" width=110><a href="/displays.php?id=<?php echo $row['id']; ?>"><img src="<? echo $row['imgurl']; ?>" class="border" height"75" width="100"></a></td><td class="bg1"><? echo $row['address']; ?><br><? echo $row['city']. "," . $row['state']. " " . $row['postal']; ?><br><? echo $row['country']; ?></td><td class="bg1" style="vertical-align: middle">> <a href="displays.php?id=<?php echo $row['id']; ?>"><b>Learn more about Display</b></a><br><br>> <a href="http://www.mapquest.com/maps/map.adp?searchtype=address&amp;formtype=search&amp;countryid=US&amp;addtohistory=&amp;country=US&amp;address=<? echo $row['address']; ?>&amp;city=<? echo $row['city']; ?>&amp;zipcode=<? echo $row['postal']; ?>&amp;historyid=&amp;submit=Get+Map" target="_NEW"><b>Get Directions</b></a></td></tr></table>	</p>

</div>



   </div>
 </div>

<div id="footer">
&copy; 2007 Mesquite Country Christmas

<br />
<br />

<script type="text/javascript"><!--
google_ad_client = "pub-8048181801684156";
//468x60, created 1/8/08
google_ad_slot = "0360766123";
google_ad_width = 468;
google_ad_height = 60;
//--></script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>


</div>

</div>
</body>
</html>
<?php
}
?>

-Thanks

reddrum

Your data is all the same because you are not iterating the row array. When we used the new arrays for each field of your table:

$address[$i] = $row["address"];

each field can be used with its index: $address[0], $address[1]ect., so if you set each field array with its index in your markup you will see all the data.

DedoMraz

reddrum wrote:
Your data is all the same because you are not iterating the row array. When we used the new arrays for each field of your table:
$address[$i] = $row["address"];
each field can be used with its index: $address[0], $address[1]ect., so if you set each field array with its index in your markup you will see all the data.

And it not while at the beginning, the problem. What you get at the end will be always last data. How can you call $address[0] and then $address[1] etc, after while?

Here is scrap from my code...

if ($result->num_rows > 0)

for ($i=0; $i < $result->num_rows; $i++)
{
    $row=$result->fetch_assoc();
	$name=$row['username'];
	echo '<tr><td><strong>'.($i+1).'. </strong></td>';
	echo '<td>'.htmlspecialchars(stripslashes($row['username'])).'</td>'; 
	echo '<td>'.stripslashes($row['type']).'</td>';
	echo "<td><input type='checkbox' name='chk_zmaz_usr[]' value='$name'></td></tr>";
}
else
{
	echo'V databáze sa nie su registrovany ziadny uzivatelia!';
}

Dada78

reddrum wrote:
Your data is all the same because you are not iterating the row array. When we used the new arrays for each field of your table:
$address[$i] = $row["address"];
each field can be used with its index: $address[0], $address[1]ect., so if you set each field array with its index in your markup you will see all the data.

I understand what you are saying but I don't follow you, does that make sense? When you say $address[0], $address[1]ect. is that echoed in the HTML or something. Where exactly is that used?

-Thanks

reddrum

There are better ways of doing this but to keep things simple, if you change what you have in your HTML

<td class="bg2"><? echo $row['address']; ?><br><? echo $row['city']. "," . $row['state']. " " . $row['postal']; ?><br><? echo $row['country']; ?></td><

To:

<td class="bg2"><? echo $address[0]; ?><br><? echo $city[0]. "," . $state[0]. " " . $postal[0]; ?><br><? echo $country'[0]; ?></td><

and so on.
That is after you populated the arrays.

Dada78

Thank you I like simple. I am just a HTML, XHTM, CSS developer. I got stuck with the php when they guy that was suppose to do this bailed. So thank you for keeping it simple.

So if I under stand this correctly in the array I would set this up like this.

<?php

include ('db_connect.php');
function show_data(){
   $address = array();
   $city = array();
   $state = array();
   $postal = array();
   $country = array();
   $id = mysql_real_escape_string($_GET['id']);
   $i=0;
   if (isset($id)) {
      $sql = "SELECT * FROM users";
      if($result = mysql_query($sql)) {
         while ($row = mysql_fetch_array ($result)) {
            $address[0] = $row["address"];
            $city[0] = $row["city"];
            $state[0] = $row["state"];
            $postal[0] = $row["postal"];
            $country[0] = $row["country"];
            $address[1] = $row["address"];
            $city[1] = $row["city"];
            $state[1] = $row["state"];
            $postal[1] = $row["postal"];
            $country[1] = $row["country"];
            ++$i;
         }
      }
   }
}
?>

And so on like that then in the HTML I would do this for each table row.

<? echo $address[0]; ?>

<? echo $address[1]; ?>

<? echo $address[2]; ?>

etc.. Is that correct or and Im I off?

Also just FYI the code you gave me the last

prrint"</td></tr>";

and a extra r in the print which is why I was getting the error.

-Thanks

Dada78

Wait the array should be done like this right? read the above post first though.

$address[1] = array();
   $city[1] = array();
   $state[1] = array();
   $postal[1] = array();
   $country[1] = array()

$address[2] = array();
   $city[2] = array();
   $state[2] = array();
   $postal[2] = array();
   $country[2] = array()

That is not the full code but would that be correct?

-Thanks

reddrum

Yes I think you got it, except you want to use var $i inyour while loop. each time loop iterates it increases its value "++$i" by 1 starting at 0.

<?php 

include ('db_connect.php'); 
function show_data(){ 
   $address = array(); 
   $city = array(); 
   $state = array(); 
   $postal = array(); 
   $country = array(); 
   $id = mysql_real_escape_string($_GET['id']); 
   $i=0; 
   if (isset($id)) { 
      $sql = "SELECT * FROM users"; 
      if($result = mysql_query($sql)) { 
         while ($row = mysql_fetch_array ($result)) { 
            $address[$i] = $row["address"]; 
            $city[$i] = $row["city"]; 
            $state[$i] = $row["state"]; 
            $postal[$i] = $row["postal"]; 
            $country[$i] = $row["country"]; 

        print"$address[$i] "; 
        print"$city[$i] "; 
        print"$state[$i] "; 
        print"$postal[$i] "; 
        print"$country[$i]"; 

        ++$i; 
     } 
  } 
   } 
} 
?>

reddrum

Sorry dada78, I left too much in that version
try this

<?php 

include ('db_connect.php'); 

   $address = array(); 
   $city = array(); 
   $state = array(); 
   $postal = array(); 
   $country = array(); 
   $id = mysql_real_escape_string($_GET['id']); 
   $i=0; 
   if (isset($id)) { 
      $sql = "SELECT * FROM users"; 
      if($result = mysql_query($sql)) { 
         while ($row = mysql_fetch_array ($result)) { 
            $address[$i] = $row["address"]; 
            $city[$i] = $row["city"]; 
            $state[$i] = $row["state"]; 
            $postal[$i] = $row["postal"]; 
            $country[$i] = $row["country"]; 
            ++$i; 
         } 
      } 
   } 

?>

Dada78

Sorry... Which part is right this below like in the example at the top?

$address[1] = array();

-Thanks

Dada78

Ok I have tried this code below and I am getting this error.

Parse error: syntax error, unexpected T_VARIABLE in /home/mesquit1/public_html/local/browse.php on line 12

The starting <?php is line 1

<?php

include ('db_connect.php');

   $id[0] = array();
   $imgurl[0] = array();
   $address[0] = array();
   $city[0] = array();
   $state[0] = array();
   $postal[0] = array();
   $country[0] = array()
   $id = mysql_real_escape_string($_GET['id']);
   $i=0;
   if (isset($id)) {
      $sql = "SELECT * FROM users";
      if($result = mysql_query($sql)) {
         while ($row = mysql_fetch_array ($result)) {
            $id[$i] = $row["id"];
            $imgurl[$i] = $row["imgurl"];
            $address[$i] = $row["address"];
            $city[$i] = $row["city"];
            $state[$i] = $row["state"];
            $postal[$i] = $row["postal"];
            $country[$i] = $row["country"];
            ++$i;
         }
      }
   }

?>