MySQL & JavaScript Arrays

[Anon]

Okay, I have a table. Something similar to the following...

---

ID | name | ref_id |

1 | mark | 2 |

2 | chris | 1 |

3 | charles | 4 |

4 | don | 4 |

5 | stacy | 2 |

What I need to do is print out the names into javascript arrays. Easy enough. However, I need a different array for each ref_id group. So, it would print out as follows...

ref_id_1[0] = "chris"

ref_id_2[0] = "mark"
ref_id_2[1] = "stacy"

ref_id_4[0] = "charles"
ref_id_4[1] = "don"

Now, I can easily do this with multiple mysql statements (select name where ref_id=2, etc.). However, as the ref_id column numbers grow this method isn't practical. In addition, whatever method I use needs to be dynamic and the ref_id numbers may skip (4 -> 7).

Any ideas on how to make this more efficient?

[Anon]

try this :

// order it by ref it to group it
$res = mysql_query(... " ORDER BY ref_id");
$previous = "";
$index = 0;
while (($row = mysql_fetch_array($res)!="")
{
$name = $row["name"];
$ref_id = $row["ref_id"];
if ($ref_id==$previous) $index++;
else $index = 0;
print("ref_id_".$ref_id."[".$index."]=\"".$name."\";\n");
$previous = $ref_id;
}

[nostradamus]

I dont know java, but what about a two-dimensional array and a loop

in php that would be :

ref_id(ref_id, counter)

so your array would look like :

ref_id(1, 0) = "chris"
ref_id(2, 0) = "mark"
ref_id(2, 1) = "stacy"
ref_id(4, 0) = "charles"
fer_id(4, 1) = "don"

I think something like that should work in java too.

[Anon]

I have some ideas, hope it helped.  

(1).firstly, you should execute such sql statement: "select * from you_table order by ref_id"
      your table would be the following... 

---

ID | name | ref_id |

2 | chris | 1 |

1 | mark | 2 |

5 | stacy | 2 |

3 | charles | 4 |

4 | don | 4 |

(2).secondly: some codes like this:

  $curr_id = 0 ; 
  $c = 0 ;
  while ($row = mysql_fetch_array()) {

    if ($row("ref_id") == $curr_id) $c ++;
    else $c = 0;

        print ("ref_id_" . $row("ref_id") . "[" . $c . "] = \"" . $row("name") . \";\n";

    $curr_id = $row("ref_id");

    }

I don't test it , but it should work . if you still have some questions, u can email me: [e-mail]