Drop down bar

[The Doctor]

If I have a database row called rpalignment, and that database row contains two sections, name and id, how do I extract those so that the names appear in a drop-down bar?

I've tried:

Code:

<?php

$sql = "SELECT name,id FROM `".db_prefix("rpalignment");
$res = db_query($sql);

while ($row = db_fetch_assoc($res)){
rawoutput("<option value={$row['id']}>{$row['name']}</option>");
}
rawoutput("</select>");
?>

but that doesn't seem to work.

[Brendan]

Code:

<?php

$sql = "SELECT name,id FROM " . db_prefix("rpalignment") . "";
$res = db_query($sql);

rawoutput("<select name='select'>");
while ($row = db_fetch_assoc($res)){
rawoutput("<option value={$row['id']}>{$row['name']}</option>");
}
rawoutput("</select>");
?>

[The Doctor]

Thanks, Brendan. xD It doesn't seem to work with the SQL query inside the select tags.. xD

[Brendan]

The query isn't in the select tags. I tested it before hand and it was working.

[The Doctor]

The query isn't in the select tags. I tested it before hand and it was working.

Curious and curiouser.. o.o Everything with computers hates me. xD

[Nightborn]

I believe ... Logic is not something made for your 

[The Doctor]

I believe ... Logic is not something made for your 

Logic..? What is this logic you speak of?