drop down menu appear php

timmybuck

Hi Guys,

I have a page that that displays tickets for an event. However when the ticket information is

displayed i would like one of the fields to have a drop down menu appear so that people choose adult

or child ticket. There is a corresponding price difference eg adult tickets cost $10.00 and the

child costs $5.00. The field name that should display a drop drop down menu is tickettype

How would i go about making this drop down menu appear, is having a drop down menu even a good

solution for this

timmybuck

No worries guys i have figured it out using a radio button method, but i still get an extra table being generated

here is my code can anyone see why

<html>

<head>

<body>
<form action= "ticketype.php" method="post">
<?php
$categoryID=$_POST['categoryID'];
$color[0] = "red";

$color[1] = "green";

mysql_connect("localhost","phpuser","phpuser03") or die ("Database connection error");

mysql_select_db('booking');

$sql = "SELECT ticket.TicketType, ticket.Price, event.EventID FROM ticket,event WHERE event.EventID=ticket.EventID";
$result = mysql_query($sql);
#while ($row = mysql_fetch_array($result)) {
#echo $row['EventName'] . ',' . $row['Date'] . ',' . $row['Venue'] . "<br>\n";
echo "<table>\n";

echo " <tr>\n";

echo " <th><b>Ticket Type</b></th>\n";

echo " <th><b>Price</b></th>\n";

echo " <th><b>TicketID</b></th>\n";

echo " </tr>\n";

while ($row = mysql_fetch_array($result)) {

$a = ($a+1)%2;

echo '<tr bgcolor='.$color[$a] . ">\n";

#echo ' <td>'.$row['TicketType'].'</td>'."\n";
echo ' <td> <input name= "button" type="radio" value="adult" checked>Adult <input type="radio" name="button" value="child">Child</td>',$row['TicketType'],'</td>'."\n";
echo ' <td>'.$row['Price'].'</td>'."\n";

echo ' <td>'.$row['EventID'].'</td>'."\n";

echo ' </tr>'."\n";

}

echo '</table>';

	  ?>

  </form>

</body>

</html>

timmybuck

Dont worry guys

I have figured it out.

end of thread

bastien

What if the user wants a combination of child and adult tickets?

timmybuck

good point

so how do u think i should do it

timmybuck

ok i want create something where people can choose either adult tickets or child. The price is also different $10.00 for adults and $5.00 for children. I thought by using a radio buttons i could do it, but its look weired to me and i dont think it will look good if i had radio buttons for the price, so now im confused about how to design it.

hopefully you will see what i mean here

http://homepage.ntlworld.com/unixhome/poo.htm

bastien

Screw the dropdown

two input elements

No. of Child:<input name="tick_child" type="text">
No. of Adult:<input name="tick_adult" type="text">