Joining the two

[paulman888888]

I have my php script that sends data to mySQL and i would like to also send the date (and time if its easy) and IP address.

 

<?php
// Insert a row of information into the table "example"
mysql_query("INSERT INTO example 
(name, score) VALUES('" . mysql_real_escape_string(substr($_GET['name'], 0, 13)) . "', '" . mysql_real_escape_string($_GET['score']) . "')") 
or die('Theres an error.# Please try again.#');  
echo "Score Uploaded!#";
?>

 

and this is my other page

<?php
if($_SERVER['HTTP_X_FORWARD_FOR'])
{
    $ip = $_SERVER['HTTP_X_FORWARD_FOR'];
}
else
{
    $ip = $_SERVER['REMOTE_ADDR'];
}

mysql_query("INSERT INTO ips (ip) VALUES ('{$ip}')");
?>
<?php
$today = date("m.d.y"); 
mysql_query("INSERT INTO date (date) VALUES ('{$today}')");
?>

I would like all the information to go into the same database.

Please help.

[GingerRobot]

Sorry, what's the problem?

 

If you're inserting into 3 different tables then you have you to use 3 separate queries.

[radar]

the code you got for ip should be okay... 

 

mysql_query("INSERT INTO ips set ip = '$_SERVER[REMOTE_ADDR]'");

 

and for date:

 

mysql_query("INSERT INTO date SET date = now()");

 

and it'll give you the date and time....

 

-- radar

 

 

[paulman888888]

i would like all of them to go into the same table.

But i dont know how please help

[radar]

Well first off you need to have the columns in the table for it...

 

 

So instead of 3 tables you would have 1 table with 4 colums (or more) -- name, score, ip, date (date_time)

 

then do...

 

$sql = "INSERT INTO example SET

name = '".$name."',

score = '".$score."',

ip = '".$ip."',

date_added = now()";

mysql_query($sql);

 

and there ya go...  it would add all of them into the same table.