Re: PHP Newbee Question

Thanks for the tip. Unfortunately it didn't fix the issue. I am sorry about the way the address message is displayed. There unfortunately isn't anything I can do about it. Jeffrey Norsworthy MCP, CCNA Network Administrator Community Health Services norswj@chsmaine.org >>> Bogdan Stancescu <mgv@canad.ro> 07/02/02 10:15AM >>> Variable names are case-sensitive in PHP - try $HTTP_POST_VARS["first"] - or, for new versions of PHP, $_POST["first"]. In another train of thoughts, please use the proper e-mail address - I'm sure I'm not the only one using filters to automatically move mail to folders and your although probably valid according to the RFC, the way you formatted the php list e-mail address doesn't match the filter names... Thanks! Bogdan Jeffrey Norsworthy wrote: >Hello All, > I am new to PHP, and I am trying to design what I thought would be a fairly simple form, that > queries a MYSQL database for two fields, (first, and last name). It should then return the entire > results of the entry in the table. This part is actually 5 fields. > If I run the script with static entries for "first", and "last", the > process work flawlessly (as it should). If I try using variables for the search values, I do not > receive any results. I have tried changing the form method from post, to get, and the problem > continues. Any help would be greatly appreciated. Thank you. The first grouping is the html form, > the second set is the php form that actually performs the search. Also the username, and password > are populated in the actual script, I just took them out for the email. Thanks again. > ><html> ><head><title>Contact lookup form</title></head> ><body> ><form action="test.php" method="post"> >First Name: <input type="text" name="first"><br> >Last Name: <input type="text" name="last"><br> ><input type="submit" value="lookup"> ></form> ></body> ></html> > > > > > > > > > > ><?php >define ('mysql_host', 'localhost'); >define ('mysql_user', ''); >define ('mysql_pass', ''); >define ('mysql_db', 'chs'); > >if (! mysql_connect(mysql_host, mysql_user, mysql_pass) ) >{ > die('Failed to connect to host " ' . mysql_host . ' " . '); >} >else >{ > echo '' . mysql_host . '<br>'; >} > >mysql_select_db(mysql_db); >if ($http_get_vars['first'] && $http_get_vars['last']) >{ > echo $http_get_vars['first'] . ' ' . $http_get_vars['last'] . > '<br>'; >} >$result=mysql_query("select * from chs where first='$first' or >last='$last'"); >echo "<h2 align='center'>Results</h2>"; > >while ($row = mysql_fetch_array($result)) >{ > echo > "<b>{$row['first']}&nbsp{$row['last']}&nbsp&nbsp&nbsp{$row['branch']}&nbsp&nbsp&nbsp{$row['extension']}&nbsp&nbsp >&nbsp{$row['voice_mail']}&nbsp&nbsp&nbsp{$row['position']}</b> ><br>"; >} >?> > > > >Jeffrey Norsworthy MCP, CCNA >Network Administrator >Community Health Services >norswj@chsmaine.org > > > Mail scanat cu RAV Antivirus! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php