Retrieving Multiple Returns

[Anon]

I'm sort of new to PHP and MySQL. I've been working with it though, I have ran into a problem. I'm trying to find a way to return multiple IDs from a query. Here is my Query:

$result = mysql_query("SELECT ID FROM Table1 Where Field1='<some text>'", $link);

This searches Table1 for all entries that contain <some text> in Field1. I want a list of ID's for each. Does $blah store all of the IDs? When I use:

$num_rows = mysql_num_rows($result);

I get 6, which is the correct number of instances that <some text> appears, but I want a list of IDs. So I can further manipulate the data.

Thanks

[toma42]

loop through your result set and add the id's to an array.

while ($db->next_record()) {
$ids[] = $db->f('key');
}

That's written using phplib's sql class, but I think you get the idea.

BTW, why arn't you using a database abstraction layer?

[Anon]

while( $row = mysql_fetch_array($sql_id) ) {
//do stuff with $row["id"], etc.
}

That's a framework for MySQL specifically. Tom's point is also worth considering: writing a SQL abstraction layer (not that I've done that, but it's worth thinking about 🙂