[RESOLVED] Simple query help

[mattastic]

Hi,

I need to query my db using a date and then, if the query returns anything, I need to set a variable.

However I keep getting the error :

Function name must be a string

Can anyone help?

Thankyou

$host = "localhost";
$user = "root";
$pass = "";
$dbname = "test";

$connection = mysql_connect($host,$user,$pass) or die (mysql_errno().": ".mysql_error()."<BR>");
mysql_select_db($dbname);



$currentdate = "2006-04-12";
// check for events
// check for events
$sql = "SELECT * FROM date where '$currentdate' BETWEEN eventdate AND enddate";


 $result = mysql_query($sql);
if (!$result) {
   die('Invalid query: ' . mysql_error());
}
if ($mysql_num_rows($result)) { // see if we got 1 or more rows returned
$event = 1;

} else{
$event = 0;
}

[stewartship]

sure post me the code and i will have a look....

[stewartship]

sorry ignore last will look through it could not see it on my last screen lol!

[stewartship]

try the query in the following format:

$sql = "SELECT * FROM date where '$currentdate' >= eventdate AND '$currentdate' <= enddate";

i am presuming that the eventdate and enddate are field names in your table which hold dates in the same format as your currentdate varibale is set to.

[mattastic]

Hi thanks for your reply. Yes, the dates are in the same format.

I still get the error:

Fatal error: Function name must be a string in C:\xampplite\htdocs\indextest.php on line 34

[stewartship]

can you post me

Fatal error: Function name must be a string in C:\xampplite\htdocs\indextest.php on line 34

the line and surronding code in question, might just be that the function defined is incorrect....

[mattastic]

THe sql works fine , when I use the query in phpmyadmin

[stewartship]

ah ok, then it definitely must be in the function call or definition....

[Blulagoon]

What is on line 34, and the preceding couple of lines ?

In the code you posted I see neither 34 lines nor anything much looking like a function call.

Blu

[mattastic]

LIne 34 is this line of code:

if ($mysql_num_rows($result)) { // see if we got 1 or more rows returned

[stewartship]

try doing

if($result){

// now check for rows

$num_rows = $mysql_num_rows($result);

if ($num_rows > 0){
$event = 1;
}
else{
$event = 0;
}

}
else{

'Could not perform database query.<br>';

}

[mattastic]

I get the same error but with this line of code:

$num_rows = $mysql_num_rows($result);

[stewartship]

can you echo $result for me and tell me what the output is, echo before the error part....

[Houdini]

eliminate the $ from this and it will work

$num_rows = $mysql_num_rows($result);

this will work

$num_rows = mysql_num_rows($result);

[mattastic]

Thanks for all your help.

I get:

Resource id #3

when I echo out the reult

[stewartship]

yeah Houdini was right i added an extra '$', php can be damn fiddly!! SO def remove that!

[Houdini]

Did you alter the code like I just posted that is your problem you tried to make a variable out of the mysql_num_rows() function so it caused the error.

[stewartship]

Ok so Resource id#3
is a description of the object $result after the
query is done.

so it should be fine to use the following type of functions on mysql_fetch_array(),mysql_fetch_assoc(),
mysql_result(), mysql_num_rows()....

after removing the $ i mistakenly put before the mysql_num_rows() (sorry 🙂 !) are you still getting the same result / error?

[mattastic]

Brilliant!

Thanks for all your help, works fine now.

Your right stewartship, PHP is damn fiddley! 😕