hello. i hope you can help...
now, i have 3 tables,
users, categories, links
the fields i am gonna use are:
at users: id
at categories: id, userid, name
at links: id, catid, name, url
what i want to do is, for a user whose id is given, i would like to assign all the categories and links to multidimensional arrays.
like:
$link1 = [catname] [linkname, linkurl]
$link2 = [catname] [linkname, linkurl]
...
how can i do that?
for example, if i have these values at db:
users:
id: 4,
links:
id: 1, catid: 1, name: stuff, url: www.stuff.com
id: 2, catid: 1, name: stufftwo, url: www.morestuff.com
categories:
id: 1, userid: 4, name: kat1
so, i want to assign these values to arrays like that:
$link1 = [kat1] [stuff, www.stuff.com]
$link2 = [kat1] [stufftwo, www.morestuff.com]
sorry for my bad english...
