$DB = "dbproj1"; $HOST = "localhost"; $USRNAME = "dbs"; $PSSWD = "********"; //Use real password here if( !@mysql_connect($HOST, $USRNAME, $PSSWD) ) { print "Error connecting to $DB"; exit(0); } else { //Can build sql string dynamically $sqlstr = "SELECT * FROM vendor WHERE name LIKE '%"; $sqlstr .= $name; $sqlstr .= "%' "; $sqlstr .= $tie; $sqlstr .= " state LIKE '%"; $sqlstr .= $state; $sqlstr .= "%';"; $result = mysql_db_query($DB, $sqlstr); if ( $result == 0 ) { print "Invalid Query"; }?>