IF STATEMENT HELP

Posted on 16th Feb 2014 07:03 pm by admin

Hi
i have created a calendar from a table:

Code: Calendar: October 2009
<table width=300 border="1">
<tr>
<th><a href="calendar.php"><</a></th>
<th>M</th>
<th>T</th>
<th>W</th>
<th>T</th>
<th>F</th>
<th>S</th>
<th>S</th>
<th><a href="calendar.php?nov09">></a></th>
</tr>
<tr>
<td></td>
<td>&nbsp; </td>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td>1</td>
<td>2</td>
<td>3</td>
<td>4</td>
</tr>
<tr>
<td></td>
<td>5 </td>
<td>6</td>
<td>7 </td>
<td>8 </td>
<td>9 </td>
<td>10 </td>
<td>11 </td>
</tr>
<tr>
<tr>
<td></td>
<td>12 </td>
<td>13 </td>
<td>14</td>
<td>15 </td>
<td>16 </td>
<td>17 </td>
<td>18 </td>
</tr>
<tr>
<td></td>
<td>19 </td>
<td>20 </td>
<td>21 </td>
<td>22</td>
<td>23 </td>
<td>24 </td>
<td>25 </td>
</tr>
<tr>
<td></td>
<td>26 </td>
<td>27 </td>
<td>28 </td>
<td>29 </td>
<td>30 </td>
<td>31 </td>
<td>&nbsp; </td>
</tr>
</table>

The table works fine.
But i have a mysql table and it has some dates in it, so for example it has 01102009 which is the 1st October 2009 and it has another date eg. 12102009 which is the 12th October 2009 etc. I want it so that the table recognises the dates and the dates are shown in blue. I was going to do this like this:
Code: $booked = mysql_query("SELECT * FROM calendar WHERE `company` = '$logged[company]'");
$booked = mysql_fetch_array($booked);
echo'
<table border="1">
<tr>
<td>M</td>
<td>T</td>
<td>W</td>
<td>T</td>
<td>F</td>
<td>S</td>
<td>S</td>
</tr>
<tr>
<td>';
if($booked[datebooked] == "01102009"){
echo"<font color='blue'>01</font>";
}
else{
echo"01";
}
echo'</td>
<td>';
if($booked[datebooked] == "02102009"){
echo"<font color="blue">02</font>";
}
else{
echo"02";
}
echo'</td>
<td>03</td>
<td>04</td>
<td>05</td>
</tr>
</table>
';
And so on, this works the first time so 01 would be blue, but 12 would be normal, i know this is something to do with it only being able to select one at a time, but i dont know how to fix it, any ideas.
I could maybe use a while loop if anyone hasnt got any better ideas???
Thanks In Advance

Your Answer:

Login to answer

Other forums

Delete records not in top 15
Hi,

I'm creating a hall of fame page in my game and the page will only display the top 15 sco

PHP Login
Hey!
I got this shopcart code online, am trying to modify it but am getting an error when i try a

Any help with my email script?
I have an email script, I have not tested it, although someone tested it for me and said it worked f

blank page.... nothing is happening.
I'm new to a lot of this but in the last 24hrs have learned a lot.
Installed latest version of my

php redirecting
i wont open a new thread but i have a question about redirecting....
i wonder why my code doesnt

On page view, minus credit
Hello all, please, I need a little help with this script. I am charging one credit (credits can be p

php forms and database navigatio
Hello,
I'm new to php and i'd like to post the following.
I have written code to get records f

Update data to upper case in parent/child tables
Hi Gurus!

In production we have a product table and which is being reference by many tabl

php code to accept and delete incoming data
Using following HTML Code please show me how to write PHP code to accept and delete the incoming dat

$action = "insert"; //$action = $_GET['action'];
$action = "insert";
//$action = $_GET['action'];

why is this invalid type? I am