Little problem creating databases
Posted by: Dristrillo (---.95.150.115.cableonline.com.mx)
Date: May 04, 2006 07:58AM

<html>
<head>
<title>Autos</title>
</head>
<body>
<?PHP
$link = mysql_connect("localhost", "root", "passx"winking smiley or die ("Error en la conexion"winking smiley;
$lista_bd=mysql_list_dbs($link);
while($i= mysql_fetch_object($lista_bd))

{
if($i-> Database == 'autos')
{
echo 'Ya existe la base de datos.';
exit; }
}

$dbname = 'CREATE DATABASE' .$prueba;
mysql_query($dbname);
mysql_select_db("Autos",$link);
//$crear_db =mysql_create_db("Autos"winking smiley or die ("Error al crear la base de datos"winking smiley;
?>
</body>
</html>
What is wrong.???.
with
$crear_db =mysql_create_db("Autos"winking smiley or die ("Error al crear la base de datos"winking smiley;
This error
Fatal error: Call to undefined function mysql_create_db() in C:\wamp\www\Prueba\1base.php on line 21
With
$dbname = 'CREATE DATABASE' .$prueba;
mysql_query($dbname);
mysql_select_db("Autos",$link);
No errors, but don't create the database

Options: ReplyQuote
Re: Little problem creating databases
Posted by: CyberSpatium (---.hsd1.or.comcast.net)
Date: May 06, 2006 01:46PM

change
$crear_db =mysql_create_db("Autos"winking smiley or die ("Error al crear la base de datos"winking smiley;

to
$crear_db =mysql_create_db("Autos", $link) or die ("Error al crear la base de datos"winking smiley;


More Info
[us2.php.net]

Options: ReplyQuote


Sorry, only registered users may post in this forum.