•
•
•
•
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 374,021 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,736 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.
Please support our MS SQL advertiser:
Views: 5059 | Replies: 7
 |
•
•
Join Date: May 2006
Posts: 8
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
SQL problem - table names as variables 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:
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?
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:
$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
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 3
Solved Threads: 19
Posting Pro in Training
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:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
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
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 3
Solved Threads: 19
Posting Pro in Training
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
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:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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
Location: Dallas, TX
Posts: 481
Reputation:
Rep Power: 3
Solved Threads: 19
Posting Pro in Training
that should be fine. Did you get profiler to work?
•
•
Join Date: May 2006
Posts: 8
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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.
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.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
Other Threads in the MS SQL Forum
- Previous Thread: finding a matches recursively
- Next Thread: chicken and egg problem
