SQL problem - table names as variables

•

•

•

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 391,616 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,679 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser:

SQL problem - table names as variables

•

•

Join Date: May 2006

Posts: 8

Reputation: clarkeyboy is an unknown quantity at this point

clarkeyboy is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

clarkeyboy clarkeyboy is offline

clarkeyboy is offline

Offline

Newbie Poster

SQL problem - table names as variables

#1

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

(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')");
		}
	}
}

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?

Reply With Quote

Forum Highlights

Related Features

DANIWEB FEATURE INDEX

Advertisement

Statistics

Members: 391,616

Users Online Now: 2,679

Active IRC Users: 18

Forum Threads: 127,959

Forum Posts: 657,653

Code Snippets: 877

Blogs: 144

Blog Entries: 2,056

Directory Links: 562