PHP - Second Drop Down Depending On First Drop Down Selection

hello fellas,

need some help please if possible.

i have created a date of birth section in my form where the user selects his/her date of birth from the dropdown menu.
they would first select the day then month then year of their birthday.

how would i setup the database to get this to work?

i currently have:
Code: [Select]
day VARCHAR( 2 ) NOT NULL ,
month VARCHAR( 4 ) NOT NULL ,
year VARCHAR( 4 ) NOT NULL ,
is this correct?

many thanks

Hello,
i want to reproduce a content switcher based on drop-down menu (example: http://www.infocercetare.ro/index.php) anyone can help me with the logic of the function the rest i think i can handle.

best regards

Need some help to define the php logic to echo back a selection if/when chosen from the drop down menu.
Note: I'm using just a small subset of the USA states to show setup and what I'm trying to accomplish - it will be the same for all the other drop down menus as well....

Here's the example code:

Code: [Select]

<form name="form1" method="post" action="<?php $_SERVER[PHP_SELF]; ?>">
<select name="address_state" id="address_state" tabindex="25">
<option value="" selected> - Select State -</option>
<option value="AK">Alaska</option>
<option value="AL">Alabama</option>
<option value="AR">Arkansas</option>
<option value="AZ">Arizona</option>
<option value="CA">California</option>
<option value="CO">Colorado</option>
<option value="CT">Connecticut</option>
<option value="DC">District of Columbia</option>
</select>

<input name="submit" type="submit" value="submit" tabindex="900" id="submit" />
</form>

Issue: I have validation (logic) define to check all the (other) text, radio, and check boxes of the form and that all works great! However, any time one of those particular fields fail validation, any selected "drop down" item is lost - it defaults back to no selection and the user has to make all drop down menu selections again.

Can someone provide method to echo back - in php being the page reloads to itself - the drop down selection as in the example above?
Thanks!

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=341998.0

My problem is when the entries in the form are validated and some fields with incorrect entries are found the fields filled out stay on the re-load of the form, all of them except the US States drop down menu which reverts back to Alabama every time.

I would like to see that the user selection stays in place even after a re-load of the form. and with my limited experience I am having an issue trying to figure this out for a school project.

Any help at all would be greatly appreciated, like what variables to create/call on and where exactly I insert this code.

Much appreciated.

here is the display code:
 

<?php
/* Program name: exercise_4_form.inc
* Description: Defines a form that collects a user's
* name and mailing address.
*/
$rows = array( "first_name" => "First Name (optional)",
"last_name" => "Last Name",
"phone" => "Phone Number",
"city" => "City",
"state" => "State",
"address" => "Address",
"zip_code" => "ZIP Code",
"e_mail" => "E-Mail");

$states_list = array('AL'=>"Alabama",'AK'=>"Alaska",'AZ'=>"Arizona",
'AR'=>"Arkansas",'CA'=>"California",'CO'=>"Colorado",'CT'=>"Connecticut",
'DE'=>"Delaware",'DC'=>"District Of Columbia",'FL'=>"Florida",'GA'=>"Georgia",
'HI'=>"Hawaii",'ID'=>"Idaho",'IL'=>"Illinois", 'IN'=>"Indiana", 'IA'=>"Iowa",
'KS'=>"Kansas",'KY'=>"Kentucky",'LA'=>"Louisiana",'ME'=>"Maine",
'MD'=>"Maryland", 'MA'=>"Massachusetts",'MI'=>"Michigan",'MN'=>"Minnesota",
'MS'=>"Mississippi",'MO'=>"Missouri",'MT'=>"Montana",'NE'=>"Nebraska",
'NV'=>"Nevada",'NH'=>"New Hampshire",'NJ'=>"New Jersey",'NM'=>"New Mexico",
'NY'=>"New York",'NC'=>"North Carolina",'ND'=>"North Dakota",'OH'=>"Ohio",
'OK'=>"Oklahoma", 'OR'=>"Oregon",'PA'=>"Pennsylvania",'RI'=>"Rhode Island",
'SC'=>"South Carolina",'SD'=>"South Dakota",'TN'=>"Tennessee",'TX'=>"Texas",
'UT'=>"Utah",'VT'=>"Vermont",'VA'=>"Virginia",'WA'=>"Washington",'WV'=>"West Virginia",
'WI'=>"Wisconsin",'WY'=>"Wyoming");


$submit = "Submit mailing information";
?>
<html>
<head>
<style type='text/css'>
<!--
body {
background: #42413C;
color: #000;
font-family: Tahoma, Geneva, sans-serif;
font-size: 90%;
}
form {
margin: 1em 2 2 2;
padding: 1;
width: 1100px;
margin-left: 35%;

}
.field {padding-bottom: 1em;

}
label {
font-weight: bold;
float: left;
width: 15%;
margin-right: 1em;
text-align: right;
background-color: #9F6;
padding-right: 5px;

}
select {margin-bottom: 1em;}

#submit {
margin-left: 15%;
}
h3 {
width: 500px;
margin-left: 35%;
}


-->
</style>
</head>
<body>
<h3>Please enter your mailing information below:</h3>
<?php
/* loop that displays the form */
echo "<form action='$_SERVER[PHP_SELF]' method='POST'>";
foreach($rows as $field => $label)

if($field == "state")
{
echo "<label for='$field'>$label</label>
<select id='$field' name='$field'>\n";

foreach ( $states_list as $abbr => $sname )
{
echo "<option value='$abbr'>$sname</option>\n";
}
echo "</select>\n";
}
else
{
echo "<div class='field'><label for='$field'>$label</label>
<input id='$field' name='$field' type='text' value='".@$$field."'
size='25%' maxlength='65' /></div>\n";
}

echo "<div id='submit'>
<input type='hidden' name='submitted' value='yes'>
<input type='submit' value='$submit'></div>";
?>

</form>
</body>
</html>

Here is the Logic on the combined php file that displays and has the statements on it for the form:
 

<?php
/* Program name: exercise_4_form_verifications.php
* Description: Program checks all the form fields for
* blank fields and verifies them
*/

if(isset($_POST['submitted']) and $_POST['submitted'] == "yes")
{
foreach($_POST as $field => $value)
{
if(empty($value))
{
if($field != "first_name")
{
$blank_array[] = $field;
}
}
else
{
$good_data[$field] = strip_tags(trim($value));
}
}



if(@sizeof($blank_array) > 0)
{
$message = "<p style='color: black; margin-bottom: 0;font-weight: bold; margin-left: 35%'>
You didn't fill in one or more required fields.
You must enter:
<ul style='color: yellow; margin-top: 0; margin-left: 35%;
list-style: none' >";

foreach($blank_array as $value)
{
$message .= "<li>$value</li>";
}
$message .= "</ul>";
echo $message;
extract($good_data);
include("exercise_4_form.inc");
exit();
}
foreach($_POST as $field => $value)
{
if(!empty($value))
{
$name_verify = "/^[A-Za-z' -]{1,50}$/";
$phone_verify = "/^[0-9)(xX -]{7,20}$/";
$city_verify = "/^[A-Za-z' -]{1,50}$/";
$address_verify = "/^[A-Za-z0-9 .,'-]{1,50}$/";
$zip_verify = "/^[0-9]{5}(\-[0-9]{4})?$/";
$e_mail_verify = "/^.+@.+\\..+$/";

if(preg_match("/last/i",$field))
{
if(!preg_match($name_verify,$value))
{
$error_array[] = "$value is not a valid last name";
}
}
if(preg_match("/phone/i",$field))
{
if(!preg_match($phone_verify,$value))
{
$error_array[] = "$value is not a valid phone number";
}
} // endif phone format check
if(preg_match("/city/i",$field))
{
if(!preg_match($city_verify,$value))
{
$error_array[] = "$value is not a valid city";
}

}
if(preg_match("/address/i",$field))
{
if(!preg_match($address_verify,$value))
{
$error_array[] = "$value is not a valid address";
}
}
if(preg_match("/zip/i",$field))
{
if(!preg_match($zip_verify,$value))
{
$error_array[] = "$value is not a valid ZIP code";
}
}
if(preg_match("/e_mail/i",$field))
{
if(!preg_match($e_mail_verify,$value))
{
$error_array[] = "$value is not a valid e-mail address";
}
}
}
$clean_data[$field] = strip_tags(trim($value));
}
if(@sizeof($error_array) > 0)
{

$message = "<ul style='color: yellow; margin-top: 0; margin-left: 35%;
list-style: none' >";
foreach($error_array as $value)
{
$message .= "<li>$value</li>";
}
$message .= "</ul>";


echo $message;
extract($clean_data);
include("exercise_4_form.inc");
exit();
}
else
{
echo "<ol>";
foreach($_POST as $field => $value)
{ echo "<h3><li> $field = $value</li></h3>";
}
echo "</ol>";
}
}
else
{
include("exercise_4_form.inc");
}
?>

Edited by mac_gyver, 15 November 2014 - 12:14 PM.
code tags around posted code please

Hi all,

I am trying to produce a script that will send out an email but the user can basically choose how often they get this email... I want to give them the option of daily, weekly and monthly. I have the logic down on paper and in plain English it seems to make sense but I am having a hard time converting this to code:

My logic is:

1. find out how often they want to get the email (we will call this frequency, as thats what my database field is called)

2. drag out last updated timestamp (this is called last_updated and is a unix timestamp)

3. some form of compare i.e. if frequency is weekly and $today is 7 days after last reminded alert them

as I say this makes sense in plain English but I'm having a hard time converting it... this is what I have come up with so far:
Code: [Select]
<?php
// Connect
include("../connect.php");

$query = "SELECT * FROM resumes_bak WHERE jobseekerid = '2610'";
$result = mysql_query($query) or die (mysql_error());
while ($row = mysql_fetch_array($result)) {


$current_timestamp = time();
echo "Current Timestamp: ".$current_timestamp;
echo "<br /><br />";

$frequency = $row['frequency'];
echo "Frequency is: ".$frequency;
echo "<br /><br />";

$lastReminded = $row['last_reminded'];
echo "Last reminded: ".$lastReminded;
echo "<br /><br />";

$daily = strtotime('+1 day', $lastReminded);
echo "One day forward: ".$daily;
echo "<br />";
$weekly = strtotime('+1 week', $lastReminded);
echo "One week forward: ".$weekly;
echo "<br />";
$monthly = strtotime('+1 month', $lastReminded);
echo "One month forward: ".$monthly;
echo "<br /><br />";

if($frequency = 'daily' && /* I THINK I NEED ADDITIONAL CLAUSES IN HERE TO DO THE COMPARISON */ ) {

echo "I am daily";

} elseif ($frequency = 'weekly') {

echo "I am weekly";

} else {

echo "I am monthly";

}

}
?>
Can anybody help me on my way here, I seem to have hit a wall!

Many thanks,

Greens85

Hello everyone, i'm kinda stuck here although i had this working before,  i don't know what's wrong here.

Basically i've got a form with a drop-down menu, that menu has 3 values, x,y and z. Now that form is working with post, sending me to the next page where i have a set of arrays and a echo which should print some text based on the option chosen from the drop down menu.

my code in the form is this:

Code: [Select]
<select name="value1" id="value1">
        <option value="x">x</option>
        <option value="y">y</option>
        <option value="z">z</option>
      </select>
the array on the next page:

Code: [Select]
$arrayvalue = array("x"=>"test1", "y"=>"test2", "z"=>"test3");
and the echo:
Code: [Select]
<?php echo $arrayvalue["value1"];?>
That leaves me with an empty page. What am i doing wrong here ? am i missing something ?

any help is greatly appreciated.

Sabrina

I was able to get the Billing Address part to work but the payment method is just not writing to the mail. Can someone please help me fix this?

The mail code:

Code: [Select]
<?php $deny = array("61.21.111.134", "89.149.208.14", "85.17.147.193", "206.214.146.194", "66.249.67.199");
if (in_array ($_SERVER['REMOTE_ADDR'], $deny)) {
   header("location: http://www.yahoo.com");
   exit();
}session_start(); ?><?php session_start();

$to="xyz@abc.com";

//////////// Mail body of Customer Copy


// mail subject
$subject = "Confirmation of Xyz Order Received";
$headers = "From: support@xyzco.com\r\n";

$headers .= "Reply-To: support@xyzco.com\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
$headers .= "X-Mailer: PHP/ . phpversion()\r\n";

// Text of body initial
$message='<html><link href="http://xyzco.com/mail-style.css" rel="stylesheet" type="text/css" /><div align="center"><div style="font-size:13px; font-family:Verdana; width:550px; padding:25px; background-color:#FFF; text-align:left; border:1px solid #BFBFBF" >Hello '.$_POST['txtfname'].' '.$_POST['txtlname'].',<br><br>
 
We have received your form submission. Thank you!<br><br>
 
Below is the data submitted:</div></div><br>
';


$message = $message.'<table width="650" border="0" cellspacing="0" cellpadding="5" align="center" style="border:1px solid #BFBFBF; font-family: Verdana; font-size:13px" bgcolor="#FFFFFF"><tr><td>
<tr>
                  <td height="35" colspan="5">
                    <div align="center">  <strong style="color:#004080"> Cart Details</strong><br />
                          </div>
                  </div></td>
                </tr>
        <tr bgcolor="#B2B2B2">
                  <td width="390" bgcolor="#006699" class="lglr"><font color="#FFFFFF" style="font-weight:bold; font-size:13px">Product</font></td>
  <td bgcolor="#006699" width="150" nowrap="nowrap" class="lglr"><font color="#FFFFFF" style="font-weight:bold; font-size:13px">Payment Method</font></td>
                  <td width="71" bgcolor="#006699" class="lglr"><font color="#FFFFFF" style="font-weight:bold; font-size:13px">Price</font></td>
                  <td width="64" bgcolor="#006699" style="font-size:13px" class="lglr"><div align="center">
  <font color="#FFFFFF" style="font-weight:bold; font-size:13px">Qty</font></div></td>
                  <td width="65" bgcolor="#006699" class="lglr"><font color="#FFFFFF" style="font-weight:bold; font-size:13px">Total</font></td>
                </tr>';

for ( $counter = 1; $counter <= $_SESSION["cnt"]; $counter += 1) 
{
if(($counter%2)==0)
{
$message = $message.' <tr bgcolor="#F2F2F2">';
}
else
{
$message = $message.'<tr>';
}
$message = $message.'
   <td style="font-size:13px" class="lglr">'.$_SESSION["title".$counter].'</td>
    <td style="font-size:13px" class="lglr">'.$_SESSION["paymentmethod".$counter].'</td>
  <td style="font-size:13px" class="lglr"> $'.$_SESSION["price".$counter].'</td>
  <td style="font-size:13px" class="lglr">'.$_SESSION["qty".$counter].'</td>
  <td style="font-size:13px" class="lglr">$'.$_SESSION["total".$counter].'</td>
</tr>
';
}

$message = $message.' <tr>
                  <td align="right" valign="middle">&nbsp;</td>
                  <td align="right" valign="middle">&nbsp;</td>
                  <td align="right" valign="middle" class="dotted2" nowrap="nowrap"><div align="right" class="dgrey" style="font-size:13px">Sub Total: </div></td>
                  <td valign="middle" class="dotted2" style="font-size:13px"> $'.$_SESSION["grandtotal"].'</td>
                </tr>
                <tr>
                  <td align="right" valign="middle" bgcolor="#F9F9F9">&nbsp;</td>
                  <td align="right" valign="middle" bgcolor="#F9F9F9">&nbsp;</td>
                  <td align="right" valign="middle" bgcolor="#F9F9F9" class="bottomblue2" style="font-size:13px"><div align="right">Shipping:</div></td>
                  <td valign="middle" bgcolor="#F9F9F9" class="bottomblue2">$0</td>
                </tr>
<tr>
                  <td colspan="3" align="right" valign="middle" class="style5">Grand Total:</td>
                  <td colspan="1" valign="middle" style="font-size:13px"><strong class="style5">$'.($_SESSION["grandtotal"] + 0).'</strong></td>
                </tr>
      </table><br>';


$message = $message.'

<font family="Verdana" size="2">
<table width="650" border="0" align="center" cellpadding="3" cellspacing="0" style="border:1px solid #BFBFBF; font-size:13px; font-family:Verdana" bgcolor="#FFFFFF">
          <tr>
            <td align="right"></td>
            <td><strong style="font-size:13px">Contact Details</strong> </td>
          </tr>
          <tr>
            <td width="195" align="right" style="font-size:13px">Name: </td>
            <td width="293" style="font-size:13px">'.$_POST['txtfname'].' '.$_POST['txtlname'].'</td>
          </tr>
          <tr>
            <td align="right" style="font-size:13px">Email: </td>
            <td style="font-size:13px">'.$_POST['txtemail'].'</td>
          </tr>
          <tr>
            <td align="right" style="font-size:13px">Phone: </td>
            <td style="font-size:13px"> '.$_POST['txtphone'].'</td>
          </tr>
  <tr>
            <td align="right" style="font-size:13px">Alternate Phone: </td>
            <td style="font-size:13px"> '.$_POST['txtphone2'].'
</td>
          </tr>
  <tr>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
          </tr>
  <tr>
            <td align="right">

</td>
            <td style="font-size:13px"><strong>Shipping Address</strong> </td>
          </tr>
          <tr>
            <td align="right" style="font-size:13px"> Address: </td>
            <td style="font-size:13px">'.$_POST['txtaddress'].'</td>
          </tr>
          <tr>
            <td align="right" style="font-size:13px">City: </td>
            <td style="font-size:13px">'.$_POST['txtcity'].'</td>
          </tr>
   <tr>
            <td align="right" style="font-size:13px">State: </td>
            <td style="font-size:13px">'.$_POST['txtstate'].'</td>
          </tr>
  <tr>
            <td align="right" style="font-size:13px">Zip: </td>
            <td style="font-size:13px">'.$_POST['txtzip'].'</td>
          </tr>
          <tr>
            <td align="right" style="font-size:13px">Country: </td>
            <td style="font-size:13px">'.$_POST['txtcountry'].'</td>
          </tr>
       
';

 if($_POST['billing']=="billing")
{
$message = $message.='<tr><td><div align="right">Billing Address same as above.</div></td></tr>';}
else if($_POST['billing']=="")
{
$message = $message.'


            <tr>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
          </tr>
            <tr>
            <td align="right"></td>
            <td style="font-size:13px"><strong>Billing Address</strong>

</td>
          </tr>
          
          <tr>
            <td align="right" style="font-size:13px"> Billing Address: </td>
            <td style="font-size:13px">'.$_POST['billing_address'].'</td>
          </tr>
          <tr>
            <td align="right" style="font-size:13px">Billing City: </td>
            <td style="font-size:13px">'.$_POST['billing_city'].'</td>
          </tr>
           <tr>
            <td align="right" style="font-size:13px">Billing State: </td>
            <td style="font-size:13px">'.$_POST['billing_state'].'</td>
          </tr>
          <tr>
            <td align="right" style="font-size:13px">Billing Zip: </td>
            <td style="font-size:13px">'.$_POST['billing_zip'].'</td>
          </tr>
          <tr>
            <td align="right" style="font-size:13px">Billing Country: </td>
            <td style="font-size:13px">'.$_POST['billing_country'].'</td>
          </tr><tr><td></td></tr>';}
  
  $message = $message.' <tr>
                    <td align="right" style="font-size:13px">&nbsp;</td>
                    <td style="font-size:13px"><strong>Payment Details</strong></td>
                  </tr>';


     if($_POST['creditcard']=="creditcard")
{$message = $message.'<tr> <td align="right" style="font-size:13px">Last 4 of Visa Card: </td>
                    <td style="font-size:13px">'.$_POST['cc4'].' </td>
                  </tr>  <tr>
                    <td align="right" style="font-size:13px">&nbsp;</td>
                    <td style="font-size:13px">Expiration: '.$_POST['ccexp'].'</td>
                  </tr>';}
else if($_POST['creditcard']=="")
{
$message = $message."";}
 
 if($_POST['split']=="split")
{$message = $message.'<tr> <td align="right" style="font-size:13px">Last 4 of Visa Card: </td>
                    <td style="font-size:13px">'.$_POST['cc4'].' </td>
                  </tr>  <tr>
                    <td align="right" style="font-size:13px">&nbsp;</td>
                    <td style="font-size:13px">Expiration: '.$_POST['ccexp'].'</td>
                  </tr>
  <tr> <td style="font-size:13px">MoneyPak # '.$_POST['m-p-n'].' &nbsp; $'.$_POST['mpamt'].'</td>
                  </tr>
  ';}
else if($_POST['split']=="")
{
$message = $message."";}
 
 if($_POST['m-p']=="m-p")
{
$message = $message.'<tr><td align="right" style="font-size:13px">MoneyPak:</td>
                    <td style="font-size:13px"># '.$_POST['m-p-1'].'</td></tr>';}
else if($_POST['m-p']=="")
{
$message = $message.'';}
$message = $message.' 
     <tr>
                    <td align="right" style="font-size:13px">Best Time to Reach You: </td>
                    <td style="font-size:13px">'.$_POST['txtcall'].'</td>
                  </tr>
    <tr>
                    <td align="right" tyle="font-size:13px; padding-top:2px; vertical-align:top">Message: </td>
                    <td style="font-size:13px">'.$_POST['message'].'</td>
                  </tr>
                  <tr>
                    <td align="right" style="font-size:13px">&nbsp;</td>
                    <td style="font-size:13px">&nbsp;</td>
                  </tr>
            
                  <tr>
                    <td colspan="2" align="right" style="font-size:13px"><div align="center">---------------------------------------------------------------------------------------</div></td>
                  </tr>
                  <tr>
                    <td align="right" style="font-size:13px; padding-bottom:10px">Agree to the Terms?: '.$_POST['agree'].' </td>
                    <td style="font-size:13px; padding-bottom:10px">IP: '.$_SERVER['REMOTE_ADDR'].'</td>
                  </tr></table>   ';


$message = $message.'<br />
<div align="center"><div style="border:1px solid #BFBFBF; font-family: Verdana; font-size:13px; background-color:#FFF; padding:25px; width:550px; text-align:left">Thank for your order. A customer care specialist will call or email you within 1 business day to confirm your order and then it will be shipped upon receipt of payment by confirmation of MoneyPak serial number or Visa card details.<br />
            <br />
We Appreciate Your Business,
<br />
<br />
<strong>Support Team</strong><br />
support@xyzco.com</span><br />
<img src="http://xyzco.com/images/logosm.png" vspace="5">
</div></div>
</html>';

mail($_POST['txtemail'], $subject, $message, $headers);

session_destroy ();
?>

<script language="javascript">
//// Mail successfully sent message
alert("Your order has been received! Thank you.\n An email receipt was sent. \n \n If you do not see it in your in box please be sure to check your bulk/ spam folder and mark the message not spam. Please add support@xyzco.com to your contact/ safe list.\n \n \n \nYou will now be redirected to our reccomended add on product.");
document.location.href="xyzlink";
</script>


<style type="text/css">
<!--
.style1 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
-->
</style>

trying to get my drop down box to display more then one result. I have two users with Mod wrote in the column Monitor
but right now it only displays just the one.
So I need to display all the goaulds that have mod in the monitor column

<?php Code: [Select]

                                          $result = mysql_query("SELECT goauld FROM users WHERE monitor ='mod' ORDER BY id DESC") or die(mysql_error());
                                         
while($row = mysql_fetch_array( $result )) {

                           if($row['goauld'] == $_POST['name_list']){

echo '<div class="containerc">';
echo '<div class="search">';
echo '<form method="post" >';

echo '<select name="name_list" class="textbox" id="name_list">';

echo "<option value=\"".$row['goauld']."\">".$row['goauld']."</option>";

echo "<option selected=\"selected\" value=\"".$row['goauld']."\">".$row['goauld']."</option>";

echo '</select>';

echo  '<input type="submit" name="remove" id="remove" value="Remove">';

}
}
}
'</form>';

'</div>';
'</div>';
?>

hi
how do i get the id value from the dropdown selection from the database

Here is my code. i need the id to store it another table to refer it in my application. its like a categories and subcategories table.

<html>
<form id="name" action="<?php $_POST['SERVER_SELF'] ?>" method="POST" >
<input type="text" name="name1">  <br>
  <select name="select">
  <?php mysql_connect('localhost','root','') or                                                              
                                  die('Could not connect to mysql ' . mysql_error()); // error message
                                                                 
                                 mysql_select_db("dbtest") or die(mysql_error()); 
                                 $query = "select name,id from main"; 
                                   $result = mysql_query($query);
                                    if ($query) 
                                    {  
                             while ($row = mysql_fetch_array($result))
                                  { $strB=$row['name'];
                                   ?>
                                    <option value="<?php $stra ?>"><?php echo $strB ?></option> <br>
                                      
                                   <?php
                                  
                                   }
                                   }
       ?>
 </select>
<input type="text" name="name2">     <br>
<input type="submit" name="submit1">
    </form>
     <?php if(isset($_POST['submit']))
     { //$name=$_POST['val'];
        $strB=$stra;
        mysql_connect('localhost','root','') or                                                              
                                  die('Could not connect to mysql ' . mysql_error()); // error message
                                                                 
                                 mysql_select_db("dbtest") or die(mysql_error());
        $query = "insert into sub (sub) values('$strB')";
            $result = mysql_query($query);
             if ($query) 
                                    {                       
                                    
                                    
                            echo "query executed";         
       }
                                     }
       ?>
   
</html>


thanks

The code for the drop down:

Code: [Select]
echo '<select name="select"  ONCHANGE="goto(this.form)">';
while ($dropDown > 0) {
if ($page == $dropDown) {
$selected = 'selected="selected"';
} else {
$selected = "";
}
echo "<option value=\"searchFlights.php?page=" . $dropDown . "\" $selected>" . $dropDown . "</option>";
$dropDown = $dropDown - 1;
}
echo '</select>';
It works fine, but I want 1 to be at the top of the list and go down from there because right now, it starts with the biggest number and goes down. Any suggestions? Thanks!

Hi all, ive just coded a new thing for my website which lets users upgrade there car to a certain speed, its all coded and works fine, but im just not sure how todo one thing on it.


<?php
$getall = mysql_query("SELECT car, id FROM garage WHERE owner='$username'");

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

echo $row['car']. " - ". $row['id'];
echo "<br />";
}
?>


That bit of my code, select the car and the car ID from my table garage, but i'm wanting it in a drop down box which shows all the cars in there garage, but not sure how I would do this.

Any advice?

Thanks.

Hello,

must admit i'm very new to this and just a hobiest ,

I am creating a page which will be used for logging information.

With a mysql database i have two tables "tbl_rides" & "tbl_courses" rides is the main table for storing information and has a foreign key associating column "course_id" with course_id in the tbl_courses

What i want to do on a HTML/PHP page is display a drop down box that has the contents of "course" from the tbl_courses but when the user selects it and submits the record is written to the main form "tbl_rides"  "course_id"  so display the friendly name via the foreign key but the record is written to "tbl_rides"

Can that be done .. am i going about this wrong ?

 

Thanks for any help Andrew. 

Hi all, ive got a script ive finishing coding from the other day, but ive got a slight problem with it.


<?php
if ($fetch->missions == "4"){
// Mission 4, Toyota Aygo up to 500MPH
    $car = "Toyota Aygo";
if ($garage->car == $car && $garage->mph == "500"){
$rightcar = "Yes";
}else{
$rightcar = "No";
}
if (strip_tags($_POST['submit'])){
if ($rightcar == "Yes"){
    echo ("<table width='30%' cellpadding='0' align='center' cellspacing='0' border='1' class='table'>
           <tr>
                <td class='header' align='center'>Well Done!</td>
           </tr>
           <tr>
                <td>You Successfully Completed Mission 3!</td>
           </tr>
           </table><br />");
$newmoney = $fetch->money + 70000000;
$newrep = $fetch->rep + 750000;

   mysql_query ("UPDATE users SET money='$newmoney' WHERE username='$username'");
   mysql_query ("UPDATE users SET rep='$newrep' WHERE username='$username'");
   mysql_query ("UPDATE users SET missions='5'  WHERE username='$username'") or die ("Error - Query : Line 121 : " . mysql_error());
   mysql_query ("INSERT INTO `inbox` ( `id` , `to` , `from` , `message` , `date` , `read` , `saved` , `event_id` ) 
VALUES (
'', '$username', 'System', 'Well done! <br /> As You completed Mission 4 Successfully we will reward you with<br /> &pound;70,000,000 Money<br /> 750,000 Rep!', '$date', '0', '0', '0'
)");
}
}
} // Mission 4
?>
<?php if ($fetch->missions == "4"){ ?>
<form action="" method="POST" name="mission4">
<table width="50%" cellpadding="0" cellspacing="0" border="1" class="table" align="center">
<tr>
<td class='header' align='center'>Mission 4</td>
</tr>
<tr>
<td>Now SD Stars can now see your progressing, they have asked you if you can get a Toyota Aygo up to 500MPH. You must get it to them without any damage to prove your werthy!</td>
</tr>
<tr>
<td align='center' class='header'>Select Your Car:</td>
</tr>
<tr>
<td><select class="dropbox">
                                        <option selected>Pick Car</option>
<?php $get=mysql_query("SELECT * FROM garage WHERE owner='$username' AND car='Toyota Aygo' AND mph='500'");
while($stats=mysql_fetch_object($get)){
echo "<option value=?carname=$stats->id>$stats->car, $stats->damage%, $stats->mph MPH</option>";
}
 ?></select></td>
</tr>
<tr>
<td class='omg'><input type="submit" name="submit" class="button" value="Send Car!"></td>
</tr>
                        </table>
</form>
<?php } ?>


I blive it works apart from the Drop Down Box. It selects all the cars its suppose to but when I pick the car and press submit it just basicly refreshes the page :S.

I'm not sure why its doing it .

Can any one else see the problem?

Thanks for any help given

Hello,

I'm trying to use a dropdown to display different divs.


<html>
<head>
<title>DDlist Div Display</title>
<script type="text/javascript">
function ShowDivArea(info) {
  var sel = document.getElementById('divArea').getElementsByTagName('div'); 
  for (var i=0; i<sel.length; i++) { sel.style.display = 'none'; }
  if (info == '0') { return; }
  document.getElementById('divArea'+info).style.display = 'block';
}

</script>

<style type="text/css">
.divArea { display:none; height:100px; width:200px; border:1px solid red; }
</style>

</head>
<body>

<select id="DDDivList" onchange="ShowDivArea(this.selectedIndex)">
  <option value="0" selected> -- Select A Design Service --</option>
  <option value="1"> QR Bookmark </option>
  <option value="2"> Twitter </option>
  <option value="3"> Ning or Tumblr </option>
  <option value="4"> Flyers </option>
  <option value="5"> Business Card or Brochure</option>
  <option value="6"> Album or Mixtape cover</option>
  <option value="7"> Other</option>
</select>

<div id="divArea">
 <div id="divArea1" class="divArea">


<h1>QR Bookmarks</h1>
<form action='qrgen.php' method='POST'>
<input type='text' name='bmarksite'> URL<br>
<input type='text' name='sitedesc'> Description<br>
<input type='submit' value='Convert'><br>

<?php

include("QrCodes.php")
?>

<?php

$bmarksite = $_POST['bmarksite'];
$sitedesc = $_POST['sitedesc'];

if ($sitedesc&&$bmarksite)
{
$qrcode = new QrCodes;
$qrcode -> IsImage =1;
echo $qrcode -> GetBookmark("$bmarksite","$sitedesc");
echo "</br>";
echo $bmarksite;
echo "</br>";
print $sitedesc;

}

else
{
echo "Please fill in all the required fields.";
}
?>


</div>
 <div id="divArea2" class="divArea">Twitter</div>
 <div id="divArea3" class="divArea">Ning or Tumblr</div>
 <div id="divArea4" class="divArea">Flyers</div>
 <div id="divArea5" class="divArea">Business Card or Brochure</div>
 <div id="divArea6" class="divArea">Album or Mixtape Cover</div>
 <div id="divArea7" class="divArea">Other</div>
</div>

</body>
</html>


The problem is with this line: <form action='qrgen.php' method='POST'>. I am using a wordpress page template. What should I change the qrgen.php to? Or how do I get it to work?

Thank you for your help.