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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 14, 2002 3:10 PM
To: [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
[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

Reply via email to