Re: [PHP-DB] sql query problem From: SenthilVelavan (senthilvellan <email protected>)
Date: 06/14/02

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: <chip.wiegand <email protected>>
To: <php-db <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 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