[RESOLVED] Drop down menu confusion

robkir

I've got two tables relating to real estate-- Property Name & Suite

I have code that displays each of a Properties and its Suites together on one page, so that the operator can update all the various Properties Suite's prices or configuration changes.

Example:
Vista Building | Suite 25 | $25.85/sq ft | Window View

I want to have the Properties as a drop down table--but I am doing something wrong. I can get the drop down to work by itself, and I get the suite updates to work by itself. But if I put them together it looks like a car wreak. I'm still in the beginner phase and easily confused (at least that's my excuse). I've spent a day trying to figure this out...at this point, there's no hair left on the head. Here's the code. Help would be gratefully accepted.

$get_info="SELECT prop_id, prop_name
	FROM office_avail_props
	ORDER BY prop_name ";

$get_info_res=mysql_query($get_info, $link )or die(mysql_error($mysql));


$result = mysql_query("SELECT id_suite, prop_id, suite, sq_ft, rate, detail, notes, prop_name
				   FROM office_avail_suites 
				   LEFT JOIN office_avail_props
				   USING(prop_id)
				   ORDER BY prop_name ASC, suite ASC
				  "); 

while ($units = mysql_fetch_array($result)) {
	//display details in table

print "<input type='hidden' name='id_suite[$i]' value='{$units['id_suite']}' />";

print "<tr>
<td><select name=\"property_info\">";
while($row=mysql_fetch_array($get_info_res)){

print "<option value=\"".$row['prop_id']."\">" . $row['prop_name'] ;

 echo "</option></select></td>";	

	print "
	<td class =\"table_cell\" width = \"5\"><input type='text' size='5' name='suite[$i]' value='{$units['suite']}' />\n </td>
    <td class =\"table_cell\" width = \"10\"><input type='text' size='5' name='sq_ft[$i]' value='{$units['sq_ft']}' />\n </td>
    <td class =\"table_cell\" width = \"10\"><input type='text' size='5' name='rate[$i]' value='{$units['rate']}' />\n </td>
	<td class =\"table_cell\" width = \"25\"><input type='text' size='45' name='detail[$i]' value='{$units['detail']}' />\n </td>
	<td class =\"table_cell\" width = \"25\"><input type='text' size='45' name='notes[$i]' value='{$units['notes']}' />\n </td>


  </p>\n </td></tr>";



};
// add 1 to the count, close the loop, close the form, and the mysql connection
++$i;
}

CoderDan

you have the line

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

that opens the while loot with a { and fail to close with a }

To help prevent these kinds of errors I recommend you look into code indentation practices, and keep them consistent.

robkir

Hi Coder Dan,

You're right about looking into code indentation practices--I am a bit sloppy.

I am not sure where the } will go. I tried a couple of positions--but nothing works yet. Suggestions?

CoderDan

at a guess, something like this:

<?php
$get_info="SELECT prop_id, prop_name
    FROM office_avail_props
    ORDER BY prop_name ";

$get_info_res=mysql_query($get_info, $link )or die(mysql_error($mysql));


$result = mysql_query("SELECT id_suite, prop_id, suite, sq_ft, rate, detail, notes, prop_name
                       FROM office_avail_suites
                       LEFT JOIN office_avail_props
                       USING(prop_id)
                       ORDER BY prop_name ASC, suite ASC
                      ");

while ($units = mysql_fetch_array($result)) {
    //display details in table

print "<input type='hidden' name='id_suite[$i]' value='{$units['id_suite']}' />";

print "<tr>
<td><select name=\"property_info\">";
while($row=mysql_fetch_array($get_info_res)){

    print "<option value=\"".$row['prop_id']."\">" . $row['prop_name'] . "</option>";
}

echo "</select></td>";    // moved /oprion above

print "
    <td class =\"table_cell\" width = \"5\"><input type='text' size='5' name='suite[$i]' value='{$units['suite']}' />\n </td>
    <td class =\"table_cell\" width = \"10\"><input type='text' size='5' name='sq_ft[$i]' value='{$units['sq_ft']}' />\n </td>
    <td class =\"table_cell\" width = \"10\"><input type='text' size='5' name='rate[$i]' value='{$units['rate']}' />\n </td>
    <td class =\"table_cell\" width = \"25\"><input type='text' size='45' name='detail[$i]' value='{$units['detail']}' />\n </td>
    <td class =\"table_cell\" width = \"25\"><input type='text' size='45' name='notes[$i]' value='{$units['notes']}' />\n </td>


  </p>\n </td></tr>";
++$i;  // moved inside the loop
}
// add 1 to the count, close the loop, close the form, and the mysql connection
?>

robkir

Hi Coder Dan,

Still not working quite right...it shows the drop down on the first row correctly, but there are 6 additional records that show the drop down box, but it is empty. I tried putting the closing } at various points, each affects the layout, but none solve the problem.

Ain't programming great fun?

I really appreciate your input--any other thoughts?

(I'm off to work...gotta pay that internet bill)

CoderDan

oops.. i should have actually read all teh code, not just the indentation 😛

<?php
$get_info="SELECT prop_id, prop_name
    FROM office_avail_props
    ORDER BY prop_name ";

$get_info_res=mysql_query($get_info, $link )or die(mysql_error($mysql));
// create the options
$options = array();
while($row=mysql_fetch_array($get_info_res)){

  $options[] = "<option value=\"".$row['prop_id']."\">" . $row['prop_name'] . "</option>";
}


$result = mysql_query("SELECT id_suite, prop_id, suite, sq_ft, rate, detail, notes, prop_name
                       FROM office_avail_suites
                       LEFT JOIN office_avail_props
                       USING(prop_id)
                       ORDER BY prop_name ASC, suite ASC
                      ");

while ($units = mysql_fetch_array($result)) {
    //display details in table

print "<input type='hidden' name='id_suite[$i]' value='{$units['id_suite']}' />";

print "<tr>
<td><select name=\"property_info\">";
echo join( '', $options ); // show the options

echo "</select></td>";    // moved /oprion above

print "
    <td class =\"table_cell\" width = \"5\"><input type='text' size='5' name='suite[$i]' value='{$units['suite']}' />\n </td>
    <td class =\"table_cell\" width = \"10\"><input type='text' size='5' name='sq_ft[$i]' value='{$units['sq_ft']}' />\n </td>
    <td class =\"table_cell\" width = \"10\"><input type='text' size='5' name='rate[$i]' value='{$units['rate']}' />\n </td>
    <td class =\"table_cell\" width = \"25\"><input type='text' size='45' name='detail[$i]' value='{$units['detail']}' />\n </td>
    <td class =\"table_cell\" width = \"25\"><input type='text' size='45' name='notes[$i]' value='{$units['notes']}' />\n </td>


  </p>\n </td></tr>";
++$i;  // moved inside the loop
}
// add 1 to the count, close the loop, close the form, and the mysql connection
?>

robkir

Hi Coder Dan,

That worked...but as with all good solutions it requires some additional understanding. Alas...I'm still fuzzy on an issue. How do I get the value out of the option?

Thanks for helping me understand. I'm slowly clawing my way up to the next plateau of understanding (hopefully no avalanches will take me down)

robkir

CoderDan

change

<select name=\"property_info\">

<select name=\"property_info[$units[id_suite]]\">

or something
then print_r( $_POST ) on a submission and look at what u have

robkir

I made the change to:

and see the array when I use printr

but can't I get the output by $_POST['prop_id']. I am still missing a puzzle piece. What is the correct code?

Thanks,

CoderDan

should be something like:

foreach ( $_POST['property_info'] as $property_id => $selected_value ) { do stuff }

robkir

okay...let me fool with it.

Thanks!

robkir