Not Returning Primary_Key Field

[poisedforflight]

I am trying to implement a drop down menu for a form. The select name should be a field(topicName) from the MySQL db, and the select value should be another field(topicId) which is also the key for the table. My script is returning the topicName properly, but not the topicId. Any ideas?

Here's the code:

<?
dbConnect("jmcclure_MyNotes");
print "<select name='topicParent'>";
print "<option value = 'new'>New Page</option>";

$queryA = "SELECT topicId FROM topicsTable WHERE topicParent = 'NULL'";
$queryB = "SELECT topicName FROM topicsTable WHERE topicParent = 'NULL'" ;
$resultA = mysql_query($queryA) or die ("Query 'A' Failed");
$resultB = mysql_query($query😎 or die ("Query 'B' Failed");

while($topId = mysql_fetch_assoc($resultA)){
foreach($topId as $col=>$valA){
print "<option value= $valA>";
}
}
while($topName = mysql_fetch_assoc($result😎){
foreach($topName as $col=>$val😎{
print "$valB";
}
}
print "</select>";
?>

[bretticus]

There is no need to run two identical queries different only by column. Instead get both columns with one query.

Try this...

dbConnect("jmcclure_MyNotes");
print "<select name='topicParent'>";
print "<option value = 'new'>New Page</option>\n";
$query = "SELECT `topicId`, `topicName` FROM `topicsTable` WHERE `topicParent` = 'NULL'";
$result = mysql_query($query) or die ("Query Failed");
while($row = mysql_fetch_assoc($result)){
	print "<option value=\"{$row['topicId']}\">{$row['topicName']}</option>\n";
}
print "</select>";
?>

[poisedforflight]

Can you tell me if this will do the same thing? Sorry for the newbie questions.

<?
dbConnect("jmcclure_MyNotes");
$query = "SELECT topicId, topicName FROM topicsTable WHERE topicParent = NULL'";
$result = mysql_query($query) or die ("Query 'A' Failed");

 print "<select name='topicParent'>";
 print "<option value = 'NULL'>New Page</option>";
   while($row = mysql_fetch_assoc($result)){
       $topId = $row['topicId'];
       $topName = $row['topicName']; 
       print "<option value = $topId>$topName</option>";
   }

[bretticus]

yep, same thing.