[Newbie]automatic select form a db if something is posted

[Grandiozo]

hey everyone,

I'm busy with learn php & mysql. I'm now busy with a guestbook.
I can post messages into my database.
I've read a lots of articles (dutch), but I haven't find it.
How can I automatic show a message?
Now I muss add the message self, but I want that it happen automatic. So, somebody post a message and than automatic will be the message add on a page...
Where can I find a script (English or Dutch) or who can write a script for me?
If you want help me, thank you very much!!
For MSN you can contact me on [e-mail]

Greets,

Edwin

[bastien]

but

<?
$sql="select * from table_guest where limit order by id desc limit 10"
//selects the last 10 results from the DB based on an
//autoincrement field called id

$result=mysql_query($sql) or die("Database not available");
//you'll need to code for the db connection whatever wya you
//choose

echo "<table>";

while ($rows=mysql_fetch_array($result)){
$username=$rows['username'];
$message=$rows['message'];
$dateleft=$rows['dateinserted'];

 //note the above is not really needed, you can reference the 
 //data another way, but i put here for clarity

echo "<tr><td>$username</td><td>$message</td><td>
          $dateleft</td></tr>";
 //write out the data

} //end the loop

echo "</table>";

?>

hth

[Grandiozo]

don't know your db structure

The table name is gegevens
And into that table:

naam (translate to English: name)
email
website
bericht (translate to English: message)

Greets,

Edwin

[Grandiozo]

Originally posted by bastien
but

<?
$sql="select * from table_guest where limit order by id desc limit 10"
//selects the last 10 results from the DB based on an
//autoincrement field called id

$result=mysql_query($sql) or die("Database not available");
//you'll need to code for the db connection whatever wya you
//choose

echo "<table>";

while ($rows=mysql_fetch_array($result)){
$username=$rows['username'];
$message=$rows['message'];
$dateleft=$rows['dateinserted'];

 //note the above is not really needed, you can reference the 
 //data another way, but i put here for clarity

echo "<tr><td>$username</td><td>$message</td><td>
          $dateleft</td></tr>";
 //write out the data

} //end the loop

echo "</table>";

?>

hth [/B]

I've try to use this, but It didn't work, he had connection with the db, because I didn't see "Database not available"

[bastien]

The table name is gegevens
And into that table:
id //add this to give an easy primary key as name maybe duplicated
naam (translate to English: name)
email
website
bericht (translate to English: message)
date_inserted //add a datestamp on registration - love those datestamps ever so handy for all sorts of things

<?
$sql="select * from gegevens where order by id desc limit 10"
//selects the last 10 results from the DB based on an
//autoincrement field called id

$result=mysql_query($sql) or die("Database not available");
//you'll need to code for the db connection whatever wya you
//choose

echo "<table>";

while ($rows=mysql_fetch_array($result)){
$username=$rows['naam'];
$email =$rows['email'];
$message=$rows['bericht'];
$dateleft=$rows['date_inserted'];
$website=$rows['website'];

//note the above is not really needed, you can reference the
//data another way, but i put here for clarity

echo "<tr><td>$username</td><td>$email</td>
<td>$message</td><td>$dateleft</td><td>
$website</td></tr>";
//write out the data

} //end the loop

echo "</table>";

?>

this should do it....

and hey

if you're not dutch, you're not much😃