$result=mysql_query("SELECT name - url -(max(views) as \"topview\") FROM runevids");
while($row = mysql_fetch_array($result)){
echo $row[ name ];
echo $row[ url ];
echo $row[ topview ];
}

But if i only put this it works but i need the name and url :(
SELECT max(views) as \"topview\" FROM runevids

Help please
Thank you both of you.... both your code works so i pick the first 1 :) Thanks

http://www.runescapegod.com
A runescape help site and more

Hai friends-
i have this japanies charactors 竜野
i want to store this charactos in a MySQL database. probably you one of have a mysql db i hope.
can you pls tell me the name of the charactor set / Collation you use to store this type of charactors?

Agent matter. pls.
thanks and ill check that.

So i was wondering what parts of the script i need to change to allow scripts to run on a server using safe mode. Is there like certain variables or something? I ve tried so many scripts that use MySQL and PHP and they don t work!

Please help!

Thank you!

i have one column in a table that is a URL- like http://www.yahoo.com- http://www.google.com etc. When i pull the table in HTML format from MySQL- the links are not really links. That is- you cannot click on them and go to the corresponding websites. How can i modify my code so that when the table is processed- the URLs become links that allow for clicking? you could of course just copy and paste every URL- but that isnt efficient when you have so many.
here is the code:

<?php

$dbhost = "myhost";
$dbuser = $_POST[ username ];
$dbpass = $_POST[ password ];
$dbname = "myDatabase";

$db = mysql_connect($dbhost- $dbuser- $dbpass)
Or die(mysql_error());
echo "<p>Welcome to my Database.</p>";
mysql_select_db($dbname);
$query = "select column1- column2- URLs from myTable";
$result = mysql_query($query);

echo "<table width= 100% border= 1 cellpadding= 5 ><tr>";
echo "<th align= left >column1</th><th align= left >column2</th><th align= left >URLs</th></tr>";
while($row = mysql_fetch_row($result)) {
echo "<tr><td>".$row[0]."</td>";
echo "<td>".$row[1]."</td>";
echo "<td>".$row[2]."</td></tr>";
}
echo "</table>";

mysql_close($db);

?>
guys thanks a lot for reply- rainof yes you got the problem right- I tried dave s code but it appears that i got mixed up with the ""- just couldnt put my finger on it. Could someone be kind enough to re-write the last bit- i.e. echo "<td><a href=\"".$row[2]."\">".$row[2]."</a></td...- for me?. Thank you so much- just couldnt find where to properly put those "":-).

I need to store few Japanies charactors in my mysql table.
i.e. 焼尻
now i am not sure which of the following Collation / Charactor_seto to select in the table for above Japan charactors.

Sjis
sjis_Bin
sjis_apanese_ci

or

Ujis
ujis_Bin
Ujis_japanies_ci

Please help.
raino-
thanks and i am also looking in google.

I want to be constructive with my time this summer and learn how to do something with languages. I was thinking of learning a little bit of C++ or Java- but the idea of web design and designing my own little blog as a summer project are fascinating.

Questions:
-If I was to design a good- interactive blog (people leaving comments and all that)- what languages would I have to learn besides basic HTML?
-Someday- I hope to create a database/community. Kind of like the way IMDb.com works (forum- hundreds of thousands of movies- a rating system- movie reviews- etc.-.) what would I have to learn before creating something of that magnitude?
-If I chose to learn Java or C++ this summer- would that help me in web design at all?
-Can someone explain to me what exactly CSS- PHP- MySQL- CMS do? I ve tried to look it up- but all I get are all of these really technical terms that are hard for someone like me to understand.

Thanks!