PHP - Php Sql Count

Hello,   I am trying to get the report of my sales table. I want to get total number of leads for each month. And then i have to use this data to create graph using google graph.    But i am not getting how eactly i can get this.   Here is my code

 <?php 
if(isset($_POST['submit']))
{
	$type = $_POST['type'];
	


$sql="select * from leads where lead_customer='".$type."'";



$query=mysql_query($sql);

while ($row = mysql_fetch_array($query))
{
	
list($year,$month,$day)=explode("-", $row['last_modified']);
$l = $row['last_modified'];
$count=mysql_num_rows($month);
echo $count;


$myurl[] = "['".$month."', ".$count."]";
}

 print_r($myurl);
 echo implode(",", $myurl);
}


?>

But for $count, it doesn't show any values. below is my database.    Capture.PNG   18.16KB   0 downloads   Please suggest me

returns -30.

how can i remove the minus

so it just returns 30


Code: [Select]

$days = (strtotime(date("Y-m-d")) - strtotime($info['expiredate'])) / (60 * 60 * 24)

echo $days

Hello, I'm using the following code to count the amount of SQL results and divide it. Works great as is but I want to alter it so it works with categories.

$amount = mysql_query('SELECT COUNT(`car_id`) AS num FROM `tbl_cars`') or die(mysql_error());
$amount_row = mysql_fetch_assoc($amount);

I tried adding...

WHERE car_cat = '".$cat."'

which causes an error.

Why doesn't this work, and how can I get the amount of results as a variable?

hey i'm just woundering how i would go abouts on echoing unread messages sent to a user
i want to beable to see how many unread messages i have

$count=0;
$numb=50;
foreach ($sepkeys as $dbkey)
{
for ($page=10;$page<=$numb;$page=$page + 10)
  {
// the if block

$count=$count+1;
 
}

}

I am trying to maintain a separate a count for each key number in the above code.

Eg: key- 574, it searches from pages 10-50 and increments the count by 1.

The problem that I have is the count is continuous. After searching for the first key and moves on to the next key and them I need the count to start from the beginning rather than being continuous.

Eg: key-874 : count = 22, in my case the next key 875 : the count is 23

I need to make it 1.

I removed the if block and several lines because the code is too long.

Can someone please suggest me a way how to do it

This topic has been moved to MySQL Help.

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

Hi,

Cut down code

SELECT count(number) FROM table GROUP BY title

echo $title .'<br>'. $number;



That outputs

Code: [Select]
Title1
5

Title2
9

Title3
2

But what do i do if i wanted to retain and loop through the "$number" actual values, not JUST count the total? I still need access to what "$number" is while looping. But as GROUP BY returns one result.. im stuck.

Ideally i want this as the resulting output

Code: [Select]
title1 // grouped title
3   // total number of $numbers per grouped title
1234
12345
123456  // The actual values of $number totalling to the above grouped number

title2 // grouped title
2   // total number of $numbers
1234
123456  // The actual values of $number totalling to the above grouped number

This topic has been moved to JavaScript Help.

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

               $count = 0;
   foreach($myArray as $date => $values){   
   if($count >= 20) break;
    echo 'blablabla' ;
               $count++;}

i am using $date as a key,
and i want to start counter if $date is bigger then 20
php operates in order so i guess i have to put something before $count command so
it must be something like this :

               if ($date >=20) {$count = 0;}
   foreach($myArray as $date => $values){   
   if($count >= 20) break;
    echo 'blablabla' ;
              $count++;}
all suggestions are welcome.

Hi,
I want the user to be able to go to one page and hit a button, once he hits the butten I want a count down to start from 10 minutes. When the user goes to the page within those 10 minutes, I want it to show him a live countdown until those ten minutes run out.

Any ideas how I would go about doing this?

Hi All,
The following code works but for some reason it is leaving 1 result off of each page when displaying results from DB. I assume there is something wrong with the count but I cannot find the problem.

Thank you for any help.

Code: [Select]

<?php   
         
$page = $_GET['page'];

$result2 = mysql_query("SELECT * FROM vendors WHERE vendor_type_id = '$vdrt' AND active ='Yes' ORDER BY RAND()");
$total_results = mysql_num_rows($result2); 
   
if (empty($total_results)) {echo "Sorry, but we do not have any results for that search at this time. <br/><br/><a href='index.php'>Please try your search again</a>";} 

else {
 
$total_pages = ceil($total_results / $results_limit); // $results_limit is set to 7 in config file
if (empty($page)) 
    { 
        $page = "1"; 
    } 
$offset = ($page - 1) * $results_limit;
 
$result = mysql_query("SELECT * FROM vendors WHERE vendor_type_id = '$vdrt' AND active ='Yes' LIMIT $offset, $results_limit") or die ("$DatabaseError"); 
 
$row = mysql_fetch_assoc($result);
$vendor_type_id = $row['vendor_type_id'];
$num = mysql_numrows($result); 
  if ($num == 0) : 
  print "<br><br><p>Sorry, no vendors could be found.</p><br><br>"; 
  
  elseif ($num > 0) :

echo "Page - "; 
if ($page != 1) 
{ 
echo "<a href=$PHP_SELF?city=Orlando&state=FL&vdrt=$vendor_type_id&page=1><< First</a>&nbsp;&nbsp;&nbsp;"; 
$prevpage = $page - 1; 
} 
        if ($page == $total_pages) 
            { 
                  $to = $total_pages; 
            } 
        elseif ($page == $total_pages-1) 
            { 
                  $to = $page+1; 
            } 
        elseif ($page == $total_pages-2) 
            { 
                  $to = $page+2; 
            } 
        else 
            { 
                  $to = $page+3; 
            } 
        if ($page == 1 || $page == 2 || $page == 3) 
            { 
                  $from = 1; 
            } 
        else 
            { 
                  $from = $page-3; 
            } 
             
for ($i = $from; $i <= $to; $i++) 

    { 
    if ($i == $total_results) $to=$total_results; 
    if ($i != $page) 
        { 
        echo "<a href=$PHP_SELF?city=Orlando&state=FL&vdrt=$vendor_type_id&showold=yes&page=$i>$i</a>"; 
        } 
    else 
        { 
        echo "<b><span class='current-page'>[$i]</span></b>";

        } 
    if ($i != $total_pages) 
        echo "&nbsp;"; 
    } 
if ($page != $total_pages) 
{ 
$nextpage = $page + 1; 

echo "&nbsp;&nbsp;&nbsp;<a href=$PHP_SELF?city=Orlando&state=FL&vdrt=$vendor_type_id&page=$total_pages>Last >></a>";
}
 if ($num == 0)  { echo "<br><br>";} else {echo "<br><br>";}

    $i = 0; 
    while ($i < $num) : 

        while ($row = mysql_fetch_assoc($result)) {
            $vdrid = $row['vendor_id'];
$vendor_name = $row['vendor_name'];
$vendor_name_enc = urlencode($row['vendor_name']);
$vendor_city = $row['vendor_city'];
            $vendor_state = $row['vendor_state'];
$vendor_phone = $row['vendor_phone'];
$vendor_overview = $row['vendor_overview'];

// Trim overview
if(strlen($vendor_overview) > 385) {$trimed_vendor_overview = substr($vendor_overview,0,385) . "...";
} else {
$trimed_vendor_overview = $vendor_overview;
}

            echo "<strong><a href='listing.php?$vendor_name_enc-$vendor_city-$vendor_state-&vdrid=$vdrid'>$vendor_name</a> </strong> - $vendor_city, $vendor_state $vendor_phone<br/>";           
echo "$trimed_vendor_overview<br/><br/>";
        }


        $i++; 
    endwhile; 

  endif;
  

}

?>

How to write the code to get the count of the word "CHECKED" from a row?

I tried this and it's not working. Please help.
$query = mysql_query("SELECT field1, field2, field3, COUNT(CHECKED) as counter FROM db1 WHERE row_name = 'science'");
while($line = mysql_fetch_array($query))
{
echo $query['counter'];
}

I need some help. I have this script that pulls timestamps from the database. What I want to do is create a count of how many of those timestamps that were returned were from the morning(6am-12pm), Afternoon (12pm-6pm), Evening (6pm-12am), or Night (12am-6am). How do I do I parse the timestamps to do that and display the count. Thanks!

Code: [Select]
<?php

/**
 * @author William Morris
 * @copyright 2010
 */
 
include('inc/db.php');

//function to show date and time based on timestamp
function showTIME($timestamp){
    $date = date('F j Y h:i:s A', $timestamp);
    return $date;
}

$startdate = "2010-07-01";
$enddate = "2010-08-05";

//query to pull time stamps in between dates

//convert dates into timestamp
//$startdate = strtotime($_POST['startdate']);
//$enddate = strtotime($_POST['enddate']);

//convert dates into morning timestamp
$startdate1 = strtotime($startdate."06:00:00");
$enddate1 = strtotime($enddate."11:59:59");

$sql = mysqli_query($conn, "SELECT event_time FROM event WHERE event = 'Registration' 
AND event_time BETWEEN '$startdate1' AND '$enddate1'");

while($row = mysqli_fetch_array($sql)){
    echo showTIME($row['event_time'])."<br>";
}
?>

I would appreciate if someone could figure this out or tell me the easiest way to do this. I need a count up counter that appears in a textbox so I can record the time a user is on a page. On a side note, I do have their Start and finish time timestamp recorded in myphpadmin database but I am looking for the easiest (or best) way to do this. Any advice or scripts would be very much appreciated.   Thanks in advanced.   I did find this counter that works but the numbers appear 0.0.1 if counting up. I don't want to confuse the user. I really want to display to the user how long they was on a certain page.

<script>
  $(document).ready(function() {
    var time = '00:00:00',
        parts = time.split(':'),
        hours = +parts[0],
        minutes = +parts[1],
        seconds = +parts[02],
        input = $('#timeInput');
 
    var timer = setInterval(function(){
        seconds++;
        if(seconds == 60) {
            seconds = 00;
            minutes++;
 
            if(minutes == 60) {
                minutes = 00;
                hours++;
            }
        }
        var newTime = hours + ":" + minutes + ":" + seconds;
        $('#timeInput').val(newTime);
    }, 1000);
 
});
</script>
 
<input type="text" name="time" id="timeInput"/>

How to write this in a shorter way?

I've got a set of results and I need to check them against another database results. If they both are similar then I want to make it as "1" (points). The questions and the answers are in the same order (Question1, Question2, Question3 = Answer1, Answer2, Answer3). sa I guess the maching could be done using a set of arrays.

E.g.
get records from db1 get records from db2
get records from dbY get records from dbX
COUNT the matching data from db1 against dbY = echo TOTAL_SCORE1
COUNT the matching data from db2 against dbX = echo TOTAL_SCORE2

I've managed to get the data from the databases in order. But i need to get the COUNT of the MATCHING records.


php
\\Assume this is db1
$SomeVar = $_POST['sitting2'];
$queryU =  "SELECT * FROM adxone WHERE username = '".$SomeVar."'";
$resultU = mysql_query($queryU);
$scoreU = mysql_fetch_assoc($resultU);
$userRa1 = $scoreU['roundzAa'];
$userRa2 = $scoreU['roundzAb'];
$userRa3 = $scoreU['roundzAc'];
$userRa4 = $scoreU['roundzAd'];
$userRa5 = $scoreU['roundzAe'];
$userRa6 = $scoreU['roundzAf'];
$userRa7 = $scoreU['roundzAg'];
$userRa8 = $scoreU['roundzAh'];

\\ Assume this is dbY
$WinVar = 'examinationA';
$query =  "SELECT * FROM markacs WHERE roundx = '".$WinVar."'";
$result = mysql_query($query);
$scoreM = mysql_fetch_assoc($result);
$winRa1 = $scoreM['markwinxa'];  
$winRa2 = $scoreM['markwinxb']; 
$winRa3 = $scoreM['markwinxc']; 
$winRa4 = $scoreM['markwinxd']; 
$winRa5 = $scoreM['markwinxe']; 
$winRa6 = $scoreM['markwinxf']; 
$winRa7 = $scoreM['markwinxg']; 
$winRa8 = $scoreM['markwinxh']; 

/*need to match if 
$winRa1 = $userRa1, $winRa2 = $userRa2, etc..

then get the COUNT of the matching results*/