mysql_query()

[strix]

I only started learning PHP and mySQL yesterday... so forgiveme for being so stupid...

But... i call this line in my PHP code

mysql_query("INSERT INTO requests (Artist,Title) VALUES ($Artist,$Title);");

and it doesn't insert it into the db...

but if i add things directly (ie using mysql.exe) i can get them to show when i run my code

Can any one help

[pootergeist]

try ....

mysql_query("INSERT INTO `requests` (Artist,Title) VALUES ('$Artist','$Title')");

note: $Artist / $Title / Artist / Title and requests all need to be case sensitive correct.

subnote: if mysql breaks, just add
echo mysql_error();
after the query line to get some hints of what is wrong.

[strix]

Thanx for your help

echo mysql_error();
was useful.

For some reason it works like this...

mysql_query("INSERT INTO requests(Artist,Title) VALUES ('$Artist','$Title');");