RE: [PHP-DB] sql query problem

The problem is they are parts of different rows. In a relational database rows only know about other rows through relationships. You have either: 1. Designed your database incorrectly. or 2. Are a genius with a unique concept that I do not grasp. <>< Ryan -----Original Message----- From: chip.wiegand@simrad.com [mailto:chip.wiegand@simrad.com] Sent: Friday, June 14, 2002 3:10 PM To: php-db@lists.php.net Subject: [PHP-DB] sql query problem I have a database layout similar to this- id order title name page cat 0 0 title1 blue ap 1 2 blue1 page1 ap 2 3 blue2 page2 ap 3 1 blue3 page3 ap I would like to get title1 (title column only) and blue2 (name column only) like this- title1 blue2 I am finding it difficult to write the proper select statement to get just those items in a web page using php/mysql. Suggestions? -- Chip Wiegand Computer Services Simrad, Inc www.simradusa.com chip.wiegand@simrad.com "There is no reason anyone would want a computer in their home." --Ken Olson, president, chairman and founder of Digital Equipment Corporation, 1977 (They why do I have 9? Somebody help me!) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php