[SOLVED] parse error, unexpected T_STRING

[kev wood]

i am getting this error now and cannot work out the problem it says my error is on line 24 which is this line of code

 

mysql_query($sql) or die (mysql_error() mysql_errno());

 

the code which comes before this is as follows

 

$sql="CREATE TABLE IF NOT EXISTS `merc_users` (

		`****` int not null,
		`******` varchar (250) not null,
		`*****` varchar(250) not null,
		`******` varchar(250) not null,
		`*****` varchar(250) not null,
		`******` varchar (250) not null,
		`*******` varchar(250) not null,
		`****` varchar(250) not null,
		`****` varchar(250) not null,
		`******` varchar (250) not null,
		`********` varchar(250) not null,
		`******` varchar(250) not null
	)";	
	mysql_query($sql) or die (mysql_error() mysql_errno()); (line 24)

 

i cannot see any errors myself but i could be wrong

[Zwiter]

<?php
mysql_query($sql) or die (mysql_error() . mysql_errno());// <-- a dot : you need to concatenate

[kev wood]

even with that it still gives the error.

[Zwiter]

with the dot, the request worked perfectly (add merc_users).

 

Without the dot :

Parse error: syntax error, unexpected T_STRING in test.php on line 56

 

The dot is the key, or you have another erreur :

• you cannot connect to mysql
  
• you dont have selected a databse before trying to create a new table
  

 

 

Z.

[kev wood]

the error i was getting after that was could not connect to the database.  i have fixed it now i just had to delete the other db from off the server and start over it work in the end.  thanks for your help.