how to store html in mysql

Anon

Hi everyone,

I'm really new to using mysql and php, have them setup and running locally and with my host and have successfully got basic database running.

Now what i want to do is be able to pull a html table from db (the same one each time) and have data inserted into each cell.

How is this done?

Ive done search after search and read article after article but this topic never seems to be discussed.

Basically most of my page is static and its just the content column that needs a pretty table repeated showing hotel information, picture, address and some graphic icons for telephone number and so on.

I'm thinking it has something to do with includes but im really left scratching my head as to how to actually do what i want.

thanks for any help.

zhabala

I think, that it is quite difficult. You have to play with some database MySQL or PostgreSQL. You have to learn Structured Query Language SQL to insert data into DB, to select data from DB, to update data in DB. Then you can populate your HTML table from DB.

Zdenek

philsown

Most PHP/Database topics will help you with this. Check out the articles on webmonkey.com. Basically your script should do the following:

connect to the database
perform your query
if the query returned rows
start the html table
do a while loop for each row
output one table row of cells
end the html table
otherwise
print a nice message saying "no hotels"

Look up the mysql functions in the database.

Good luck!

hearn

Here's some example code of what phil had to say:

<TABLE WIDTH="600" CELLPADDING="4" CELLSPACING="0" BORDER="0">
<?php
$link = mysql_connect("$db_address", "$db_username", "$db_password") or exit("Could not connect to database");
mysql_select_db("$db_db") or die("Could not select database");
$result = mysql_query("SELECT * FROM $table_passwords ORDER BY $orderby");

while ($row = mysql_fetch_array($result)) {
    echo "enter your table and fields";
    echo $row["fieldname"]; // prints a table variable
}
mysql_free_result($result);
mysql_close($link);

?>
</TABLE>