option value problems, please help

mrose

Hi,

This option value drop down list code works fine for one row of data but will not give me the full list as extracted from my db on mulitple rows. Can anybody help me with this.

Many thanks,

Mike

$sql = "SELECT skill_hier_lev3.skl_lev3, skill_hier_lev3.description3 FROM skill_hier_lev3, skill_hier_lev2
WHERE skill_hier_lev3.skl_lev2 = skill_hier_lev2.skl_lev2
and skill_hier_lev3.skl_lev2 = '$skl_lev2'";
$sql_result = mysql_query($sql,$connection) or die ("Query Execute");
$sql2 = "SELECT FROM ability;";
$sql_result2 = mysql_query($sql2,$connection) or die ("Query Execute");
$num_rows = mysql_numrows($sql_result);
$sql3 = "SELECT FROM skill_system;";

echo "Number of available skills in the section is <b>$num_rows</b>";
echo "<table cellpadding=0 cellspacing=0 border=1 width=760 align=center>";
echo "

<tr><br>
<td align=\"center\" width=200>Description</td>
<td align=\"center\">Ability</td>

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

	$ab_id = $row["ab_id"];
	$description = $row["description"];
	}

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

	$skl_lev3 = $row["skl_lev3"];
	$description3 = $row["description3"];

echo"
<tr>
<td>$description3 ($skl_lev3)</td>
<td><select name=ability>";

echo"
<option value=$ab_id>$description</option></select>";
}

Anon

I can't tell what you are trying to display. The first "while" loop fetches from $sql_result2 but doesn't do anything with the rows it fetches. The second loop fetches from $sql_result and creates a select for each row, but the uses the $description variable from the first while loop. Maybe you intended to use $description3 in the sccond loop? But what use is the first loop?

mrose

The first sql result returns a varied number of rows which displays fine in the table. For this example lets say that we are dealing with 9 rows. The second sql result selects 6 values from my database, these are option values that are assigned to the 9 rows already returned. Does that help with explaining what I am trying to achieve. For each row I want a drop down list of those six values I mentioned. At present it only gives me a list on the first row and nothing for the remaining eight rows.

Cheers,

Mike

Anon

Look at the first loop. When this finishes, you will have $ab_id and $description set to the values from the last row; the other 8 rows are lost. The second loop uses $decription in the option tag, but that isn't what you describe above.

while ($row = mysql_fetch_array( $sql_result2 ) )
{
$ab_id = $row["ab_id"];
$description = $row["description"];
}

I'm guessing you intended to nest the two while loops, but that means you'll have to reset the inner result resource back to the first row every iteration of the outer loop.

http://www.phpbuilder.com/manual/function.mysql-data-seek.php

mrose

Thanks Tom, but I'm pretty new to php so you'll have to explain a bit more simplistic if that's ok. I think I understand what you mean but can't seem to grasp it when I try to code it!