Php/mysql help needed

[dx3k]

hey

can you tell me what is wrong with this script please i keep getting "unexpected ) on line 18"

<?
include('sqlinfo.php');
$connect = mysql_connect($host, $account, $password);
$db = mysql_select_db("dx3k_logger)";       <<<< this is line 18
$query = "INSERT INTO ip VALUES (''$ip");

?>

thanks

dx3k

 

[adam_uk]

$db = mysql_select_db("dx3k_logger)";


should be

$db = mysql_select_db("dx3k_logger");

 

[dx3k]

still dont want to work

this is what i have now

<?
$ip = $REMOTE_ADDR;
echo "$ip"; 
?>
<?
include('sqlinfo.php');
$connect = mysql_connect($host, $account, $password);
$db = mysql_select_db("dx3k_logger");   <<< line 18
$query = "INSERT INTO 'ip' VALUES (''$ip");

?>

 

[flexiwebhost.com]

$query = "INSERT INTO 'ip' VALUES (''$ip");

that is wrong as well, you opened the quotes outside of the bracket but closed them in the bracket also wht do you have ''$ip

try :-

$query = "INSERT INTO 'ip' VALUES ('".$ip."')";

 

[dx3k]

now it is on about a T_STRING erro on line 18 ( i h8 this line lol) what is a t_string?




<?
include('sqlinfo.php');
$db = mysql_connect("$host", "$account");
mysql_select_db("dx3k_logger",$db);
$query = INSERT INTO `data` ( `ip` , `browser` )
VALUES (
'$ip'
);

?>



thanks

dx3k

 

[cerebus]

<?
include('sqlinfo.php');
$db = mysql_connect($host,$account);
mysql_select_db("dx3k_logger",$db);
$query = "INSERT INTO `data` ( `ip` , `browser` ) VALUES ('$ip')";
?>

That should work. Just note that you have two fields defined in the fields list and only one value, in case you intend to run the query.

I must really recommend you to read a few PHP beginner tutorials.

 

[dx3k]

i am already , most of the script i copyd from the book

 

[superprogrammer]

now it is on about a T_STRING erro on line 18 ( i h8 this line lol) what is a t_string?




<?
include('sqlinfo.php');
$db = mysql_connect("$host", "$account");
mysql_select_db("dx3k_logger",$db);
$query = INSERT INTO `data` ( `ip` , `browser` )
VALUES (
'$ip'
);

?>



thanks

dx3k

Can you print out the line 18 here?
Thanks

 

[cerebus]

One of the following ought to be line 18 as it aint enclosed in quotes:
$query = INSERT INTO `data` ( `ip` , `browser` )
VALUES (
'$ip'
);

 

[flexiwebhost.com]

you will need to enclose them in quotes, also why are you only assigning ip when your query should be inserting 2 lots of data (ip and browser)

 

[dx3k]

yer i got it to work now 100% my fault... i hadnt added myself as a user to the database :red: :red: i am an idiot :hehe: