splitting the strings of an array

ade

$result = mysql_query($query,$link_id) or die ("Query failed");
while($data = mysql_fetch_row($result))

$id =$data[0];
$name=$data[1]

echo "$id";
etc }

what i want to do is to split the string into into other variables,

i want it to loop thru the rows but assign variables for example

$data[0] values are $id1, $id2, $id3 etc
$data[0]=123 $id1=1 $id2=2 $id3=3 if you get what i mean?

cgraz

mmmmm. . . why would you want an array ($data[0]) if you only want one key? A better way to do this would be to have each id be a different key in the array. Simple enough.


while($row = mysql_fetch_array($query)) {
   $data[] = $row["id"];
}

That will create an array, $data, and each key will hold a different id. So if you have three id's

1, 2, and 3

The output will look like this:

$data
0 => 1
1 => 2
2 => 3

However if you want it to output a variable that holds the value "123" for whatever reason, you could do it like this:


$ids = "";
while($row = mysql_fetch_array($query)) {
   $ids .= $row["id"]
}

I don't think this is a very good way to do it. What if you you have double-digit id's (ten and above). You'll have a string that looks like this

01234567891011121314151617181920

That's just ugly. Array would be not only nicer, but much easier to use for other purposes by looping through.

Good luck.

Cgraz

ade

$query = "SELECT * FROM members";
$result = mysql_query($query,$link_id) or die ("Query failed");
while ($row = mysql_fetch_array($result)) {
$data[] = $row["id"]; 
echo "$data[0]<br>";
echo "$data[1]<br>";
echo "$data[2]<br>";
[code=php] }

that nearly gets there but the output it is odd

1
2

1
2
3

i want it show
1
2
3

cgraz

You are echoing the variables inside of the while loop. Think about this logically. The first time the while loop is executed

$data[0] = 1
$data[1] =
$data[2] =

The second time the while loop is executed

$data[0] = 1
$data[1] = 2
$data[2] =

The third time the while loop is executed

$data[0] = 1
$data[1] = 2
$data[2] = 3

Now if you output each time the while loop is executed, you are going to get

1
2

1
2
3

Make sense?

Cgraz

ade

got you now, its slightly different to the

mysql_fetch_row and fetch_object function

i was wondering if i could run two fetch_array function at the same time

while($row = mysql_fetch_array($query)) { 
   $data[] = $row["id"]; 
while($names=mysql_fetch_array($query)){
   $name[] = $names["name"];
}}

i'll have a play around and see what results i get

cgraz

Why would you need two fetch arrays? You can do what you want with just one.

while($row=mysql_fetch_array($query)) {
   $date[] = $row["id"];
   $name[] = $row["name"];
}

Cgraz

ade

i need to get two arrays for a flash movie

one array for a picture the other for and id or name, for example i want to show each member of band a then someone can click and see more about that member

one would work actually but i am playing safe if i use two

cgraz

one would work actually but i am playing safe if i use two

It wouldn't be playing it safe; it'd simply be un-necessary. If you just want to form two arrays as I did in my previous post, one mysql_fetch_array is sufficient. You can do two if you chose; one more fetch array isn't going to slow down the processing time to anything significant, but it's good coding to keep things simple.

Good luck.

Cgraz

ade

easiest thing is to show you when i am finished, thx for the help saved me hours of pulling my hair out and swearing at the computer