[MYSQL] A recursive query?

[MYSQL] A recursive query?

El Forum
Guest

03-13-2009, 05:01 AM

[eluser]pistolPete[/eluser]
I'd suggest having a look at SQL JOIN.

How does your database layout look like?
How many levels do you have in your structure? Could you give an example of the structure?

Btw: You have a syntax error in your function.

Code:
// is always TRUE because of the single '='

if ($sub_categories=$this->get_children($row['child']))

Messages In This Thread

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 04:28 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 04:57 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 05:01 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 05:10 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 05:13 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 05:19 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 05:30 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 09:11 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 10:09 AM

[MYSQL] A recursive query? - by El Forum - 03-13-2009, 10:15 AM

[MYSQL] A recursive query? - by El Forum - 03-14-2009, 02:25 AM

[MYSQL] A recursive query? - by El Forum - 03-14-2009, 05:26 AM