View Single Post
  #6 (permalink)  
Old April 28th, 2004, 09:34 PM
happygv happygv is offline
Friend of Wrox
Join Date: Jun 2003
Location: Bangalore, KA, India.
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post

Alex, (Sorry I was off for the psat couple of days, So couldn't replay any of the posts here)

You would curse yourself, seeing the solution. You have missed the concatenation operator inbetween;)

$query = "UPDATE AddTable2 SET Code='" . $c . "', Description='" . $d . "', Name='". $n . "' WHERE Id='" . $Id . "'";

NOTE: Something to remember always, Do not use Single Quotes around the VARIABLE, if its DATATYPE is of NUMERIC set in the DATABASE.

May be you can alter the above said query, as I am not sure about the Datatypes of each column there.

PS: I will be online for next 5 days (Early morning IST).


-Vijay G
Reply With Quote