Complete noob question but....

porked

Can someone please tell me why this is not working?

<?php
$server = "localhost";
$user = "tjons";
$password = "g0at15";
$conn = mysql_connect($server, $user, $password)
or die ( "sorry - Could not connect to MySql" );

$rs1 = mysql_create_db( $_request['db'] );

$rs2 = mysql_list_dbs( $conn );
for( $row = 0; $row < mysql_num_rows( $rs2 ); $row++ )
{ $list .= mysql_tablename( $rs2, $row) . " | "; }
?>
<html>
<head>
<title>Create your database</title></head>
<body>
<form action = "<?php echo( $_server['php_self'] ); ?>
method="post">Current Databases: <?php echo( $list ); ?>
<hr>Name:<input type = "text" name = "db">
<input type = "submit" value = "create database">
</form>
</body>
</html>

I have a working php 5 and apache 2 MySql install but for some reason when i go to display this it's nothing but a blank page....

Thanks,
Porked

_RL_Ian

The first thing to do is to add some error handling to your script.

<?php
$link = mysql_connect("localhost", "mysql_user", "mysql_password");

mysql_select_db("nonexistentdb", $link);
echo mysql_errno($link) . ": " . mysql_error($link). "\n";

mysql_select_db("kossu", $link);
mysql_query("SELECT * FROM nonexistenttable", $link);
echo mysql_errno($link) . ": " . mysql_error($link) . "\n";
?>

By echoing the mysql_errno and mysql_error, you will get a plain text desciption if you are having any issues with your script.

Aside from that, I would check to make sure your user has privilages to create databases.