[Resolved] mysql query

[thekidscareya]

I can't figure out what's wrong...The query will never perform $sql and doesn't update it...why?

Form

echo "<input type=hidden name=id value='$id'>";

$id = $_POST[id];

later in the code

 
	$sql = 'UPDATE `tblapp` SET `Status` = `Rejection Email Sent` WHERE `AppID` ='.$id.''; 
	$query = mysql_query($sql);
	echo "Status for Application ID $id has been change to - Rejection Email Sent - successfully.";
	echo "<BR>";

The email is sent each time I test the script...the database details are all correct...but I can't figure out what's wrong. Can someone help me?

[trex005]

Quick Debugging :

$query = mysql_query($sql);
echo "<PRE>$sql</PRE>", mysql_error();

Keep us posted

[thekidscareya]

UPDATE tblapp SET Status = Rejection Email Sent WHERE AppID =2
Unknown column 'Rejection Email Sent' in 'field list'Status for Application ID 2 has been change to - Rejection Email Sent - successfully.
Please wait while you are redirected...

[tomhath]

I'm kind of confused by the quotes in your query, maybe MySQL is too.

Is Rejection Email Sent supposed to be a quoted string or a column name?

[trex005]

from that I'd infer that Rejection Email Sent is not supposed to be a filed, yet you are enclosing it in back ticks
instead you want to inclose it in apostophies so MySQL knows that it is indeed a string
'Rejection Email Sent'
NOT
Rejection Email Sent

[thekidscareya]

I got it to work. 🙂

 
$sql = "UPDATE `tblapp` SET `Status` = 'Acceptance Email Sent' WHERE `AppID` ='.$id.'"; 

EDIT: Nevermind....doesn't work

[tsinka]

Hi,

try

$sql = "UPDATE `tblapp` SET `Status` = 'Acceptance Email Sent' WHERE `AppID` ='$id'";

or

$sql = "UPDATE `tblapp` SET `Status` = 'Acceptance Email Sent' WHERE `AppID` ='".$id."'";

Thomas

[thekidscareya]

the second one works....thanks soooooooo much...i really appeciate it.