[SOLVED] help with a comment system

[kiana]

ive just started learning php and mysql ive got most of this script running fine but i cant figure out how to put the poster after the message and then have a line break any help please

 

^{mysql_select_db("message1") or die(mysql_error());}

 

^{if (isset($_POST['mess'])) {}

^{$message = $_POST['mess'];}

^{$poster = $_POST['poster'];}

^{$sql = "insert into message set}

^{mess='$message',}

  ^{poster='$poster',}

^{date=CURDATE()";}

^{if(@mysql_query($sql)) {}

 

^{echo '<p>';}

^{} else {}

^{echo '<font face="verdana" size="1">error adding message: ' .}

^{mysql_error() . '';}

^}

^}

 

 

^{$result = @mysql_query('SELECT mess FROM message');}

^{if (!$result) {}

^{exit('error performing query:'}

^{. mysql_error(). ' ');}

^}

^{while ($row = mysql_fetch_array($result)) {}

^{echo '<font face="verdana" size="1"> ' . $row['mess']  .' - ';}

^}

 

^{$result = @mysql_query('SELECT poster FROM message');}

^{if (!$result) {}

^{exit('error performing query:'}

^{. mysql_error(). ' ');}

    ^}

^{while ($row = mysql_fetch_array($result)) {}

^{echo '<font face="verdana" size="1"> ' . $row['poster']  .' - ';}

^}

 

^{echo '<center><a href="'. $_SERVER['PHP_SELF'] . '?addmessage=1">add a message</a>';}

 

^endif;

^?>

[only one]

$sql = "insert into message set

  mess='$message',

poster='$poster',

  date=CURDATE()";

 

does this work??

 

try this, your probobally not seeing an error because your @ infront of the mysql_query

$sql = "INSERT INTO clan_apps (`mess`, `poster`, `date`)VALUES('$message','$poster', 'CURDATE()')";

[paul2463]

you are running two queries from the same table to get two different things, run one query

 

$result = mysql_query("select mess, poster FROM message");

 

then one while loop will work

while ($row = mysql_fetch_array($result)) {
echo '<font face="verdana" size="1"> '' . $row['mess']  .' - ' . $row['poster'];
}

[kiana]

cheers the last one worked a treat

[kiana]

another small problem

 

<?Php

 

$result = @mysql_query("select news, poster, newsdate FROM message ORDER BY date DESC LIMIT 5");

while ($row = mysql_fetch_array($result)) {

echo '<b>' . $row['poster'] .' - '. $row['date']. '<br></b>' .  $row['News'] . '<p>';

}

?>

 

thats using the same code you gave me before but come up with an error on the mysql_fetch_array line

any ideas?

[per1os]

Seriously stop surpressing errors it does no good (the @ sign)

 

$result = mysql_query("select news, poster, newsdate FROM message ORDER BY `newsdate` DESC LIMIT 5") or DIE(mysql_error()); // the or die gives you a helpful error if one occurs.

 

Date is a reservered word that and since you were pulling it out by "newsdate" in the select portion I assumed you mean that. If you did not and you did mean date enclose it in the tick marks ` ` which will override the reserved word portion