justlukeyou Posted July 26, 2012 Author Share Posted July 26, 2012 "You can however manipulate the value after it's chosen. " I just dont understand this. Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1364730 Share on other sites More sharing options...
justlukeyou Posted July 27, 2012 Author Share Posted July 27, 2012 Hi, Does anyone have any suggestions please. I dont understand how following two points connect. INSERT INTO table (link, name) VALUES('reception-room', 'Reception Room'); "You can however manipulate the value after it's chosen. " Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1364951 Share on other sites More sharing options...
Jessica Posted July 27, 2012 Share Posted July 27, 2012 What happens BEFORE the insert query? Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1364952 Share on other sites More sharing options...
justlukeyou Posted July 27, 2012 Author Share Posted July 27, 2012 Theres an escape string and an empty query error message. Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1364953 Share on other sites More sharing options...
Jessica Posted July 27, 2012 Share Posted July 27, 2012 Okay, now I really give up. At over 400 posts you should know how to write a basic program and also how to ask intelligent questions and get help. Start over if you don't get it. Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1364955 Share on other sites More sharing options...
justlukeyou Posted July 27, 2012 Author Share Posted July 27, 2012 Im sorry but Im not just understanding what your getting at. What does happen BEFORE the insert query? That answer should would help massively. Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1364956 Share on other sites More sharing options...
Jessica Posted July 27, 2012 Share Posted July 27, 2012 I don't know, it's your code! Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1364959 Share on other sites More sharing options...
silkfire Posted July 27, 2012 Share Posted July 27, 2012 Gareth please consider taking a professional PHP course. The people here are tired of teaching you, it goes into one ear and exits the other after a minute. (No offense). Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1364960 Share on other sites More sharing options...
justlukeyou Posted July 27, 2012 Author Share Posted July 27, 2012 I don't know, it's your code! But I posted the code. Maybe you missed it. Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1364961 Share on other sites More sharing options...
justlukeyou Posted July 30, 2012 Author Share Posted July 30, 2012 HI, I have reread through this topic however I still dont understand what I need to do or what process to follow. Could someone please kindly explain what I need to do. Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1365460 Share on other sites More sharing options...
Pikachu2000 Posted July 30, 2012 Share Posted July 30, 2012 http://forums.phpfreaks.com/index.php?topic=361970.msg1712724#msg1712724 http://forums.phpfreaks.com/index.php?topic=361970.msg1716262#msg1716262 http://forums.phpfreaks.com/index.php?topic=361970.msg1718131#msg1718131 Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1365473 Share on other sites More sharing options...
justlukeyou Posted July 30, 2012 Author Share Posted July 30, 2012 Yeah thanks, but that doesn't help. Could someone please explain it very simple terms what I need to do. Do I select "Reception Room" from the drop down menu and then convert one into "reception-room" and then enter that into 'linkcategory'? Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1365482 Share on other sites More sharing options...
Pikachu2000 Posted July 30, 2012 Share Posted July 30, 2012 Why don't you try it and see? Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1365484 Share on other sites More sharing options...
justlukeyou Posted July 30, 2012 Author Share Posted July 30, 2012 Why don't you try it and see? I dont wish to be rude but that doesn't help. A simple yes or no would be a more suitable response. Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1365486 Share on other sites More sharing options...
Pikachu2000 Posted July 30, 2012 Share Posted July 30, 2012 How does trying something to see if it works not help? This site is here to help people learn, not to do their research, coding and testing for them. Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1365488 Share on other sites More sharing options...
justlukeyou Posted July 30, 2012 Author Share Posted July 30, 2012 How does trying something to see if it works not help? This site is here to help people learn. How does it help people learn? Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1365490 Share on other sites More sharing options...
Christian F. Posted July 30, 2012 Share Posted July 30, 2012 By stimulating people to think for themselves, not by spoon-feeding or doing everything for them. You, my good sir, have gotten stuck in a specific mindset, a mindset which is hindering you in seeing the solution to the problem (even though it's been explained in detail several times). Hell, you don't even see the problem itself clearly, evidenced by your lack of a clear and concise description of what you're trying to do. My advice is to take a couple of days off this issue, then come back and read up on how to do string manipulation, database access, and try to find a different way to build up this functionality. Doing that should, hopefully, break the pattern you're locked into by now. PS: I think you'll find this article educational reading. Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1365510 Share on other sites More sharing options...
justlukeyou Posted July 30, 2012 Author Share Posted July 30, 2012 By stimulating people to think for themselves, not by spoon-feeding or doing everything for them. You, my good sir, have gotten stuck in a specific mindset, a mindset which is hindering you in seeing the solution to the problem (even though it's been explained in detail several times). Hell, you don't even see the problem itself clearly, evidenced by your lack of a clear and concise description of what you're trying to do. My advice is to take a couple of days off this issue, then come back and read up on how to do string manipulation, database access, and try to find a different way to build up this functionality. Doing that should, hopefully, break the pattern you're locked into by now. PS: I think you'll find this article educational reading. Thanks, in many respects you are correct. How would you clearly explain the problem Im trying to solve. How should I phrase it differently? Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1365514 Share on other sites More sharing options...
Pikachu2000 Posted July 30, 2012 Share Posted July 30, 2012 How does trying something to see if it works not help? This site is here to help people learn. How does it help people learn? In the same way one learns to swim. Having someone swim for you teaches you nothing. Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1365519 Share on other sites More sharing options...
justlukeyou Posted July 30, 2012 Author Share Posted July 30, 2012 Bit confused. I asked... "Do I select "Reception Room" from the drop down menu and then convert one into "reception-room" and then enter that into 'linkcategory'?" I dont think that is me asking anyone to swim for me to do the work for me. That is me trying to found out what route I need to take to solve this problem because I haven't been able to make head nor tail of peoples previous answers. Although I am increbily for their help. Is that not the sort of question I should be asking? If so what sort of question should I be asking? Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1365525 Share on other sites More sharing options...
jazzman1 Posted July 31, 2012 Share Posted July 31, 2012 Bit confused. I asked... "Do I select "Reception Room" from the drop down menu and then convert one into "reception-room" and then enter that into 'linkcategory'?" I dont think that is me asking anyone to swim for me to do the work for me. That is me trying to found out what route I need to take to solve this problem because I haven't been able to make head nor tail of peoples previous answers. Although I am increbily for their help. Is that not the sort of question I should be asking? If so what sort of question should I be asking? Yes, you can do it without any problems. You need to insert the same value comes from drop down menu to different database columns. INSERT INTO tbl_name (col1,col2) VALUES('reception-room','reception-room'); Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1365587 Share on other sites More sharing options...
hakimserwa Posted July 31, 2012 Share Posted July 31, 2012 Bit confused. I asked... "Do I select "Reception Room" from the drop down menu and then convert one into "reception-room" and then enter that into 'linkcategory'?" I dont think that is me asking anyone to swim for me to do the work for me. That is me trying to found out what route I need to take to solve this problem because I haven't been able to make head nor tail of peoples previous answers. Although I am increbily for their help. Is that not the sort of question I should be asking? If so what sort of question should I be asking? Yes, you can do it without any problems. You need to insert the same value comes from drop down menu to different database columns. INSERT INTO tbl_name (col1,col2) VALUES('reception-room','reception-room'); how would you then specify which value is to go into a specific table field. i think some sourt of php needs to be done on the values to sperate it before its inserted to the database fields. the values comes as an array and then you use a foreach loop to to get the values the you implode the values and asign them to valuables after that you insert those values through the valuable to the right fields Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1365602 Share on other sites More sharing options...
justlukeyou Posted July 31, 2012 Author Share Posted July 31, 2012 Thanks, I did try this but couldn't get it to work. INSERT INTO tbl_name (col1,col2) VALUES('reception-room','reception-room'); So this is quote difficult then. Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1365839 Share on other sites More sharing options...
jazzman1 Posted August 1, 2012 Share Posted August 1, 2012 INSERT INTO tbl_name (col1,col2) VALUES('reception-room','reception-room'); Which part of this statement does not work ? Did you replace it with your tables and columns name ? Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1365844 Share on other sites More sharing options...
Jessica Posted August 1, 2012 Share Posted August 1, 2012 Yeah thanks, but that doesn't help. Could someone please explain it very simple terms what I need to do. Do I select "Reception Room" from the drop down menu and then convert one into "reception-room" and then enter that into 'linkcategory'? WHY DIDN'T YOU TRY DOING THIS? I smell a troll at this point. Quote Link to comment https://forums.phpfreaks.com/topic/265177-insert-2-values-from-drop-down-menu/page/2/#findComment-1365851 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.