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
