Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : A small problem guys about the syntax PLZ

[freeboy1]

Hi guys
i have a problem with a php script , i am trying to install it and it gives me this error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'eccaone_list' at line 1

check the link:
http://www.eccao.net/maillist/create.php


this is the creat.php file

<?php
include("connect.php");

$link = "eccaone_list";
$res = mysql_query($link) or die(mysql_error());

mysql_select_db("eccaone_list");

$link = "
CREATE TABLE `newsletters` (
`name` text NOT NULL,
`content` text NOT NULL,
`id` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1;";
$res = mysql_query($link) or die(mysql_error());

$link = "
CREATE TABLE `users` (
`name` varchar(50) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`date` text NOT NULL,
`status` text NOT NULL,
`unsubscribed` text NOT NULL,
`id` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1;";
$res = mysql_query($link) or die(mysql_error());

if ($res)
die("<p>Succesfully made database. Please delete this file for security reasons.</p>");
?>

[dollar]

Well the problem is that you are trying to run a query:

PHP Code:

$link = "eccaone_list";
$res = mysql_query($link) or die(mysql_error()); 


When I think you mean to run a mysql_connect

Maybe:

PHP Code:


// Connect to the database
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}

//Select the database
mysql_select_db("eccaone_list");

// Create a query
$q = "
CREATE TABLE `newsletters` (
`name` text NOT NULL,
`content` text NOT NULL,
`id` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1;";

//Run the query
$res = mysql_query($q) or die(mysql_error());

//Create another query
$q = "
CREATE TABLE `users` (
`name` varchar(50) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`date` text NOT NULL,
`status` text NOT NULL,
`unsubscribed` text NOT NULL,
`id` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1;";

//Run the second query
$res = mysql_query($q) or die(mysql_error());


if ($res)
die("<p>Succesfully made database. Please delete this file for security reasons.</p>"); 


[Burhan]

Just delete these two lines:

$link = "eccaone_list";
$res = mysql_query($link) or die(mysql_error());

And it should work.