[SOLVED] Unexpected T_STRING

[Akenatehm]

Hey Guys,

 

Here's the error:

 

Parse error: syntax error, unexpected T_STRING in /home/kaurlcom/public_html/messenger/createtable.php on line 15

 

and the code:

 

<?php
include "connect.php";

$author=$_POST['author'];

$random=$_POST['random'];

$insert = "INSERT INTO `chatrooms` (author,time)
VALUES ($author,$random)";

$result= "SELECT `chat_id` FROM chatrooms where random = $random AND author = $author";

while($row = mysql_fetch_array($result))
  {
$create = "CREATE TABLE "chat_"'$result'""
(
username text,
message text
)";
  }
  
?>

[darkfreaks]

nevermind

[Akenatehm]

Ok...

[KrisNz]

What are you trying to do with this exactly?

 

 

[MatthewJ]

Your quotes are out of whack in the CREATE statement

[The Little Guy]

Try this buddy!

 

<?php
include "connect.php";

$author=$_POST['author'];

$random=$_POST['random'];

$insert = "INSERT INTO `chatrooms` (author,time)
VALUES ($author,$random)";

$result= "SELECT `chat_id` FROM chatrooms where random = $random AND author = $author";

while($row = mysql_fetch_array($result))
{
$create = "CREATE TABLE `chat_{$result}`
(
username text,
message text
)";
}
  
?>

[Akenatehm]

Thanks for your help again The Little Guy.