PLEEEASE help with this!!! I will pay via paypal for help!

[m37h0d]

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''socom2' ORDER BY guest_id' at line 1

is the error im getting.

I'm using functions, and trying to select databases via a variable.

This is my select from database line...

 $select_data=("SELECT guest_id, console, clan_name, leaders_name, member_num, clan_plays, home_server, gb_id, clan_rank, first_name, last_name, age, email, email_confirm, aim, yahoo, msn, op_msg, username, password, password_confirm, date_time, guest_ip FROM '$gtbl' ORDER BY guest_id");
 $ver=mysql_query($select_data);

[dewen]

try replace '$gtbl' with {$gtbl}

also try split long query into

 
SELECT 
      x,
      y,
      ...
FROM 
      ....

it's ez for read

[Frederick]

1st, it looks as you are selecting all the fields in your table. You can shorten the query by just using * astic.

2nd, Break up your query at your table name location and call the variable value.

$sql = mysql_query("SELECT * FROM ".$gtbl." ORDER BY guest_id") or die (mysql_error());

[harlowhair]

Or just remove the quotation marks from around the $gtbl variable.....

[bodzan]

Why using ()'s when assigning a value in a variable?

Shouldn't just

$select_data="SELECT guest_id, console, clan_name, leaders_name, member_num, clan_plays, home_server, gb_id, clan_rank, first_name, last_name, age, email, email_confirm, aim, yahoo, msn, op_msg, username, password, password_confirm, date_time, guest_ip FROM '$gtbl' ORDER BY guest_id";

be enough?

And yes loose the ' around $gtbl...