PHP - Distinct Lookup And Display

Hi I have been trying to populate my data from 3 tables and display like this:

                  DATE             $acronym1                        $acronym2
POSTS   1/9/2011          10 (this is no of posts)                  3
POSTS   31/8/2011         20                                                10
and so on. the threads and user table will be similar as well.
 I am not able to populate the distinct dates since the dateline contains time as well. So when I try to print out the just dates(without time) , it prints  with the dates repeated. it prints something like this:
1/9/2011 1
1/9/2011 1
and so on..
How can populate and print the the date and number of posts in the above format. Here is my complete code below:


Code: [Select]
<?php
error_reporting(-1);
//ini_set('display_errors',1);
include("db.php");
//$thirty_days_ago = strtotime("-30 days");
$limit = strtotime("-1 month");
$sql=mysql_query(("SELECT * from new_site"),$con) or die(mysql_error());
while($row=mysql_fetch_assoc($sql))
{
   $include=$row['include'];
   $forumurl=$row['forumurl'];
   $url=$row['url'];
   $acronym=$row['acronym'];
   include("$include");
   //echo $include."<br>";
   $configdbname=$config['Database']['dbname'];
   $configdbconport=$config['MasterServer']['servername'].":".$config['MasterServer']['port'];
   $configusername=$config['MasterServer']['username'];
   $configpassword=$config['MasterServer']['password'];
   $configprefix=$config['Database']['tableprefix'];
   /* Connect to the required database */
   $con2=mysql_connect($configdbconport, $configusername, $configpassword);
   if (!$con2)
   {
       die('Could not connect: ' . mysql_error());
   }
   mysql_select_db($configdbname, $con2);
   $postdate=mysql_query("SELECT DISTINCT dateline,postid from post WHERE dateline >='$limit' ORDER by dateline DESC") or die(mysql_error());
   while($postdate_results=mysql_fetch_assoc($postdate))
   {
      $postdate_record=$postdate_results['dateline'];
     // echo $postdate."<br>";
      $postdate_formatted=date('M dS  Y ',$postdate_results['dateline']);
      $post_count=mysql_query("SELECT * from post WHERE dateline >='$postdate_record'");
      while($post_count_results=mysql_fetch_assoc($post_count))
      {
         //$postdate_formatted=date('M dS  Y ',$post_dateline_results['dateline']);
         $posts=mysql_num_rows($post_count) or die(mysql_error());
         //echo $acronym.":POSTS:".$posts."<br>";
         echo '<table border="1">';
         echo "<tr>";
         echo "<th>Category</th>";
         echo "<th>".$acronym."</th>";
         echo "</tr>";
         echo "<tr>";
         echo "<td>POSTS:DATE:".$postdate_formatted."</td>";
         echo "<td>".$posts."</td>";
   echo "</tr>";
      }
     
   $threaddate=mysql_query("SELECT * from thread WHERE dateline >='$limit' ORDER by dateline DESC") or die(mysql_error());
   while($threaddate_results=mysql_fetch_assoc($threaddate))
   {
      $threaddate_record=$threaddate_results['dateline'];
            $threaddate_formatted=date('M dS  Y ',$threaddate_results['dateline']);
            $thread_count=mysql_query("SELECT * from thread WHERE dateline='$threaddate_record'");
           while($thread_count_results=mysql_fetch_assoc($thread_count))
           {
              $threads=mysql_num_rows($thread_count) or die(mysql_error());
             //echo $acronym.":THREADS:".$threads."<br>";
             echo "<tr>";
             echo "<td>THREADS:DATE:".$threaddate_formatted."</td>";
             echo "<td>".$threads."</td>";
             echo "</tr>";
             $userdate=mysql_query("SELECT * from user WHERE joindate >='$limit' ORDER by joindate DESC") or die(mysql_error());
             while($userdate_results=mysql_fetch_assoc($userdate))
    {
        $userdate_record=$userdate_results['joindate'];
        $userdate_formatted=date('M dS  Y ',$userdate_results['joindate']);
                 $user_count=mysql_query("SELECT * from user WHERE joindate='$userdate_record'");
                 while($user_count_results=mysql_fetch_assoc($user_count))
                 {
                    $users=mysql_num_rows($user_count) or die(mysql_error());
                  //echo $acronym.":USERS REGISTERED:".$users."<br>";
                    echo "<tr>";
                    echo "<td>REGISTERED USERS::DATE:".$userdate_formatted."</td>";
                    echo "<td>".$users."</td>";
                   echo "</tr>";
       }
              }

            }
         }
  
       }
     }

echo "</table>";
?>

I am running a search for a specific link on my site in order to make a big change but some of my entries are a little malformed.
How do I make this script go to the next record if no match is found. Here are the two pieces of code:





$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_assoc($result)){
echo $row['name'];
echo "<br />";




//After the page is loaded search for specified links
for ($i = 0; $i < $hrefs->length; $i++) {
   $href = $hrefs->item($i);
   $url = $href->getAttribute('href');
  $purl = substr($url, 30,300); 

//Here I would like to continue the while loop
//Maybe if i could find the value "No entities were found" it would escape it just as well?





At the end of the code I would like to continue the while loop if i could find the value "No entities were found" on the page that is missing the link I need.

Thanks for the help.

Firstly hello - I've not posted on here before!

I'm after a bit of advice if possible - I recently upgraded to a new server with RHEL6 and PHP 5.3.10 from a previous server with RHEL4 and PHP 5.2.17.

I have some postcode lookup software running that functioned perfectly on our old server, but seems to cause a server 500 error with the updated version of PHP. I cannot downgrade to PHP 5.2.17 so I need to fix the issue or workaround it. A snippet of the code is as follows:

Code: [Select]
$data = simplexml_load_string(file_get_contents($url));

foreach ($data->Rows->children() as $row)
{

I have narrowed down the cause of the failure to "children()" - it seems that anything with the curly brackets causes the code to die?

As you may guess I'm not a guru with PHP - I just know enough to get by. What do I need to do to get this working?

Many thanks in advance.

Danny

Is there a way, and if so how would I detect the state of the user on my site. Like by using their ip? Thanks!

I have been learning php and have put together a simple site to track vehicle faults and repairs, but now i am trying to transfer it to cakephp framework to make it easier to work with. My problem is that i have 4 tables, the fault and repair a list of vehicles a list of symptoms a list of fault codes. Each repair can have 3 vehicles, 3 symptoms and 3 codes relating to it so i have lookup table to link the fault/repair id to the symptoms, code and vehicles. i have setup basic code for the vehicle , symptom and fault code models like this: public $hasAndBelongsToMany = array(
'Fault' =>
array(
'className' => 'Fault',
'joinTable' => 'Faults_vehicles',
'foreignKey' => 'vehicle_id',
'associationForeignKey' => 'fault_id'
) 
); and this lets me search for any faults in the faults table with a given vehicle ID, and this works fine. My problem is how can i set it up so i can do a search for faults in the Faults table with a given vehicle ID and a given symptom ID that have a matching Fault code ID. I am very new to php and have only just started using cakephp so sorry in advance if this makes no sense at all. thanks for your time j