PHP - Unable To Print Distinct Dates And Display In A Specific Format..

Hi all

I've created a database with news articles. And a page that displays the newsarticles through dynamic links.
What I want to do though is start archiving past posts into months.

I want say on the February link just display the posts between 1 - 29th feb.

My query currently displays all posts in the database

$news_sql="SELECT newsID, headline, dateposted, image, article FROM news ORDER BY newsID DESC";

Can anyone help with modifying this to display posts between dates?

Thanks in advance

Dear all, 

Kindly help with this code I have written, it is not returning the array I created. It is a very small script but I have been looking for a very long time but I couldn't see why it went wrong.

$duration = 2;
$start='01-01-2019';
$month =date('n', strtotime($start));
$year =date('Y', strtotime($start));
$mon = 12-$month+1;
$remainingMonth = $duration*12;

$years_arr = array("$year");
$residue_arr = array("$remainingMonth");
$years_arr = process($remainingMonth,$year,$mon,$years_arr,$residue_arr);

print_r($years_arr); //<output

function process($remainingMonth,$year,$mon,$years_arr,$residue_arr){
    $residue = $remainingMonth - $mon;//$D$18-D20
    if($residue != 0){
        $new_year = $year+1;
        array_push($years_arr, $new_year);
        array_push($residue_arr, $residue);
        
        if($residue > 12 ){
            $mon = 12;
        } else {
            $mon = $residue;
        }
        echo "<br>";
        process($residue,$new_year,$mon,$years_arr,$residue_arr);
    } else {
        print_r($years_arr);
        return $years_arr;
    }
}//end of process(..)

The objective is to add a year to the $years_arr array and then print it put, yet I notice that nothing get's printed out. Please assist, if you need more info from my side, please do ask. Thank you very much in advance.

i am printing the dates from the last 30 days in ascending order and then comparing them in my query to print the results. How can I can print the below array in descending order without affecting my query?
Code: [Select]
   
  $thirtydaysago = time() - (30 * 24 * 60 * 60);
 
  $oneday=24 * 60 * 60;
  for($i=0;$i<31;$i++)
  {
     $d[$i]= $thirtydaysago + ($i*$oneday);
echo date('Y-m-d',$d[$i])."<br>";
  }
  for($i=0;$i<31;$i++)
  {
     $postsql=mysql_query("SELECT DATE_FORMAT(FROM_UNIXTIME(dateline), '%Y-%m-%d') AS FmtDate, COUNT(postid) AS PostCnt FROM post " .
              "WHERE dateline < '" . $d[$i+1] . "' AND dateline >= '" . $d[$i] . "' GROUP BY DATE_FORMAT(FROM_UNIXTIME(dateline), '%Y-%m-%d') DESC") or die(mysql_error());
   

   if($postsql_rows=mysql_fetch_assoc($postsql))
   {
    $data_date[$i]["date"]=$postsql_rows['FmtDate'];
$data_postcount[$k][$i]["postcount"]=$postsql_rows['PostCnt'];
   }
 }
 $k++;
 }

I know it is an "if" statement, but I am struggling with a simple issue.

I want to format specific words, like a keyword. (ex: <b>Open</p>, if that word is contained in my ".$data['status']." field of the database ".$db_prefix."fieldstatus.

Code: [Select]
$sql = dbquery(
"SELECT * FROM ".$db_prefix."fieldstatus
ORDER BY fieldstatus_id ASC"
);

if (iADMIN) echo "<center><a href='".MODS."fieldstatus_panel/fieldstatus_admin.php'>".$locale['imp135']."</a><br><br></center>";

if (dbrows($sql)) {
$i = 0;
echo "<table width='100%' cellpadding='0' cellspacing='1'>\n";

while ($data = dbarray($sql)) {

echo "<tr><td valign='top'><font size='1' color='#db3026'><b>".$data['fields']."</b> is </font><font size='1'>".$data['status']."</font></td></tr><tr>
</tr>\n";
}
echo "</table>\n";
} else {
echo "<center><br>\n".$locale['imp141']."<br><br>\n</center>\n";
}

Any suggestions would be greatly appreciated.

Hi again!
I'm trying to use this code that i found somewhere in the net to display all the dates between 2 dates.
It is exactly what i need but..
I understand the code and its structure (i think) but it gives me an error (maximum execution time of blah blah) which i think is
because it makes an infinite loop(not sure..  )

Code: [Select]
function GetDays($sStartDate, $sEndDate)
{   
$sStartDate = gmdate("Y-m-d", strtotime($sStartDate)); 
$sEndDate = gmdate("Y-m-d", strtotime($sEndDate)); 
       
     $aDays[] = $sStartDate; 
     
     $sCurrentDate = $sStartDate; 
     
      while($sCurrentDate < $sEndDate){ 
        $sCurrentDate = gmdate("Y-m-d", strtotime("+1 day", strtotime($sCurrentDate))); 
     
        $aDays[] = $sCurrentDate; 
      } 
     
      return $aDays; 
    } 


Appreciate the help and suggestions!
Gonna browse the forums for answers for the meantime...

I have looked and looked around on google, but I can't seem to enter the right keywords for this.  I have an events page and I need the events to only display between the date ranges...........startdate and enddate.  here is the entire code for the page,

Code: [Select]
<?php
session_start(); // Must start session first thing
/* 
Created By Adam Khoury @ www.flashbuilding.com 
-----------------------June 20, 2008----------------------- 
*/
// Here we run a login check
if (!isset($_SESSION['id'])) { 
   echo 'Please <a href="login.php">log in</a> to access your account';
   exit(); 
}
//Connect to the database through our include 
include_once "connect_to_mysql.php";
// Place Session variable 'id' into local variable
$userid = $_SESSION['id'];
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$name = $row["name"];
$phone = $row["phone"];
$username = $row["username"];
$address = $row["address"];
$city = $row["city"];
$state = $row["state"];
$zip = $row["zip"];
$cell = $row["cell"];
$email = $row["email"];
$accounttype = $row["accounttype"];
$rank = $row["rank"];
$badges = $row["badges"];
}
// Set error message as blank upon arrival to page
$errorMsg = "";
// First we check to see if the form has been submitted 
if (isset($_POST['username'])){
$name = ereg_replace("[^A-Z a-z0-9]", "", $_POST['name']); // filter everything but numbers and letters
$phone = ereg_replace("[^A-Z a-z0-9]", "", $_POST['phone']); // filter everything but spaces, numbers, and letters
$username = ereg_replace("[^A-Z a-z0-9]", "", $_POST['username']); // filter everything but spaces, numbers, and letters
$address = ereg_replace("[^A-Z a-z0-9]", "", $_POST['address']); // filter everything but spaces, numbers, and letters
$city = ereg_replace("[^A-Za-z0-9]", "", $_POST['city']); // filter everything but lowercase letters
$state = ereg_replace("[^A-Za-z0-9]", "", $_POST['state']); // filter everything but lowercase letters
$zip = ereg_replace("[^A-Za-z0-9]", "", $_POST['zip']); // filter everything but lowercase letters
$cell = ereg_replace("[^A-Za-z0-9]", "", $_POST['cell']); // filter everything but lowercase letters
$email = stripslashes($_POST['email']);
$email = strip_tags($email);
$email = mysql_real_escape_string($email);

if((!$email)){

$errorMsg = "You did not submit the following required information!<br /><br />";

    if(!$email){ 
       $errorMsg .= "--- Email Address"; 
    
   }
} else { $sql = mysql_query("INSERT INTO events (name, phone, username, address, city, state, zip, cell, email) 

VALUES('$name','$phone','$username','$address','$city','$state','$zip','$cell','$email") or die (mysql_error());

$to = "$email";
// Change this to your site admin email
$from = "events@final.net46.net";
$subject = "Complete your registration";
//Begin HTML Email Message where you need to change the activation URL inside
$message = '<html>
<body bgcolor="#FFFFFF">
Hi ' . $username . ',
<br /><br />
You must complete this step to activate your account with us.
<br /><br />
Please click here to activate now &gt;&gt;
<a href="http://www.somewebsite.com/activation.php?id=' . $id . '">
ACTIVATE NOW</a>
<br /><br />
Your Login Data is as follows: 
<br /><br />
E-mail Address: ' . $email . ' <br />
Password: ' . $password . ' 
<br /><br /> 
Thanks! 
</body>
</html>';
// end of message
$headers = "From: $from\r\n";
$headers .= "Content-type: text/html\r\n";
$to = "$to";
// Finally send the activation email to the member
mail($to, $subject, $message, $headers);
// Then print a message to the browser for the joiner 
print "<br /><br /><br /><h4>OK $firstname, one last step to verify your email identity:</h4><br />
We just sent an Activation link to: $email<br /><br />
<strong><font color=\"#990000\">Please check your email inbox in a moment</font></strong> to click on the Activation <br />
Link inside the message. After email activation you can log in.";


exit(); // Exit so the form and page does not display, just this success message
} // Close else after database duplicate field value checks
  } // Close else after missing vars check
 //Close if $_POST

 
?>
<?php


// if no id is specified, list the available articles
if(!isset($_GET['eventid']))
{
   $self = $_SERVER['PHP_SELF'];

   $query = "SELECT eventid, event, startdate, enddate FROM Registration ORDER BY eventid";
   $result = mysql_query($query) or die('Error : ' . mysql_error());
  
   // create the article list

   while($row = mysql_fetch_array($result, MYSQL_NUM))
   {
      list($eventid, $event, $startdate, $enddate) = $row;
  
      $as = "<a href=\"$self?eventid=$eventid\">$startdate - $enddate --- $event</a>\r\n";
   }


   $Events = 'Events';
} else {
   // get the article info from database
     $query = "SELECT event, description, startdate, enddate, location, subevent1, subevent2, subevent3, subevent4, subevent5, subevent6, subevent7, subevent8, price1, price2, price3, price4, price5, price6, price7, price8 FROM Registration WHERE eventid=".$_GET['eventid'];
   $result = mysql_query($query) or die('Error : ' . mysql_error());
   $row = mysql_fetch_array($result, MYSQL_ASSOC);

  $event = $row['event'];
   $description = $row['description'];
   $startdate = $row['startdate'];
     $enddate = $row['enddate'];

     $location = $row['location'];
 $subevent1 = $row['subevent1'];
$subevent2 = $row['subevent2'];
$subevent3 = $row['subevent3'];
$subevent4 = $row['subevent4'];
$subevent5 = $row['subevent5'];
$subevent6 = $row['subevent6'];
$subevent7 = $row['subevent7'];
$subevent8 = $row['subevent8'];

$price1 = $row['price1'];
$price2 = $row['price2'];
$price3 = $row['price3'];
$price4 = $row['price4'];
$price5 = $row['price5'];
$price6 = $row['price6'];
$price7 = $row['price7'];
$price8 = $row['price8'];
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Register</title>
<style type="text/css">
#apDiv1 {
position:absolute;
left:33px;
top:320px;
width:252px;
height:48px;
z-index:1;
}
#apDiv2 {
position:absolute;
left:33px;
top:361px;
width:254px;
height:46px;
z-index:2;
}
#apDiv3 {
position:absolute;
left:33px;
top:525px;
width:256px;
height:43px;
z-index:3;
}
#apDiv4 {
position:absolute;
left:33px;
top:402px;
width:250px;
height:48px;
z-index:4;
}
#apDiv5 {
position:absolute;
left:106px;
top:616px;
width:263px;
height:255px;
z-index:5;
}
#apDiv6 {
position:absolute;
left:323px;
top:200px;
width:898px;
height:530px;
z-index:5;
}
#apDiv7 {
position:absolute;
left:33px;
top:443px;
width:266px;
height:42px;
z-index:6;
}
#apDiv8 {
position:absolute;
left:111px;
top:500px;
width:125px;
height:37px;
z-index:7;
}
#apDiv8 strong {
font-size: 24px;
}
#apDiv9 {
position:absolute;
left:33px;
top:408px;
width:267px;
height:49px;
z-index:8;
}
#apDiv10 {
position:absolute;
left:33px;
top:449px;
width:242px;
height:23px;
z-index:9;
}
#apDiv8 a {
color: #000;
}
#apDiv11 {
position:absolute;
left:101px;
top:490px;
width:168px;
height:42px;
z-index:10;
font-size: 24px;
font-weight: bold;
}
#apDiv11 a {
color: #000;
}
#apDiv12 {
position:absolute;
left:33px;
top:210px;
width:205px;
height:107px;
z-index:11;
}
#apDiv12 {
text-align: center;
}
#apDiv13 {
position:absolute;
left:33px;
top:320px;
width:248px;
height:47px;
z-index:12;
}
#apDiv {
position:absolute;
left:33px;
top:484px;
width:225px;
height:35px;
z-index:11;
}
#apDiv14 {
position:absolute;
left:33px;
top:566px;
width:298px;
height:51px;
z-index:12;
}
#apDiv15 { position:absolute;
left:101px;
top:611px;
width:168px;
height:42px;
z-index:10;
font-size: 24px;
font-weight: bold;
}
#apDiv5 a {
font-size: 24px;
color: #000;
font-weight: bold;
}
#apDiv23 table tr td1 {
font-size: 14px;
}
</style>
<script type="text/javascript">
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}
function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
</script>

<style type="text/css">
#apDiv6 #form1 table tr th {
text-align: center;
}
#apDiv6 table tr td table tr td {
text-align: center;
}
#apDiv16 {
position:absolute;
left:330px;
top:45px;
width:208px;
height:100px;
z-index:13;
}
#apDiv6 table tr td #apDiv16 table tr th {
font-size: 36px;
}
#apDiv17 {
position:absolute;
left:183px;
top:342px;
width:427px;
height:65px;
z-index:13;
}
#apDiv6 table tr td #Accordion1 .AccordionPanel.AccordionPanelOpen .AccordionPanelContent #apDiv17 table tr th {
color: #999;
}
</style>

<style type="text/css">

#apDiv19 {
position:absolute;
left:33px;
top:320px;
width:271px;
height:33px;
z-index:13;
}
#apDiv20 {
position:absolute;
left:578px;
top:368px;
width:157px;
height:87px;
z-index:14;
}
#apDiv21 {
position:absolute;
left:8px;
top:705px;
width:270px;
height:683px;
z-index:15;
}
#apDiv22 {
position:absolute;
left:476px;
top:313px;
width:596px;
height:124px;
z-index:16;
}
#apDiv6 table tr td table tr th {
text-align: left;
}
#apDiv23 {
position:absolute;
left:326px;
top:30px;
width:247px;
height:85px;
z-index:16;
text-align: center;
font-size: 36px;
}
#apDiv23 table tr td {
text-align: center;
font-size: 24px;
}
#apDiv24 {
position:absolute;
left:364px;
top:202px;
width:247px;
height:63px;
z-index:17;
text-align: center;
font-size: 20px;
}
.klgjsa {
font-size: 18px;
}
#apDiv24 {
font-size: 16px;
}
#apDiv24 {
font-size: 18px;
}
#apDiv24 {
color: #C90;
}
#apDiv23 {
color: #F00;
}
#apDiv24 {
color: #000;
}
a:link {
color: #C90;
}
a:visited {
color: #C90;
}
a:hover {
color: #000;
}
</style>


</head>
<body onload="MM_preloadImages('button/pictures2.png','button/projects1.png','button/news2.png','button/eventmanager2.png','button/membermanager2.png','button/newsmanager2.png','button/myprofile2.png')">
<div id="apDiv6">
<table width="600" border="0" align="center" cellpadding="10" cellspacing="1" bgcolor="#336699">
  <tr>
  <td bgcolor="#FFFFFF"><h1 align="center"><?php echo $Events; ?></h1>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p><strong><?php echo $as; ?></strong> </p>
   
  <p>&nbsp;</p>
   
  <p>&nbsp;</p>
  <?php
$sql = mysql_query("SELECT * FROM members WHERE userid='$userid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$name = $row["name"];
$phone = $row["phone"];
$address = $row["address"];
$city = $row["city"];
$state = $row["state"];
$zip = $row["zip"];
$cell = $row["cell"];
$email = $row["email"];
}
$q = mysql_query("SELECT * FROM Registration WHERE eventid=".$_GET['eventid']."");
while($row = mysql_fetch_array($sql)){
$event= $row["event"];
$subevent1 = $row['subevent1'];
$subevent2 = $row['subevent2'];
$subevent3 = $row['subevent3'];
$subevent4 = $row['subevent4'];
$subevent5 = $row['subevent5'];
$subevent6 = $row['subevent6'];
$subevent7 = $row['subevent7'];
$subevent8 = $row['subevent8'];

$price1 = $row['price1'];
$price2 = $row['price2'];
$price3 = $row['price3'];
$price4 = $row['price4'];
$price5 = $row['price5'];
$price6 = $row['price6'];
$price7 = $row['price7'];
$price8 = $row['price8'];
}
?>
  <?php
// when displaying an article show a link
// to see the article list
if(isset($_GET['eventid']))
{
?>
  <div id="jQueryUIAccordion">
<h3>&nbsp;</h3>
<div>
<p>

    <div id="apDiv23"><?php echo $event; ?> <br />
</div>
<div id="apDiv24"><?php echo $startdate;?> <span class="klgjsa">-</span> <?php echo $enddate; ?></div>
    <table width="575" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th width="563" bgcolor="#999999" scope="col">Location</th>
        </tr>
      </table>
    <table width="574" height="16" border="0" cellpadding="2" cellspacing="2">
      <tr>
        <th height="12" scope="col"><?php echo $location; ?></th>
        </tr>
      </table>
    <table width="573" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th width="561" bgcolor="#999999" scope="col">Description</th>
        </tr>
      </table>
    <table width="576" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th width="564" height="11" scope="col"><?php echo $title1; ?><br /><?php echo $price1; ?></th>
        <th width="564" scope="col"><?php echo $subevent1; ?></th>
       

        </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title2; ?><br /><?php echo $price2; ?></th>
        <th scope="col"><?php echo $subevent2; ?> </th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title3; ?><br /><?php echo $price3; ?></th>
        <th scope="col"><?php echo $subevent3; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title4; ?><br /><?php echo $price4; ?></th>
        <th scope="col"><?php echo $subevent4; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title5; ?><br /><?php echo $price5; ?></th>
        <th scope="col"><?php echo $subevent5; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title6; ?><br /><?php echo $price6; ?></th>
        <th scope="col"><?php echo $subevent6; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title7; ?><br /><?php echo $price7; ?></th>
        <th scope="col"><?php echo $subevent7; ?></th>
      </tr>
      <tr>
        <th height="11" scope="col"><?php echo $title8; ?><br /><?php echo $price8; ?></th>
        <th scope="col"><?php echo $subevent8; ?></th>
      </tr>
      </table>
    <hr />
    <table width="200" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th scope="col">Price:</th>
        </tr>
      </table>
    <table width="200" border="0" cellspacing="2" cellpadding="2">
      <tr>
        <th scope="col">$<?php echo  $price; ?></th>
        </tr>
      </table>
</p>
<?php
if (isset($_GET['eventid'])) {
include('connect1.php');
$sql = mysql_query("SELECT * FROM Registration WHERE eventid='$eventid' LIMIT 1");
while($row = mysql_fetch_array($sql)){
$eventid = $row["eventid"];
$event = $row["event"];
$date = $row["date"];
$description = $row["description"];
$location = $row["location"];
}
$result = mysqli_query($dbcon, $query) or die('error getting data');

echo "<table>";
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
echo "<tr><td>";
echo "<a href=\"registration.php?eventid=".$_GET['eventid']."\"><ul>Register Now!</ul></a>";
echo "</td></tr>";
}
echo "</table>";

}
?>

   
   
   
   
   

 
 
   
   
  <div id="apDiv18"></div>
  <p align="center"><a href="<?php echo $_SERVER['PHP_SELF']; ?>">Back to Events</a></p>
   
   
   
  <?php
}
?></td></tr>
</table>


</div><div id="apDiv2"><a href="register.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image3','','button/register2.png',1)"><img src="button/register1.png" name="Image3" width="235" height="50" border="0" id="Image3" /></a></div>
<div id="apDiv4"><a href="projects.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image4','','button/projects2.png',1)"><img src="button/projects1.png" name="Image4" width="235" height="50" border="0" id="Image4" /></a></div>

<div id="apDiv11"><?php if ($accounttype == "Scout") {
echo '<a href="../logout.php">Logout</a>';} ?></div>
<div id="apDiv12"><?php echo "$accounttype"; ?>
  <p><?php echo "$name"; ?></p>
  <p>Troop 78</p>
</div>

<div id="apDiv5"><?php if ($accounttype == "Admin") {
echo "<a href=\"../logout.php\">Logout</a>";
}
?></div>


<div id="apDiv7"><a href="news.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image6','','button/news2.png',1)"><img src="button/news1.png" name="Image6" width="235" height="50" border="0" id="Image6" /></a></div>
<div id="apDiv"> <?php if ($accounttype == "Admin") {
echo "<a href=\"../search1.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image7','','../button/membermanager2.png',1)\"><img src=\"../button/membermanager1.png\" name=\"Image7\" width=\"235\" height=\"50\" border=\"0\" id=\"Image7\" /></a>";
} 
?></div>
<div id="apDiv3"><?php if ($accounttype == "Admin") {
echo "<a href=\"../eventmanager.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image8','','../button/eventmanager2.png',1)\"><img src=\"../button/eventmanager1.png\"  name=\"Image8\" width=\"235\" height=\"50\" border=\"0\" id=\"Image8\" /></a>";
}
?>
</div>
<div id="apDiv14"><?php if ($accounttype == "Admin") {
echo "<a href=\"../newsmanager.php\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('Image9','','../button/newsmanager2.png',1)\"><img src=\"../button/newsmanager1.png\"  name=\"Image9\" width=\"235\" height=\"50\" border=\"0\" id=\"Image9\" /></a>";
}
?>
</div>

<div id="apDiv19"><a href="myprofile.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image5','','button/myprofile2.png',1)"><img src="button/myprofile1.png" name="Image5" width="235" height="50" border="0" id="Image5" /></a></div>
<div id="apDiv21"><img src="button/red.png" width="282" height="687" /></div>

<img name="boyscout" src="buttons/boyscout.jpg" width="1180" height="700" border="0" id="boyscout" alt="" />
</body>
</html>
This is a big big big part of website and so I really need this to be working.  Is there also a way I could possibly display this by events in a month instead of by day?  If any body could help me, that would be so awesome.

==> MySQL version    5.0.91-community

So once upon a time I was working on a CMS.
I worked on it for 3 months, had to wipe my computer - but didn't worry about it because I backed up the files on a flash drive... which got smushed by some boxes when I moved <.< awesome -.-
Anyway, a year later (ie: today), I've decided to start again from scratch.

For me - for whatever reason - the simplest things always seem to give me the most trouble.

I decided to start with a "user" table - naturally - and began working on the first page: user_view.php and added an include file that connects to the database (connectDB.php). Since I started today, everything is simple - no design elements yet - just good 'ol code.

The View Users Page is simply a page that grabs all the rows from Table: users and prints the information to the screen, as if you were viewing a Members page on a forum.  This Page works fine. No complaints, does everything I need it to, prints all the rows and cols from Table Users.

Then I created the Edit User Page. When I did this a year ago, and I wanted to print out all the data from the table, I used the while loop. When I wanted to only grab certain variables from a table, I just created a new set of variables, as show below. Using the same method from a year ago, I started working on printing various data to the screen (such as "Welcome $username"). 5 minutes of typing... refresh page... nada.
So I stripped away just about every tag but the essentials and it still wouldn't work

Code: [Select]
<?php
...
$userID = 3;
$sql = "SELECT * FROM users WHERE userID='$userID'";
$result = mysql_query($sql);
$rows = mysql_fetch_row($result);

echo $rows['username'];
...
?>
Normally, this would just grab the username from a row in Table users where the userID = 3
But instead - it does nothing. I just see a blank page. It's a simple 5 lines of code and it's like "im just gonna do w.e the fk i wanna do mmmk thxforplaying"

 

PS: Keep in mind there is nothing wrong with the connection to the database, and as already stated I'm able to print ALL values from the Users Table using this same method: Code: [Select]
<?php
...
$user_sql = "SELECT * FROM users ORDER BY username ASC";
$user_result = mysql_query($user_sql);
while ( $user_rows = mysql_fetch_array($user_result) )
...
?>

Hi all,

Newbie here, i am having a problem to get my images to show which are stored in mysql database as a mediumblob. I get id number to print in table ut am just getting empty square with red cross in where my image should be. Is my code incorrect or is it something else?
Appreciate your help with this.
I have included both of the pages codes i am using.

Thanks
Tony

image2.php

<?php
include("common.php");
error_reporting(E_ALL);
$link = mysql_connect(host,username,password) or die("Could not connect: " . mysql_error());
mysql_select_db(db) or die(mysql_error());
$sql = "SELECT id FROM photos";
$result = mysql_query("$sql") or die("Invalid query: " . mysql_error());
?>
<table border="1"><tr><td>id</td><td>image</td></tr>
<?php
while($row=mysql_fetch_assoc($result)){
print '<tr><td>'.$row['id'].'</td><td>';
print '<img src="image1.php?id='.$row['id'].'height="75" width="100"">';
}
echo '</td></tr></table>'
?>

image1.php

<?php
ob_start();
include("common.php");    
   mysql_connect(host,username,password) or die(mysql_error());
   mysql_select_db(db) or die(mysql_error()); 

$query = mysql_query("SELECT imgage FROM photos WHERE id={$_GET['image_id']}";
$row = mysql_fetch_array($query);
$content = $row['image']; 
header('Content-type: image/jpg');
     echo $content;
 }
 ob_end_flush();
?>

Hi,
I am a newbie to this forum and php as well.  I have a script which inserts data and image file into mysql database.  Now I want to display this image on web  page but unable to do it.  I tried a lot but couldn't find out any solution.  I would appreciate your help.
<?php

$con = mysql_connect("localhost", "root", "xx");
if(!$con)
{
 die('Could not connect:' .mysql_error());
}
mysql_select_db("yyy",$con);

$memberid = '$_POST[memberid]';
$fname = '$_POST[fname]';
$lname = '$_POST[lname]';
$gender= '$_POST[gender]';
$add1 = '$_POST[add1]';
$add2 = '$_POST[add2]';
$city = '$_POST[city]';
$state = '$_POST[state]';
$zip = '$_POST[zip]';
$country = '$_POST[country]';

$photo1 = '$_FILES[image][name]';
echo "$photo1";

//if ($memberid= $_GET['memberid']){
$query="select memberid,fname,lname,gender,add1,add2,city,state,zip,country,photo1 from vadhuvar_member where memberid =(select max(memberid)from vadhuvar_member)";

$result=mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_assoc($result))
{
$memberid = $row['memberid'];
$fname = $row['fname'];
$lname = $row['lname'];
$gender = $row['gender'];
$add1 = $row['add1'];
$add2 = $row['add2'];
$city = $row['city'];
$state = $row['state'];
$zip = $row['zip'];
$country = $row['country'];
//$photo1=chunk_split(base64_encode($photo1));
$photo1 = $row['photo1'];

//echo base64_encode($photo1);


echo "Name:$fname $lname<br>";
//echo "Name:$_POST[fname]$_POST[lname]<br>";
echo "Gender:$gender<br>";
echo "Address:$add1 $add2<br>";
echo "$city $state $zip<br>";
echo "$country<br>";
//echo "<img src=".upload/$photo1 ." alt="" width="200" height="300" /><br />";


    }
//}
?>


<!--img src="<?php echo '.upload/$_FILES[image][name]?memberid=$row[memberid]'?>"alt="" width="200" height="300"/-->;
<?php echo "<img src=". upload/$row[photo1]" alt="" width="200" height="300">";?>
<!--img src="<?php echo ".\upload\$photo1" ?>" alt=""  width="200" height="300"/-->;

<? set_magic_quotes_runtime(1); // turn back on ?>
Thanks
Smita

I am doing simple program to display text entered by user..

Following is my code but its display 'error msg' instate of txtbox contents

<html>
<head><title>Date</title></head>
<body>
<form action="" enctype="multipart/form-data">
Enter Date:
<input type="text" name="txtdate"/>
<input type="submit" value="Display"/>
</form>
</body>
</html>

<?php
if(isset($_POST['txtdate']))
{
   $display =$_POST['txtdate'];
echo 'You have entered'.$display;
}
else
{
echo 'Error msg';
}
?>

This is my code is display my database (member_details) after user sign up but when a user register first name = <script>window.location="google.com"</script>  This error occur=(The requested URL /yy2/html/google.com was not found on this server)

Code: [Select]
<?php
  session_start();
  include ('includes/database_connection.inc.php');
$conn = connectDatabase();

  if($_SESSION['uid'] == ''){
    // redirect unauthenticate user to login page.
  header('Location: login.php');
  }

  if($_GET['task'] == 'delete' && $_GET['id'] != ''){
      // delete function here
     $sql="DELETE FROM Newest Where ID='".mysql_real_escape_string($_GET['id'])."'";
     
     mysql_query($sql,$conn);
     header('Location: member_list.php');
  }

  if($_POST['Logout']){
     session_destroy();
   header('Location: login.php');
}

?>

<html><head><title>Member Details</title>
</head>
<body>
<div style=" margin: 350px ">
<?php 


      $sql="SELECT * FROM Newest";
      $rs = mysql_query($sql,$conn)
        or die( mysql_error() );

   
   $list = "<table border=\"1\" cellpadding= \"2\">";
   $list .= "<tr><th>First Name</th>";
   $list .="<th>Last Name</th>";
   $list .= "<th>User Name</th>";
   $list .= "<th>Email</th>";
   $list .= "<th>Edit User</th>";
   $list .= "<th>Delete User</th>";
    $list .= "<th>Change Password</th>";
   

While( $row = mysql_fetch_array($rs) ) {
   
    $list .= "<tr>";
    $list .= "<td>".$row["name"]."</td>";
     $list .= "<td>".$row["last"]."</td>";
    $list .= "<td>".$row["user"]."</td>";
    $list .= "<td>".$row["email"]."</td>";
    $list .= "<td><a href='member_details.php?id=".$row['ID']."'>Edit</a></td>";
    $list .= "<td><a onclick='return confirm(\"Are you sure to delete ".$row["name"]." \")' href='member_list.php?id=".$row["ID"]."&task=delete'>Delete</a></td>";
     $list .= "<td><a  href='Password.php?id=".$row['ID']."'>Click Here</a></td>
     </tr>";
   
} 
   $list .= "</table>";
   echo ( $list );
   
?>
   <form method="post" action="member_list.php"><br>
   <div style="margin : 0px 600px">
   <style type="text/css">
body {background:#F5F5F5 url('http://images.apple.com/downloads/dashboard/travel/images/traveltodolist_20070724165034.jpg') no-repeat top;;
     
       }</style>
   
         
         <input type="submit" name="Logout" value="logout" />
         
      </form>
</body>
</html>

MOD EDIT: [code] . . . [/code] BBCode tags added.

I'm working on creating a Realtors website.
Currently mysql DB has 4 tables. 3 of them are needed in this script to show up as 1 item.
Table called Listings has 2 fields that call on 2 other tables. one is MLS which calls on the Images Table the other agent calls on the Agents table.
I'm trying to see why I can't While loop all 3 tables together? How can I connect all 3?


<?php

if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}


//mysql_select_db($database_CarneyRealty, $CarneyRealty);
//$query_Update1 = "SELECT * FROM listings";
//$Update1 = mysql_query($query_Update1, $CarneyRealty) or die(mysql_error());
//$rrows = mysql_fetch_assoc($Update1);
//$totalRows_Update1 = mysql_num_rows($Update1);
 
include 'dbc.php';
page_protect();

$err = array();
$msg = array();

$page_limit =4; //CHANGE FOR THE NUMBER OF LISTINGS PER PAGE!
$page_num_limit =10;

$ret = $_SERVER['HTTP_REFERER'];


$host  = $_SERVER['HTTP_HOST'];
$host_upper = strtoupper($host);
$login_path = @ereg_replace('admin','',dirname($_SERVER['PHP_SELF']));
$path   = rtrim($login_path, '/\\');

// filter GET values
foreach($_GET as $key => $value) {
$get[$key] = filter($value);
}

foreach($_POST as $key => $value) {
$post[$key] = filter($value);
}


$rs_all = mysql_query("select count(*) as total_all from listings") or die(mysql_error());
$rs_active = mysql_query("select count(*) as total_active from listings where status='ACTIVE'") or die(mysql_error());
$rs_total_contingent = mysql_query("select count(*) as tot2 from listings where status='CONTINGENT'");
$rs_total_pending = mysql_query("select count(*) as tot from listings where status='PENDING'");    
$rs_total_sold = mysql_query("select count(*) as tot1 from listings where status='SOLD'");
$rs_resall = mysql_query("select count(*) as res from listings where class='Resident'") or die(mysql_error());
$rs_comall = mysql_query("select count(*) as com from listings where class='Commerical'");
$rs_farmall = mysql_query("select count(*) as farm from listings where class='Farmland'");    
$rs_otherall = mysql_query("select count(*) as other from listings where class='Other'");

list($all) = mysql_fetch_row($rs_all);
list($active) = mysql_fetch_row($rs_active);
list($total_contingent) = mysql_fetch_row($rs_total_contingent);
list($total_pending) = mysql_fetch_row($rs_total_pending);
list($total_sold) = mysql_fetch_row($rs_total_sold);

list($resall) = mysql_fetch_row($rs_resall);
list($comall) = mysql_fetch_row($rs_comall);
list($farmall) = mysql_fetch_row($rs_farmall);
list($otherall) = mysql_fetch_row($rs_otherall);

///////////////////////////////////////////////////////////////////////////////////////

///////////////////////////////////////////////////////////////////////////////////////////////////
$sqlagents = mysql_query("select * from agents where id='$_SESSION'");
//$agentname= mysql_query($sqlagents) or die(mysql_error());
$sqllistings = mysql_query("select * from listings where id='$_SESSION'"); 
$sqlimages = mysql_query("select * from images where id='$_SESSION'");
////////////////////////////////////////////////////////////////////////////////////////////////////////
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
  <head>
  <title>Search CarneyRealty Listings</title>
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
  <link rel="stylesheet" href="../css/mm_brochure.css" type="text/css">
  <style type="text/css">
<!--
body {
background-image: url(http://www.carneyrealty.com/newsite/images/IMG_0161a.jpg);
}
.style1 {
font-size: 16px
}
.style2 {
font-family: Geneva, Arial, Helvetica, sans-serif
}
.style10 {
font-size: 13px;
font-weight: bold;
color: #FF0000;
}
.style7 {
color: #FF0000;
font-weight: bold;
}
.style8 {
color: #0000FF;
font-weight: bold;
}
-->
</style>
  </head>
  <body bgcolor="#bcbc85" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<div align="center">
    <table width="81%" border="0" cellspacing="0" cellpadding="0">
    <tr bgcolor="#999966">
        <td width="25" nowrap="nowrap"><center>
        <img src="../images/mm_spacer.gif" alt="" width="15" height="1" border="0" /></td>
        <td height="60" colspan="3" class="logo" nowrap="nowrap"><div align="center"><img src="images/Carney_Logo1_000.jpg" width="630" height="158" /><br />
          </div></td>
        <td width="4"></td>
      </tr>
    <tr bgcolor="#797947">
        <td width="25" nowrap="nowrap"></td>
        <td colspan="3" valign="top"><div align="center">
            <table width="460" border="0" cellpadding="0" cellspacing="0" id="navigation">
            <tr>
                <td width="59" align="center" nowrap="nowrap"><div align="center"><a href="../index.htm" class="style1"><strong>HOME</a></div></td>
                <td width="127" align="center" nowrap="nowrap"><div align="center"><strong><a href="../SearchCarneyRealtyListings.php" class="style5">LISTINGSEARCH</a></strong></div></td>
                <td width="94" align="center" nowrap="nowrap"><div align="center"><strong><a href="../Aboutus.html" class="style5">ABOUT US</a></strong></div></td>
                <td width="10" align="center" nowrap="nowrap"><div align="center"></div></td>
                <td width="95" align="center" nowrap="nowrap"><div align="center"><strong><a href="../Community.htm" class="style5">COMMUNITY </a></strong></div></td>
                <td width="81" align="center" nowrap="nowrap"><div align="center"><strong><a href="../Login.php" class="style5">LOGIN</a></strong></div></td>
              </tr>
          </table>
            <table width="307" border="0" cellpadding="0" cellspacing="0" id="navigation">
            <tr>
                <td width="84" align="center" nowrap="nowrap"><div align="center"><a href="http://www.carneyrealty.com/newsite/listingsearch.php?doSearch=MLS+Search&q=Resident" class="style1">Residential</a></div></td>
                <td width="103" align="center" nowrap="nowrap"><div align="center"><strong><a href="http://www.carneyrealty.com/newsite/listingsearch.php?doSearch=MLS+Search&q=Commerical" class="style5">Commercial</a></strong></div></td>
                <td width="102" align="center" nowrap="nowrap"><div align="center"><strong><a href="http://www.carneyrealty.com/newsite/listingsearch.php?doSearch=MLS+Search&q=Farmland" class="style5">Farms &amp; Land</a></strong></div></td>
                <td width="18" align="center" nowrap="nowrap"><div align="center"></div></td>
              </tr>
          </table>
            <table width="573" border="0" cellpadding="0" cellspacing="0" id="navigation">
            <tr>
                <td width="72" align="center" nowrap="nowrap"><div align="center"><a href="residental0-60.php" class="style1">$0-$60K</a></div></td>
                <td width="80" align="center" nowrap="nowrap"><div align="center"><strong><a href="residental61-85.php" class="style5">$61K-$85K</a></strong></div></td>
                <td width="87" align="center" nowrap="nowrap"><div align="center"><strong><a href="residental86-115.php" class="style5">$86K-$115K</a></strong></div></td>
                <td width="1" align="center" nowrap="nowrap"><div align="center"></div></td>
                <td width="103" align="center" nowrap="nowrap"><div align="center"><strong><a href="residental116-160.php" class="style5">$116K-$160K</a></strong></div></td>
                <td width="93" align="center" nowrap="nowrap"><div align="center"><strong><a href="residental161-230.php" class="style5">$161K-230K</a></strong></div></td>
                <td width="126" align="center" nowrap="nowrap"><div align="center"><strong><a href="residential231up.php" class="style5">$231K-And Up</a></strong></div></td>
                <td width="11" align="center" nowrap="nowrap">&nbsp;</td>
              </tr>
          </table>
          </div></td>
      </tr>
    
        <td width="25" valign="top"><?php 
/*********************** MY MLS MENU ****************************
This code shows MLS account menu only to logged in users. 
Copy this code till END and place it in a new html or php where
you want to show myaccount options. This is only visible to logged in users
*******************************************************************/
?>
        <?php 
  if(!empty($msg)) {
  echo $msg[0];
  }
  ?>
        <? //$row_settings1=mysql_fetch_array($sqllistings1);?>
        <?php while ($row_settings1 = mysql_fetch_array($sqllistings)){
$row_settings2=mysql_fetch_array($sqlimages);
$row_settings3=mysql_fetch_array($sqlagents);
?>
        <?php } ?>
  </table>
    <table width="81%" border="0" align="center" cellpadding="10" cellspacing="0" style="background-color: #FF9933;padding: 2px 5px;border: 1px solid #F90;" >
    <tr>
        <td height="44" align="center"><form name="form1" method="get" action="listingsearch.php">
            <p>
            <input name="doSearch" type="submit" id="doSearch2" value="MLS Search" />
            <input name="q" type="text" id="q" size="40">
            <strong> S CARNEY&amp; ASSOCIATES INC 800-757-5783</strong> <br>
          </p>
          </form></td>
      </tr>
  </table>
    </td>
    </tr>
    </table>
  </div>
<p>
    <?php if ($get['doSearch'] == 'MLS Search') {
  $cond = '';
  if($get['qoption'] == 'active') {
  $cond = "where `status`='ACTIVE' order by date desc";
  }
  if($get['qoption'] == 'contingent') {
  $cond = "where `status`='CONTINGENT' order by date desc";
  }
  if($get['qoption'] == 'pending') {
  $cond = "where `status`='PENDING' order by date desc";
  }
  if($get['qoption'] == 'sold') {
  $cond = "where `status`='SOLD' order by date desc";
  }
  if($get['qoption'] == 'resident') {
  $cond = "where `class`='Resident' order by price desc";
  }
  if($get['qoption'] == 'farmland') {
  $cond = "where `class`='Farmland' order by price desc";
  }
  if($get['qoption'] == 'commerical') {
  $cond = "where `class`='Commerical' order by price desc";
  }
  if($get['qoption'] == 'other') {
  $cond = "where `class`='Other' order by price desc";
  }
   //if($get['qoption'] == '') {
   if($get['q'] == '') { 
$sql = "select * from listings order by price asc";
 // $sql = "select * from listings $cond"; 
 // } 
  } 
  else { 
  $sql = "select * from listings where `price` = '$_REQUEST[q]' or `mls`='$_REQUEST[q]' or `seller`='$_REQUEST[q]' or `class`='$_REQUEST[q]' or `status`='$_REQUEST[q]' order by `price` asc";
//$sql1="select * from images where `mls`='$sql'";
//$sql2="select * from agents where `tag`='$sql'";
//  $sql = "select * from listings where `mls`='$_REQUEST[q]' or `price`='$_REQUEST[q]'";
  }

  //$rs_total1=mysql_query($sql1) or die(mysql_error());
  $rs_total = mysql_query($sql) or die(mysql_error());
  $total = mysql_num_rows($rs_total);
 // $total1=mysql_num_rows($rs_total1);
  if (!isset($_GET['page']) )
{ $start=0; } else
{ $start = ($_GET['page'] - 1) * $page_limit; }
  
  $rs_results = mysql_query($sql . " limit $start,$page_limit") or die(mysql_error());
  $total_pages = ceil($total/$page_limit);
 // $rs_results1 = mysql_query($sql1 ."limit $start,$page_limit") or die (mysql_error());
  ?>
    <?php 
  
  // outputting the pages
if ($total > $page_num_limit)
{
echo "<table width='81%' border='0' align='center' cellpadding='2' cellspacing='0' background='#fcfcdd'><span class='subHeader'><center>Pages: ";
$i = 0;
while ($i < $page_num_limit)
{


$page_no = $i+1;
$qstr = ereg_replace("&page=[0-9]+","",$_SERVER['QUERY_STRING']);
echo "<a href=\"listingsearch.php?$qstr&page=$page_no\">$page_no</a> ";
$i++;
}
echo "</span></td></table>";
}  ?>
    <? 
//while ($rrows3 = mysql_fetch_array($rrows3)){

?>
  <form name "searchform" action="listingsearch.php" method="post">
  </form>
</table>
<?php
//////////////////////////////////////////////////////////////////////////////
 while ($rrows = mysql_fetch_array($rs_results)) {
 $rrows2=mysql_fetch_array($sqlimages);
$rrows3=mysql_fetch_array($sqlagents);

///////////////////////////////////////////////////////////////////////////////
//$imagenamevar=($rrows['mls']=$rrows2['mls']);
//echo $rrows3['id'];
//$agentpicvar=($rrows['seller']=$rrow3['tag']);

?>
<tr>
    <table width="81%" border="0" align="center" cellpadding="2" cellspacing="0" background="#fcfcdd">
    <?  echo $rrows['agents'.'seller_id'];?>
    
        <td width="161" height="211" align="center" valign="top" bgcolor="#fcfcdd"><div align="center"><img src="http://www.carneyrealty.com/newsite/uploads/<?php echo $rrows['mls'];?>/<? echo $mainimagevar; ?> width="214" height="160" />
            </p>
          </div>
        <p class="tagline">Click for Additional Pictures</p></td>
        <td width="568" align="center" valign="top" bgcolor="#fcfcdd" class="calendarText"><div align="left">
            <table width="592" height="180" border="1">
            <tr valign="top">
                <td width="74" height="27" bgcolor="#fcfcdd" class="tagline">Location </td>
                <td width="249" bgcolor="#fcfcdd"><strong><?php echo $rrows['location'];?> <br>
                  <?  echo $rrows['location1'];?>
                  <br>
                  <? echo $rrows3['tag'];?> </strong></td>
                <td width="180" rowspan="2" bgcolor="#fcfcdd" class="tagline"><div align="center">
                    <table width="180" height="62" border="1">
                    <tr valign="top">
                        <td width="70" rowspan="2" class="tagline"><a href="http://www.carneyrealty.com/newsite/upload/<?php echo $rrows['mls'];?>/<? echo "SD_disp.pdf";?>"><img align="absbottom" src="http://www.carneyrealty.com/newsite/Listing_pages/images/datasheet_018.jpg" width="58" height="50" /></a></td>
                        <td width="50" class="tagline"><div align="left">Status </div></td>
                        <td width="68"><div align="right" class="subHeader"><?php echo $rrows['status']; ?></div></td>
                      </tr>
                    <tr valign="top">
                        <td height="24" class="tagline"><div align="left">PRICE</div></td>
                        <td align="center" valign="top"><div align="right"><strong class="subHeader"><?php echo $rrows['price']; ?></strong></div></td>
                      </tr>
                  </table>
                    <span style="color: #fcfcdd"><strong><a href="mailto:<? echo $rrows['selleremail'];?>"><img src="http://www.carneyrealty.com/newsite/Listing_pages/images/mail_004.gif" width="14" height="15" /><? echo $rrows['seller'];?></a></strong></span></div></td>
                <td width="61" rowspan="2" bgcolor="#fcfcdd" class="tagline"><div align="right"></div>
                <span style="color: #fcfcdd"><img src="<? 
    
/////////////////////////////////////////////////////////////

while ($rrows3=($rrows['seller']=$rrows3['seller_id'])){
   echo $rrows3['agentimage'];
   }
   //////////////////////////////////////////////////////////////
   ?>" width="60" height="91" /></a></span></td>
              </tr>
            <tr valign="top">
                <td height="64" bgcolor="#fcfcdd" class="tagline">Specs</td>
                <td bgcolor="#fcfcdd"><strong><?php echo $rrows['specs']; ?></strong></td>
              </tr>
            <tr valign="top">
                <td height="77" bgcolor="#fcfcdd"  class="tagline">Description</td>
                <td colspan="3" bgcolor="#fcfcdd" ><strong>MLS #<?php echo $rrows['mls'];?><br>
                  <? echo $rrows['description'];?></strong>
                <p><strong>Call <? echo $rrows['seller'];?> at <? echo agentnumbervar;?> to view   or for more information.</strong></p></td>
              </tr>
          </table>
            
            <tr>
                <td height="18" colspan="2" align="center" valign="top" bgcolor="#FF9933"><span class="bodyText style2" style="color: #fcfcdd"></span><span class="bodyText style2">S   Carney &amp; Associates Real Estate Brokerage 800 757 5783&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span></td>
              </tr>
        </div></td>
      </tr>
      </span>
    
    <? } ?>
    
        <td height="4"></td>
    </table>
    <? } ?>
    <? //} ?>
  </tr>
<?php 
  

  
  // outputting the pages
if ($total > $page_limit)
{
echo "<table width='81%' border='0' align='center' cellpadding='2' cellspacing='0' background='#fcfcdd'><span class='subHeader'><center>Pages: ";
$i = 0;
while ($i < $page_num_limit)
{


$page_no = $i+1;
$qstr = ereg_replace("&page=[0-9]+","",$_SERVER['QUERY_STRING']);
echo "<a href=\"listings.php?$qstr&page=$page_no\">$page_no</a> ";
$i++;
}
echo "</span></td></table>";
}  ?>
</td>
</tr>
<tr>
    <td height="22" class="bodyText"><?
 include 'footer1.shtml';
  ?>
</td>
</tr>
<tr>
    <td height="194" class="bodyText"><div align="center">
        <table width="513" border="0">
        <tr valign="top">
            <th width="94" scope="col"><div align="center"><a href="http://www.realtor.org/technology/crt_secure/home?opendocument"><img src="images/index.1.gif" width="43" height="42" border="0" /></a></div></th>
            <th width="46" scope="col"><div align="center"></div></th>
            <th width="100" valign="middle" scope="col"><div align="center" class="style7">
                <div align="center"><a href="http://www.nacogdochesmls.com/nag/passwd.php"><img src="images/MLS_a_94-50.gif" width="92" height="51" alt="Multiple Listing Service" /></a></div>
              </div></th>
            <th width="119" scope="col"><div align="center"><a href="http://www.hud.gov/offices/fheo/FHLaws/"><img src="http://www.habitatwhitley.org/equal_housing_logo.jpg" alt="Equal Housing Opportunity" width="60" height="62" border="0" /></a></div></th>
            <th width="129" scope="col"><div align="center"></div></th>
          </tr>
        <tr valign="top">
            <td height="32"><div align="center" class="style8"><a href="http://www.realtor.org/technology/crt_secure/home?opendocument">REALTOR.ORG</a></div></td>
            <td><div align="center"></div></td>
            <td valign="middle"><div align="center"><span class="style10"><a href="http://www.nacogdochesmls.com/nag/passwd.php">Multiple Listing System</a></span></div></td>
            <td><div align="center"><strong><a href="http://www.hud.gov/offices/fheo/FHLaws/">Equal Housing Opportunity</a></strong></div></td>
            <td><div align="center"><a href="http://www.bbb.org/">BETTER BUSINESS BUREAU</a></div></td>
          </tr>
      </table>
      </div></td>
  </tr>
</table>
<div align="left">&nbsp;<br />
  </div>
</div>
</td>
<td valign="top"><div align="left"></div></td>
<td width="4"><div align="left"></div></td>
</tr>
<tr>
    <td width="15">&nbsp;</td>
    <td width="35">&nbsp;</td>
    <td width="698"><div align="center">
    <?php
  include 'footer.shtml';
  ?>
  </div>
  </td>
  <td width="1"><div align="center"></div></td>
  <td width="4">&nbsp;</td>
  </tr>
  </table>
  </table>
  </table>
  </div>
  </body>
  </html>





 
 

I would like to know the best practice to achieve the following:

I have a list of dates related to live events for performing artists.  When someone views the web page that contains a section to display the dates, I would only want to show the dates from today into the future and not show any dates from the past.

What is the best way to accomplish this?

Thanks in advance...

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=321950.0

hi there, the code below is suppose to display something like the attachement "code2" but instead it displays something like attachement "code1" please assist in find what is wrong with my echo lines.

<?php 
                        $counter = 2;
			$sqlq="select * from state WHERE status = 0 ";
			$categorysqlq = mysql_query($sqlq);
			$varq = mysql_num_rows($categorysqlq);

			while($catfetchq = mysql_fetch_array($categorysqlq))
			{
 $cnty =  $catfetchq[0];

		 $sqllq="select * from vehicle WHERE country = '$cnty' ";
			$categorysqllq = mysql_query($sqllq);
		
			
			$numsql = "select * from branchaddr WHERE state = '$cnty' ";
			$numquery = mysql_query($numsql);
$varqa = mysql_num_rows($numquery);
$cntyfetchq= mysql_fetch_array($numquery);	
if($varq != 0){
					if($counter == 2){
                                            	echo "<tr><td><a href=\"transport2.php?id=".$cntyfetchq['state'].">".$catfetchq[1]."(<span style=\"color:red\">".$varqa."</span>)</a></td>";                                                                              
						$counter--;
					}
					else{						
						echo "<td><a href=\"transport2.php?id=".$cntyfetchq['state'].">".$catfetchq[1]."(<span style=\"color:red\">".$varqa."</span>)</a></td></tr>";                                          
						$counter = 2;
					}
				}
			}	
?>

Attached Files  code1.png   12.65KB   0 downloads  code2.png   25.34KB   0 downloads