creating database

[abhi201090]

Please tell me what is wrong with this code and how to correct it?

i am not able to create database with this code

 

<?php

mysql_connect('localhost','root','password');

$name="xyz";

$create="CREATE DATABASE '$name'";

mysql_query($create) or die(mysql_error());

mysql_close();

?>

 

 

[attachment deleted by admin]

[Mchl]

Do you get any errors?

[abhi201090]

yes....i am getting mysql syntax error

[phpchamps]

change this line

 

$create="CREATE DATABASE '$name'";

 

to

 

$create="CREATE DATABASE ".$name;

[Mchl]

yes....i am getting mysql syntax error

 

For future reference: when someone asks you about error message, give them full error message.

What phpchamps proposes should work. Or even:

$create="CREATE DATABASE $name";

[abhi201090]

it worked thanks