Getting a Sunday printed when its not in the table

swatisonee

1) I've tried a few options from the manual to expand date field from say, 2006-02-02 to Thurs, 02.02.2006 format but i cannot figure out where i am going wrong. Code below.

2) This is a monthly roll call so Sundays dont get recorded in the table. Is there a way I can have the Sunday getting printed on the output ?

3) This code currently shows up on screen as :

[QUOTE] Date | Time | IP | Note

29.01.06 |07:25:40 | aaa.bb.cc.dd | abcde
31.01.06 |07:00:00 | aaa.bb.cc.dd | [/QUOTE]

What I want

[QUOTE]Date | Time | IP | Note

Sat, 29.01.06 |07:25:40 | aaa.bb.cc.dd | abcde
Sun, 30.01.06 |
Mon, 31.01.06 |07:10:00 | aaa.bb.cc.dd | [/QUOTE]

Could someone pl help ? Thanks.


$sql1 = "SELECT * FROM `Roll` WHERE `user`='$user' && Month(`date`)= $month && Year(`date`)= '$year' ORDER BY `date` asc ";

$result1 = mysql_query($sql1)
    	or die ("Unable to get results.");
if ($myrow1 = mysql_fetch_array($result1))
{
do
{

list ($ayear, $amonth, $adate, $aday) = explode ("-" , $date) ; // doesnt work

printf("<tr>
<td> %s </td>
<td> %s </td>
<td> %s </td>
<td> %s </td>
</tr>",

calculatedate($myrow1["date"]), // This gives 31.01.06 

//   DateConvert($myrow1["date"], "D, m.d.Y") , // This gives a blank screen 

//$aday. "," $adate ."-" $amonth."-".$ayear ,          // This gives a blank screen


and so on for the rest of the code

devinemke

$result = mysql_query("SELECT *, DATE_FORMAT(date, '%a %d.%m.%y') AS date_formatted, DAYNAME(date) AS dayname FROM Roll WHERE user = '$user' AND MONTH(date) = '$month' AND YEAR(date) = '$year' ORDER BY date") or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo $row['date_formatted'] . ' | ';
	echo $row['time'] . ' | ';
	echo $row['ip'] . ' | ';
	echo $row['note'];

if ($row['dayname'] == 'Saturday')
{
	echo '<br>' . date('D d.m.y', strtotime($row['date'] . ' +1 day'));
}

echo '<br>';
}

swatisonee

Hi,

Thanks but i've run into a problem. All the sundays appear on top like this

Sun 08.01.06
Sun 15.01.06

Followed by the rest of the dates.

Fri 06.01.06 10:07:25
Sat 07.01.06 10:19:35 aaa.bb.cc.dd
Mon 09.01.06 10:07:04 aaa.bb.cc.dd
Tue 10.01.06 10:27:08 aaa.bb.cc.dd

I cannot use echo as i have to use the printf format as i have a table in which this data must come.

Could you please advise how i should modify it so the sunday appears after the saturday ?

Thanks again.