[SOLVED] Can someone have a look at this for me please?

[Mardoxx]

id

name

1

Adam

2

Bill

 

<?php

$id_list_array = array(1,2);

			foreach ($id_list_array as $id_number) {
			echo "$id_number<br />";
				if ($row['id'] == $id_number)
				{
					echo $row['id'] . "<!!!>" . $row['name'] . "<!!!>added\n";
					break;
				} else {
					echo $row['id'] . "<!!!>" . $row['name'] . "<!!!>notadded\n";
					break;
				}
			}
?>

 

It just outputs this:

 

2<!!!>Bill<!!!>notadded

 

 

instead of

 

1<!!!>Adam<!!!>added

2<!!!>Bill<!!!>added

 

 

any ideas why?

 

thanks in advance!

[Mardoxx]

or if anyone can think of a more efficient way of doing it I would be very grateful!

 

What ID is unique, and so are the ID's in the array

 

I can't think of a way of mayching them up other than checking each new row against the whole array.

 

anyone?

[.josh]

what exactly are you trying to accomplish?

[abazoskib]

and what query are you running? perhaps you are pulling the result set in a way where Bill would show up as the first row returned.

[Mardoxx]

SELECT * FROM data

 

 

there's a csv list of data that has been selected posted to the php file this is then exploded to an array.

 

I want this php script to echo ALL the data but give a different output on the data that has an ID which is in the array. (also I want it done in one query if possible)

[papillonstudios]

could we see all the code for this file?

[.josh]

$ids = array(1,2,3);
while($row = mysql_fetch_assoc($result)) {
  if (in_array($row['id'],$ids)) {
    // id is in $ids, do something
  } else {
    // id is not in $ids, do something
  }
}

[papillonstudios]

This should work

 

<?php
$id_array = array(1,2);

while($row = mysql_fetch_assoc($result)) {

  if (in_array($row['id'],$id_array)) {
    
echo $row['id'] . '<!!!>' . $row['name'] .'<!!!>added<br />';

  } else {
    
echo $row['id'] . "<!!!>" . $row['name'] . "<!!!>notadded<br />";

  }
  
}
?>

[Mardoxx]

Crayon Violent, gfadmin

Works great, thank you very much!!!!

 

[papillonstudios]

no problem