[RESOLVED] update function????

[gszauer]

Question, i found the following script:

$query = "UPDATE Class SET class_id = 10 WHERE class_id = 3";
mysql_query($query); 

My database is set up like so

CREATE TABLE vexour(
id int(11) NOT NULL auto_increment,
track_title varchar(50) NOT NULL default '',
band_name varchar(50) NOT NULL default '',
song_name varchar(50) NOT NULL default '',
song_url varchar(50) NOT NULL default '',
image_url varchar(50) NOT NULL default '',
band_url varchar(50) NOT NULL default '',
stars decimal(1,1) NOT NULL default '3',
PRIMARY KEY  (id)
)

Now, i want to replace the stars value of an entery, but i can only relate it to the track_title.... so the code would be:

$query = "UPDATE Class SET stars= $stars WHERE track_title= $current";
mysql_query($query); 

$stars being the new value of the ammount of stars i want, and $current being the current track title....

Did i get this right?

So the code would be

[AIS4U]

gszauer:

Did i get this right?

Nope! I don't think so.

First of all, I don't know where you "found" that code, but there must have been more to it than just those couple of lines.

The basic syntax for UPDATE starts with: UPDATE tablename.

So, since your table name is vexour, it would be UPDATE vexour.

Then you use SET and the column name you want to change.

So, in your case, yes you did get that part right. SET stars.

Then you have stars= to the variable $stars which is ok if the variable $stars is going to refer to the value you want stars to have or you could just enter the value that you want stars to have such as stars = 4.

Next you have your WHERE clause and, again that is ok if the variable $current is going to refer to the value you want title_track to have. This is the same as with stars, you could just use whatever the actual value of title_track is, like title_track = abcdef.

However, none of this is going to work unless you write PHP code to connect to MYSQL and Select the database that the table vexour is in.

It is also a good idea to run a select query on the database table to make sure the record you are about to change is the one you want to change.

Then after the UPDATE you should also include an If statement using mysql_affected_rows( ) to verify that the UPDATE did happen.

If you don't have a good book on PHP/MYSQL then it might be a good idea to go to the on-line manuals and do a little reading on updating databases.

Hope this help you at least a little bit.

Good Luck

[gszauer]

It helped greatly, thank you, yes there is more to the code than the sniplet, but i only needed help with the sniplet, so i thought that's the only part i'd post.
Thank you wery mutch for the help, it is really appriciated
~Gabor