array displaying array

[wazo]

Hi guys

I have a problem, im calling a array into a dropdown. Its showing the correct number of rows but they all display 'array' and not the values from the database

Can anyone help me?

$sql = "SELECT category FROM category";
$result = mysql_query($sql) or die("SQL error: ".mysql_error());

if(mysql_num_rows($result) != 0)
{
 while($tmp = mysql_fetch_assoc($result))
 {
   $allcategory[] = array($tmp);

 }
} 

<? echo "<select name='category'>";
foreach($allcategory as $z) {
   $selected = ($z == $category) ? 'selected="selected"' : '';
   echo "<option value='$z' $selected>$z</option>\n";
}
?>

[hexburner]

If you use the results returned by the database more than once, this is a good approach, else you can just echo the things you need inside the while-loop.
$allCategories = array();

while($row = mysql_fetch_assoc($result))
{
    $allCategories[] = $row;
}

foreach ($allCategories as $dbCategory) {
    $selected = $category == $dbCategory['id'] ? ' selected="selected"' : '';
    echo '<option value="'.$dbCategory['id'].'"'.$selected.'>'.$dbCategory['Name'].'<option>';
} 

[wazo]

it now displays all the categories but doesn't highlight the one it should

[hexburner]

I don't know what fields you have in the table with categories, so it would be nice to be a little more specific on that part.

[byron3@earthlink]

while($row = mysql_fetch_assoc($result)) {
    $allCategories[] = $row;
}

foreach ($allCategories as $dbCategory) {
    if ( $selected == $dbCategory["Name"]) {
        echo "<option value='" .$dbCategory["Name"]. "' selected='selected'>" .$dbCategory["Name"]. "</option>\n";
    } else {
        echo "<option value='" .$dbCategory["Name"]. "'>" .$dbCategory["Name"]. "</option>\n";
    } 
} 

[glowdot]

$selected = $category == $dbCategory['id'] ? 'selected="selected"' : ''; 

    if ( $selected == $dbCategory["Name"]) { 

Aren't you using $selected in two totally different contexts here?

[byron3@earthlink]

it appears there is only one column in category. Go back and look @ the first post in this thread. Follow the post in this thread.

it now displays all the categories but doesn't highlight the one it should

So I can presume the only column would be "Name".

Yes I see your point the code should read.

if ( $category = $dbCategory["Name"] ) { 

[glowdot]

Sorry byron3, for some reason I thought your post was made by the OP. It's been a long day