dropbop

For now I just want to move on to the next part, I will however be going back over most of the code again near the end to give it all a good clean up. Im learning so much from this forum, have been popping in and out for a good while, and really glad of the few bits of help I got from it so far. Thanks again guys Eoin

YEAH!!! Finally got it to work!!! Really appreciate the help guys... Although they were not the solutions I needed for this particular bit, I have learned a bit more today. A simple little 'if' was the man for the job. Thanks again guys for taking the time to help me, it wont go unforgotten. Eoin PS: I dont see any Thank You or Helped buttons or I would have been clicking the whole way down the thread

I am back again after trying all day again with no joy. I have tryied the above but its just not working. I though that if I used an if statement to do it, that it might work but it only seems to be outputting the first one ie. 1 - Dublin Maybe im doing it wrong. $county=$_POST['county']; if ($county = "1") { $countyname = "Dublin"; } elseif ($county = "2") { $countyname = "Westmeath"; } elseif ($county = "3") { $countyname = "Galway"; }

Is there a reason the hidden field in second form needs to be populated with the county name? Couldn't you keep passing the number? Then you would just use the switch method to get the county name in the end. Hi, yes the number of the county is used for a categoryID in the database and the name of the country needs to be shown on the websites front end. The database is of a Zen Cart site that the info is inserted into. So if someone chooses Dublin for instance, then the details are inserted in the Dublin category with a catagory ID of the master category '1'. There is an email sent to the person who filled in the form showing all the details they filled in including the county. Also when the form is submitted, it creats a txt file which is actually a download product that contains the full details of what was submitted in the form... Im not sure if im explaining myself very well here but I will try and shorten it down for you. A person is looking for quotes for their timber decking project... 1) the person fills in the form with the personal and project details 2) the form is submitted and the details are sent in 3 ways job details inserted into database full details emailed to person looking for quote txt file created as a downloadable attribute which can be purchased by contractors (this file contains the full details also, which inludes the county in the address part) 3) The job details are on display on zen cart front end as products 4) Contractors purchase the products (leads) and download the full details so they can contact the potential client and provide a quote. If i am confusing anyone, please let me know because I think I am starting to confuse myself lol here it is if you need to see it for yourself www.timberdecks.ie and the zencart where the contractors will purchase leads is here www.timberdecks.ie/trades I will try what you guys have suggested so far and see if any works, hopefully it will and I will be able to move on to the next stage. Thanks all for your replies so far, very much appreciated indeed. Eoin

Hi, I have a form with a dropdown <select name="county" id="county"> <option selected="selected">Choose A County</option> <option value="1">Dublin</option> <option value="2">Westmeath</option> <option value="3">Galway</option> <option value="4">Roscommon</option> </select> What I am trying to do is seperate for example the value '1' and the option 'Dublin'. The results are passed to hidden field on a second form page. This is what I have, but it doesnt seem to be working... <input type="hidden" name="county" value="<?php echo ($_POST['county']); ?>" /> <input type="hidden" name="county1" value="<?php echo ($_POST['county']); ?>" /> so I was wondering if anyone might be able to give me a pointer in the right direction. I have tried using an array on the processing page to split it but its not working either.. like this: $county = (float) $_POST['county']; $county1 = in_array($county, array(1, 2, 3, 4)) ? $county : 5; $county1 = $_POST['1']='Dublin'; $county1 = $_POST['2']='Westmeath'; $county1 = $_POST['3']='Galway'; $county1 = $_POST['4']='Roscommon'; $county1 = $_POST['5']='Cork'; I have been trying to get this to work for a few days and I have searched everywhere for the answer, but I can't find it anywhere. I would be so grateful if someone could help me with this and it the last part I need to do before I move on to the next part of my project. Thanking you Eoin

Sorted it $price = (float) $_POST['budget']; $price = in_array($price, array(1, 2, 3, 4, 5, 6)) ? $price : 7; $budget = $_POST['1']='Up to 500'; $budget = $_POST['2']='500 to 1000 Euros'; $budget = $_POST['3']='1000 to 1500 Euros'; $budget = $_POST['4']='1500 to 3000 Euros'; $budget = $_POST['5']='1000 to 2500 Euros'; $budget = $_POST['6']='1000 to 2500 Euros'; $budget = $_POST['7']='No Budget Set Yet'; Thanks to your code SamT.... much appreciated! Drinks on me

Actually I think I may have been a little premature in checking the results properly. I am finding that the price is being inserted as it should depending on the value selected from the 'budget' dropdown. But I also have a field in my database to insert the value from budget but now its inserting the price associated with the value. So for example, if someone selects 500 to 1000 Euros as a value, it is now inserted into the database as '5.00' instead of the string of text - '500 to 1000 Euros'. It might be best explained if you could see it in action... On this page www.timberdecks.ie there is a form that is filled in, which is then processed and the results inserted into the database. Those results are actually products in a zencart site here: www.timberdecks.ie/trades/ I you were to put some sample data into the form and submit it, then to the zencart part of the site. You will notice the data you sent in the form for 'budget' is showing the price instead. Here is a snippet from my form processing page: <?php $name=$_POST['name']; $email=$_POST['email']; $telephone=$_POST['telephone']; $address=$_POST['address']; $size=$_POST['size']; $material=$_POST['material']; $handrail=$_POST['handrail']; $description=$_POST['description']; $timeframe=$_POST['timeframe']; $termsagree=$_POST['termsagree']; $date= date("F j, Y"); $model = time(); $processed=$POST['processed']; $county=$POST['Dublin']='1'; $county=$POST['Westmeath']='2'; $county=$POST['Galway']='3'; $county=$POST['Roscommon']='4'; $budget = (float) $_POST['budget']; $price = in_array($budget, array(3.50, 4.00, 4.50, 5.00, 5.50, 6.00)) ? $budget : 4.00; $query = "INSERT INTO zen_products (products_id, products_model, products_quantity, products_image, products_date_added, products_status, master_categories_id, products_price, manufacturers_id, products_size, products_material, products_handrail, products_timeframe, products_budget) VALUES ('$model', '$model','3','product.jpg', NOW(), '1','1', '$price', '0','$size', '$material', '$handrail', '$timeframe', '$budget')"; mysql_query($query) or die(mysql_error()); mysql_close(); ?> <?php mysql_connect ($dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error()); mysql_select_db($dbname) or die(mysql_error()); $query = "INSERT INTO zen_products_description (products_id, language_id, products_name, products_description) VALUES ('$model', '1', 'Quote Request $model', '$description')"; mysql_query($query) or die(mysql_error()); mysql_close(); ?> <?php mysql_connect ($dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error()); mysql_select_db($dbname) or die(mysql_error()); $query = "INSERT INTO zen_products_to_categories (products_id, categories_id) VALUES ('$model', '$county')"; mysql_query($query) or die(mysql_error()); mysql_close(); ?> Any ideas? regards DB

That has worked perfectly, I haven't done anything in arrays really up to now, so this has been a great learning curve for me. Just in case your wondering what I am doing, I am trying to use a use a form to import data as products to a zen cart site. And thanks to you I know how to set prices depending on what budget option is chosen and inserted into my products table, without having to go near the zencart admin. Your help is very much appreciated indeed. Hopefully I will be able to answer other peoples questions as I learn more and more. Thanks again DB

Hi, I have been on and off this forum loads of time and it has helped me out so much over the past few months with different projects. But today there is one thing i simply cant figure out or find any kind of answer anywhere and would be really grateful if someone could give me a pointer. I have a form which which i use to input data into a mysql database. One of the variables $budget=$_POST['budget']; which I use to add data to the 'budget' field in my database. In the form, budget is a dropdown with a few options: <select name="budget" id="budget"> <option selected="selected">Please Choose One</option> <option>up to 500 Euros</option> <option>500 to 1000 Euros</option> <option>1000 to 1500 Euros</option> <option>1500 to 3000 Euros</option> <option>3000 to 5000 Euros</option> <option>Over 5000</option> <option>No Budget Set Yet</option> </select> I have another field in my database called 'price'. What I would like to do is, if someone chooses a budget of 3000 to 5000 I would like this to enter 5.00 in the price field in the database. I have tried a number of things, but nothing is working for me. This is where I am at now, which doesn't work either but thought it might give a better explanation of what I am trying to achieve. $budget=$_POST['budget']; $price=$budget['up to 500 Euros']='3.50'; $price=$budget['500 to 1000 Euros']='5.00'; $price=$budget['1000 to 1500 Euros']='4.50'; $price=$budget['1500 to 3000 Euros']='5.00'; $price=$budget['3000 to 5000 Euros']='5.50'; $price=$budget['Over 5000']='6.00'; $price=$budget['No Budget Set Yet']='4.00'; Also keep in mind that there is no 'price' field in the form. So no price is being posted to the processing page. I need to price to be worked out by what is posted from the budget field. This is the only thing I am stuck with without having to ask for any help, and these forums have been a saviour to me and an excellent place for learning. But sometimes I think you have to give in and just ask for help! lol Many thanks, DB