Re: [PHP-DB] sql query problem

[SenthilVelavan]

Hello Chip,
   Could you please send your program to dig more.And also
send your database schema.
Do you want to
select title,name from your_table_name where title='title1' and
name='blue2';
Is the title and name field are unique.If it so,then the above query will
helps you.
Regards,
SenthilVelavan.P


- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 15, 2002 2:39 AM
Subject: [PHP-DB] sql query problem


> I have a database layout similar to this-
>
> id  order   title   namepagecat
>
> 0   0   title1  blueap
> 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

RE: [PHP-DB] sql query problem

[Ryan Jameson (USA)]

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   namepagecat

0   0   title1  blueap
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