counting etc

[zingbats]

What would the script be that counts how many rows there are in a table?

Also... I have a query that is run in a loop. It has the name and banner of the website. I also want a "position" column. This will number each row 1 - 10 or whatever.

What would the script be that you could echo in the postion cell to show the position.

[sleepingdanny]

Basically you can use:

1. mysql_num_rows - Get number of rows in result
2. mysql_affected_rows - Gets the number of rows affected in the previous mysql operation

[zingbats]

cheers, anyone know about the position column?

[laserlight]

you could simply order by the position column in the query, then it should be arranged according to the position.

[jayant]

What would the script be that counts how many rows there are in a table?

use the query:-
SELECT COUNT(*) FROM table_name;

[zingbats]

There ISN'T a postition column. Only a points column. It orders DESC with the points column. I want my script (in the loop) to assign a postition to each of the rows. So the one with the most poins (At the top) gets assigned 1, the next 2 etc.

It was mysql_num_rows I was looking for 🙂

[jayant]

$sql = "SELECT ......... ORDER BY points DESC;";

$num=0;
$result=mysql_query($sql);
if(mysql_num_rows($result)>0) {
while($arr=mysql_fetch_array($result)) {
$num++;
echo $num;
print_r($arr);
}

}

[zingbats]

hmmmm

      <?php
    /* Connecting, selecting database */
    $link = mysql_connect("localhost", "username", "pwl")
        or die("Could not connect");
    mysql_select_db("tycooneden_com") or die("Could not select database");

$query = "SELECT * FROM clans ORDER BY 'clan_points' DESC";
$result = mysql_query($query) or die("Query failed");

 while($foo=mysql_fetch_array($result)){ 
 $clan_url=$foo['clan_url']; 
 $clan_logo=$foo['clan_logo']; 
 $clan_admin=$foo['clan_admin']; 
 $clan_admin_email=$foo['clan_admin_email']; 
 $clan_forum=$foo['clan_forum']; 
 $clan_name=$foo['clan_name']; 
 $clan_logo_height=$foo['clan_logo_height']; 
 $clan_logo_width=$foo['clan_logo_width'];
 $clan_points=$foo['clan_points'];
?>
<?
$link2 = mysql_connect("localhost", "username", "password") or die("Could not connect");
mysql_select_db("tycooneden_com") or die("Could not select database");
$query2 = "SELECT * FROM clans ORDER BY 'clan_points' DESC"; 
$num=0; 
$result2=mysql_query($query2); 
if(mysql_num_rows($result2)>0) { 
while($arr=mysql_fetch_array($result2)) { 
$num++; 
echo $num; 
print_r($arr); 
} 

}
?>

You can see how it doesn't work by visiting http://tycooneden.com/tecc2.php

[jayant]

 
      <?php 
    /* Connecting, selecting database */ 
    $link = mysql_connect("localhost", "username", "pwl") 
        or die("Could not connect"); 
    mysql_select_db("tycooneden_com") or die("Could not select database"); 

$query = "SELECT * FROM clans ORDER BY 'clan_points' DESC"; 
$result = mysql_query($query) or die("Query failed"); 
$num=0;  

     while($foo=mysql_fetch_array($result)){  

     $clan_url=$foo['clan_url'];  

     $clan_logo=$foo['clan_logo'];  

     $clan_admin=$foo['clan_admin'];  

     $clan_admin_email=$foo['clan_admin_email'];  

     $clan_forum=$foo['clan_forum'];  

     $clan_name=$foo['clan_name'];  

     $clan_logo_height=$foo['clan_logo_height'];  

     $clan_logo_width=$foo['clan_logo_width']; 
     $clan_points=$foo['clan_points']; 
$num++;  

echo "<br><hr>".$num;  

// instead of using print_r($foo) you can
// echo $clan_rl. $clan_logo, ... etc
print_r($foo);

}  

?> 

[zingbats]

That sort of helped... look at http://www.tycooneden.com/tecc2.php now :rolleyes:

[crosbystillsnas]

post your actual code again.

[zingbats]

<table cellSpacing="0" cellPadding="0" width="80%" border="3" style="border-collapse: collapse">
  <tr align="middle" bgColor="#1b3f27">
    <td bgcolor="#FFCC66"><font color="#000000"><b><i>Position:</i></b></font></td>
    <td bgcolor="#FFCC66"><font size="6" color="#000000"><b><i>--Leader Board--</i></b></font></td>
    <td bgcolor="#FFCC66"><font color="#000000">Points</font></td>
  </tr>
      <?php  

    /* Connecting, selecting database */  

    $link = mysql_connect("localhost", "username", "pwl")  

        or die("Could not connect");  

    mysql_select_db("tycooneden_com") or die("Could not select database");  

$query = "SELECT * FROM clans ORDER BY 'clan_points' DESC";  
$result = mysql_query($query) or die("Query failed");  
$num=0;   

     while($foo=mysql_fetch_array($result)){   

     $clan_url=$foo['clan_url'];   

     $clan_logo=$foo['clan_logo'];   

     $clan_admin=$foo['clan_admin'];   

     $clan_admin_email=$foo['clan_admin_email'];   

     $clan_forum=$foo['clan_forum'];   

     $clan_name=$foo['clan_name'];   

     $clan_logo_height=$foo['clan_logo_height'];   

     $clan_logo_width=$foo['clan_logo_width'];  

     $clan_points=$foo['clan_points'];  

$num++;   

echo "<br><hr>".$num;   

// instead of using print_r($foo) you can 
// echo $clan_rl. $clan_logo, ... etc 
print_r($foo); 

}   

?>
  <tr align="middle" bgColor="#1b3f27">   

    <td bgcolor="#FFCC66"><font face="Verdana" size="2" color="#000000"><b>
    <a href="<?=$clan_url?>"><font color="#000000"><?=$clan_name?></font></a><br>
    </b></font><font color="#000000"><br>
    </font>
    <?php
$logo_location = "$clan_logo"; 
$fp = @fopen($logo_location,"r"); 
if ($fp == ""){
if ($clan_logo ==""){ 
?> 
<font color="#000000">Sorry, no image has been specified</font>
<?php 
}
else
{
?> 
<font color="#000000">Sorry, no picture is avaliable for the clan <?=$clan_name?></font>
<?
} 
?>
<?
@fclose($fp);
} else {
print "<img border='0' src='$clan_logo' width='$clan_logo_width' height='$clan_logo_height'>";
?>
</td>
    <td align="middle" bgcolor="#FFCC66"><font color="#000000"><?=$clan_points?></font>&nbsp;</td>
  </tr>
  <?php
}
?>
</table>
</center>

[crosbystillsnas]

follow jayants instructions...

change:

// instead of using print_r($foo) you can 
// echo $clan_rl. $clan_logo, ... etc 
print_r($foo);

to:

print_r($clan_url)."<br />";
print_r($clan_logo)."<br />";
print_r($clan_admin)."<br />";
//.....and all the others defined before.

[zingbats]

yes... but that doesn't generate a postion column does it?

[jayant]

$num is used to generate numbering for position column.

use:

echo "<tr>".
         "<td>$num</td>".
         "<td>$clan_url</td>".
         "<td>$clan_logo</td>".
         "<td>$clan_admin</td>".
         "</tr>";

[zingbats]

Yeah, that is cool.
However, the below script doesn't want to work and I don't know why not

      <?php  

    /* Connecting, selecting database */  

    $link = mysql_connect("localhost", "username", "pwl")  

        or die("Could not connect");  

    mysql_select_db("tycooneden_com") or die("Could not select database");  

$query = "SELECT * FROM clans ORDER BY 'clan_points' DESC";  
$result = mysql_query($query) or die("Query failed");  
$num=0;   
 while($foo=mysql_fetch_array($result)){   
 $clan_url=$foo['clan_url'];   
 $clan_logo=$foo['clan_logo'];   
 $clan_admin=$foo['clan_admin'];   
 $clan_admin_email=$foo['clan_admin_email'];   
 $clan_forum=$foo['clan_forum'];   
 $clan_name=$foo['clan_name'];   
 $clan_logo_height=$foo['clan_logo_height'];   
 $clan_logo_width=$foo['clan_logo_width'];  
 $clan_points=$foo['clan_points'];  
$num++;
print ('
    <tr>
      <td width="13%" bgcolor="#CCFFFF"><font color="#000000">Position:</font></td>
      <td width="70%" bgcolor="#CCFFFF"><font color="#000000">Clan Details</font></td>
      <td width="17%" bgcolor="#CCFFFF"><font color="#000000">Points</font></td>
    </tr>
    <tr>
      <td width="13%" bgcolor="#CCFFFF"><font color="#000000">$num</font>&nbsp;</td>
      <td width="70%" bgcolor="#CCFFFF">
      <a href="$clan_url"><font color="#000000">$clan_name</font></a><font color="#000000"><br>
    </b><br>
$logo_location = "$clan_logo"; 
$fp = @fopen($logo_location,"r"); 
if ($fp == ""){
if ($clan_logo ==""){  

print "<font color="#000000">Sorry, no image has been specified";
}
else
{ 
print "Sorry, no picture is avaliable for the clan $clan_name";
} 
@fclose($fp);
} else {
print "<img border="0" src="$clan_logo" width="$clan_logo_width" height="$clan_logo_height">";
}
</font></font></font></td>
      <td width="17%" bgcolor="#CCFFFF"><font color="#000000">$clan_points</font>&nbsp;</td>
    </tr>');
    }
?>