Insert sql into existing row...please help!

[hostcord]

One look at my code and should understand what I'm doing...

$query = "UPDATE fonts SET default = '".$fontname."' WHERE fontfoldername = '".$fontfolder."'";
echo $query."<br />";
$result = mysql_query($query) or die(mysql_error());  ; 

but if not I wanna insert data into a column of a certain row that already exists...grabbing the row by the other column value...

please help I have searched everwhere.

[thorpe]

Explain what it is you want to do and why your code isn't working.

[hostcord]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'default='akaDylan Open.ttf' WHERE fontfoldername = 'akadylan'' at line 1

is my error

I'm trying to look for a row where the fontfolder name is one thing and then insert into the other column (default) a value.

UPDATE fonts SET default='akaDylan Open.ttf' WHERE fontfoldername = 'akadylan'

is the query echo - looks good doesn't it?

[notaloser]

just test the query without a . in the default value.. i think you are getting a syntax error because of the . in akaDylan Open.ttf, and in that case you will have to escape it

[Drakla]

Default is a reserved word in MySQL so it needs to be sorrounded by them clicky things if you want to use it as a column name

SET default = 'whatever'