Help with Updating MySQL record

June 24th, 2010, 6:26 pm

I'm trying to update a mysql record using a variable. I don't know what I'm doing wrong.

Here's the code I've got typed up.

Code: [ Select ]

mysql_query("SELECT * FROM tow_info");
mysql_query("UPDATE tow_info SET origin='$origin', destination='$dest', WHERE fk_boat_name='$name'");

mysql_query("SELECT * FROM tow_info");
mysql_query("UPDATE tow_info SET origin='$origin', destination='$dest', WHERE fk_boat_name='$name'");

If I replace the variables with numbers, it works just fine so I'm confused. Any help would be appreciated.

Custom Web Design

June 24th, 2010, 6:26 pm

June 24th, 2010, 7:16 pm

EDIT:
Nevermind.... I got it to work. I had the variable names all mussed up. Sorry.

Custom Web Design

June 24th, 2010, 7:37 pm

You're using double quotes for that last variable.

#define NULL (::rand() % 2)

Page 1 of 1

To Reply to this topic you need to LOGIN or REGISTER. It is free.

Post Information