I need Help with You in this script

[meno]

Hi everybody
.....................
i make php script "links" like site guide
i need code from you which make results appear like that
example

http://www2.serveur4u.com/2cool/example.htm

OR
my file which browse sites is here how i can edit on it

<?
// *******************************************************************
//  include/show.php
// *******************************************************************

if(!isset($sr)){

$sr=0;
}

$get_sites_count = sql_query("
select
 ID
from
 $tb_links
");

$total_sites = sql_num_rows($get_sites_count);

$sql = "
select
 $tb_links.ID as site_id,
 $tb_links.SiteName as site_name,
 $tb_links.SiteURL as site_url,
 $tb_categories.Category as category_name,
 $tb_categories.ID as cat_id,
 $tb_links.Added as added,
 $tb_links.LastUpdate as last_update,
 $tb_links.Description as site_description,
 $tb_links.Country as country,
 $tb_links.HitsIn as hits_in,
 $tb_links.HitsOut as hits_out,
 count($tb_reviews.ID) as total_reviews
from
 $tb_links
left join
 $tb_categories
on
 $tb_links.Category = $tb_categories.ID
left join
 $tb_reviews
on
 $tb_links.ID = $tb_reviews.SiteID
group by
 site_id
order by
";
 // HERE NEW SITE
if($show == "new"){

$sql .= "last_update ";
}
 // HERE COOL SITE
if($show == "cool"){

$result = mysql_query(" hits_in");
while ($row = mysql_fetch_array($result)) {
$id = $row["id"];
// HERE CATEGORIES NAME
$www = mysql_query("select * $tb_links.ID as site_id");
while ($web = mysql_fetch_array($www)) {
$wid = $row["id"];
// HERE CATEGORIES INCLUDED

$sql .= "hits_in ";
}

if($show == "pop"){

$sql .= "hits_out ";
}

$sql .= "
 desc
limit
 $sr, $pp
";

$get_sites = sql_query($sql);

echo draw_sites($total_sites, $get_sites);

?>

[Yamakazi]

First off, i don't understand you question. Try to ask the question in your own language i'll try to translate it myself. Or use www.systransoft.com to translate into English. (not a bash, i don't speak every language in the world either.)

First remark on your code instead of this

$get_sites_count = sql_query(" 
select 
 ID 
from 
 $tb_links 
"); 

$total_sites = sql_num_rows($get_sites_count);

do this

$get_sites_count = sql_query("select count(ID) as amount from  $tb_links "); 

$result = sql_fetch_array($getsites);
$total_sites = $result['amount'];

This way your not tranfering a huge recored set from DB to PHP but jst a single number.

And then this code

if($show == "cool"){ 

$result = mysql_query(" hits_in"); 
while ($row = mysql_fetch_array($result)) { 
$id = $row["id"]; 
// HERE CATEGORIES NAME 
$www = mysql_query("select * $tb_links.ID as site_id"); 
while ($web = mysql_fetch_array($www)) { 
$wid = $row["id"]; 
// HERE CATEGORIES INCLUDED 

$sql .= "hits_in "; 
} 

I don't understand what is you try to do:

1) mysql_query(" hits_in");

How can that be a SQL statement?

2) while ($web = mysql_fetch_array($www)) {
$wid = $row["id"];

You itterate over a record set but always overwrite $wid same with $id??

😕

Try to be more specific in your question and give some explenation with your code 'cause i don't understand halve of what you ar doing

[meno]

for reply
but i can't understand you

can i get help??

[Yamakazi]

Meno where ya from. Wich country? Try to ask the question in your own language. If i can, i'll reply in that language.