php tut

[blacksheepradio]

yes some on... site content that changes automatically from a database

[robbie]

please elaborate... that's simple enough but what kind of site content do you want to change automatically etc?

connecting and displaying database stored content:

Code: Select all

<?php
mysql_connect("localhost", "user" , "pass");
mysql_select_db("databasename");

$query = mysql_query("SELECT Data FROM SiteContent WHERE Page = 'index' LIMIT 1");
$row = mysql_fetch_array($query);

$info = stripslashes( nl2br( $row['Data'] ) );

echo $info;

mysql_close();
?>


simply connecting to server/database, retrieving row where column "Page" has value "index" and getting the Data column's contents (the index page content).
next taking out escape slashes that are added when posted, and automatically dropping a line where necessary with nl2br. then lastly outputting the content and closing the connection.

hope thats what you wanted

[blacksheepradio]

could be..... it hasn't sunk in yet (newbie)

some thing like a new "quote" or it loads different pics in particular spots.

[robbie]

www.hotscripts.com have an excellent range of free and commercial web scripts, including quote randomization and display scripts. check them out