Wow Tchuki, that's really cool. I'm not a programmer so this is all magic to me.
I'd just need a couple of more things for this to work for me.
1. the ability to add/edit/delete the contents of the list. The person who would be doing the updating is completely non-technical. Is there an easy way to set this up?
2. The list would not show any items who's date has already passed.
So just to be clear, I'd setup a mysql database and import the "create table" script you created? Once the db is setup I'd put the php code into my page where I want it to show? Am I missing anything important?
Thanks a million for the help!
Main Topics
Browse All Topics
by: TchukiPosted on 2007-06-01 at 12:03:08ID: 19197183
You could always just make your own ?
create table `class_detail` (
id tinyint(3) auto_increment not null primary key,
title varchar(50) not null,
descrption varchar(100),
date timestamp not null,
);
<?PHP
// connect to a database
include_once ("db_connection.php");
// get all the detail about classes from the database
$sql = mysql_query("SELECT * FROM class_detail") or die ("Could not complete $sql. MySQL said: " . mysql_error());
// start a table for output
echo ("<table><tr><td>Class Title</td><td>Description<
// while there is still detail in the database keep printing to the screen
while ($detail = mysql_fetch_array($sql)) {
$title = $detail['title'];
$description = $detail['description'];
$date = $detail['date'];
echo ("<tr>$title<td></td>$desc
echo ("</table>");
}
?>
To get the info into your database, a simple 4 field form would do the trick and again is simple to create.