why does this function not work...

k994519

hi guys

I am writing a function which compares the date now with 2 dates using datetime on the data base mysql

can some one improve the the function as its not working properly no syntax errors a logical one me thinks


function check_date(now()) //systemdate 
{

global $link;

$query="SELECT test_id FROM tests where now() between start_test and end_test";
$result=mysql_query($query, $link)
	or die("date error fatal error: ".mysql_error());

// Check exactly one row is found:
if(mysql_num_rows($result)==1) {
	$row=mysql_fetch_array($result);
	return $row;
}
// either ealry or late....:
return false;
}

btw i call the function in like this

			if( !($row =  check_date(now() ) ) 

    { 
    // Staff ID does not exist, create an error message: 
        $messages[]="Can not access test $test can not be accessed: THe time for this test has gone or not yet started "; 
    }            	

[/php

thanks for all ur help......

swr

I don't know how you would not be getting any errors. This:

function check_date(now())

would most certainly generate a parse error because "now()" is not a valid variable name.

k994519

I do get an error

but

could u please advise me what to do for this function to work.... thanks

Weedpacket

Originally posted by k994519
I do get an error

What is it? Really, you're going to have to be a bit more forthcoming.

k994519

error is

Parse error: parse error, unexpected '{' in c:\program files\apache group\apache\htdocs\view_created_test.php on line 40

this is just after calling the function check_date())... sorry it took me soo long to reply its 4.32 in the morning went to get some coffee

Weedpacket

Ah, well, there it is then.

function check_date(now())

¿Que? You're calling a function in the argument list of a function declaration? swr has mentioned this, and I guess neither of us are sure what you're trying to achieve by it.