Problems with comment script

[rjcfan4ever]

I got an comment script of internet and created a mysql database but if someone sumbit a message it just works.. But if a second person want to sumbit an message he doesn't work D:

 

Script:

$host = "localhost"; 
$user = "username"; 
$pass = "password"; 
$db = "database"; 

mysql_connect($host, $user, $pass) OR die ("Could not connect to the server."); 
mysql_select_db($db) OR die("Could not connect to the database."); 
       
$name = stripslashes($_POST['txtName']); 
$message = stripslashes($_POST['txtMessage']); 

if (!isset($_POST['txtName'])) { 

    $query = "SELECT id, name, message, DATE_FORMAT(date, '%D %M, %Y @ %H:%i') as newdate FROM guests ORDER BY id DESC"; 
    $result = mysql_query($query); 
     
    while ($row = mysql_fetch_object($result)) { 

?> 

<p><strong><?php echo $row->message; ?></strong> 
<br />Posted by <?php echo $row->name; ?> on <?php echo $row->newdate; ?></p> 

<?php 
         
    } 
     
?> 

 

Live view: http://theelephantcrew.awardspace.info/thehappytutorials.php

[kikesv]

You must insert data at mysql

 

$host = "localhost"; 
$user = "username"; 
$pass = "password"; 
$db = "database"; 

mysql_connect($host, $user, $pass) OR die ("Could not connect to the server."); 
mysql_select_db($db) OR die("Could not connect to the database."); 
       
$name = stripslashes($_POST['txtName']); 
$message = stripslashes($_POST['txtMessage']); 

if (isset($_POST['txtName'])) { 
     $query = "INSERT INTO guests  (name, message,date) values ('".mysql_real_escape_string($name)."','".mysql_real_escape_string($message)."','".date('Y-m-d H:i:s')."')";; 
    $result = mysql_query($query); 
}

    $query = "SELECT id, name, message, DATE_FORMAT(date, '%D %M, %Y @ %H:%i') as newdate FROM guests ORDER BY id DESC"; 
    $result = mysql_query($query); 
     
    while ($row = mysql_fetch_object($result)) { 

?> 

<p><strong><?php echo $row->message; ?></strong> 
<br />Posted by <?php echo $row->name; ?> on <?php echo $row->newdate; ?></p> 

[rjcfan4ever]

I did

[Nodral]

Check your original code.

 

There is no INSERT statement, so how are you writing to your DB?

[rjcfan4ever]

Sorry don't get it 

[Nodral]

Read through your original code that you posted in your question.

 

At no point in this code do you have either an INSERT or UPDATE statement.  How can you expect to transfer information to a DB without actually having the commands in your script that will do this for you????????

 

That's like me thinking of a number and then asking you what it is.  You won't know, because I've not transferred that information from my brain to yours via my mouth!!!!!

[rjcfan4ever]

Okey but can you explain how to adjust this?

[Nodral]

Read the post by kikesv.  He has already shown how to do this.

 

What's the point of posting on here if you don't read, digest and try to understand what people are doing to help?

 

You may want to do a bit of Googling about basic MySQL databases and the fundamental statements and interactions that php has with it.

[rjcfan4ever]

I fill in the database information and that's not the problem

[Nodral]

How do you fill in the database information without using either an INSERT statement or UPDATE statement?

 

 

Show me the bit of your code which interacts with your DB and writes into it.