Get day number from database

[joice]

I am new to PHP, but do have experience in programming in ASP. I would like to make a function that gets the day number of a date I get from the database (Sunday = 1, Saturday = 7). Now in ASP I would use the day-function on the variable:

<%
found_date = rs("date")
day_number = day(found_date)
%>

The code I have in PHP now is:

$result = mysql_query("select datum,count(*) from xxx group by datum order by datum");

while (($row = mysql_fetch_row($result)) AND ($result > 0))
echo"<TR BGCOLOR=#685F9B height=15>";
$breedte = floor($row[1] * (300 / $max_aantal));
echo"<TD VALIGN=middle ALIGN=left><B>&nbsp;$row[0]</B></FONT><BR></TD>";

row[0] represents the date field I get from my database. Now I want to determine what the day number of row[0] is. How do I do that??????

Joyce

[joice]

In addition to my question above: I put the date I get from the database in a variable:

$today = $row[0];
$day = date("w",$today);

I want the last rule the determine the day number of the database date...

Joyce

[mrmufin]

Well, you could let MySQL do it for you:

$result = mysql_query("SELECT DAYOFYEAR(datum), COUNT(*) FROM xxx GROUP BY datum ORDER BY datum");

[mrmufin]

Ooops, sorry, I see you wanted the day 'number'... Which is fine, MySQL has a function for that, too:

$result = mysql_query('SELECT DATE_FORMAT(datum,"%w"), COUNT(*) FROM xxx GROUP BY datum ORDER BY datum');

But, according to MySQL '0', not 1, represents Sunday.

[joice]

Thanks for your reply.
The "problem" is, I need the variable 'datum' later, to print in a list. I get all these dates from the database and print them in a long list. Now when the date is a saturday or sunday, I want the date to be printed in black, if it is a monday-friday, it has to be printed in white. That is why, I think, I need the day number. If I use the query you gave me, I get a long list, not of dates, but of numbers (DAYOFYEAR).
So I still want my 'datum' from the database, but printed in black if in a weekend, and in white if not....

English is not my native language, so I hope you understand what I mean....

Joyce

[joice]

Ha, I think I have the solution! :-)

I made the query like this:
$result = mysql_query('SELECT datum, DATE_FORMAT(datum,"%w"), COUNT(*) FROM xxx GROUP BY datum ORDER BY datum');

Now I can use row[0] to print the whole date and row[1] to get the day number

Thanks for your help!

Joyce

[mrmufin]

Cool... you beat me to my next suggestion! You're learning PHP fast!

[joice]

Hehe, well, actually, your solution helped me find my own solution, sooo 😃

Joyce