Jump to content

Archived

This topic is now archived and is closed to further replies.

deciblelovechild

I need to use a variable for the table name in a sql query

Recommended Posts

hi i need some help with this,

 

i\'ve done some research on this and the only thing i came up with is that dynamic sql is the only way to use a variable for table name. Is this true??? If so, how would you do that with the following code?

 

$db = $_SESSION[\'User\'];

$db = $db . \"_buddies\";

 

$online_query = \"select buddy_name from $db WHERE online= \'n\'\";

 

any help is truly appreciated. thanks in advance....

 

dlc

Share this post


Link to post
Share on other sites

That will work.. or you can do it the dirty way:

[php:1:a9971eb821]$online_query = \"select buddy_name from \".$HTTP_SESSION_VARS[\'User\'].\"_buddies WHERE online= \'n\'\";[/php:1:a9971eb821]

 

Hope that helps.

Share this post


Link to post
Share on other sites

i copied and pasted your code and it returns the same error i have been getting all along:

 

Supplied argument is not a valid MySQL result resource

 

i read somewhere it is only possible using dynamic sql... do you know if this is true?????

Share this post


Link to post
Share on other sites

is there any information in the database to gather? ad hoc that query.

Share this post


Link to post
Share on other sites

yes i\'m sure we all have used a variable in a query.. nothing fancy.

 

see if there\'s an error in the query:[php:1:1527049cfd]$online_query = \"select buddy_name from \".$HTTP_SESSION_VARS[\'User\'].\"_buddies WHERE online= \'n\'\";

mysql_query($online_query) or die(\"Error : query failed.<br>MySQL said: <i>\".mysql_error().\"</i><br>rn\");[/php:1:1527049cfd]

 

hope that helps.

Share this post


Link to post
Share on other sites

also echo $online_query out and see if it is was you are expecting.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.