Issues using Week() or Weekofyear() functions with php

[Ben Whitesell]

I'm trying to use the week() or weekofyear() functions in a php script.
Here's a clipping of the code:
 
$sql = SELECT WEEK('2004/06/01');
echo $sql; //used for checking purposes
$week = mysql_query($sql, $link);//where $link is in an inc file
linking that file to this page
echo $week;
 
Here is the result I get:
 
SELECT WEEK('2004/06/01')
Resource id #3
 
Am I doing something wrong? Is this supposed to work? Please help!!! :P
 
Thanks,
Ben

Re: Issues using Week() or Weekofyear() functions with php

[Alex croes]

Ben Whitesell wrote:

I'm trying to use the week() or weekofyear() functions in a php script.
Here's a clipping of the code:
   $sql = SELECT WEEK('2004/06/01');
   echo $sql; //used for checking purposes
   $week = mysql_query($sql, $link);//where $link is in an inc file
linking that file to this page
   echo $week;

You are echo'ing the compleet Recordset. that is why you get the value of

Resource id #3
You can try the following: 

$sql = SELECT WEEK('2004/06/01') AS weeknummer;
$recordset = mysql_query($sql, $link);
$week = mysql_result($recordset, 0, 'weeknummer');
Alexander Croes
 --
http://www.viganed.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]