How do I auto populate a form?

[NSC]

Being new to programing, I hope I can explain the problem I'm having.

From a PHP script that provides a name of a city for each pass through of the

while (!$recordSet1->EOF) loop, I need to create a HTML form option. I've being trying to use this...

echo '<option value="city">city</option>';
placed within the loop.

This works outside of the loop...
echo "<form method=\"POST\" action=\"/or/addons/featbyclass/addon.inc.php\">";
echo "City: <select name=\"city[]\" multiple>";
echo "<option value=\"example\"> example</option>";
echo "</select>";
echo "<input type=\"submit\" name=\"Order\">";
echo "</form>";

I need help getting this to work...

echo "<form method=\"POST\" action=\"/or/addons/featbyclass/addon.inc.php\">";
echo "City: <select name=\"city[]\" multiple>";
function cities_display_addon_link() {
global $conn, $config, $lang, $State,$title,$City1;
require_once($config['basepath'].'/include/misc.inc.php');
$misc = new misc();
$display .= "";
$count = 1;
$numcols = 1;

$sql1 = "SELECT listingsdbelements_field_value, count(*) as cityCount
FROM " . $config['table_prefix'] . "listingsdbelements, " . $config['table_prefix'] . "listingsdb
WHERE " . $config['table_prefix'] . "listingsdbelements.listingsdb_id = " . $config['table_prefix'] . "listingsdb.listingsdb_id
and listingsdb_active = 'yes'
and listingsdbelements_field_name LIKE 'city'
group by listingsdbelements_field_value ";

$recordSet1 = $conn->Execute($sql1);
if ($recordSet1 === false)
{
$misc->log_error($sql1);
}
while (!$recordSet1->EOF) {
$City = $recordSet1->fields[listingsdbelements_field_value];
$cityCount = $recordSet1->fields[cityCount];
$num_rows = $recordSet1->RecordCount();
$cnt = $num_rows;
$Link = "<a href='index.php?action=searchresults&city=$City'>" . $City . " (" . $cityCount . ")</a>";
if ($count % $numcols == 0 )
{
$display .= "<li class=group>" . $Link . "</li>";
}
// ... This is the problem I'm having
echo "<option value=\"example\"> example</option>";

$count++;
$recordSet1->MoveNext();
}
return $display;

}
echo "</select>";
echo "<input type=\"submit\" name=\"Order\">";
echo "</form>";

?>

The output produced is displayed below the form...

example example example example example example example example
instead of populating the form with ...
example
example
example
example
example
example
example
example

I hope there's help for this newbie out there somewhere.
Thanks

[bpat1434]

Please use &#91;php&#93;&#91;/php&#93; tags when posting code. I've edited your post to use them.

What database layer are you using? PDO or something different? Have you tried var_dump() of $recordSet1 during the loop to see it's structure? Or perhaps using the Reflection API to get an idea of what methods are available on the object?

Without know the methods, and even more-so the database layer you're using, it's difficult to help. If you're talking about the $Link variable showing a horizontal list rather than a vertical, add a <br/> to the end of the string:

$Link = "<a href='index.php?action=searchresults&city=$City'>" . $City . " (" . $cityCount . ")</a><br />";

[NSC]

Thanks bpat1434,
I'm using MySQL version 5.0.45-community and PHP version 5.2.4.

var_dump($City) shows that I get a different City name for each pass of the loop.

Notice though that it's my test echo statement that's failing. My test echo does not contain the $City yet. And when I do include the $City variable, it also fails.

This works:

echo "<form method=\"POST\" action=\"/or/addons/featbyclass/addon.inc.php\">";
echo "City: <select name=\"city[]\" multiple>";
for($looop =1; $looop <=10; $looop++)
{
echo "<option value=\"example\"> example</option>";
}
echo "</select>";
echo "<input type=\"submit\" name=\"Order\">";
echo "</form>";

But replacing the above loop with the loop in my function does not work.

Any ideas?

[bpat1434]

What methods does the $conn object have? I see the Execute method, but the regular mysqli extension reserved Execute for prepared statements (which you're not doing), same thing with PDO. So what are you using to connect to the database & run queries? What's the name of the class you're using? Your answer should be found in the documentation.

[NSC]

Thank you bpat1434 for for your help.
I found that my first 2 lines of echo

echo "<form method=\"POST\" action=\"/or/addons/featbyclass/addon.inc.php\">";
echo "City: <select name=\"city[]\" multiple>"; 

needed to be placed inside my funtion.

It works fine now.

[bpat1434]

Great. Please mark this thread as resolved if it is:

Thread Tools --> Mark Thread Resolved.