[how do i transfer db between two locations?]

i need to use my db at two different locales. My ftp software doesn\'t let me upload the mysql db\'s. is there away that i can transfer the db\'s between the two places? thanks

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

yea the query works fine. just not when i use a variable as a tablename. have you ever used a variable as a tablename before???

 

thx

dlc

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

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?????

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

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