PHP and MySQL question

[ATLien]

I use a topsite script on my site and I wanted to beable to display the top 5 sites on other pages of my site. How could I do this? could some one give me a link or maybe make me a script that will connect to a database, then go into a specific table and look at a specific area of that table. The database i want to connect to is wiredATL_topsites, mtl_sites is the table, votes is the feild. What I want to do is call the 5 rows with the hightest #'s from the votes feild. then on the actual site I want to display what is in the "site_banner" and "site_url" feilds of those top five rows. is this possible? If so could someone maybe write me a script using **** for the server info. or maybe tell me how to do it. I some about php but not much. Thanks in advanced.

ATLien

[noahspop]

The Php should be something like this:

$db = mysql_connect ("localhost","user","password");
mysql_select_db ( "wiredATL_topsites");

$query = "select site_banner, site_url from mtl_sites order by votes DESC limt 5";

$res = mysql_query ( $query, $db );

This will do the actual collection of the data, then wherever you want to display it do:

while ( $row=mysql_fetch_object   ( $res ) ) {
     print "<a href=\"$row->site_url\">$row->site_banner</a>\n";
}

Hope that helps.

[ATLien]

hey thanks for the help but when i used that script I got this error:
Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/wirednig/public_html/include.php on line 10

can you tell me why it is doing that?

[noahspop]

It means the value of $res is incorrect. So either you have a problem in your db connection, ( the line $db=....) or in your query.

Try running the query manually in the shell.

[ATLien]

a shell?

[ATLien]

Problem solved I got it handled. thanks everyone for the imput