Php/mysql help needed

dx3k · Jan 4, 2005

hey

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

PHP:

<?
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 · Jan 4, 2005

$db = mysql_select_db("dx3k_logger)";

should be

$db = mysql_select_db("dx3k_logger");

dx3k · Jan 4, 2005

still dont want to work

this is what i have now

PHP:

<?
$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 · Jan 4, 2005

$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 · Jan 4, 2005

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 · Jan 4, 2005

<?
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 · Jan 5, 2005

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

superprogrammer · Jan 5, 2005

dx3k said:
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 · Jan 6, 2005

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 · Jan 6, 2005

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 · Jan 6, 2005

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:

Php/mysql help needed

Established Member

Established Member

Established Member

Established Member

Established Member

Established Member

Established Member

VIP Member

Established Member

Established Member

Established Member

OffLease.com

emiratesbd.com

Ubms.com

PeakStore.com

Syntrix.com

jupoo.com

Online.Business

SweetWise.com

MSQL.com

pexell.com

Similar threads

We're social

OffLease.com

emiratesbd.com

Ubms.com

PeakStore.com

Syntrix.com

jupoo.com

Online.Business

SweetWise.com

MSQL.com

pexell.com

Pinned

Appreciation

Preference

Appreciation

Upvoting

Agreement

Answers

Decisions

Relevance

Reaction

Facial expressions

Vocal expressions

Status

Workflow

Clarification

Feeling

Sympathy