sooy Posted June 4, 2012 Share Posted June 4, 2012 Hello good people here's the thing i have a database in phpmyadmin called records in the records database i have two tables each with a field function ive made a form in php in which a user can insert his function then i want to compare that user input with a predefined function field in the other table Thank you very much Quote Link to comment https://forums.phpfreaks.com/topic/263626-database-sqlphp-comparing-two-table-fields/ Share on other sites More sharing options...
awjudd Posted June 4, 2012 Share Posted June 4, 2012 Write a SELECT statement to run after they post to validate the function type? ~awjudd Quote Link to comment https://forums.phpfreaks.com/topic/263626-database-sqlphp-comparing-two-table-fields/#findComment-1351081 Share on other sites More sharing options...
sooy Posted June 4, 2012 Author Share Posted June 4, 2012 im sorry to ask but could you help write one i tried the whole day without succes $result = $mysqli->query("SELECT naam FROM personalia WHERE naam LIKE (SELECT bedrijfsnaam FROM vacaturelijst") Quote Link to comment https://forums.phpfreaks.com/topic/263626-database-sqlphp-comparing-two-table-fields/#findComment-1351087 Share on other sites More sharing options...
fenway Posted June 16, 2012 Share Posted June 16, 2012 What are you trying to do? That looks like it should be a JOIN. Quote Link to comment https://forums.phpfreaks.com/topic/263626-database-sqlphp-comparing-two-table-fields/#findComment-1354389 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.