Loop doesn't seem to be working for me in my AWS script

[RockNRollPig]

In this:
$ArraySearchString = array(
497024 => "Web Development",
229614 => "Graphics",
497022 => "Video & Music"
);I'm trying to use a loop to eacho the node and name from my database and have tried doing it like so:
$ArraySearchString = array(
while($row = mysql_fetch_array($result1)){
echo($row['amazonid'] =>."".$row['name'].",");
}
);But I get a parse error on this row:
while($row = mysql_fetch_array($result1)){Anyd ideas?

[GCT13]

You don't need those mysql functions, your BrowseNodes are stored in an array, not in a database.

Echo the array like this:
foreach($ArraySearchString as $key => $value){
echo $key. ', ' .$value;
}

[RockNRollPig]

That's what I'm saying...i'm trying to populate the array with the correct nodes and category titles. And my database has the nodes and category titles.

[GCT13]

If your data is stored in the database, you don't need to re-create the $ArraySearchString array.

[RockNRollPig]

Hmm...well I'm using the tutorial you wrote...so in aws-functions.php...what goes in $ArraySearchString?
$ArraySearchString = array(

#what goes here#

);

[MattM]

I'm storing the nodes in a database and I don't have anything under $ArraySearchString. You won't need it unless you want to echo that variable instead of the database.

[RockNRollPig]

Originally posted by MattM
I'm storing the nodes in a database and I don't have anything under $ArraySearchString. You won't need it unless you want to echo that variable instead of the database. Well...for instance, in browse.php this code:
if(!isset($ArraySearchString[$Browse])){ i'm assumign i just need to remove that?

[GCT13]

In the tutorial I used an array to store the BrowseNode info for a handful of reasons. If your BrowseNode info is stored in a database then you'll have to find each instance of $ArraySearchString and update it to pull the data from the database instead.

[RockNRollPig]

Ah...ok...

[MattM]

I didn't explain correctly on my part - I updated it to pull the data from the database instead.

[RockNRollPig]

Originally posted by MattM
I didn't explain correctly on my part - I updated it to pull the data from the database instead. That's what I've been trying to do from the start...and it wasn't working. Are you saying you updated $ArraySearchString to pull it's info from the database? If so...how?

[GCT13]

AutomatikStudios, if you don't have a lot of BrowseNodes you may want to use the array setup for now for whatevery site you're working on. That'll give you time to work on the database setup.