Re: sql query problem
| From: | SenthilVelavan | Date: | Sat, 15 Jun 2002 03:21:18 +0000 |
| Subject: | Re: sql query problem | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19821@lists.php.net to get a copy of this message | ||
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@simrad.com>
To: <php-db@lists.php.net>
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@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
>