update mysql

[shlocko]

OKay so I am trying to make this simply update my mysql server. Can anyone maybe see why this isn't working?  The code all works perfectly up until while statement... So if someone maybe sees something wrong? Thanks...

<?
session_start();
include('nconnect.php');

 	$uname=$_POST['to'];
	$result = mysqli_query($con, "SELECT * FROM messages
	 WHERE to='{$uname}' ");
	 $content=$_POST['content'];

	while($row = mysqli_fetch_array($result)){
mysqli_query($con, "UPDATE messages SET content='{$content}' WHERE to='{$uname}' ");
header('location: p1.php');




}
?>

[denno020]

What doesn't happen that you are expecting to happen?

 

Also, the while loop will only fire one query, because as soon as you call the query, you're redirecting the user to p1.php.. So it will only update one record, but maybe that was your intention?

[Barand]

You should check the output from mysql_error() function and you will find you have a syntax error in the query. "TO" is a mysql reserved word. If you must use it as a column name it needs to be inside backticks (`to`)

[shlocko]

Ooh okay, thanks so much for the help, I was so confused because I've used this exact code a hundred other times and it's worked, then it just kinda stopped, thanks for clarifying that for me!