Re: [PHP-DB] Re: Again Select then update

2002-03-24 Thread Adam Royle
In your UPDATE query, should you have a WHERE clause? eg. UPDATE my_items SET name = '$update' WHERE ID = $ID OR do this $update = $name; instead of $update = "$name"; Try running the query on the command line (on *nix) or through phpmyAdmin or something to see if the query is actually wo

Re: [PHP-DB] Re: Again Select then update

2002-03-24 Thread Jen Downey
Hi Bill, No it isn't the latest it is updated with the quotes and slashes in the script. I have found that even if I put my name Jen as $update it still wont update the table. $update = "Jen" There is no error and the script acts like it work fine without updating. I just did a test.php script

Re: [PHP-DB] Re: Again Select then update

2002-03-24 Thread Bill Morrow
On Sat, Mar 23, 2002 at 11:46:36PM -0800, Jen Downey wrote: > Hi all again! > > As Bill Morrow stated (in a private e-mail) I needed to use SET name = > \"$update\""; instead of SET name = $update"; > It has stopped giving the error but it isn't updating the table. Am I doing > something wrong? >

[PHP-DB] Re: Again Select then update

2002-03-23 Thread Jen Downey
Hi all again! As Bill Morrow stated (in a private e-mail) I needed to use SET name = \"$update\""; instead of SET name = $update"; It has stopped giving the error but it isn't updating the table. Am I doing something wrong? line 4 shows print("your name is $name"); The user name is printed to th