Wednesday, March 28, 2012

doubt of join in cakephp

Hello, i have a doubt regarding join in cakephp. i have a primary key
which is a foreign key of other table... i want to retrieve the table
along with values s in othertable by checking some condition sin two
tables.....
fields in first table:- db_offer
offer_id seller_id package_id category_id reference_no title
description extra_details offer_price original_price offer_weblink
published offer_coverimage start_date end_date gallery_type flash_file
width height embed_code notes hot_deals cleranace_deals today_special
views

other table:-db_offerpromotion
id offer_id offer_type start_date end_date added_date published

i want to retrive all values of offer with offerid from two tables
with condition that todays date less than end datyes of offerpromo..
can u please help..me..it's urgent?? how i can do this???

when iam using hasmany... it retreives table but it is not performing
check condition..pls help??

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.


To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

No comments: