Insert into table... Variable errors?

Oni

Heyas...

I have a small problem which I've been working on for a while...

$query = "INSERT INTO tbl(username,ip,link) VALUES("Brin' . $result['id'] . '","$REMOTE_ADDR","http://www.domain.com/sub/start.php?username=Brin"' . $result['id'] . ' )";
mysql_query($query);

Any ideas? Ty 😉

Oni

$query = "INSERT INTO tbl(username,ip,link) VALUES("Brin' . $result['id'] . '","$REMOTE_ADDR","http://www.domain.com/sub/start.php?username=Brin"' . $result['id'] . ' )";
mysql_query($query);

If it's easier to read...

I tried to put \s before the // so that it doesn't see it as a note as in don't execute anything after the //

but that didn't help..?

Oni

eh?

Rodney_H_

Edit: This might help with your query statement:

<?php
$query = "INSERT INTO tbl(username,ip,link) VALUES('Brin" . $result['id'] . "'," . $REMOTE_ADDR . ",'http://www.domain.com/sub/start.php?username=Brin'" . $result['id'] . "')";

$results = mysql_query($query) or die('<p>Query failed: ' . mysql_error() . '</p>');
?>

HTH. 😃