How to use PHP & MySQL Display Multiple Column

Author: admin | Posted: 25-03-2010 | Category: PHP & MySQL

How to use PHP & MySQL Display Multiple Column Learn PHP how to using PHP list data from mysql table and display result of multiple column.

ShotDev Focus:
- PHP & MySQL list data and multiple column.

Example

php_mysql_multiple_column.php


<html>
<head>
<title>ShotDev.Com Tutorial</title>
</head>
<body>
<?
$objConnect = mysql_connect("localhost","root","root") or die(mysql_error());
$objDB = mysql_select_db("mydatabase");
$strSQL = "SELECT * FROM gallery";
$objQuery = mysql_query($strSQL);
echo"<table border=\"1\"  cellspacing=\"1\" cellpadding=\"1\"><tr>";
$intRows = 0;
while($objResult = mysql_fetch_array($objQuery))
{
echo "<td>";
$intRows++;
?>
<center>
<img src="shotdev/<?=$objResult["Picture"];?>"><br>
<?=$objResult["GalleryName"];?>
<br>
</center>
<?
echo"</td>";
if(($intRows)%2==0)
{
echo"</tr>";
}
}
echo"</tr></table>";
?>
</body>
</html>
<?
mysql_close($objConnect);
?>

Create a php file and save to path root-path/myphp/

Run
http://localhost/myphp/php_mysql_multiple_column.php

Screenshot

.
.
.