Programming Help

Web Development

Welcome to Dream.In.Code
	Getting PHP Help is Easy! Join 117,543 PHP Programmers for FREE! Ask your question and get quick answers from experts. There are 1,710 online right now! We've got more than 500 tutorials and 2,000 snippets. Join and find out why Dream.In.Code is the #1 programming help community on the internet! Registration is fast and FREE... Join Now! Chat LIVE With a PHP Expert Register to Make This Box Go Away!

dilemmalurve	20 Jul, 2008 - 06:56 PM Post #1
New D.I.C Head Joined: 22 Jun, 2008 Posts: 16 My Contributions	Hi, I need help. I have a marketplace page which has a table which shows all the different contests. However, when i have selected a particular contest and returns to the contest page, im not supposed to see THAT CONTEST anymore. The problem should lie with the select statement. Marketplace uses a database table called CONTEST and the people who selected the contest will be saved into CONTESTANTS table. CODE $result2; if ($select==""){ $result2=mysql_query("select * from Contest c, Contestants d where NOT (c.CON_ID = d.CON_ID AND c.CON_TITLE = d.CON_TITLE) ORDER BY $sort LIMIT $offset, $rowsPerPage"); } PS:USERS ARE USING COOKIES. USER_NAME = '$_COOKIE[ID_my_site]' thanks!!!(: This post has been edited by dilemmalurve: 20 Jul, 2008 - 06:58 PM
	This Post Was Helpful! ^New!

dilemmalurve	20 Jul, 2008 - 07:40 PM Post #2
New D.I.C Head Joined: 22 Jun, 2008 Posts: 16 My Contributions	Forgot to mention about the fields in the table. In Contest CON_ID USER_NAME CON_TITLE CON_DESC CAT_TITLE START_DATE END_DATE PRIZE_AMT PRIZE_QTY INVOICE In Contestants CON_TITLE ID CON_ID USER_NAME JOINED_DATE BLOG_URL Thanks!
	This Post Was Helpful! ^New!