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!

Hi all-

I was wonder is it possible to update figure from an SQL BD using php WITHOUT refreshing the page. So the number automatically change whenever they are altered on the SLQ DB
IF so where can I learn more about it?
Also can I be given Simple samples of these proposed ideas

I want to create this website asap- it is a client s project. They have given us 5 days and it is not possible for me to learn PHP- MySql or other languages in 5 days and create the website too. So- I am looking for some ready-to-install php codes. Client s server configuration is - Linux- Apache- PHP- cPanel