Re: Problem running sql stored in the database

Not quite sure what you mean... So I assume the data was written into the worng fields. If that is the case you could modify your insert query: INSERT INTO table (id, name) VALUES ('$id', '$name') hth Richard Friday, April 9, 2004, 4:11:05 PM, you wrote: > Hi, > I am getting 2 values from a form: > $client_id and $client_name (for understanding: client_id = '12' > name='ryan') > when the client submits the form: > 1. I run a query in my php script inserts this data into the db,assigns a > C_ID. > 2. The query also checks if I have a stored sql statement for this C_ID > 2a. If "YES" it tries to execute the query (if NO, execution stops here, all > is well) > 3.The stored SQL is usually something like "insert into > tester('$client_id','$client_name')" > Heres where the problems coming in, it seems to be doing everything as it > should except when > I check the database I see that it has inserted: > "$client_id" "$client_name" into the fields instead of "12" > "ryan" > The above should explain everything but if you want the code I can post it. > Kindly reply. > Thanks, > -Ryan