MS SQL

SQL problem - table names as variables

Please support our MS SQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: May 2006

Posts: 8

Reputation: clarkeyboy is an unknown quantity at this point

Solved Threads: 0

clarkeyboy clarkeyboy is offline

Offline

Newbie Poster

SQL problem - table names as variables

May 19th, 2006

Hi,

I have a slight problem. I am trying to create a mail service for a new game which I have started creating recently. Each user that registers also creates a table for their mail. As the usernames are variable and the table name is the username, I need to insert messages, subjects and "froms" into this variable table.

I am using the following code:

 Help with Code Tags 
 MS SQL Syntax (Toggle Plain Text) 
$to = $_SESSION["to"];
$subject = $_SESSION["subject"];
$message = $_SESSION["message"];
$from = $_SESSION["username"];
echo "To: $to<br>";
echo "Subject: $subject<br>";
echo "Message: $message<br>";
echo "From: $from<br>";
include 'connection.php';
IF ($to <> "") {
	IF ($subject <> "") {
		IF ($message <> "") {
			$rsusers = $conn->Execute("INSERT INTO $to (subject, message, from) VALUES('$subject', '$message', '$from')");
		}
	}
}
$to = $_SESSION["to"];
$subject = $_SESSION["subject"];
$message = $_SESSION["message"];
$from = $_SESSION["username"];
echo "To: $to<br>";
echo "Subject: $subject<br>";
echo "Message: $message<br>";
echo "From: $from<br>";
include 'connection.php';
if ($to <> "") {
	if ($subject <> "") {
		if ($message <> "") {
			$rsusers = $conn->Execute("INSERT INTO $to (subject, message, from) VALUES('$subject', '$message', '$from')");
		}
	}
}

The problem is that it will not accept $to as the table name - it just comes up with some nasty error about the syntax of my insert statement. Can anyone help me on this, please?

•

Join Date: Jul 2005

Posts: 483

Reputation: campkev is an unknown quantity at this point

Solved Threads: 19

campkev

Offline

Posting Pro in Training

Re: SQL problem - table names as variables

May 19th, 2006

if you are using sql server, try running profiler to make sure that your php page is actually sending the script correctly

•

Join Date: May 2006

Posts: 8

Reputation: clarkeyboy is an unknown quantity at this point

Solved Threads: 0

clarkeyboy clarkeyboy is offline

Offline

Newbie Poster

Re: SQL problem - table names as variables

May 19th, 2006

•

Originally Posted by campkev

if you are using sql server, try running profiler to make sure that your php page is actually sending the script correctly

I don't know what a profiler is - could you explain how to run it please? Also, I MAY have just figured out what it is that is wrong as it has happened on a couple of pages now. I am accessing several tables at the same time (or at least trying to). Is it possible to extract data or insert data into several tables at the same time or do you have to close one before opening another one?

RC

•

Join Date: Jul 2005

Posts: 483

Reputation: campkev is an unknown quantity at this point

Solved Threads: 19

campkev

Offline

Posting Pro in Training

Re: SQL problem - table names as variables

May 19th, 2006

look under start>programs>microsoft sql server>profiler

yes you can extract data from more than one table at a time but I don't know of anyway to insert into more than one table at a time

•

Join Date: May 2006

Posts: 8

Reputation: clarkeyboy is an unknown quantity at this point

Solved Threads: 0

clarkeyboy clarkeyboy is offline

Offline

Newbie Poster

Re: SQL problem - table names as variables

May 19th, 2006

I am not exactly trying to insert into more that one table at ONE time - I didn't exactly make that clear. I am using several SQL statements in a row to insert into several tables.

•

Join Date: Jul 2005

Posts: 483

Reputation: campkev is an unknown quantity at this point

Solved Threads: 19

campkev

Offline

Posting Pro in Training

Re: SQL problem - table names as variables

May 19th, 2006

that should be fine. Did you get profiler to work?

•

Join Date: May 2006

Posts: 8

Reputation: clarkeyboy is an unknown quantity at this point

Solved Threads: 0

clarkeyboy clarkeyboy is offline

Offline

Newbie Poster

Re: SQL problem - table names as variables

May 19th, 2006

No, I couldn't find it - I am using Dreamweaver for all my webpages and just use SQL code by reading out of a book or searching on the internet.

The error it comes up with is as follows:

Fatal error: Uncaught exception 'com_exception' with message 'Source: Microsoft OLE DB Provider for ODBC Drivers
Description: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.' in D:\Websites\ClarkeyBoy\wwwroot\gametrialversion\sendmail.php:76 Stack trace: #0 {main} thrown in D:\Websites\ClarkeyBoy\wwwroot\gametrialversion\sendmail.php on line 76

I have been trying to find a solution all evening but have got nowhere.

I have sort of managed to fix it - but now, whenever I go to the view mail page I get the following error:

CGI Error
The specified CGI application misbehaved by not returning a complete set of HTTP headers.