[SOLVED] Basic PHP Mysql problem

[sarathy_1116]

Hi all,

I am new to php. I am trying to create a table through php script in mysql server. This is is my code for creating the table

<?php
$link = mysqli_connect('localhost', 'root', '');
mysqli_query(link, query)

$sql = 'CREATE TABLE sample (  
     EMPID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,  
     FIRSTNAME TEXT,  
     LASTNAME TEXT  
   ) DEFAULT CHARACTER SET utf8';  
if (!mysqli_query($link, $sql))  
{  
$output = 'Error creating sample table: ' . mysqli_error($link);  
include 'output.html.php';  
exit();  
}  

$output = 'sample table successfully created.';  
include 'output.html.php';
?>

 

But the problem is am getting this error "Parse error: syntax error, unexpected T_VARIABLE"  in line 5.. Any help would be appreciated.

Thanks in advance..

[ram4nd]

<?php
$link = mysqli_connect('localhost', 'root', '');
mysqli_query(link, query)

$sql = 'CREATE TABLE sample ( 
     EMPID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, 
     FIRSTNAME TEXT, 
     LASTNAME TEXT 
   ) DEFAULT CHARACTER SET utf8'; 
if (!mysqli_query($sql)) 
{ 
$output = 'Error creating sample table: ' . mysqli_error($link); 
include 'output.html.php'; 
exit(); 
} 

$output = 'sample table successfully created.'; 
include 'output.html.php';
?>

[Zane]

your missing a semicolon after mysql_query

[sarathy_1116]

Thanks a lot ppl.  . thank u so much!!!