error

[aleucrazy]

Error:

Parse error: syntax error, unexpected T_STRING in /home/vhosts/democlick.freeoda.com/install_clickz.php on line 14

<?php
// TREBUIE SETATA CONEXIUNEA IN CONFIG.PHP SI CONNECTION.PHP !!!
include('connection.php');


$conexiune=mysql_connect($host, $username, $password)
or die ("eroare !");

$bazadate=mysql_select_db($db_name, $conexiune)
or die ("eroare !");

$table="

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `admins`
--

CREATE TABLE IF NOT EXISTS `admins` (
  `id` int(4) NOT NULL auto_increment,
  `username` varchar(65) NOT NULL default '',
  `password` varchar(65) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Salvarea datelor din tabel `admins`
--

INSERT INTO `admins` (`id`, `username`, `password`) VALUES
(1, 'admin', 'parola');


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(255) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `clickz` int(11) NOT NULL,
  `date` varchar(255) NOT NULL,
  `ip` text NOT NULL,
  `status` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Salvarea datelor din tabel `users`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `votes`
--

CREATE TABLE IF NOT EXISTS `votes` (
  `votefor` text NOT NULL,
  `ip` text NOT NULL,
  `date` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Salvarea datelor din tabel `votes`
--



";
if(mysql_query($table)){
echo "<center><font color='green' face='Comic Sans Ms'><br><br><br><b>Instalarea a avut succes!</b></font></center>";
}
else{
echo "<center><font color='red' face='Comic Sans Ms'><br><br><br><b>Instalarea a esuat!</b></font></center>";
} 
?>

tnx XD

[ZibingsCoder]

Line 14 appears to be the line with 'SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";' The reason you're getting the error is because you can't have unescaped double quotes inside your string that is enclosed with double quotes.

For a better way of doing multi-line complex string, read up on heredoc.

[aleucrazy]

what can i do?

[dagon]

change the doubles(") to singles (')

[bradgrafelman]

dagon's answer is best, since strings in SQL should be delimited by single quotes (since double quotes can be used in place of backticks, meaning the are used to denote identifiers and not strings).

Another option would be to escape the unescaped quotes; see the PHP manual for what a [man]string[/man] is and how to handle single/double quotes inside of strings.