Creating an array

[master82]

I need to create an array from a list of IDs within a database table.

 

The table consists of 3 fileds, a unique ID, a user ID and the last is an int value (item number)

 

eg

1 3 7

2 4 5

3 3 2

etc...

 

How would I go about using this query

 

$query1=mysql_query("SELECT itemnumber FROM table WHERE userid = '{$user}'");

 

Would i be right in thinking I can use:

$array = mysql_fetch_array($query1);

 

to store all the item numbers associated with the user specified in the first query?

[per1os]

while ($row = mysql_fetch_array($query1)) {
$array[] = $row;
}
print_r($array);

[Dragen]

$sql = "SELECT itemnumber FROM table WHERE userid = '{$user}'";
if($result = mysql_query($sql)){
	if(mysql_num_rows($result) > 0){
		while($row = mysql_fetch_assoc($result)){
			$itemnumber[] = $row['itemnumber'];
		}
	}else{
		echo 'not found';
	}
}else{
	echo mysql_error();
}
}

[master82]

Would they allow me to place the array into another select query (in the where part) later on, or cant you place an array into such  queries?

[Dragen]

for that you'd need to echo out the array using a foreach statement.

for example:

$sql = "SELECT ";
foreach($array as $key => $value){
     $sql .= $value . ", ";
}
$sql .= "FROM table WHERE userid = '{$user}'";

 

That's an example. It wont work completely, because you'll have a ',' just before FROM which wont work.

You'd have to check if it's the last one in the array and if so NOT output the ','