[Resolved] Mysql Array

kickme21

I am trying to get the contents of the database into an list menu. so far I have this. But it don't work.

$link = mysql_connect("localhost","root","");
mysql_select_db("f1racers",$link);
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
echo "<form name=\"form1\" method=\"post\" action=\"\">
<select name=\"select\">";
$query = "SELECT * FROM gearbox";
$result = mysql_query($query, $link) or die(mysql_error());
$row = mysql_fetch_array($result, MYSQL_BOTH);
printf "<option value=\"8\">\"$row["Stage No"]$row["Description"]\"</option>";
  echo "</select>";
echo "</form>";

any advise

TheDefender

Just stabbing in the dark here, since "it don't work" isn't in the manual... (Give more details in the future please.)

$link = mysql_connect("localhost","root",""); 
mysql_select_db("f1racers",$link); 
if (!$link) { 
   die('Could not connect: ' . mysql_error()); 
} 
echo "<form name=\"form1\" method=\"post\" action=\"\"> 
<select name=\"select\">"; 
$query = "SELECT * FROM gearbox"; 
$result = mysql_query($query, $link) or die(mysql_error()); 

// Loop through your array
while($row = mysql_fetch_array($result)){ 
    echo "<option value=\"8\">".$row['Stage No'].$row['Description']."</option>";
}
echo "</select>"; 
echo "</form>";

Note, though that each one will have a value of 8, and I don't know which of your DB values you will use there, so I left that part alone. Also, you may want to use something other than "select" for the name of your select box. SELECT is a reserved word in MySQL. Lastly, mysql_fetch_array defaults to MYSQL_BOTH, so if that's what you want, you don't need to define it.

kickme21

that is perfect it was exsactly what I was after. Thanks v much

TheDefender

You're welcome. Glad I was able to help. Have a good day.

kickme21

just one other thing if I want get the stage no. value that has been select how would I find that out.

TheDefender

OK, we'll work with the relevent part of the code:

// Assign an action (page) to post this form to.
echo "<form name=\"form1\" method=\"post\" action=\"selectstage.php\">";

// Note, the cnahge to the name of the select box per my discussion above.
echo "<select name=\"stageselect\">";  

$query = "SELECT * FROM gearbox";  

$result = mysql_query($query, $link) or die(mysql_error());  

// Loop through your array 
while($row = mysql_fetch_array($result)){  

    // Assign the stage number to the value of the select option
    echo "<option value=\"".$row['Stage No']."\">".$row['Description']."</option>"; 
} 
echo "</select>";  

echo "</form>";

Now, on selectstage.php, you would just use the $_POST array to get the value.

// Echo it out if you want
echo $_POST['stageselect'];

// Assign the array element to a variable and manipulate that variable however you wish.
$stageselect = $_POST['stageselect'];
echo "Stage Number: ".$stageselect;

How you use it is up to you... I hope this helps.

kickme21

the trub is I already have anouther value there so I need an extra value box

TheDefender

the trub is I already have anouther value there so I need an extra value box

Not sure what you mean here... I noticed you had 8 hard set in the value of the option, but that defeats the purpose of the option to begin with... Can you further explain what you mean?

kickme21

well on the table I have three filds and were the 8 was I have put anout colum from the table it it look like this now.

    echo "<option value=".$row['Cost'].">"."Stage No:".$row['StageNo']." Description: ".$row['Description']." Cost:".$row['Cost']."</option>"; 
} 
echo "</div></select>";
echo "<div align=\"center\">
 <input type=\"submit\" name=\"Submit\" value=\"Submit\">
  </div>";  

echo "</form>";

kickme21

I am after the stage no that has been selected

kickme21

no worries I have sorted it. Thanks v much for ur help.

$newgearbox = $oldgearbox+$select['Cost'];

kickme21

damm thought it worked but maybe not

TheDefender

$newgearbox = $oldgearbox+$_POST['stageselect'];

kickme21

that just gives me 0 every time. If I could get the row nomber that was selected that would be fine. I have called the drop down menu "gearselect". If I put gearselect in the post bit all I get is the price and not the row no. that has been selected. The row no or the StageNo make no difference they are both the same but I do need one or the other.