Nat

No worries - thanks for trying to help. I should prob. try to figure it out myself. Although any tutorials you can recommend would be great.

unfortunately I can't because it's an assignment and I don't want to get in strife but I will try and give a little bit more info. I'm stuck on the results.php page. On the search.php page I have a dynamically populated search list - linked to a table but there's a option called "Any" which if selected will retrieve all of the options within the selection list. But I need it to retrieve the result if only 1 of the options is selected also. Also another problem is that the options are represented by a number in another column of the table in MySQL, and I have to also link that to the options in the selection list. if you can recommend any tutorials or know what the problem could be would be most appreciated.

I'm stuck on the results.php page. On the search.php page I have a dynamically populated search list - linked to a table but there's a option called "Any" which if selected will retrieve all of the options within the selection list. But I need it to retrieve the result if only 1 of the options is selected also.

Hi, I have created a PHP page with a dynamically populated selection list and submit button. And another php page that is suppose to display the results in a table from MySQL. But haven't got the code quite right. Does anyone know some good tutorials for building search and results pages in PHP?

Hi, I have entered data into tables in phpMyAdmin. Then, I removed a couple of rows. Later, when I re-entered more data into the table it stuffed up the auto-incrementing. I think it may have something to do with the 'Next Autoindex' it didn't refresh when I deleted the rows. Does anyone know how to rectify this in phpMyAdmin?

I finally worked it out. $query = "SELECT first_name, last_name, sport, hobby FROM people, interests"; Thanks.

Hi, Let's say I have a database created in MySQL containing 2 different tables. For instance table 1 is called people and table 2 is called interests. I know how to retrieve a query when there's one table from a database, for instance: // Define a query that retrieves the names $query = "SELECT first_name, last_name FROM people"; However, what do I do when I want to get the info. from 2 different tables. I'm doing what's below but this isn't working. Any advice or direction would be greatly appreciated. // Run the query and store the result $result = mysqli_query($link, $query); // Define a query that retrieves the names and interest $query = "SELECT first_name, last_name FROM people, AND sport, hobby FROM interests"; // Run the query and store the result $result = mysqli_query($link, $query);

Thank you for the response... That makes sense... But, how would I add the answers of the radio buttons to the answer chosen of the checkboxes? Nat.

Hi, I've designed a form that contains some radio buttons and checkboxes. For instance, <p>Size:<br /> <input type="radio" id="sml" name="size" value="Small" /></label for="sml">Small</label><br /> <input type="radio" id="med" name="size" value="Medium" /></label for="med">Medium</label><br /> <input type="radio" id="lge" name="size" value="Large" /></label for="lge">Large</label><br /></p> <p>Colours:<br /> <input type="checkbox" id="green" name="hat[]" value="Green" /><label for="green">Green</label><br /> <input type="checkbox" id="red" name="hat[]" value="Red" /><label for="red">Red</label><br /> </p> Does anyone know how I can assign a dollar value to different options. So that if options are chosen it will calculate the price. For instance a small, red hat would equal different price to a large, green hat. Any guidance would be appreciated I can't find anything anywhere on this topic and I'm so lost.

Thank you so much 'HeyRay2'. You're a legend. You've solved my problem.

hi! Was wondering if anyone could help me with this problem. I have made a form consisting of an array of seven checkboxes. I'm trying to figure out how to write a php script to calculate 1 dollar for every checkbox chosen. Nat.