SQL statement are: > What is proper way to define a variable to include all dates newer than > 1995-01-01? > $query = "???"
select * from table where date > '1995-01-01' > What is proper way to define a variable to include all dates older than > 1995-01-01? > $query = "???" select * from table where date < '1995-01-01' > What is proper way to define a variable to include all dates between > 1995-01-01 and 1998-12-31? > $query = "???" select * from table where date < '1998-12-31' and date > '1995-01-01' Regards, Dan Thanks for the reply Dan, I don't think that will do what I need. I want to assign my query to a variable and have the variable inserted into the query statement. See my script below. If I change the query statement as you show, the rest of the script will need to be rewritten as $query is used throughout. I'm not able yet to do that. :( Any help would be appreciated. Thanks Craig ><> [EMAIL PROTECTED] <? $db_addr = 'localhost'; // address of MySQL server. $db_user = 'root'; // Username to access server. $db_pass = 'abc123'; // Password access server. $db_name = 'db1'; // Name of database to connect to. $connect = @mysql_connect("$db_addr", "$db_user", "$db_pass"); $query = ""; if (!($connect)) // If no connect, error and exit(). { echo("<p>Unable to connect to the database server.</p>"); exit(); } if (!(@mysql_select_db($db_name))) // If can't connect to database, error and exit(). { echo("<p>Unable to locate the $db_name database.</p>"); exit(); } if (!($limit)){ $limit = 3;} // Default results per-page. if (!($page)){ $page = 0;} // Default page value. $numresults = mysql_query("SELECT * FROM table1 WHERE date LIKE '%". $query ."%'"); // the query. $numrows = mysql_num_rows($numresults); // Number of rows returned from above query. if ($numrows == 0){ echo("No results found matching your query - $query"); // bah, modify the "Not Found" error for your needs. exit();} $pages = intval($numrows/$limit); // Number of results pages. // $pages now contains int of pages, unless there is a remainder from division. if ($numrows%$limit) { $pages++;} // has remainder so add one page $current = ($page/$limit) + 1; // Current page number. if (($pages < 1) || ($pages == 0)) { $total = 1;} // If $pages is less than one or equal to 0, total pages is 1. else { $total = $pages;} // Else total pages is $pages value. $first = $page + 1; // The first result. if (!((($page + $limit) / $limit) >= $pages) && $pages != 1) { $last = $page + $limit;} //If not last results page, last result equals $page plus $limit. else{ $last = $numrows;} // If last results page, last result equals total number of results. //escape from PHP mode. ?> <html> <head> <title>Search Results for <?=$query?></title> </head> <body> <center><h2>Search Results for <?=$query?></h2></center> <table width="100%" border="0"> <tr> <td width="50%" align="left"> Results <b><?=$first?></b> - <b><?=$last?></b> of <b><?=$numrows?></b> </td> <td width="50%" align="right"> Page <b><?=$current?></b> of <b><?=$total?></b> </td> </tr> <tr> <td colspan="2" align="right"> </td> </tr> <tr> <td colspan="2" align="right"> Results per-page: <a href="<?=$PHP_SELF?>?query=<?=$query?>&page=<?=$page?>&limit=5">5</a> | <a href="<?=$PHP_SELF?>?query=<?=$query?>&page=<?=$page?>&limit=10">10</a> | <a href="<?=$PHP_SELF?>?query=<?=$query?>&page=<?=$page?>&limit=20">20</a> | <a href="<?=$PHP_SELF?>?query=<?=$query?>&page=<?=$page?>&limit=50">50</a> </td> </tr> </table> <? //Go back into PHP mode. // Now we can display results. $results = mysql_query("SELECT * FROM table1 WHERE date LIKE '%". $query ."%' ORDER BY date ASC LIMIT $page, $limit"); while ($data = mysql_fetch_array($results)) { ?> <p><?=$data["date"]?> - <?=$data["abc"]?> - <?=$data["def"]?> - <?=$data["ghi"]?></p> <? } ?> <p align="center"> <? if ($page != 0) { // Don't show back link if current page is first page. $back_page = $page - $limit; echo("<a href=\"$PHP_SELF?query=$query&page=$back_page&limit=$limit\">back</a> \n");} for ($i=1; $i <= $pages; $i++) // loop through each page and give link to it. { $ppage = $limit*($i - 1); if ($ppage == $page){ echo("<b>$i</b> \n");} // If current page don't give link, just text. else{ echo("<a href=\"$PHP_SELF?query=$query&page=$ppage&limit=$limit\">$i</a> \n");} } if (!((($page+$limit) / $limit) >= $pages) && $pages != 1) { // If last page don't give next link. $next_page = $page + $limit; echo(" <a href=\"$PHP_SELF?query=$query&page=$next_page&limit=$limit\">next</a>\n");} ?> </p> </body> </html> --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php