[SOLVED] table names for queries

[ShaolinF]

Hi Guys

 

Im trying to carry out an SQL statement using object oriented methods but am having some problems. See code below:

 

$field = $_GET['statment']; /*Specifies table name*/

 

$db->query("INSERT INTO $wpdb->$field ($query)VALUES ($query_data)");

 

The problem is with the $wpdb->$field - It doesn't work when I use the $field var. If I use a table name like posts in its place then the code will work. But what I want to do is specify the table name in the GET method and feed it into the $field variable. That way, I won't need to make several queries with the different tables to do this. Does anyone know how I can do this?

[Jabop]

<?php
$db->query("INSERT INTO ".$wpdb->$field." (".$query.")VALUES ('".$query_data."')");
?>

 

The variables need to be escaped.

[ShaolinF]

I tried that and it gave me an unexpected T_OBJECT_OPERATOR error.

[ShaolinF]

Never mind. I managed to fix it. I am getting a syntax error when trying to run an update query:

 

query("UPDATE " . $db->$field1 . "SET userlog = test WHERE ID = 4");

 

Anyone know where I could be going wrong?

[Jabop]

query("UPDATE " . $db->$field1 . "SET userlog = test WHERE ID = 4");

 

Is $db->$field1 a field or table?

There is no space between the $db->$field1 quotation and SET.

[.josh]

$db->field1