[ivan]

dear all,
example : i have a table in mysql
city table
-----------
id city_name
1 new york
2 paris
3 roma
4 baghdad
5 madrid
6 others

I want preview in browser (with PHP script ) like this :
new york paris roma
baghdad madrid others
........ ........

Can you give me the script ?

regards,
ivan

[fyrestrtr]

After you have successfully connected to the database

PHP Code:

$query = "SELECT city_name FROM city_table";

if(!($result = mysql_query($query)))

{

   die(mysql_errno()." : ".mysql_error());

}

while ($row = mysql_fetch_assoc($query))

{

   echo $row['city_name'];

} 

[ivan]

thank you,but if your script run in browser :

$query = "SELECT city_name FROM city_table";
if(!($result = mysql_query($query)))
{
die(mysql_errno()." : ".mysql_error());
}
while ($row = mysql_fetch_assoc($query))
{
echo $row['city_name'];
}


result in browser :
newyork paris roma baghdad madrid others

i want this preview :

newyork | paris | roma
baghdad | madrid | others
others | others |

3 or 4 or 5 column preview (like photo galery)

regards,
ivan

[fyrestrtr]

add a counter, then mod it by the number of columns. If the result of the mod operation is 0, then echo out a <br />

Something like this (modify it for you own needs)

PHP Code:

$count = 1;

$num_cols = 3;

while($row = mysql_fetch_assoc($query))

{

   echo $row['city_name']." | ";

   $count++;

   if ($count % $num_cols == 0)

   {

      echo "<br />";

   }

} 

[ivan]

thank you,
your script work fine