Why My Drop Down List is Empty? Help!!! Pls...

osnewbie2004

Hello!

I have been trying to find an answer for this one...
all i am trying to do is...populating a drop down list from a
mysql db...why is my drop down list empty?

whats wrongwith the below code...?

<HTML>

<select name="home_name">
<?php

include "mysql_data.inc";

$strsql = "select * from homes";

$rsTmp = mysql_query($strsql) or die("Query failed");

while($rowTmp = mysql_fetch_array($rsTmp,MYSQL_ASSOC)) { ?>
echo "<option><?=$rowTmp[0]?></option> ";
<?php } ?>
</select>

</HTML>

LarsLai

echo has to stand inside your php-tags

<HTML> 
<select name="home_name"> 
 <?php 
   include "mysql_data.inc"; 
   $strsql = "select * from homes"; 
   $rsTmp = mysql_query($strsql) or die("Query failed"); 
   while($rowTmp = mysql_fetch_array($rsTmp,MYSQL_ASSOC)) {  

     echo "<option><?=$rowTmp[0]?></option> "; 
   } 
 ?>
</select> 
</HTML>

osnewbie2004

Thanks for a prompt reply...
I guess I have echo inside my php tags...can u pls
rewrite the code...with changes u r talking about?

Thanks,
Sean

LarsLai

hi!
thats your posted code:

<HTML> 
<select name="home_name"> 
<?php 
include "mysql_data.inc"; 
$strsql = "select * from homes"; 
$rsTmp = mysql_query($strsql) or die("Query failed"); 
while($rowTmp = mysql_fetch_array($rsTmp,MYSQL_ASSOC)) { ?> 
echo "<option><?=$rowTmp[0]?></option> "; 
<?php } ?> 
</select> 
?> 
</HTML>

and looking at the color of your "echo" you will see its not in php tags.
so i have already posted the correct code in my last answer.

TheDefender

Not quite LarsLai, because in your code, you now have code attempting to open PHP tags, while inside of PHP tags...

Try this instead:

<HTML> 
<select name="home_name"> 
<?php  

    include "mysql_data.inc";  

    $strsql = "select * from homes";  

    $rsTmp = mysql_query($strsql) or die("Query failed");  

    while($rowTmp = mysql_fetch_array($rsTmp,MYSQL_ASSOC))
    {
    echo "<option value=\"".$rowTmp[0]."\" />".$rowTmp[0];
    }  

?> 
</select> 
</HTML>

LarsLai

oh, quite right. i didnt saw that one...
thanks for correction.

osnewbie2004

Hello! guys,

I don't know why but it never worked...it would give me a drop down with no...values in it...
Anyways, I have had a work around on that one...
this thing works...but there is a syntax error...
Parse error: parse error, unexpected T_VARIABLE, expecting ',' or ';' in ...

echo "<select name="$Var_Home_Names">";
for ($i=0; $row = mysql_fetch_assoc($result); $i++)
{
// echo "<option value=\".($row["Home_Name"]).\"</option>\n";
echo "<option value=\"".$row["Home_Name]."\"/>".$row[Home_Name].\"</option>\n";
}
echo "</select>\n";

can u guys pls help me with this one...

Thanks,
Sean

LarsLai

you have some errors from your quoting. in your echo-statements use ' or \"
and please use the PHP mark up for your next post, then you probably will see it by yourself...

echo "<select name='$Var_Home_Names'>"; 
for ($i=0; $row = mysql_fetch_assoc($result); $i++) 
{ 
// echo "<option value='" . ($row['Home_Name']) . "'</option>\n"; 
echo "<option value='" . $row['Home_Name'] . "' />" . $row[Home_Name] . "</option>\n"; 
} 
echo "</select>\n";