GoFuckYourself.com - Adult Webmaster Forum - View Single Post - Mysql $query = Update $variable field quick php question

darksoul · 12-17-2009, 03:30 AM

thats a pretty fugly style with all those escapes. The only escape you need is for timestamp which is a reserved keyword

Code:

$query = "UPDATE sms.messages_import SET `timestamp` = NOW, status=2 WHERE messages_import.id=$id";

You also don't need LIMIT 1, since the id is unique (in most cases anyway)

12-17-2009, 03:30 AM
darksoul Confirmed User Join Date: Apr 2002 Location: /root/ Posts: 4,997	thats a pretty fugly style with all those escapes. The only escape you need is for timestamp which is a reserved keyword Code: $query = "UPDATE sms.messages_import SET `timestamp` = NOW, status=2 WHERE messages_import.id=$id"; You also don't need LIMIT 1, since the id is unique (in most cases anyway) __________________ 1337 5y54\|)m1n: 157717888 BM-2cUBw4B2fgiYAfjkE7JvWaJMiUXD96n9tN Cambooth