Syntax error unexpected T_String

[acctman]

This is the line below with the T_STRING error. Can someone tell me why i'm receiving the error?

 

mysql_query("UPDATE rate_members SET m_ip=$ip, m_del_rd=NOW(), m_del_type=1 WHERE m_id=$_POST['id']");

[Mchl]

Change it to;

 

mysql_query("UPDATE rate_members SET m_ip=$ip, m_del_rd=NOW(), m_del_type=1 WHERE m_id={$_POST['id']}");

[Maq]

You should also have single quotes around values that aren't integers.

[Mchl]

You should also have single quotes around values that aren't integers.

 

That would throw a mysql error though.

I suspect there's also an error in lines above this one.

[acctman]

this is the complete section of coding. still getting an error.

 

$ip = getenv("REMOTE_ADDR");

if(!isset($_POST['del_acct'])) {
if($_POST['ban'] == 1) {	
	delete_record($_POST['id'])		
	mysql_query("UPDATE rate_members SET m_ip='$ip', m_del_rd='NOW()', m_del_type='1' WHERE m_id={$_POST['id']}");
}
	header("Location: /files/acct-removed.php");
	session_destroy();
	exit;
}

[acctman]

oh i see my error its the function

 

delete_record($_POST['id'])

 

should me

delete_record($_POST['id']);

 

complete fix... how does that look?

$ip = getenv("REMOTE_ADDR");

if(!isset($_POST['del_acct'])) {
if($_POST['ban'] == 1) {	
	delete_record($_POST['id']);		
	mysql_query("UPDATE rate_members SET m_ip='$ip', m_del_rd='NOW()', m_del_type=1 WHERE m_id={$_POST['id']}");
}
	header("Location: /files/acct-removed.php");
	session_destroy();
	exit;
}

[Maq]

What exactly does the error say, specifically line #?

[Mchl]

complete fix... how does that look?

 

Should be working now.

[acctman]

What exactly does the error say, specifically line #?

 

I didn't run the script since its designed to delete accounts. i wrote it inside phpDesigner and it highlighted that line with the error.

[Maq]

What exactly does the error say, specifically line #?

 

I didn't run the script since its designed to delete accounts. i wrote it inside phpDesigner and it highlighted that line with the error.

 

So why didn't you show us that line from the beginning?