[php]SELECT * from tstraffle r, items i WHERE r.RID =1 AND i.raffle_id=1[/php]
[php]/*
Navicat MySQL Data Transfer
Source Server : Localhost
Source Server Version : 50523
Source Host : localhost:3306
Source Database : raffle
Target Server Type : MYSQL
Target Server Version : 50523
File Encoding : 65001
Date: 2014-03-11 10:42:18
*/
SET FOREIGN_KEY_CHECKS=0;
– Table structure for items
DROP TABLE IF EXISTS items
;
CREATE TABLE items
(
item_id
int(11) NOT NULL AUTO_INCREMENT,
raffle_id
int(11) DEFAULT NULL,
item
varchar(255) DEFAULT NULL,
item_info
varchar(255) DEFAULT NULL,
PRIMARY KEY (item_id
),
KEY raffle_id
(raffle_id
),
CONSTRAINT items_ibfk_1
FOREIGN KEY (raffle_id
) REFERENCES tstraffle
(RID
) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
– Records of items
INSERT INTO items
VALUES (‘1’, ‘1’, ‘172’, ‘Unique1’);
INSERT INTO items
VALUES (‘2’, ‘1’, ‘173’, ‘Unique2’);
INSERT INTO items
VALUES (‘3’, ‘1’, ‘174’, ‘Unique3’);
– Table structure for tstraffle
DROP TABLE IF EXISTS tstraffle
;
CREATE TABLE tstraffle
(
RID
int(11) NOT NULL AUTO_INCREMENT,
nameofraffle
varchar(30) NOT NULL,
slots
varchar(16) DEFAULT NULL,
noofpeople
varchar(32) DEFAULT NULL,
duration
varchar(32) DEFAULT NULL,
otherinfo
varchar(32) DEFAULT NULL,
entfees
varchar(32) DEFAULT NULL,
entinfo
varchar(255) DEFAULT NULL,
PRIMARY KEY (RID
)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
– Records of tstraffle
INSERT INTO tstraffle
VALUES (‘1’, ‘My First raffle’, ‘12’, ‘12’, ‘36’, ‘Please Do it fast’, ‘222’, ‘Please do it fast’);
[/php]