i have over 10-000 articles in a table and i want to organize them by alphabet- so i need to scan all the titles and figure out the first string to see if it should go under A-B-C... or not...
is there a way to do is easily?
THANKS

i m using yahoo web hosting. i need to connect to MySQL- which they support along PHP- using a third party application. it asks for:

host/server name (or IP):
username:
password:

i have emailed yahoo and i am sure they will reply (not sure when though). Butr just couldnt wait.

Does anyone know how to find out the above? thanks a lot.
candle- that was very nice of you. Well- i have done just that. What you said is just what i had done. But I keep getting the error message that it couldn t recognize or resolve host mysql. Bad luck- huh?:-)
aha "You will not be able to access your database using a desktop client or other tools run outside of Yahoo!" too bad.
hi rina- yes i did create the database which i can access with no problems. I am- however- using an aplication called PHPRunner which i wished to try. Yahoo couldnt allow me to connect. I can only connect from within the website. Odd- huh?

I am planning on a site (hopefully) expecting really high traffic. I know java/jsp/tomcat/mysql very well. Is there a good hosting with load balancing etc.. that can do this ? Or do I have to switch to LAMP or Python direction ?

My preference is to stick to Java/jsp/tomcat/mysql but will switch if I have to as we are in really early stages.

I am trying to make a mysql table. Could some one tell me how to do this?

I picked a bad host which has lots of problems(goes down alot) I found a better host which also has mysql and php and I want to move my forum but how do I change my sql username and password because it seems to be linked to the orignal one?
its a phpbb2 forum
I dont have a config.php?
I deleted config because it said too- is there a default one I can download and add to it?

$query=mysql_query("INSERT INTO watch_list( username - offence - punishment - offence_text )VALUES( $username - $offence - $punishment - $offence_text )");

Seems there are is a syntax errror with the above query.
<?php
$username= $_POST[ username ] ;
$offence = $_POST[ offence ] ;
$punishment=$_POST[ punishment ];
$offence_text=$_POST[ offence_text ];

$dbhost= localhost ;
$dbuser = root ;
$dbpass = a ;

$conn=mysql_connect($dbhost-$dbuser-$dbpass) or die( Sorry T- error! );

if ($conn){ echo Connected to MySQL ;}

mysql_select_db("offender_list")or die(mysql_error());

$query=mysql_query("INSERT INTO watch_list ( username - offence - punishment - offence_text )VALUES( $username - $offence - $punishment - $offence_text )");

if($query){echo "Your information has been successfully added to the database.";}
else {echo mysql_error();} // remove mysql_error() before final version is completed

?>

Thats it in full..

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near watch_list ( username - offence - punishment - offence_text )VALUES

Is the error message
$query=mysql_query("INSERT INTO watch_list ( username - offence - punishment - offence_text ) //

VALUES( $username - $offence - $punishment - $offence_text )");

Ive put the VALUES line onto a fresh line so you can see it.
VALUES( $username - $offence -

$punishment - $offence_text )");
VALUES( $username -

$offence -

‘$punishment’-

‘$offence_text )

");
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near mysql_query(INSERT INTO watch_list ( username - offence - punishment - offence_ at line 1