Big trouble with mySQL db ?

[Pellefant]

Hello! 🙂

I am new to mySQL database, I guess I make some kind of a newbie error. There is no data added to the database, and it is no error msg given.

The database name is: user_tonydb and the table name is : reviews. I have granted access for the user to the database.

I really would be happy for any kind of help.

$Link = mysql_connect("localhost", "user_user", "password");
mysql_select_db("reviews", $Link);
$datum = date("Y-j-n");                       

echo "$datum <BR>\n";
echo "$typ <BR>\n";
echo "$artist <BR>\n";
echo "$title <BR>\n";
echo "$rating <BR>\n";
echo "$coverlink <BR>\n";
echo "$author <BR>\n";
echo "$authoremail <BR>\n";
echo "$reviewtext <BR>\n";
echo "$link1 <BR>\n";
echo "$link2 <BR>\n";

$Query = "insert into reviews( `datum, `typ` , `artist` , `title` , `rating` , `coverlink` , `author` , `authoremail` , `reviewtext` , `link1` , `link2` , `approved` , `clicks` ) 
values ( '$datum', '$typ',   '$artist', '$title', '$rating', '$coverlink', '$author', '$authoremail', '$reviewtext', '$link1', '$link2', '0','0')";
mysql_db_query ( "user_tonydb", $Query, $Link);

And get this output:

2003-4-16 
Show Review 
Madonna 
Like a virgin 
Decent 
none 
Scott 
[email][e-mail][/email] 
Great album, bla bla bla 
none 
none 

So I know there is data in all variables.

The design of the mySQL database looks like this:

Field  Type Attributes Null Default Extra Action 

id  int(10)   No    auto_increment  

datum  varchar(100)   Yes  NULL
typ  varchar(100)   Yes  NULL    

artist  varchar(100)   Yes  NULL    

title  varchar(100)   Yes  NULL    

rating  varchar(100)   Yes  NULL    

coverlink  varchar(100)   Yes  NULL    

author  varchar(100)   Yes  NULL    

authoremail  varchar(100)   Yes  NULL    

reviewtext  varchar(100)   Yes  NULL    

link1  varchar(100)   Yes  NULL    

link2  varchar(100)   Yes  NULL    

approved  tinyint(100)   Yes  0    

clicks  varchar(100)   Yes  0    

I am clueless now. 😕

[superwormy]

When you do your query, do this:

mysql_query ("select whatever etc. etc your query here") or die (mysql_error());

[Pellefant]

Originally posted by superwormy
When you do your query, do this:

mysql_query ("select whatever etc. etc your query here") or die (mysql_error());

Hello! 🙂

You mean like this, right?

mysql_db_query ( "user_tonydb", $Query, $Link) or die (mysql_error());

Now I get an error msg. 🙂

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 'typ,artist,title,rating,coverlink,author` ,

[superwormy]

OK, so now go through your query until you find yoru error :-)

And use mysql_query(), exerpt from PHP manual:

Note: This function has been deprecated since PHP 4.0.6. Do not use this function. Use mysql_select_db() and mysql_query() instead.

[superwormy]

Your error is in here btw...

reviews( datum,typ,artist` ,

[Pellefant]

Thanks, fixed now, but still same error 🙁

[spannah]

When you use:

mysql_select_db("reviews", $Link);

you are passing the table name as the database argument. You should use instead:

mysql_select_db("user_tonydb", $Link);

However, you could also eliminate the step above since you are selecting the database on the mysql_db_query function

You also missed a ` on you query right after datum, which could be causing the error message

[Pellefant]

Hi!

Thanks.

Now finaly I was able to get something (1983)into the database with this:

$Query = "insert into reviews(datum) values ($datum)";

🙂

Will try to add the ':s and the other variables one by one now. 🙂

[Pellefant]

This solved the problem 🙂 🙂 🙂

$Query = "insert into reviews(datum,typ,artist,title,rating,coverlink,author,authoremail,reviewtext,link1,link2,approved,clicks) values ( '$datum', '$typ', '$artist', '$title', '$rating', '$coverlink', '$author', '$authoremail', '$reviewtext', '$link1', '$link2', '0','0')";

Thanks all.