How to get variables from MySQL Query (multiple level array)?

Question

I have the following:

$sql = "SELECT c.category_name
         , c.category_name_url 
    FROM blog_categories AS c 
      JOIN blog_articles AS a
        ON a.category_name = c.category_name
    WHERE c.category_status = 'online'
    GROUP BY c.category_name
    ";

$result = mysql_query($query) or die(mysql_error());

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

$category_name = $row['c']['category_name'];
$category_name_url = $row['c']['category_name_url'];

}

But it's not working (generating blanks). I'm sure I'm doing something wrong, but I don't know what the formal terms of what I'm looking for is so Google is no help =/.

Why are you JOINing on blog_articles - it doesnt look like you are using it at all? — Cody Caughlan
– Cody Caughlan, Commented Jul 14, 2011 at 13:08

Mithun Satheesh · Accepted Answer · 2011-07-14 13:07:25Z

3

code was not running because you dint supply a valid resource for the mysql_fetch_array. also $row will be a single dimensional array.

$sql = mysql_query("SELECT c.category_name
     , c.category_name_url 
FROM blog_categories AS c 
  JOIN blog_articles AS a
    ON a.category_name = c.category_name
WHERE c.category_status = 'online'
GROUP BY c.category_name
");

 while($row = mysql_fetch_array($sql)) {

 $category_name = $row['category_name'];
 $category_name_url = $row['category_name_url'];

 }

answered Jul 14, 2011 at 13:07

Mithun Satheesh

27.9k14 gold badges80 silver badges103 bronze badges

Add a comment |

Raffael · Accepted Answer · 2011-07-14 13:15:52Z

1

$category_name = $row['category_name'];

Well, I vote for PDO, but I am pretty sure you can skip the 'c', as $row will refer to the fieldname. The c is just evaluated by the DBMS to associate the field with the propper table.

edited Jul 14, 2011 at 13:15

answered Jul 14, 2011 at 13:04

Raffael

20.1k16 gold badges92 silver badges168 bronze badges

Also by using mysql_fetch_array() you can use indices. Ex: $row[0] for category_name, $row[1] for category_name_url etc.

Sinan
– Sinan

07/14/2011 13:09:50
Commented Jul 14, 2011 at 13:09

Add a comment |

LeleDumbo · Accepted Answer · 2011-07-14 13:03:54Z

0

You should call mysql_query on your $sql (the sql query), you then call mysql_fetch_array againts the result of the call. Anyway, you should almost always call mysql_error to check for errors.

answered Jul 14, 2011 at 13:03

LeleDumbo

9,3704 gold badges26 silver badges38 bronze badges

Ah, actually I did do that (I just didn't add that line in there) - edited for clarification :)

Jay
– Jay

07/14/2011 13:07:08
Commented Jul 14, 2011 at 13:07

Add a comment |

Collectives™ on Stack Overflow

How to get variables from MySQL Query (multiple level array)?

3 Answers 3

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Your Answer

Sign up or log in

Post as a guest

Related