$pizza_selected = ""; if( $_REQUEST['pizza_choice'] != ""){ $pizza_selected = $_REQUEST['pizza_choice']; }else if($_REQUEST['other_pizza_choice'] != ""){ $pizza_selected = $_REQUEST['other_pizza_choice']; } $user="duaxlabs_pzausr"; $password=")fhRkQG3TZ_C"; $database="duaxlabs_pizza"; mysql_connect(localhost,$user,$password); @mysql_select_db($database) or die( "Unable to select database"); $query=" insert into `pizzasurvey` ( `id`, `pizza_choice`) VALUES (NULL, '".addslashes($pizza_selected)."')"; mysql_query($query) or die($query . "-" . mysql_error()); ?>
Here is what other people picked:
$query = "select * from `pizzasurvey`";
$result= mysql_query($query);
$counted_results = NULL;
while($row = mysql_fetch_assoc($result)){
//echo $row['pizza_choice'] . "
";
if($counted_results[$row['pizza_choice']] == NULL){
$counted_results[$row['pizza_choice']] = 1;
}else{
$counted_results[$row['pizza_choice']] = $counted_results[$row['pizza_choice']] + 1;
}
//var_dump($counted_results);
//echo "