[dihan]

I'm using the following loop to get results of how many times a url is located on the database.

Query:
1. I want to know how I can total the ammount (all rows added together) at the end of the loop?

and

2. Is it possiable to put these results in numerical order using php?

PHP Code:

        // Loop Start

        while ($out_list=mysql_fetch_array($out_result)) 

        {

        

        $varwhole = $out_list['out'];

        $total_link = mysql_query("SELECT `out` FROM `webstat` WHERE 1 AND `out` LIKE '$varwhole'");



        //echo the whole this

        echo '

        <tr>

        <td WIDTH="75" CLASS="text">'. mysql_num_rows($total_link) .'</td>

        </tr>';

        

        } 

I think the best way is probably to loop the information first to sort it and loop it again to get the final results? But I have no idea how to go about this! Help

[DetroitGuy]

PHP Code:

//Count Results

        $total_overall = mysql_query("SELECT count(out) FROM webstat WHERE 1 AND `out` LIKE '$varwhole'")

        or die ("Could not connect to mysql because ".mysql_error());



// Loop Start

        while ($out_list=mysql_fetch_array($out_result))

        {

        $varwhole = $out_list['out'];

        $total_link = mysql_query("SELECT 'out' FROM `webstat` WHERE 1 AND `out` LIKE '$varwhole'" order by out desc);

        //echo the whole this

        echo '

        <tr>

        <td WIDTH="75" CLASS="text">'. mysql_num_rows($total_link) .'</td>

        </tr>';

        } 

print "$total_overall links."; 

[dihan]

Thanks DetroitGuy