Weird MYSQL_FETCH_ARRAY error

[diabolo]

function display_nextSession() {
   $today = strtotime(date("m/d/y"));
   $sql = "SELECT * FROM nextsession WHERE date>='$today' LIMIT 1";
   $result = mysql_query($sql);
   $row = mysql_fetch_array($result);
      $nextDay = date("m/d/y", $row[1]);
echo $nextDay;
} 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\mcs\sources\functions\home.php on line 13
12/31/69

For some reason, the above function works on one page, but does not work on another. I get the error shown above.

Im first going to see if you can solve it without me having to put up the pages where the code is on, but if it is needed just reply, and I will get it up ASAP

[garrettroyce]

is the query returning no results?

[Twinkie]

Sorry, this is quite an unusual error from what I can tell. More details may be necessary. I recommend switching to the mysqli family of functions.

[descalzo]

You code produces:

$sql == "SELECT * FROM nextsession WHERE date>='1253077200' LIMIT 1"

What sort of field is 'date' ? Did you store it as a INT? I believe mySQL stores the 'Date' type in YYYY-MM-DD format, not as a UNIX time. Since 'Timestamp' has the UNIX date range, that might be ok.

[diabolo]

is the query returning no results?

I did var_dump(result); and got bool(false)

You code produces:

$sql == "SELECT * FROM nextsession WHERE date>='1253077200' LIMIT 1"

What sort of field is 'date' ? Did you store it as a INT? I believe mySQL stores the 'Date' type in YYYY-MM-DD format, not as a UNIX time. Since 'Timestamp' has the UNIX date range, that might be ok.

it is an INT(11). what do you suggest I do?

[garrettroyce]

your query is failing if $result == false

[descalzo]

..deleted bad suggestion...

...Edit to add:

Below is what you want. Since $result is not a resource, it is because of an error, not because the query returned no results.

[garrettroyce]

I would implement some error checking:

$result = mysql_query(.....); //your query goes here :P
if (!$result) {
  die(mysql_error());
}
if (mysql_num_rows($result) == 0) { //no rows match!
//do something else
}
else {
//now do what you were originally doing
}

Just make sure you get rid of the die(mysql_error()) part and handle it more gracefully when you go into launching your site so users don't get nasty errors.

[diabolo]

I followed what garrettroyce said,
and it gave me this error:

No Database Selected.

Let me explain something first:
It works on the user end. But in the admin end I get a problem. The admin header includes the user header, but it just has a little extra code for the administrative actions. So technically if the user end can establish a connection, shouldn't the admin area be able too?

[descalzo]

Without seeing all the code, I have no idea.

By the way, my car won't start. Can you tell me why?