PHP - Moved: Combo Box

Hi Guys. Hopefully someone can help me with this...New to coding and pretty lost on this.
I have a Mysql database which is displaying results to my webpage with no problems. However I would like to be able to add a combo box to my webpage that would update the mysql database results based on the combo box selection. For example if Ford is chosen from the combo box, the webpage would refresh and show all the results for Ford in the webpage. Can someone please help me?

Here is the code I have at the moment that works just fine. But results of the database are based on the WHERE statement.

Quote

<?php
$con = mysql_connect("server","database","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("a5525005_cars", $con);

$result = mysql_query("SELECT * FROM `cars` WHERE Makel='Ford'");

echo "<table class='ex1' border='0' width='113%' style=text-align:center; cellpadding='6' cellspacing='0'>

</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr style=font-family:verdana;font-size:80%;>";
 
    echo "<td width=13%>" . $row[""] . "<img src=\"" . $row["Photo"] . "\"></a>";
    echo '<td width="14%"><a class="mylink" href="' . $row['URL'] . '">' . $row['Model'] . '</a></td>';   
    echo '<td width="5%"><a class="mylink" href="' . $row['URL'] . '">' . $row['Year'] . '</a></td>';
    echo '<td width="4%"><a class="mylink" href="' . $row['URL'] . '">' . $row['Fuel'] . '</a></td>';
       
echo "</tr>";
  }
echo "</table>";
mysql_close($con);
?>

I am trying to make a function that will generate a random number letter combo but the letters can only be abcde, no others. It must come out in the format, 1a~3d~9b~ etc. This is what I have so far:

Code: [Select]
function randomNumLet($amount){
$theNos = array('1', '2', '3', '4', '5', '6', '7', '8', '9');
$theLet = array('a', 'b', 'c', 'd', 'e');
$combo = '';
for($i=0;$i<$amount;++$i)
{
$rand_num = array_rand($theNos, 1);
$rand_let = array_rand($theLet, 1);
$combo .= $theNos[$rand_num[0]].$theLet[$rand_let[0]].'~';
}
return $combo;
}


$num_let = randomNumLet(2);
echo $num_let;
And it returns just '~~' with no numbers or letters. I'm a bit stuck here and would appreciate any help. How can I make the function output 1a~4d~ etc?

Cheers,
Joe

Hi there.

I am trying to sort values in a combo box stored in an array. The array is written in t his way. Here this is in proper sorting:


 $WeightArray = array('' => '',
    '100gOrLess' => '100g or Less',
    '101g-250g' => '101g to 250g', 
    '251g-500g' => '251g to 500g',
    '501g-1kg' => '501g to 1kg',
    '1kg-2kg' => '1kg to 2kg',
    '2kg-3kg' => '2kg to 3kg',
    '3kg-4kg' => '3kg to 4kg',
    '4kg-5kg' => '4kg to 5kg',
    '5kg-6kg' => '5kg to 6kg',
    '6kg-7kg' => '6kg to 7kg',
    '7kg-8kg' => '7kg to 8kg', 
    '8kg-9kg' => '8kg to 9kg',  
    '9kg-10kg' => '9kg to 10kg',
    '10kg-11kg' => '10kg to 11kg', 
    '11kg-12kg' => '11kg to 12kg' 
    );


Now when I call this array and put in a combo it is displayed as shown in the Screenshot. It is displaying as, 10kg, 11kg 1kg ... in the incorrect order.

I tried few sort() functions but I am not able to sort the array as shown in the screenshot attached.

Kindly let me know how I can sort the values in the Combo box.

Thank you!!

Hi there...

I am working on a PHP web form. I have Group name and its Member details stored in the database.

The Group names from the database table gets populated in a combo box. Now what I'm trying to accomplish is, as soon I select a Group name, all its members should appear in a Label (or something) under the combo box with a textbox field next to the member name for me to assign the member position.

How can we go about doing this. Please see the Screenshot I've attached and you'll have the idea as to what we're trying to accomplish here.

All comments and feedback are welcomed!

Thank you!

I have a simple database table that has the names of countries listed with just 2 fields ID & country. I want to use this in a form to choose the country and provide statistics regarding that country. I know how to get the data from MySQL, but I don't know how I can use this in the form as a selection? How do I get the options to iterate all of the countries so that when the form is displayed a combo type box is displayed with a dropdown list?   I have not shown any code as I am not sure if this is possible.   Please can anyone advise if this is possible and if so some example code?

Hi there,

I am having a PHP form with simple combo box. Here is the code:

<form name="form1" method="get" action="">
  <select name="select" onChange="form1.submit()">
    <option value='value1'>My Value1</option>
    <option value='value2'>My Value2</option>
    <option value='value3'>My Value3</option>
  </select>
</form>

Now the form is successfully being submitted upon 'onChange' event. The only thing I am trying to do is to retain the value of the new option. As every time I select the value from the combo, it goes back and displays the 'value 1' even when I select value 3 or 2.

How do I make the combo box retain the value as 3 (when I select option 3) after the form is submitted.

Please reply.

Thank you!

Hi Good day Can someone pls help me regarding with this matter.
I have a page for inserting records. And I have a combobox that is fetched through the specific field in database. I also have a table of records, for each row i have an href edit which throws the values to its respective texbox and combobox. 
THE PROBLEM is that when i click the href edit, the value from a selected row was not displayed from the combobox

This topic has been moved to PHP Freelancing.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to Miscellaneous.

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

This topic has been moved to Third Party PHP Scripts.

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

This topic has been moved to mod_rewrite.

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

This topic has been moved to MySQL Help.

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

This topic has been moved to Miscellaneous.

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