how do I use mysql??? HELP!!!!

I'm trying to write a small forum script
How do I creat mysql tables on a remotely hosted server? does the administrator have to do this? or is it done in a php script?

To administer mysql I use telnet (or TerraTerm) to get to the Linux command line
and then type mysql <name of your database>
that brings me to the command line interface
where I can issue commands to mysql.

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by carp:
I'm trying to write a small forum script
How do I creat mysql tables on a remotely hosted server? does the administrator have to do this? or is it done in a php script?[/quote]

You can also do it through PHP. Like this:

<?

mysql_connect(localhost, user, pass);
@mysql_select_db(your_db);

$query = "
CREATE TABLE news (
date VARCHAR(22),
title VARCHAR(100),
body TEXT
id INT
)
";

$result = mysql_query($query);

if($result) {

print "Table inserted";

}

else {

print "Table not inserted";

}

mysql_close();

?>

Get phpMyAdmin, at http://www.phpwizard.com, for the easiest way to administer MySQL.