Variables while inserting into database?

[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 😉

The // before the www. seem to mess up the code as in it thinks that everything behind the // is are just comments...

Maybe just www.domain.com... would work?

[qolbu]

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

😃

[Oni]

ehh :rolleyes:

And another thing... It's really easy so I didn't wanna waste another topic on it...

I have some code that will give us the browser type

include('browser_detection.php');

if $browse_type = 'IE'

Then:

I haven't tested this code but I know something is wrong with it because that's not the way if then statements are written in php....

I have some script which I want to execute only if the browser is 'IE'...
Because other then that there's firefox which is worth mentioning and seeing that my code doesn't work with firefox I want it to run only if its an IE browser...

Thanks!! 😃

[Oni]

qolbu wrote:

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

😃

The code worked..As In it didn't give any errors when the php was run. But now that I look at the table...Which I'm looking at using MySQL command line function...it says that it's blank? As in nothings entered into the database?? I'm sure Im looking at the correct place...It's just not there 🆒

what to do... :o

[Oni]

Eh?