RE: [PHP-DB] date functions (generates parse error)
| From: | John W. Holmes | Date: | Wed, 05 Mar 2003 18:22:07 +0000 |
| Subject: | RE: [PHP-DB] date functions (generates parse error) | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-26107@lists.php.net to get a copy of this message | ||
This is very weird. What are you using to create this code?
If you remove all of the spaces (?) before $query, the code doesn't give
a parse error. It shouldn't give one either way, though, if those are
spaces or a tab before your $query = ... line.
Even if you remove all of the text and only leave <?, ?>, and those
"spaces", PHP will spit something like:
Notice: Use of undefined constant - assumed ' ' in
c:\inetpub\wwwroot\test.php on line 3
So, the fix is to remove those characters and replace them with spaces
or tabs.
---John W. Holmes...
PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
> -----Original Message-----
> From: David Rice [mailto:haloplayer@hotmail.com]
> Sent: Wednesday, March 05, 2003 12:34 PM
> To: holmes072000@charter.net; php-db@lists.php.net
> Subject: Re: [PHP-DB] date functions (generates parse error)
>
>
> Sorry, I forgot to add the part at the bottom where I am calling the
> function
>
> =================================================================
>
> <?
> function tips($weekstart){
>
> $start = date('Ymd',strtotime($weekstart));
>
> $query = "SELECT * FROM Rota WHERE date >= $start and date <=
> ($start +
> INTERVAL 6 DAY) ORDER BY staffid";
> $result = mysql_query($query);
> while ($row = mysql_fetch_array($result)){
>
> if ( isset ( $tips ) ){
>
> if (isset ( $tips[$row[staffid]] ) ){
>
> $hours = $row[finish] - $row[start];
> $tips[$row[staffid]] =
$tips[$row[staffid]] +
> $hours;
>
> }
>
> else{
>
> $tips[$row[staffid]] = $row[finish] -
$row[start];
>
> }
> }
>
> else{
>
> $tips = array('$row[staffid]' =>( $row[finish] -
> $row[start] ) );
>
> }
>
> }
>
> return $tips;
>
> }
>
> function dbconnect(){
> mysql_connect("localhost", "filterseveuk", "godisadj");
> mysql_select_db("filterseveuk");
> }
>
> dbconnect();
> $date = "2003-03-02";
>
> var_dump(tips($date));
> ?>
>
> _________________________________________________________________
> Express yourself with cool emoticons http://messenger.msn.co.uk
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php