64Digits

PHP/Mysql Help? [SOLVED]

Posted by Glen on Nov. 28, 2010, 10:51 p.m.

Kinda confused by the online tutorials on this one.

I have a table that contains id's of entries in a given category.

Table "categories"

id | category

11 | red

9 | red

8 | red

22 | blue

5 | blue

7 | green

Let's say I use this:

$query = "SELECT id FROM categories WHERE category='red'";

$result = mysql_query($query);

I need an array that would be in this format:

$ids = array("11","9","8");

How do I do the conversion? Using the result from the selection?

I need the variable $ids to be in that format for a function I'm using but can't seem to get the 11,9, and 8 like that. Any help?

Comments

Glen 14 years, 1 month ago

The output of that is only the first id with the category red. I only get 11 in return.

aeron 14 years, 1 month ago

No Spectre, that will only give you the columns of $r for the first element in the mysql result. You have to repeat the mysql_fetch part for every element in the result. Easiest way of doing so is with a while loop:

$query = "SELECT id FROM categories WHERE category='red'";
$result = mysql_query($query);

$ids = array();
while($r = mysql_fetch_assoc($result))
{
  $ids[] = $r["id"];
}

print_r($ids);

It's also worth noting that I had to construct the $ids array manually. I don't think there are any shortcuts to doing this but it's a very simple technique regardless. You have to instantiate it with array(); but after that you can use the empty brackets to append all the values. Happy coding!

firestormx 14 years, 1 month ago

Exactly what aeron said.

Glen 14 years, 1 month ago

Thanks aeron. That worked perfectly!

Zarniwooop 14 years, 1 month ago

w3schools?

Gift of Death 14 years, 1 month ago

php.net? :P

Glen 14 years, 1 month ago

a tutorial is not worth the advice of a person whose experienced. I can ask questions about something when a person shows me how to do something whereas tutorials are usually vague and don't respond when you ask them something. Typical responses post 8 and 9.