What wrong with this query ?

[GregT]

PHP tells me this query is invalid

$insert = mysql_db_query("INSERT INTO ds_articles VALUES ('$name','$text','$authorn', '$date')");

Warning: Wrong parameter count for mysql_db_query() in /home/zero/public_html/devplace/beta/admin/newarticle.php on line 21

Adding it manually like this

INSERT INTO ds_articles
VALUES (
'Test Article', 'Testing !!! 123...', 'Zero', '12.02.05'
)

through phpmyadmin works

Please help me !

 

[dawizman]

It's mysql_query, not mysql_db_query:

$insert = mysql_query("INSERT INTO ds_articles VALUES ('$name','$text','$authorn', '$date')");

 

[GregT]

Yea, i figured that out a couple seconds after I posted

 

[GregT]

Now I have another question, I get no errors on this, but when I do it the author table comes up empty

 $result = mysql_query("SELECT `nickname` FROM `ds_users` WHERE username='" . addslashes($author) . "' LIMIT 1");
 $author = mysql_fetch_row($result);
 addslashes("$name");
 addslashes("$text");
 addslashes("$author");
 addslashes("$date");
 
 $insert = mysql_query("INSERT INTO ds_articles VALUES ('$name','$text','$author', '$date')");

I believe it's because of improper use of mysql_fetch_row ?

 

[GregT]

Edit: Figured it out again, i was missing $author = $author[0];