[SOLVED] PHP MYSQL PROBLEM <-Please Help

[paulman888888]

<?php require('connect.php'); ?><?php

 

$ipaddress=$_SERVER['REMOTE_ADDR'];

$thedate=date("m:d:y");

$thetime=date("H:i:s")

mysql_query("INSERT INTO intowar1 (ipaddress, thedate, name, thename) VALUES($ipaddress, $thedate,'" . mysql_real_escape_string($_GET['name']) . "', $thetime)") or die('Theres an error. Please try again.#'); 

 

 

 

?>

I know its something to do with the quotes, i dont understand them.

 

thankyou

[unidox]

Try this:

 

<?php require('connect.php'); ?><?php

 

$ipaddress=$_SERVER['REMOTE_ADDR'];

$thedate=date("m:d:y");

$thetime=date("H:i:s");

mysql_query("INSERT INTO `intowar1` (ipaddress, thedate, name, thename) VALUES ('$ipaddress', '$thedate','" . mysql_real_escape_string($_GET['name']) . "', '$thetime')") or die("Theres an error. Please try again.");

 

 

 

?>

[paulman888888]

i get this error.

Theres an error. Please try again.

So what part have i done wrong?

thankyou

[ober]

You need to surround all of those inputs with single quotes... they're all strings. The only time you can leave off the single quotes is if the value is strictly an integer or a float.

 

Also, always use " or die (mysql_error()). That will be much more descriptive.

 

mysql_query("INSERT INTO intowar1 (ipaddress, thedate, name, thename) VALUES('$ipaddress', '$thedate','" . mysql_real_escape_string($_GET['name']) . "', '$thetime')") or die('Theres an error. Please try again.#');