Links displaying array numbers and not mySQL values

Question

As you can see on http://www.mattmaclennan.co.uk/a2 ... when you hover over "New Motorcycles", it has the array numbers, and not the labels as required. Also, the categories need to be grouped into their IDs. Below is what I have tried.

<?
$output = mysqli_query("SELECT * FROM bikes, bikeTypes WHERE bikes.model_id = bikeTypes.model_id");
$result = array();
while($row = mysqli_fetch_array($output))
  {
    $result[] = $row;
  }
//var_dump($result);
 foreach ($result as $key => $val) {
    echo "<li><a href='test.php?id=" . $val['model_id'] . "'>".$key.'</a><ul>';
    echo "<li><a href='details.php?id=" . $val['bike_id'] . "'>" . $val['bikeName'] . "</a></li>";
    echo '</ul>';   
    echo '</li>';
  }
?>

The category field is called 'model'. Thanks for any help!

Darius · Accepted Answer · 2012-11-01 20:15:19Z

1

Thats because you're display the $key, instead of the $value.

<?
$output = mysqli_query("SELECT * FROM bikes, bikeTypes WHERE bikes.model_id = bikeTypes.model_id");
while($row = mysqli_fetch_array($output))
  {
     echo "<li><a href='test.php?id=" . $row['model_id'] . "'>".$row['???'].'</a><ul>';
     echo "<li><a href='details.php?id=" . $row['bike_id'] . "'>" . $row['bikeName'] . "</a></li>";
     echo '</ul>';   
     echo '</li>';
  }
?>

answered Nov 1, 2012 at 20:15

Darius

6122 gold badges11 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Matt Maclennan Over a year ago

Hey there! thanks for the input. it has added the names successfully, but need it grouped now. I tried adding "GROUP BY bikes.model_id", but that didn't work. Any ideas?

Darius Over a year ago

What do you mean? How are you trying to display the information? GROUP BY may not be what you're looking for.

Collectives™ on Stack Overflow

Links displaying array numbers and not mySQL values

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related