Dynamic Table for website
Problem:
Trying to make a booking system.
Need to output a table showing what times on the selected day are 'availabe'. using a MS SQL 2005 database which holds and days/tims that have been booked.
Just now im using:
this is used for each time i want to display.
But when i use this it outputs the CFELSE for all rows returned by the query that dont match the time:
I need this to only display one or the other.
Sorry that was explaned so badly iv got myself v confused.
HELP PLS!
Problem:
Trying to make a booking system.
Need to output a table showing what times on the selected day are 'availabe'. using a MS SQL 2005 database which holds and days/tims that have been booked.
Just now im using:
Code:
<tr>
<td><strong>09:00</strong></td>
<td>
<cfoutput query="bookingResults">
<CFIF Time EQ '09:00'>
booked
<CFELSE>
<a href="confirmBooking.cfm">Available</a>
</CFIF>
</cfoutput>
</td>
</tr>this is used for each time i want to display.
But when i use this it outputs the CFELSE for all rows returned by the query that dont match the time:
I need this to only display one or the other.
Sorry that was explaned so badly iv got myself v confused.
HELP PLS!
Last edited: