Hi in the script below are Im trying to write out the days of a week and work hours for that day. My problem is if there is no date added. Then i want to just write out the correct day... I cant get it to work. In the code below i only show one if-question if its a Monday. And if monday has data i MySQL its no problem. But if it hasnt i would like to write monday - no data found...
$inomvecka2 = mysql_query("SELECT * FROM kalender WHERE kalender.kalender_userid='knuff' ORDER BY kalender.kalender_datum");
while ($inomvecka = mysql_fetch_array($inomvecka2))
{
$asd = mysql_query("SELECT WEEK('$inomvecka[2]',0);");
while ($vecka = mysql_fetch_array($asd))
if ($vecka[0] == 23)
{
$vilkendag2 = mysql_query("SELECT WEEKDAY('$inomvecka[2]')");
while ($vilkendag = mysql_fetch_array($vilkendag2))
{
if($vilkendag[0] == 0)
{
echo'
<tr>
<td>Monday</td>
<td>'.$inomvecka[2].'</td>
<td>'.$inomvecka[3].'</td>
<td>'.$inomvecka[4].'</td>
<td>'.$inomvecka[5].'</td>
</tr>
';
}
}
}
}
cheers knuff