mysql - Created new table OK but? 1

[4x4uk]

Please bear with we I,m new to using mysql. I created a table called stats in a database called mylandy, which already existed. However using the following php script nothing is written to the table. What am I doing wrong.
mysql version 3.23.49a, table created using mysqltool v.095

$db = mysql_connect("cdb-1.prv.ampira.com:3307" , "imcco" , "r990jcu");
mysql_select_db("mylandy", $db);
$sql = "INSERT INTO stats(ip,date,browser,referrer,request,cpu,screen,colour,javascript,cookies) VALUES ('$ip','$dtime','$agent','$ref','$svreq','$uspc','$ussd','$ussc','$usjs','$uscs')";
$results = mysql_query ($sql);

Thanks
Ian It's not a lie if you believe it!

http://www.ne4x4.org.uk/

http://www.ne4x4.org.uk/Ian/

http://www.ne4x4.fsnet.co.uk/beck/

 

[sleipnir214]

What is the value of $result after you perform mysql_query()? If the query fails, $result will be false.

If $result is false, output the return of mysql_error(). It will tell you pretty explicitly what your error is.

I have a FAQ (faq434-2999) in this forum which has some example code for writing simple MySQL access code that produces good debugging information. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[4x4uk]

Many thanks for the quick response and your help faq. I ran your test script and ironed out the problem. I had misstyped a character for the server. Everything works as expected now.

Regards
Ian It's not a lie if you believe it!

http://www.ne4x4.org.uk/

http://www.ne4x4.org.uk/Ian/

http://www.ne4x4.fsnet.co.uk/beck/

 

[sleipnir214]

FYI:

I don't know if the connection information you're passing to your mysql_connect() function is real or not, but it looks suspiciously real to me.

When posting code, I recommend you replace the host, user, and password options with innocuous bogus data. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[4x4uk]

It looks real but quite a few of the characters were altered prior to posting just in case. It's not a lie if you believe it!

http://www.ne4x4.org.uk/

http://www.ne4x4.org.uk/Ian/

http://www.ne4x4.fsnet.co.uk/beck/

 

[sleipnir214]

I recommend just changing them to "host", "user", "password".

Somebody might try to decode your mangling, and might just succeed. Although MySQL's user/password/IP authentication tuple will likely keep them out, someone might DOS you or use some security hole he knows about but you don't. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[4x4uk]

Ok will do
It's not a lie if you believe it!

http://www.ne4x4.org.uk/

http://www.ne4x4.org.uk/Ian/

http://www.ne4x4.fsnet.co.uk/beck/