RE: What wrong in this SQL

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Try escaping the $catid like:

WHERE cat_id='$catid'

Aaron

-----Original Message-----
From: Alawi shekh albaity [mailto:alawi2002@php4web.com] 
Sent: March 1, 2003 1:04 AM
To: php-db@lists.php.net
Subject:  What wrong in this SQL

 What wrong with this code in sql : 
$SQLSTATEMENT["DeleteCategory"] = "
  DELETE FROM cats, articles
  WHERE cat_id = $catid
 ";

Error no:
 1064
Details :
You have an error in your SQL syntax near 'WHERE cat_id = 1 ' at line 4

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux