Putting info from MySQL to a PHP page?

[Anon]

I have a database named losbanos. It contains two tables, council and site. Council holds all of the information for the city council members of the city, and site holds all of the page and link information. How can I use the information in those two tables to be sent into a php page?

[rrijnders]

http://www.amazon.com/exec/obidos/ASIN/1861003730/o/qid=991763743/sr=2-2/ref=aps_sr_b_1_2/107-7789357-7272524

[cheald]

You're going to want to do a query in your PHP page. This code will get you started. Play around with it as you will.

[ [ Chris ] ]

$sql = "SELECT * FROM council";
$result = mysql_query($sql);
$myrow = mysql_fetch_row($result)) {
echo "<TABLE><TR>\n";
while(list($key,$val) = each($myrow)
echo "<TH>$key</TH>\n";
mysql_data_seek($result,0);
while($myrow = mysql_fetch_array($result)) {
echo "<TR>\n";
foreach($myrow as $m) {
echo "<TD>$m</TD>\n";
}
echo "</TR>\n";
}
echo "</TABLE>\n";

[cheald]

Small addition - before any of that code, you need to connect to your DB, like this:

$db = mysql_connect("localhost", "root");
mysql_select_db("losbanos",$db);

Sorry bout that!

[cheald]

Pft. I should check my code before posting.

This actually works!

<?
$db = mysql_connect("localhost", "root");
mysql_select_db("losbanos",$db);
$sql = "SELECT * FROM council";
$result = mysql_query($sql);
$myrow = mysql_fetch_assoc($result);
echo "<TABLE BORDER=1 CELLSPACING=0 CELLPADDING=3><TR>\n";
while(list($key,$val) = each($myrow))
echo "<TH>$key</TH>\n";
mysql_data_seek($result,0);
while($myrow = mysql_fetch_assoc($result)) {
echo "<TR>\n";
foreach($myrow as $m) {
echo "<TD>$m</TD>\n";
}
echo "</TR>\n";
}
echo "</TABLE>\n";
?>

[Anon]

Hmm.. didn't work for me.
<b>Warning</b>: Variable passed to each() is not an array or object in <b>/web/sites/279/sesgalaxy/www.sesgalaxy.f2s.com/test.php</b> on line <b>8</b><br>
<br>
<b>Warning</b>: Offset 0 is invalid for MySQL result index 2 in <b>/web/sites/279/sesgalaxy/www.sesgalaxy.f2s.com/test.php</b> on line <b>10</b>