[SOLVED] problem with setting up array

[DLR]

Hi all,
I'm trying to set up an array from a table on MySQL so I can use the data in a form, using select - the data will be options. I'm trying to set up an array called sweets[]

I run the code below and it prints out "category_id" ([color=pink]I expected a value of 1 from the table[/color]!), then "Fatal error: Function name must be a string in C:\SignForce web site\site\form_test.php on line 12"

I'm lost - Please help!

Thank you

[code]
1.//Get info for array from database table
2.
3.include("SFconn.php"); // connects to database
4. $query = "SELECT category_id,category FROM categories";
5. $result = mysql_query($query) or die(mysql_error());
6.
7. while ($row = mysql_fetch_assoc($result)) {
8.
9. foreach ($row as $category_id => $category) {
10. echo $category_id . "<br>";
11.      $sweets['category_id'] = $category;
12. echo $sweets(category_id);
13. }
14. }
[/code]

[Tyche]

The error is caused by the () you used on line 12 :

echo $sweets(category_id);

As it's an arry you need to use [] to reference elements
Try this instead
echo $sweets['category_id'];

[DLR]

Thanks for this help. Solved part of the problem - now I have a "wrong data" problem!