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 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