RE: [PHP-DB] sql query problem From: Ryan Jameson (USA) (RJameson <email protected>)
Date: 06/14/02

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 <email protected> [mailto:chip.wiegand <email protected>]
Sent: Friday, June 14, 2002 3:10 PM
To: php-db <email protected>
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 <email protected>

"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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php