bjorn82dk Posted June 5, 2015 Share Posted June 5, 2015 Hello all, First of all, sorry if related post have been answered in the past, been searching for days and haven't found the answers I have been looking for. I'm a beginner when speaking php and SQL so please be a bit patient with me. I need help to do a simple query from a msql db. I hope someone can provide me with a full example and then I should be able to modifie it to my own needs. I have a DB containing following fields: Id, Name, Astart, Aend, Bstart, Bend, Cstart, Cend, link What I need is 3 form field, A, B and C to be used as the filter. Value from field A should be between [Astart] and [Aend] AND value from field B should be between [bstart] and [bend] AND value from C should be between [Cstart] and [Cend]. In my head it should be extremely simple to do but I guess I took my mouth to full since I can't find out how to. Hope some one has a complete exampel I can look over and try to modifie to my own needs. Best regards, Bjørn Quote Link to comment https://forums.phpfreaks.com/topic/296653-simple-query-help-user-inputs/ Share on other sites More sharing options...
cyberRobot Posted June 5, 2015 Share Posted June 5, 2015 Have you tried using the WHERE clause? More information can be found here: https://dev.mysql.com/doc/refman/5.0/en/where-optimizations.html Quote Link to comment https://forums.phpfreaks.com/topic/296653-simple-query-help-user-inputs/#findComment-1513253 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.