RE: [PHP] R: [PHP] SQL Query Not Kosher?

2004-02-04 Thread Ford, Mike [LSS]
On 03 February 2004 13:45, Alessandro Vitale contributed these pearls of wisdom: > try removing curly braces as follows: > > $query = mysql_query("UPDATE stories SET status='approved' >WHERE story_id={$id}"); | Nothing wrong with the above, it's perfectly valid -- just a slightly different w

[PHP] R: [PHP] SQL Query Not Kosher?

2004-02-03 Thread Alessandro Vitale
ilto:[EMAIL PROTECTED] Inviato: martedì 3 febbraio 2004 5.35 A: [EMAIL PROTECTED] Oggetto: [PHP] SQL Query Not Kosher? Hi all: I am trying to get this to work, but always get the same error: that the resource in mysql_affected_rows() is not valid. Anyone see why this would be? All variables ha

Re: [PHP] SQL Query Not Kosher?

2004-02-03 Thread Marek Kilimajer
The argument to mysql_affected_rows must be mysql CONNECTION identifier (from mysql_connect), not RESULT identifier (from mysql_query). Removing the argument will work for you. Mr. Austin wrote: Hi all: I am trying to get this to work, but always get the same error: that the resource in mysql_

Re: [PHP] SQL Query Not Kosher?

2004-02-02 Thread Mr. Austin
Message - From: "Jochem Maas" <[EMAIL PROTECTED]> To: "Mr. Austin" <[EMAIL PROTECTED]> Sent: Monday, February 02, 2004 10:41 PM Subject: Re: [PHP] SQL Query Not Kosher? > from the php function manual: > > > Note: When using UPDATE, MySQL will not

[PHP] SQL Query Not Kosher?

2004-02-02 Thread Mr. Austin
Hi all: I am trying to get this to work, but always get the same error: that the resource in mysql_affected_rows() is not valid. Anyone see why this would be? All variables have been tested for accuracy. $query = mysql_query("UPDATE stories SET status='approved' WHERE story_id={$id}"); if(m