Newbie Problem!!

[Blood22]

I am creating a booking schedule. When someone books a specific date and time, I hope to show the results to the administrator in the form of a schedule table. However currently I have managed to get the select statement to work and change the background colour of a specific cell.

I was wondering if anyone knew a way in which I could put many select statements into the one table, as the problem at the moment is that if I had 2 select statements for example 10 o clock and 1 o clock, it would produce 2 seperate html tables!

Sorry for trying to describe my problem poorly but...
here is the code so far!:

$dbh = DBI->connect($dsn, {RaiseError =>1});

$sth = $dbh->prepare("SELECT * FROM booking WHERE '$starttime 10:00:00'"

$sth->execute();

print "Content-type: text/html\r\n\r\n";
print "Results of booking search:";
print &quot;<br>&quot;;
while (my $hashref = $sth->fetchrow_hashref()) {
print &quot;<br>&quot;;
print &quot;<table width=100% border=1 bordercolor=#000000>&quot;;
...

then I list the table as a schedule, however every cell is white except the one that matches the select statement for example ..

print &quot;<td bgcolor=#ff0000>&nbsp;</td>&quot;;

then

$sth->finish();
$dbh->disconnect();
exit(0);

Any ideas or suggestions to help would be really appreciated!!!

Si22

 

[AHinMaine]

Wouldn't an OR work in this case?

select * from foo where bar = 'baz' OR 'quux'

--
Andy

http://www.nachoz.com

 

[Coderifous]

It's been a while, but I think that it will not work like that. But rather:

select * from foo where bar = 'baz' OR bar = 'quux'

--jim

 

[AHinMaine]

Oops, yes that's correct...

--
Andy

http://www.nachoz.com