I am trying to make a table of my MySQL Data. My table, test, has 5 columns: idt, datetime, col1, col2 and col3 with many rows of data.
[code=php]</php
$conn = mysql_connect(‘server.com’, ‘username’, ‘password’);
mysql_select_db(‘database’);
$sqli = “SELECT * FROM `test`;”
$resulti = mysql_query($sqli, $conn);
$index = mysql_fetch_array($resulti, MYSQL_ASSOC);
foreach ($g in count($index[‘idt’])){
$_SESSION[‘idt’] = $indexi[‘idt’];
$_SESSION[‘datetime’]=$index[‘datetime’];
$_SESSION[‘col1’] =$indexi[‘col1’];
$_SESSION[‘col2’] =$indexi[‘col2’];
$_SESSION[‘col3’] =$indexi[‘col3’];
}
mysql_close($conn);
?>
[code=html]<body>
<center><table><tr><td><br /><br /><br /></td></tr>
<tr><td><?php $_SESSION[‘idt’] ?></td></tr>
<tr><td><?php $_SESSION[‘datetime’] ?></td></tr>
<tr><td><?php $_SESSION[‘col1’] ?></td></tr>
<tr><td><?php $_SESSION[‘col2’] ?></td></tr>
<tr><td><?php $_SESSION[‘col3’] ?>
</td></tr></table></center>
</body>