Help with loops

Anon

Hello and thanks in advance. I am beginning to learn PHP and mySQL with a project that my boss gave me. I need some help with a certain part. I have a database and I am retrieving assoiciated cities based of what state a user has selected.

I am trying to write out those cities in a table so that the cities are going across a table 3 <TD> wide.

Please help, I believe I need some type of for or while loop. If I have reached the third <TD> then start a new <TR>.

jfeather

Hi Jason,
you need to use the mysql_fetch_array() function to retrieve the data which goes something like this, assuming you have connected to your server:

$query = "select City from StateInfo where State='SomeState'";

$result = mysql_db_query("YourDB", $query)

$count=0

while ($r=mysql_fetch_array($result))
{
$City=$r["City"];
$count++;
echo " <td>$City</td>";
if ($count%3==0) //every third row
{
echo "</tr><tr>";
}
}

Hope this helps
Kind Regards
John Featherstone

Anon

Would something like this work:

$numcells = "0";
for ($x=0; $x<count($cities_array); $x++) {
echo "<td>" . $cites_array[$x] . "</td>\n";
$numcells = $numcells+1;
if ($numcells == "3") {
echo "<tr>\n";
$numcells = "0";
}
}

The way this script works is it loops through your entire array of citties, the number of cells it has used up starts as zero. It puts the first city in a cell and adds 1 to the number of cells used. It checks every loop if the number of cells used equals 3, if it does, it adds a <tr>. It then sets the number of cells back to zero again.

Jason

Anon

I am trying that but this is the message that I am getting

Parse error: parse error in /www/eastcoastgolfconnection/getcities.php on line 71

This is my code
<?php
$link = mysql_connect("mysql.eastcoastgolfconnection.com", "eastcoastgolf", "golfanyone?");
$query = "SELECT Distinct City from tblCourses where State = '$state'";
$result = mysql_query($query);
$count=0
while ($r=mysql_fetch_array($result))
{
$City=$r["City"];
$count++;
echo " <td>$City</td>";
if ($count%3==0) //every third row
{
echo "</tr><tr>";
}
}
?>

Anon

But where is the place I add the city value to each TD tag

Anon

I would say your problem is with this line...
$count=0

It should have a semicolon at the end of the line?
$count=0;