skaUhhT6

1CREATE TABLE IF NOT EXISTS `manycars` (
2  `vin` int(10) unsigned NOT NULL AUTO_INCREMENT,
3  `hasGps` tinyint(1) NOT NULL COMMENT '1= TRUE, 0=FALSE',
4  `hasTow` tinyint(1) NOT NULL COMMENT '1= TRUE, 0=FALSE',
5  `hasRadar` tinyint(1) NOT NULL COMMENT '1= TRUE, 0=FALSE',
6  `hasPsteer` tinyint(1) NOT NULL COMMENT '1= TRUE, 0=FALSE',
7  PRIMARY KEY (`vin`),
8) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
9	
10CREATE TABLE IF NOT EXISTS `singlecars` (
11  `vin` int(10) unsigned NOT NULL AUTO_INCREMENT,
12  `options` int(3) unsigned NOT NULL COMMENT '1= GPS, 2=Tow, 4=radar, 8=psteer',
13  PRIMARY KEY (`vin`),
14) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
15	
16$q=SELECT options, vin FROM singlecars
17$r=mysqli_query($dbconnect, $q);
18while($record = mysqli_fetch_array($r, MYSQLI_ASSOC)){
19  $option=decbin($record['options']; // returns binary
20  $gps=substr($option,3,1);
21  $tow=substr($option,2,1);
22  $radar=substr($option,1,1);
23  $psteer=substr($option,0,1);
24  echo "GPS=$gps, Tow package=$tow, Radar=$radar, Power Steering=$psteer <br />";
25}