hi i need get list of offer detail which user is insert using User_id this user id already save by session
i need show offer which user insert when he or she login their profile
CREATE TABLE IF NOT EXISTS offer_detail
(
id
int(60) NOT NULL AUTO_INCREMENT,
company_id
int(60) NOT NULL,
offertype_id
int(60) NOT NULL,
category_id
int(60) NOT NULL,
offer_title
varchar(150) NOT NULL,
offer_description
text NOT NULL,
image
varchar(150) NOT NULL,
coupon_id
varchar(60) NOT NULL,
price
text NOT NULL,
unit_id
varchar(60) NOT NULL,
price_now
varchar(60) NOT NULL,
from
varchar(80) NOT NULL,
to
varchar(80) NOT NULL,
[color="#FF0000"][size="4"]user_id
int(10) NOT NULL,[/size][/color]
created
varchar(11) NOT NULL,
modified
varchar(10) NOT NULL,
Active
varchar(100) NOT NULL,
PRIMARY KEY (id
),
KEY company_id
(company_id
,category_id
,coupon_id
,unit_id
),
KEY category_id
(category_id
,coupon_id
,unit_id
),
KEY coupon_id
(coupon_id
),
KEY unit_id
(unit_id
),
KEY offertype_id
(offertype_id
),
KEY user_id
(user_id
,Active
)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
thank you …