have 2 vars $Tech and $Admin and then chnage you SQL so it says: >$Query = "SELECT * FROM enet WHERE TechContact LIKE '%$Tech%' AND AdminContact LIKE '%$Admin%'"; Steve "Devon" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > $Query = "SELECT * FROM enet WHERE TechContact LIKE '%' AND AdminContact > LIKE '%'"; > > This query simply prints out my entire tables, is there a way using PHP so I > can make the '%' a user input so they can search the table under those > fields. > > Cheers > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]