Hello everyone,
I'm not sure if this is the proper place to be asking this question as I
believe it is more of a question on how to traverse through php arrays and such
but it is using a mysql_query function. So if this not the place pleace don't
read any further and ignore and/or delete this message.
So I am new to mysql AND php, with a background in Oracle SQL. Anyway I am just
starting out writing a web application for a DB of the collection of videos,
games, and cds of me and my wife's. So I want to start out with just making a
table with the field names as the header rows and then the data underneath the
corresponding field name/column. The current code (last part of this message)
only prints out the right column headers/field names and then puts the right
information under it but it only gives me the first record, I want all records.
*********example of current code output*********
IdNum FName LName
1 Ryan McDougall
This is my code so far, be prepared to laugh as this is pretty bad code I'm
sure (I just don't want to be held liable for any injuries from falling out of
your chairs :-P ):
<html>
<head><title>My PHP test file</title></head>
<body>
<?php
$link = mysql_connect ("localhost", "username", "password")
or die ("Could not connect <br>\n");
print ("Connected successfully<br>\n");
mysql_select_db("DBname") or die("Could not select database");
$query = "SELECT * FROM Who";
$result = mysql_query ($query)
or die ("Query failed");
$line = mysql_fetch_array($result, MYSQL_ASSOC);
print "<table>\n";
print "\t<tr>\n";
foreach ($line as $key => $value) {
print "\t\t<td>$key</td>\n";
}
print "\t</tr>\n";
print "\t<tr>\n";
foreach ($line as $col_value) {
print "\t\t<td>$col_value</td>\n";
}
print "\t</tr>\n";
print "</table>\n";
mysql_free_result ($result);
mysql_close ($link);
?>
</body>
</html>
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
