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 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 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") 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. 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
Archived
This topic is now archived and is closed to further replies.