Guest_imported
New member
- Jan 1, 1970
- 0
How do i get the data from each row from a table and display it on my php script?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
getting mysql data
- Thread starter Guest_imported
- Start date
- Status
<?php
$db = mysql_connect("host", "user", "pasword"
;
mysql_select_db("database"
$sql = "select col1, col2, col3 from table";
$res = mysql_query($sql);
echo "<table>\n";
while ($row = mysql_fetch_array) {
echo "<tr>";
echo "<td>" . $row['col1'] . "</td>";
echo "<td>" . $row['col2'] . "</td>";
echo "<td>" . $row['col3'] . "</td>";
echo "</tr>\n";
}
echo "</table>";
?>
Just hacked away, its 6 am localtime and im a bit dizzy
cu, Sascha
$db = mysql_connect("host", "user", "pasword"
;mysql_select_db("database"
;$sql = "select col1, col2, col3 from table";
$res = mysql_query($sql);
echo "<table>\n";
while ($row = mysql_fetch_array) {
echo "<tr>";
echo "<td>" . $row['col1'] . "</td>";
echo "<td>" . $row['col2'] . "</td>";
echo "<td>" . $row['col3'] . "</td>";
echo "</tr>\n";
}
echo "</table>";
?>
Just hacked away, its 6 am localtime and im a bit dizzy
cu, Sascha- Status