query= select parent_id,categoryname from table; if you have any conditions that needs to be satisfied use the below
query= select parent_id,categoryname from table where id=<your condition value>; On 1/14/06, Biman Mandal <[EMAIL PROTECTED]> wrote: > > How I write query from to take the categoryname And Parent CategoryName > from same table. > > > Table > > id Parent_id categoryname > > > --------------------------------- > Yahoo! Photos Showcase holiday pictures in hardcover > Photo Books. You design it and we'll bind it! > > [Non-text portions of this message have been removed] > > > > > > The php_mysql group is dedicated to learn more about the PHP/MySQL web > database possibilities through group learning. > > > > SPONSORED LINKS > American general life and accident insurance > company<http://groups.yahoo.com/gads?t=ms&k=American+general+life+and+accident+insurance+company&w1=American+general+life+and+accident+insurance+company&w2=American+general+life+insurance+company&w3=American+general+life&w4=American+general+mortgage&w5=American+general+life+insurance&w6=Computer+internet+security&c=6&s=230&.sig=Kzn1J6ZDdsfc3f-9JZ-bKQ> > American > general life insurance > company<http://groups.yahoo.com/gads?t=ms&k=American+general+life+insurance+company&w1=American+general+life+and+accident+insurance+company&w2=American+general+life+insurance+company&w3=American+general+life&w4=American+general+mortgage&w5=American+general+life+insurance&w6=Computer+internet+security&c=6&s=230&.sig=q5Z_Gheyyf5dB3KHCkTGOw> > American > general > life<http://groups.yahoo.com/gads?t=ms&k=American+general+life&w1=American+general+life+and+accident+insurance+company&w2=American+general+life+insurance+company&w3=American+general+life&w4=American+general+mortgage&w5=American+general+life+insurance&w6=Computer+internet+security&c=6&s=230&.sig=1O42IK5r5LJ1BBWLyTAAKA> > American > general > mortgage<http://groups.yahoo.com/gads?t=ms&k=American+general+mortgage&w1=American+general+life+and+accident+insurance+company&w2=American+general+life+insurance+company&w3=American+general+life&w4=American+general+mortgage&w5=American+general+life+insurance&w6=Computer+internet+security&c=6&s=230&.sig=AC-EcyrN2MPgqHTxt6lmKg> > American > general life > insurance<http://groups.yahoo.com/gads?t=ms&k=American+general+life+insurance&w1=American+general+life+and+accident+insurance+company&w2=American+general+life+insurance+company&w3=American+general+life&w4=American+general+mortgage&w5=American+general+life+insurance&w6=Computer+internet+security&c=6&s=230&.sig=P8vNlXr7QopQQ3tGIepE4Q> > Computer > internet > security<http://groups.yahoo.com/gads?t=ms&k=Computer+internet+security&w1=American+general+life+and+accident+insurance+company&w2=American+general+life+insurance+company&w3=American+general+life&w4=American+general+mortgage&w5=American+general+life+insurance&w6=Computer+internet+security&c=6&s=230&.sig=OCFX-MPv3cQROoYDEaexxA> > ------------------------------ > YAHOO! GROUPS LINKS > > > - Visit your group "php_mysql<http://groups.yahoo.com/group/php_mysql>" > on the web. > > - To unsubscribe from this group, send an email to: > [EMAIL PROTECTED]<[EMAIL PROTECTED]> > > - Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > > ------------------------------ > -- Regards, Ramesh 'Desire is not the theme of my Life; Life is the theme of my desire' [Non-text portions of this message have been removed] The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
