[PHP-DB] Anyone know why this won't return results?

2002-06-07 Thread Blaine Dinsmore
html head titleResults Test/title meta http-equiv=Content-Type content=text/html; charset=iso-8859-1 /head body bgcolor=#FF text=#00 ?php $server = mdotlims; $user = httpuser; $pass = pass; $db = mysql_connect($server,$user,$pass); if (!$db) {

Re: [PHP-DB] Anyone know why this won't return results?

2002-06-07 Thread Blaine Dinsmore
Thanks Paul, You were absolutely right! I can't believe I didn't see that hidden in there. That explains why I never got any error messages. Thanks again, Blaine Paul DuBois [EMAIL PROTECTED] 06/07/02 05:55PM At 17:45 -0400 6/7/02, Blaine Dinsmore wrote: html head titleResults Test/title

[PHP-DB] How do I get a ' in my sql statement?

2002-06-10 Thread Blaine Dinsmore
I have noticed that when I try to assign the value of a input field that has a ' in it for example : can't It will goof up my attempt to load the information to the database. Anyone know a way around this? Do I have to send each string through a parsing routine before assigning my string to

Re: [PHP-DB] How do I get a ' in my sql statement?

2002-06-10 Thread Blaine Dinsmore
Terry, Thanks for the tip on the nl2br function. That function proved to be very helpful when displaying data in a HTML table. I noticed the \n is ok when sending text to a form with multiline input boxes. Thanks, Blaine Terry Romine [EMAIL PROTECTED] 06/10/02 02:35PM Any text field that