Not Inserting Into Database

[Jackthumper]

if (($update_avatar1 == 'http://images.toxicpets.co.cc/vPets/Acara11.gif') OR ($update_avatar1 == 'http://images.toxicpets.co.cc/vPets/Aisha5.gif'))
{
mysql_query("UPDATE avatar SET avatar = '$update_avatar1' WHERE username = '$username' AND game = '$game'") or die ("Database error: ".mysql_error());
mysql_query("INSERT INTO avatar ($update_avatar1 WHERE id = '$userid')");

This is an avatar System But It Is Not Inserting Into The Database

[Pikachu2000]

UPDATE avatar SET avatar

 

Your table and field names are the same?

[Jackthumper]

This Is The Database

[Pikachu2000]

The first query should work as long as all the variables have the proper values. Have you echoed the query string to make sure? The second query is using improper syntax.

[Jackthumper]

The Second Query Was Wrong But How Will It Insert If There Is No Table To Update???

[Pikachu2000]

What do you mean? Can you explain exactly what it is you want that code to do, please?

[Jackthumper]

I want it to update but if the user has no table in the database i want it to create one with there userid ,username  and game which is '1'

 

[Pikachu2000]

Have a read through INSERT . . . ON DUPLICATE KEY UPDATE syntax, and see if that sounds like what you need.

[Jackthumper]

I don't Get That it has (a,b,c) VALUES (1,2,3)