$sql = "INSERT INTO table_name(ip,browser,received) VALUES('".mysql_escape_string($ip)."','".mysql_escape_string($browser)."',now())" ;
----- Original Message ----- From: "chip" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, November 27, 2001 4:39 PM Subject: Re: [PHP] Why doesn't this work? HTTP_USER_AGENT This is interesting. I did my testing in Opera 5.05 and it fails to display the page correctly. I then opened Netscape 6.2 and it works fine. Must be a problem with Opera. I also set Opera to identify itself as Netscape and it still failed to load the page. Thanks for the assistance. Chip On Monday 26 November 2001 11:11 pm, David Robley wrote: > On Tue, 27 Nov 2001 17:43, Craig Vincent wrote: > > <snip> > > What have I done wrong in such a simple bit of code? > > ------------------------- > > <html><head><title></title></head> > > <body> > > <? > > $browser = $HTTP_USER_AGENT; > > $ip = $REMOTE_ADDR ; > > $db = mysql_connect ( "localhost" , "username" , "password" ); > > mysql_select_db ( "database" , $db ); > > $sql = "INSERT INTO table_name(ip,browser,received) > > VALUES('$ip','$browser',now())" ; > > $results = mysql_query ( $sql); > > ?> > > <h1>Howdy</h1> > > </body></html> > > -------------------------------- > > </snip> > > > > I copy & pasted your code onto a test HTML page and modified the mysql > > commands to appropriately connect to my MySQL server. There was > > absolutely no problem with this code at all. What version of PHP are > > you using? > > Just about to do that but he saved me the effort. > > Any chance you created the script with DOS end of line characters?? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]