ajg199 Posted April 28, 2009 Share Posted April 28, 2009 Keep getting the error: Parse error: syntax error, unexpected T_VARIABLE in /var/www/html/sship/search.php on line 21 Thank you for any help! AJ <html> <h2>Search</h2> <form method="post" action="<?php echo $PHP_SELF; ?>"> Search for: <input type="text" name="formfind" /> in <Select NAME="formfield"> <Option VALUE="SCHOL_NAME">Name</option> <Option VALUE="UWM_SCHOOL">School</option> <Option VALUE="AMT">Amount</option> <Option VALUE="REQ">Requirements</option> <Option VALUE="DLINE">Deadline</option> <Option VALUE="CONTACT_NAME">Contact</option> </Select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" /> </form> </html> <? require_once ('mysql_connect.php'); //This is only displayed if they have submitted the form $find = (_$POST['formfield']); if ((_POST['$searching']) =="yes") { echo "<h2>Results</h2><p>"; //If they did not enter a search term we give them an error if ($find == "") { echo "<p>You forgot to enter a search term"; exit; } // We preform a bit of filtering $find = strtoupper($find); $find = strip_tags($find); $find = trim ($find); //Now we search for our search term, in the field the user specified $data = mysql_query("SELECT * FROM sship WHERE upper($field) LIKE '%$find%'"); //And we display the results while($result = mysql_fetch_array( $data, MYSQL_ASSOC )) { echo $result['SCHOL_NAME ']; echo " "; echo $result['UWM_SCHOOL']; echo "<br>"; echo $result['AMT']; echo "<br>"; echo $result['REQ']; echo "<br>"; echo $result['DLINE']; echo "<br>"; echo $result['CONTACT_NAME']; echo "<br>"; echo $result['CONTACT_PH']; echo "<br>"; echo $result['CONTACT_EMAIL']; echo "<br>"; echo $result['WEBSITE']; echo "<br>"; echo "<br>"; } //This counts the number or results - and if there wasn't any it gives them a little message explaining that $anymatches=mysql_num_rows($data); if ($anymatches == 0) { echo "Sorry, but we can not find an entry to match your query<br><br>"; } //And we remind them what they searched for echo "<b>Searched For:</b> " .$find; } ?> EDITED BY WILDTEEN88: Please use code tags ( ) when posting code Quote Link to comment https://forums.phpfreaks.com/topic/156008-solved-php-search-function-help/ Share on other sites More sharing options...
Zhadus Posted April 28, 2009 Share Posted April 28, 2009 $find = (_$POST['formfield']); It should be: $find = ($_POST['formfield']); Quote Link to comment https://forums.phpfreaks.com/topic/156008-solved-php-search-function-help/#findComment-821279 Share on other sites More sharing options...
premiso Posted April 28, 2009 Share Posted April 28, 2009 $find = ($_POST['formfield']); if (($_POST['$searching']) =="yes") { Missing the $ before _POST Quote Link to comment https://forums.phpfreaks.com/topic/156008-solved-php-search-function-help/#findComment-821280 Share on other sites More sharing options...
ajg199 Posted April 28, 2009 Author Share Posted April 28, 2009 Thanks! knew it was something simple... Quote Link to comment https://forums.phpfreaks.com/topic/156008-solved-php-search-function-help/#findComment-821325 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.