i need a script that can search the my sql and show me the user searched the site is http://parks.no-ip.org/ptc2
$lookupUsrs = mysql_query( "SELECT Account,OtherInfo FROM `table` WHERE `Account` LIKE ".$input." OR `Account`='".$input."'" ); while( $row = mysql_fetch_array( $lookupUsrs ) ) { echo $row[ "Account" ]; echo $row[ "OtherInfo" ]; } PHP: I use MSSQL rather than MySQL, but the above should work. EDIT: Sorry, mis-read what you said. The above will list all accounts that partially match or fully match whatever you searched.