[Resolved] how to store a table

[NoBullMan]

Hi,
how can I store, and retrieve, values of a table into an assciative array?

I have a table of item_id, item_name, item_qty,item_price, ...

Can I do:

$arr[$item_id]['name'] = $item_name;
$arr[$item_id]['qty'] = $item_qty;

then to access each row:

foreach($arr as ???)

How would I sort using ksort()?

[weekender]

yep, that's how you'd store them

so say we add the following

$arr[3]['name'] = "frank";
$arr[3]['surname'] = "smith";

then, to access them -

foreach($arr AS $id=>$row){
echo $id; // for above, would echo 3;
echo $row['name']; // would echo frank;
}

[weekender]

forgot to answer the ksort question - to sort by id, do this

ksort($arr);
reset($arr);

reset just moves the array pointer back to the start, so when you start looping through the values, it will start at the first element after the sort process, not the element which was originally first

[NoBullMan]

Thanks for the info.

I am not sure what I am doing wrong here:

(Table OrderDetails has OrderDetailsID, TrackingNumber, OptionNumber, Name, Price, Cost, Qty)

  $query = "SELECT * from OrderDetails WHERE TrackingNumber='1234'";

  $res = mysql_query($query);

  if(mysql_numrows($res)>0) 
  {
    while ($row = mysql_fetch_array($res))
    {
      $_SESSION['cart'][$row['OptionNumber']]['Name'] = $row['OptionName'];
      $_SESSION['cart'][$row['OptionNumber']]['Price'] = $row['Price'];
      ....
    }

Then in another file:

  $cart = $_SESSION['cart'];
  ksort ($cart);
  reset ($cart);
  foreach($cart as $id=>$row)
  {
     ....
  }

ksort() expects parameter 1 to be array, null given
reset(): Passed variable is not an array or object
Invalid argument supplied for foreach()

[weekender]

try putting the ksort in the first file, i have a hunch that you can't store arrays in a session (although i think i'm wrong!)

[NoBullMan]

Sorry, my mistake.
I had to declare $_SESSION['cart'] to be an array() first, before using it.