Re: Why doesn't this work? HTTP_USER_AGENT

$sql = "INSERT INTO table_name(ip,browser,received) VALUES('".mysql_escape_string($ip)."','".mysql_escape_string($browser)."',now())" ; ----- Original Message ----- From: "chip" <chip@wiegand.org> To: <huntsman@www.nisu.flinders.edu.au>; <php-general@lists.php.net> 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: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net