Ok, so I'm making some arcade administration software so I don't have to add games the hard way, well anyway, one of the features I have is that on the homepage is a featured author and as such I just have it so it updates one line in the mySQL. Well, the page with the form passes on the varibles fine and the updating page recieves them because I echoed everything, then I build the query and I even echo the query and it comes out exactly how I want it to, but for some reason, the database itself won't update even though all the varibles are there.

Here's my update page



Any help, I would greatly appreciated.

Thanks

I believe you're missing one important line of code:
If you don't select which database to use, then it's not going to work the way you intended it to work.

Thank you so much, I can't believe I forgot such a silly, but important thing.

Updation Problem in MySQL
Mysql Won\'t Update

I have a problem in MySQL. When more than one client update same table as the same time,it won't work. So, how do I make out for it? example:In real-time application, one of my client updating same table and same column and at the same time one of my other client also updating the same table and same column, but only one updation is allowed and the other wont work. Can you solve this and let me know?

-question by Karthik

Hmm

I think u forgot to select the DB.

And you see, on this line 'mysql_connect(localhost,$username,$password);'
I think you should type localhost between quotes, like this "localhost", or "127.0.0.1"

And after that , select db
mysql_select_db($database);

And for the update query
if(mysql_query("UPDATE table SET column = 'lolz' WHERE id = '17'")){
echo "updated!";
} else {
echo "something went wrong ";
}

@ Trap_FeedBacker:

I dont think you can fix that, at least dont know how, im sorry.
I dont see the problem if multiple queries are being submitted at one time, that shouldnt be a problem
for mysql.

- optiplex