digitalrain Posted June 30, 2006 Share Posted June 30, 2006 Hi there...I have a database that I've created that contains showtime information for aparticular TV show. The database contains the table 'show' which contains thefollowing fields:idCountryStateCityCableStationChannelTimeZone (timezone)Here's what I want to do:Have a form that displays a drop-down list of countries. If a country OTHER thanthe US is selected, the user just clicks 'search' and gets a formatted list ofshowtimes in that country like this:Here are our current listings for [Country name]:[cable network] [time] [zone][cable network] [time] [zone][cable network] [time] [zone]etc...If, however, the US is selected, a second drop-down list of US states appears.The user would select his/her state and then click 'search' and gets a formattedlist of showtimes in that state like this:Here are our current listings for [State name]:[city] [cable network] [station] [channel] [time] [zone][city] [cable network] [station] [channel] [time] [zone][city] [cable network] [station] [channel] [time] [zone]etc...Nothing I have tried is working. Any help would be MUCH appreciated.Thanks,Cynthia Quote Link to comment https://forums.phpfreaks.com/topic/13318-tearing-my-hair-out-hereplease-help/ Share on other sites More sharing options...
.josh Posted June 30, 2006 Share Posted June 30, 2006 you cannot make another dropdown magically appear like that with php. you need javascript for that. Quote Link to comment https://forums.phpfreaks.com/topic/13318-tearing-my-hair-out-hereplease-help/#findComment-51358 Share on other sites More sharing options...
digitalrain Posted July 1, 2006 Author Share Posted July 1, 2006 That I know :) I can get the non-search functionality of the formworking. It's just the search that doesn't work.<sigh>Thanks,Cynthia Quote Link to comment https://forums.phpfreaks.com/topic/13318-tearing-my-hair-out-hereplease-help/#findComment-51504 Share on other sites More sharing options...
Drumminxx Posted July 1, 2006 Share Posted July 1, 2006 post some code.your original post does sound like your trying to do something that will need to be done with javascript, however,you mention "search" is this a sql problem?post what you have that is not working Quote Link to comment https://forums.phpfreaks.com/topic/13318-tearing-my-hair-out-hereplease-help/#findComment-51510 Share on other sites More sharing options...
redarrow Posted July 1, 2006 Share Posted July 1, 2006 why not just use a normal form and let the form be controlled via the users ip and let the form show the revelent country via there ip.for example if the user like me was from the uk then the first country showing is uk. Quote Link to comment https://forums.phpfreaks.com/topic/13318-tearing-my-hair-out-hereplease-help/#findComment-51513 Share on other sites More sharing options...
.josh Posted July 1, 2006 Share Posted July 1, 2006 okay in your OP you seem to ask how to get a dropdown box to appear with states, if the user selects the USA as their country. That's a js solution. Unless you want them to choose the US in countries and then click a button, then you could have an if statement that checks for a GET or a POST variable to see if the countries dropdown matches USA. If yes, then echo out the states dropdown box. if no, then skip it. But your next post mentions having all that figured out, but something is wrong with the search? Please post your query string and what your expected results are. Quote Link to comment https://forums.phpfreaks.com/topic/13318-tearing-my-hair-out-hereplease-help/#findComment-51533 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.