what's wroing with this code?

[stefke]

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /wh36542/public_html/start2.php on line 274

here's the code

<?php

				mysql_connect (localhost, ****, *******);

				mysql_select_db (*******);

				$startdate=curdate;
				$enddate=curdate+30;
				$limit=20;
				$numresults=mysql_query("SELECT * FROM opleiding WHERE start >= $startdate AND start <= $enddate");
				$numrows=mysql_num_rows($numresults);

				if (empty($offset)) {
				    $offset=1;
				}

									$result=mysql_query("SELECT * FROM opleiding WHERE start ='$startdate' AND start <='$enddate' ORDER by start LIMIT $offset,$limit");

				while ($data=mysql_fetch_array($result)) {

				}



				if ($offset==1) { // bypass PREV link if offset is 0
				    $prevoffset=$offset-20;
				    print "<a href=\"$PHP_SELF?offset=$prevoffset\">PREV</a> &nbsp; \n";
				}


				if ($numrows%$limit) {
				    $pages++;
				}

				for ($i=1;$i<=$pages;$i++) { // loop thru
				    $newoffset=$limit*($i-1);
				    print "<a href=\"$PHP_SELF?offset=$newoffset\">$i</a> &nbsp; \n";
				}


				if (!(($offset/$limit)==$pages) && $pages!=1) {

				    $newoffset=$offset+$limit;
				    print "<a href=\"$PHP_SELF?offset=$newoffset\">NEXT</a><p>\n";
				}

?>

[ahundiak]

You left off the $ for curdate
$startdate=curdate;
$enddate=curdate+30;

In your first query, you don't have quotes around the value for start. In the second query you do. It's going to be one or the other based on the sql datatype of start (no quotes if start is numeric).

As a general rule, you might want to check for errors after each query.

$result = mysql_query("whatever");
if (mysql_errno()) die(mysql_error());

That will flag most sql syntax problems and give you an idea of what went wrong.