Having problems with message search?
I need all cats, subcats to be in one select box, how do I do
that ?
Mohamed Badr
Senior Web Application Developer
OmegaSoft Projects
mob: +2 010 2050009
website: http://www.mohamedbadr.com/
From: phpresource@yahoogroups.com
[mailto:phpresource@yahoogroups.com] On Behalf Of Muhammad Rizwan Nawaz
Sent: Monday, June 08, 2009 11:43 AM
To: phpresource@yahoogroups.com
Subject: RE: [phpResource] multilevelscategories
Either you can used the recursive function as suggested by Atif or you can use
AJAX to reach at certain level. AJAX will be more efficient technique as in
this way you are just loading required data.
Thanks
Best Regards,
Muhammad Rizwan Nawaz
Email / MSN Messenger: rizwan_nawaz786@...
Gmail: rizwannawaz@...
Yahoo IM: rizwan051
AOL IM: riznawaz
Skype: rizwannawaz
ICQ: 442047681
=============
SECURITY NOTICE
=============
THE INFORMATION CONTAINED IN THIS TRANSMISSION IS PRIVILEGED AND
CONFIDENTIAL. IT IS INTENDED FOR THE USE OF THE INDIVIDUAL OR ENTITY
NAMED ABOVE. IF THE READER OF THIS MESSAGE IS NOT THE INTENDED
RECIPIENT, YOU ARE HEREBY NOTIFIED THAT ANY DISSEMINATION, DISTRIBUTION OR COPY
OF THIS COMMUNICATION IS STRICTLY PROHIBITED.
IF YOU HAVE RECEIVED THIS COMMUNICATION IN ERROR, PLEASE
IMMEDIATELY NOTIFY AND RETURN THE ORIGINAL MESSAGE TO THE SENDER AND DELETE IT.
THANK YOU.
To: phpresource@yahoogroups.com
From: atif_majid10@...
Date: Mon, 8 Jun 2009 01:08:48 -0700
Subject: Re: [phpResource] multilevelscategories
In
this case, you will have to check if the current ID has been used as parent or
no. If yes, run the query to find its child. Most probably, you will be writing
a recursive function to achieve this.
Atif Majid
Software Developer.
Tawasul Telecom
Kuwait Free Zone, Block C-28, D9, Shuwaik, Kuwait
Phone: +965 2295 7164
Mobile: +965 6708 53 95
www.tawasultele.com
From: Mohamed BADR <badr@...>
To: phpresource@yahoogroups.com
Sent: Monday, June 8, 2009 10:53:09 AM
Subject: RE: [phpResource] multilevelscategories
But that
means for each level I have to do a select query, and I don’t know how many
levels are there, it should be unlimited so how do I do that ??
Mohamed
Badr
Senior Web Application Developer
OmegaSoft
Projects
mob: +2 010
2050009
website: http://www.mohamedb adr.com/
From: phpresource@ yahoogroups. com [mailto:phpresource
@yahoogroups. com] On Behalf Of Muhammad Rizwan Nawaz
Sent: Monday, June 08, 2009 6:36 AM
To: phpresource@ yahoogroups. com
Subject: RE: [phpResource] multilevel categories
Hi,
Top most element don't have parent so it's partent_id is 0. Your first query is
Select * from hosp_categories where parent_id = '0'
This will give you the top elements which you can loop and shows in <select.
Once the user select any of the element in Top <select you have to pass it's
id in query string and run the following query to load the child,
select * from hosp_categories where parent_id = '$ID FROM QUERY STRING'
This will give you the list of child of selected which you can easily show in
<select. Same procedure is follow for next level of category. You can go
till n level with this approach.
Thanks
Best Regards,
Muhammad Rizwan Nawaz
Email / MSN Messenger: rizwan_nawaz786@ hotmail.com
Gmail: rizwannawaz@
gmail.com
Yahoo IM: rizwan051
AOL IM: riznawaz
Skype: rizwannawaz
ICQ: 442047681
============ =
SECURITY NOTICE
============ =
THE INFORMATION
CONTAINED IN THIS TRANSMISSION IS PRIVILEGED AND CONFIDENTIAL. IT IS
INTENDED FOR THE USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. IF THE
READER OF THIS MESSAGE IS NOT THE INTENDED RECIPIENT, YOU ARE HEREBY NOTIFIED
THAT ANY DISSEMINATION, DISTRIBUTION OR COPY OF THIS COMMUNICATION IS STRICTLY
PROHIBITED.
IF YOU HAVE
RECEIVED THIS COMMUNICATION IN ERROR, PLEASE IMMEDIATELY NOTIFY AND RETURN THE
ORIGINAL MESSAGE TO THE SENDER AND DELETE IT. THANK YOU.
To: phpresource@ yahoogroups. com
From: badr@mohamedbadr. com
Date: Sun, 7 Jun 2009 15:45:27 +0300
Subject: [phpResource] multilevel categories
I have
categories table with multilevel categories I need to make the insert statement
for the sub categories and sub subcategories so I need to populate a
<select> box with this tree so I can insert the parent id with the new
subcategory
Anyone
knows how to populate this select box with the tree ??
The table
is here
CREATE
TABLE IF NOT EXISTS `hosp_categories` (
`category_id` int(10) NOT NULL auto_increment,
`parent_id` int(10) NOT NULL,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
`image` varchar(255) NOT NULL default '',
PRIMARY KEY (`category_id` )
)
ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT= 7 ;
Lauren found her dream laptop. Find the
PC that’s right for you.
Hotmail® has ever-growing storage! Don’t worry about storage
limits. Check it out.
Offline 
Send Email