I have a table like this:
$sql = "CREATE TABLE dramaStudio
(
rowId varchar(1) not null,
columnId int not null,
status int,
firstName varchar(15) not null,
lastName varchar(15) not null,
updatedby varchar(10),
PRIMARY KEY (rowId, columnId)
)";
On the homepage of my website I would like the user to be able to see if there are any free seats without going on to the seating plan. Pretty much just a bit saying 'free seats:'followed by a number. My logic in pseudo code would be:
$j=0
select * from dramaStudio
for every status == 0
$j+1
echo $j
Any help will be greatly appreciated.