PHP - Count And Display Rows

month   a0   a1   a2   a3   a4   a5   a6   a7   a8   a9   a10   a11   a12   a13   a14   a15   a16   a17   a18   a19   a20   a21   a22   a23   a24   a25   a26   a27   a28   a29   a30   a31
         1   puudu   01   02   03   04   05   06   07   08   09   10   11   12   13   14   15   16   17   18   19   [20]   [21]   22   23   24   25   [26]   27   28   29   30   31
         2   puudu   01   02   03   04   05   06   07   08   09   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28           
         3   puudu   01   02   03   04   05   06   07   08   09   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31
         4   puudu   01   02   03   04   05   06   07   08   09   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   
         5   puudu   01   02   03   04   05   06   07   08   09   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31
         6   puudu   01   02   03   04   05   06   07   08   09   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   
         7   puudu   01   02   03   04   05   06   07   08   09   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31
         8   puudu   01   02   03   04   05   06   07   08   09   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31
         9   puudu   01   02   03   04   05   06   07   08   09   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   
         10   puudu   01   02   03   04   05   06   07   08   09   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31
         11   puudu   01   02   03   04   05   06   07   08   09   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   
         12   puudu   01   02   03   04   05   06   07   08   09   10   11   12   13   14   15   16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31


;
i need help .. with calculating how many days are between example:  january = 1  ; day =23 to feb =2; day 23
in php ... how can i do that

 $result = mysql_query("SELECT *  FROM `friend_system` WHERE `friend_system_accepter` = '$myusername' ");
echo mysql_num_rows($result);

This displays the total rows in the table.

$result = mysql_query("SELECT COUNT(friend_system_accepter)  FROM `friend_system` WHERE `friend_system_accepter` = '$myusername' ");
echo mysql_num_rows($result);

This displays '1', which is incorrect.   I want to echo out the number of rows where 'friend_system_accepter' = $myusername   Thanks

Hi Everyone,

I am working on implementing a blog comment system using the query below to display comments. My question is what is the best way to do a row count for the id column with this query or do I need to do a second db query to accomplish this? The purpose of this is to echo out the number of comments for that post, before displaying them.

Any help is appreciated.

Thanks in advance,

kaiman


<?php
// get url variables
$post_id = mysql_real_escape_string($_GET['id']);

include ("../../scripts/includes/nl2p.inc.php");

// connects to server and selects database
include ("../../scripts/includes/dbconnect.inc.php");

// table name
$tbl_name3="blog_comments";

// select info from comments database
$result3 = mysql_query ("SELECT count(*) FROM $table_name3 WHERE id='$post_id' ORDER BY id DESC LIMIT 1") 
or trigger_error("A mysql error has occurred!");
if (mysql_num_rows($result3) > 0 ) {
while($row = mysql_fetch_array($result3)) {
extract($row);

// display number of comments


// display date
$row_date = strtotime($row['date']);
putenv("TZ=America/Denver");
echo "<p class=\post\">On ".date('F, jS, Y', $row_date)." ";

// display commenter name
if($row['url'] == "") { 
echo $row['name']." wrote:</p>\n"; 
} 
     else { 
echo "<a href=\"".$row['url']."\" target=\"_blank\">".$row['name']."</a> wrote:</p>\n"; 
} 

// display content
$comments = $row['comment'];
echo nl2p($comments);
}
}
else {
echo "<p class=\"large_spacer\">No Comments</p>";
}
?>

The following works, but I don't want to have to write 50 query statements for 50 states.  How can I just write one query (using a variable I presume) and then echo the variable count each time for each state?  I'm just trying to list the total number of rows for each state, that exist in the db. 

<?         
$result = mysql_query("SELECT * FROM mytable WHERE source = 'alabama'") 
or die(mysql_error());  
$num_rows = mysql_num_rows($result);

?>
 
href="/state/alabama/">alabama</a> (<?php echo("$num_rows");?>) <br>
 
 <?
$result = mysql_query("SELECT * FROM mytable WHERE source = 'alaska'") 
or die(mysql_error());  
$num_rows = mysql_num_rows($result);
?>
href="/state/alaska/">alaska</a>  (<?php echo("$num_rows");?>) <br>   

 
The above would give output such as:
alabama (122)
alaska (212)

I have a html table displaying data from mysql database. I can count rows properly with mysql_num_rows but is there a way to echo which row number it is. What I want to do is count the rows ordered by cities and echo row number. Thanks for any help.

Folks,

Having trouble here. Forgot how you use the COUNT. Not interested in the num_rows due to it being slow compared to COUNT.

I have users table like this:

id|username|sponsor_username

0|barand|requinix

1|phpsane|alison

2|mickey_mouse|requinix

Now, I want to check if a sponsor username exists or not. Such as does the entry "requinix" exists or not in one of the rows in the "sponsor_username" column.

In our example it does twice and so the variable $sponsor_username_count should hold the value "2". Else hold "0".

I get error:

Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?' at line 1 

 

My code:

	$stmt_1 = mysqli_prepare($conn,"SELECT COUNT(sponsor_username) from users = ?"); 
            mysqli_stmt_bind_param($stmt_1,'s',$sponsor_username_count); 
            mysqli_stmt_execute($stmt_1); 
            
            //Show error if 'users' tbl was not successfully queried". 
            if (!$stmt_1) 
            { 
                echo "ERROR 1: Sorry! Our system is currently experiencing a problem loading this page!"; 
                exit(); 
            } 
            else 
            { 
                mysqli_stmt_bind_result($stmt_1,$sponsor_username_count);     
                mysqli_stmt_fetch($stmt_1); 
                mysqli_stmt_close($stmt_1); 
                
                //Check if Sponsor Username in Url ($_GET) is already registered or not. If not then show "Invalid Url" or Link message. 
                if ($sponsor_username_count < 1) 
                { 
                    echo "<b>Invalid Url or Link!<br> Invalid Sponsor: \"$sponsor_username\"!</b><?php "; 
                    exit(); 
                } 
            } 
	

I insert data in mysql table row using multiple method : 1#2#3 . 1 is ID of country, 2 is Id of state, 3 is ID of town . now i have this table for real estate listings. for each list(home) i have country/state/town (1#2#3). in country table i have list of country - in country table i have list of state - in country table i have list of town. i need to The number of houses in country / state / town . my mean is :
Code: [Select]
USA [ 13 ] <!-- This Is equal of alabama+alaska+arizona -->
----Alabama [8] <!-- This Is equal of Adamsville+Addison+Akron -->
-------Adamsville [2]
-------Addison[5]
-------Akron[1]
......(list of other City)
----Alaska [ 3 ]
-------Avondale[3]
......(list of other City)
----Arizona [ 2 ]
-------College[2]
......(list of other City)
Lisintg Table :

Code: [Select]
ID -- NAME -- LOCATION -- DATEJOIN -- ACTIVE
 1 -- TEST -- 1#2#3    -- 20110101 -- 1
 2 -- TEST1 -- 1#2#3    -- 20110101 -- 1
 3 -- TEST2 -- 1#3#5    -- 20110101 -- 1
 4 -- TEST3 -- 1#7#6    -- 20110101 -- 1
Country Table :

Code: [Select]
id       -- name 
 1        -- USA 
stats Table :

Code: [Select]
id        -- countryid -- name 
 1        -- 1             -- albama
 2        -- 1             -- alaska
 3        -- 1             -- akron
town Table :
Code: [Select]
id        -- countryid -- statsid -- name 
 1        -- 1             -- 1         -- adamsville
 2        -- 1             -- 1         -- addison
 3        -- 1             -- 1         -- akron
Thanks For Any Help.

I made the basic function to count the number of left count and right count. However now i need to display then number of additions to a tree according to their joining date. I stuck here. can someone please show me the logic to do this ?

I know i need to use UNION for sql because date of joining and tree structure are in different tables.

Sql tables-

Member table -(doj is date of join)


Tree table-


Basic Code-
Code: [Select]
<?php 
function tree_count($node)   //Function to calculate count;$node is first lchild or first rchild.
  {
    $sql = "SELECT lchild,rchild FROM tree WHERE parent = '".$node."'" ;
 // $sql = "SELECT lchild,rchild FROM tree WHERE parent = '".$node."'             should i do something like this ?
 //           UNION SELECT member_id FROM member WHERE id_sponsor=".$node." AND doj BETWEEN '".$from."' AND '".$to."'" ;
    $execsql = mysql_query($sql);
    $array = mysql_fetch_array($execsql);
    
    if(!empty($array['lchild']))
    {
      $count += tree_count($array['lchild']);
      
    } 
    if(!empty($array['rchild']))
    {
       $count += tree_count($array['rchild']);
       
    }
    
    $totalcount = 1 + $count;
    return $totalcount;
    
  }  
?>

<?php
require_once('upper.php');

require_once('database.php');
if(isset($_COOKIE['LoginIdCookie']))
{
echo '<h4>Welcome '.$_COOKIE['LoginIdCookie'].'</h4>';
}
else{ echo '<h4>Events</h4>';}
$result=mysqli_query($dbc,"select * from events") or die('Not Connected');
echo "<html>
<body>";
  echo "<form method='post' action='EventParticipator.php'>"; 
  echo "<u><h4>Please tick events in which you want to participate</h4></u>";
  /*echo "<table cellspacing='0' cellpadding='15'>
   <th><b>Event Title:</b></th>
   <th ><b>Event City:</b></th>
<th><b>Content:</b></th>
<th><b>Images:</b></th>
<th><b>Event Date:</b></th>";*/

//while($row=mysqli_fetch_array($result))
$row=mysqli_fetch_array($result);
for($i=0;$i<5;$i++)
{
$Title=$row['Title'];
$City=$row['City'];
$Content=$row['Content'];
//$Photo=$row['Photo'];
$Date=$row['Date'];
$EventId=$row['EventId'];
$Photo=$row['Photo'];
//echo $Photo;

echo "<tr><td><img src='$Photo' width='120' height='90'/></td><td>$City</td><td>,</td><td>$Date</td><td>:</td><td>$Title</td></tr>
<tr><td>$Content</td></tr>
<tr><td><a href='#'>Know more</a></td><td>/</td><td><a href='#'>Click here to participate</a></td></tr>"; 
}
//echo "<tr><td><input type='submit' name='submit' value='Participate'</td>";
if(isset($_COOKIE['LoginIdCookie']))
{
echo "<td><a href='log_out.php'>Log out</a></td>";
echo "<td><a href='EditActivity.php'>Edit Your Activities</a></td></tr>";
}
echo "</table></form></body></html>";
require_once('lower.php');
?>






Quote

Hi friends ..........
I write above code to display top 5 rows from the database but it not works properly. It displays first row 5 times which is undesireable.
Anyone please help?????????????????
thanks in advance..................

Morning

I have a table with many rows. Some of these rows have the same id number. I'm wondering how I print all the rows with the like id like so programing,design,help. My fucntion is below.

  function getPostTags($postid){
     
     $sql = mysql_query("SELECT tag FROM tags WHERE id=$postid") or die(mysql_error());
 if (mysql_num_rows($e)){
    extract(mysql_fetch_array($sql));
$tags[$postid]=array();
$tags[$postid]['tag'];

 }
 return $tags;
   }   

So if I do this <?php print $tags; ?> It only prints out one result from my table.

What do I have to do it get it to print all row field values from the table with a comma.

Right now the only way I can do this is instead of printing "$tags" (which only gives me one of the many values) I query the database again and do a while statement with
$row = mysql_fetch_array. This isn't the right way to do it.  Can someone help or give me some pointers?


Thanks for the help.

Hey guys! I've been having trouble with this all day. I'm wanting to display my results in rows. Like, 4 results in 1 row, then another 4, then another 4, etc. like this:
IMAGE  IMAGE IMAGE IMAGE
IMAGE IMAGE IMAGE IMAGE
IMAGE IMAGE IMAGE IMAGE

I'm nto sure how to do that. I want to display pictures. Here is my code for the page:
bag.php:
Code: [Select]
<?php
session_start();
include("config536.php");
?>
<html>
<head>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>

<?php
if(!isset($_SESSION['username'])) {
echo "<ubar><a href=login.php>Login</a> or <a href=register.php>Register</a></ubar><content><center><font size=6>Error!</font><br><br>You are not Logged In! Please <a href=login.php>Login</a> or <a href=register.php>Register</a> to Continue!</center></content><content><center><font size=6>Inventory</font><br><br></center></content>";
}

if(isset($_SESSION['username'])) {
echo "<nav>$shownavbar</nav><ubar><img src=/images/layout/player.gif><a href=status.php>$showusername</a>.......................<img src=/images/layout/coin.gif> $scredits</ubar><content><center><font size=6>Inventory</font><br><br>";

$action = $_GET['action'];
$gid = $_GET['itemid'];

$irow = "SELECT * FROM uitems WHERE username='$showusername'";
$iquery = mysql_query($irow);
while($ir = mysql_fetch_array($iquery)) {
$uid = $ir['uitemid'];
$iid = $ir['theitemid'];
$iun = $r['username'];
$il = $ir['location'];


$tirow = "SELECT * FROM items WHERE itemid='$iid'";
$tiquery = mysql_query($tirow);
while($tir = mysql_fetch_array($tiquery)) {
$tiid = $tir['itemid'];
$tin = $tir['name'];
$tiim = $tir['image'];
$tid = $tir['description'];
$tirr = $tir['rarity'];
$tit = $tir['type'];
$tiu = $tir['uses'];
$tis = $tir['strength'];
$tide = $tir['defense'];
$tih = $tir['heals'];

echo "<img src=/images/items/$tiim><br>$tin<br><br>";
}
}

}
?>

</html>I have no errors, everything works great! It's just I'm not sure how to display them the way I want them. Right now they are displayed like this:
IMAGE
IMAGE
IMAGE
IMAGE

Any help is greatly appreciated, thank you!

Hello.   I'm not sure whether this would come under PHP or HTML, but some sites display how many shares an article has had in a font, like this:   https://dl.dropboxus...0726.183853.png   What would the best way of doing this be?   Thanks.

I can't seem to get the math right!

I have a function, pulling 13 states (canadian provinces) from the database and I can't seem to get them all to show in 5 columns. Where am I doing this wrong. The code below only shows 7 of 13... I just can't seem to get where I am off!

PHP CODE:
function map_showCA()
{
global $db, $tpl;

// ShowLocalResources

$sSQL = "SELECT * FROM states_canada ORDER BY state;";
$db->query($sSQL);
$next_record = $db->next_record();

while ($next_record)
{
$state_id = $db->f("id");
$state = $db->f("state");
$statename = $db->f("statename");
$statename_html = $db->f("statename_html");

$next_record = $db->next_record();
if (!USE_SEO_LINKS) { $statename_html = $state_id; }
$vendors_states[] = array("name" => $statename, "id" => $state_id, "state_html" => $statename_html);
}

$vendors_states_col = array_chunk($vendors_states, 5, true);

$loop = (int)(count($vendors_states) / 5);
if(count($vendors_states) % 5 > 0) $loop++;

$j = 0;

for($i = 0; $i < $loop; $i++)
{
$parameters = 'http://'.$vendors_states_col[0][$j]["state_html"].'.ilocalize.com';
// $first_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("first_column_link", $parameters);
$tpl->set_var("first_column", tohtml($vendors_states_col[0][$j]["name"]));

$parameters = 'http://'.$vendors_states_col[1][$j+6]["state_html"].'.ilocalize.com';
// $second_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("second_column_link", $parameters);
$tpl->set_var("second_column", tohtml($vendors_states_col[1][$j+6]["name"]));

$parameters = 'http://'.$vendors_states_col[2][$j+12]["state_html"].'.ilocalize.com';
// $threeth_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("threeth_column_link", $parameters);
$tpl->set_var("threeth_column", tohtml($vendors_states_col[2][$j+12]["name"]));

$parameters = 'http://'.$vendors_states_col[3][$j+18]["state_html"].'.ilocalize.com';
// $fourth_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("fourth_column_link", $parameters);
$tpl->set_var("fourth_column", tohtml($vendors_states_col[3][$j+18]["name"]));

$parameters = 'http://'.$vendors_states_col[4][$j+24]["state_html"].'.ilocalize.com';
// $fifth_column_link = generate_vendor_seo_url($parameters);
$tpl->set_var("fifth_column_link", $parameters);
$tpl->set_var("fifth_column", tohtml($vendors_states_col[4][$j+24]["name"]));

$tpl->parse("ShowLocalResourcesCA", true);
$j++;
}
}

HTML CODE:
Code: [Select]
<table border="0" cellpadding="1" cellspacing="1"  class="description_text2"  style="padding-bottom:6px;" width="100%" id="dashed_box_gray">
             <!--BeginShowLocalResourcesCA-->
                <tr>
                    <td width="110" align="left" style="padding-left:6px; padding:6px;"><a href="{first_column_link}" class="user_blue_14px">{first_column}</a></td>
                    <td width="109" align="left" style="padding-right:6px; padding:6px;"><a href="{second_column_link}" class="user_blue_14px">{second_column}</a></td>
                    <td width="109" align="left" style="padding-right:6px; padding:6px;"><a href="{threeth_column_link}" class="user_blue_14px">{threeth_column}</a></td>
                    <td width="109" align="left" style="padding-right:6px; padding:6px;"><a href="{fourth_column_link}" class="user_blue_14px">{fourth_column}</a></td>
                    <td width="108" align="left" style="padding-right:6px; padding:6px;"><a href="{fifth_column_link}" class="user_blue_14px">{fifth_column}</a></td>
                </tr>
                <!--EndShowLocalResourcesCA-->
                </table>

I've got my code working OK in that the correct results are drawn from the database. What I have here in the code is an array consisting of an image, accompanied by its title and thirdly a link to activate a quiz associated with the image. Everything works fine, except because the page is dynamic, I always have an unknown number of sets of data (image, title and link) which I want to display so that each set of data takes up a new row.
The code I have here, while displaying the correct data, places all of the results into the same row.
Any suggestions are most welcome.
Code: [Select]
<?php
// Query the database
$query1 = mysql_query("SELECT title FROM topics WHERE managerId='".$managerId."' AND egroup1='"."1"."' ORDER BY title ASC"); 
$query2 = mysql_query("SELECT url_small FROM topics WHERE managerId='".$managerId."' AND egroup1='"."1"."' ORDER BY title ASC"); 
$query3 = mysql_query("SELECT title FROM topics WHERE managerId='".$managerId."' AND egroup1='"."1"."' ORDER BY title ASC");
while($row1 = mysql_fetch_array($query3))
{
$linkname .= $row1['title']."<br />\n";
}
?>
                  <table>
                    <tr>
                      <td>
                      <?php
                      while ($row2 = mysql_fetch_array($query2)) 
                      { 
                      $thumbnail.= $row2['url_small'];
                      echo "<img src='wood_tool_images/{$row2['url_small']}' alt='' /><br />\n";
                      }
                      ?>
                      </td>
                      <td height="200">
                      <?php
                      echo $linkname 
                      ?>
                      </td>
                      <td>
                      <?php
                      while ($row1 = mysql_fetch_array($query1)) 
                      { 
                      $quizname.= $row1['title'];
                      echo "<a href='../{$row1['title']} Safety Quiz/{$row1['title']} Safety Quiz.php'>Take This Quiz</a><br />\n";
                      }
                      ?>
                      </td>
                     </tr>
                  </table>

i'm trying to echo out the results from a query onto a page, but rather than having them echo out as rows in a table, i want them to be displayed in columns, i.e. first column would have the first 10 results and the second column would have the next to. Any ideas on how i could do this?

at the moment i'm using this code to display my results

$read=mysql_query("SELECT * FROM entry WHERE category_id=".$id." ORDER BY entry_title") or die("query failed".mysql_error());
$result=mysql_num_rows($read);
for($j = 0; $j < $result; $j++) { 
   

$row = mysql_fetch_array($read);

echo "<a href=article.php?id=".$row['entry_id']. ">".$row['entry_title']."</a><br />";
}

but this just displays it as a list down the middle

thanks