resultset and two tables in sql query

bender

Is possible to read variable using table.fieldName like in example?

example query: SELECT table1.*, table2.* FROM teble1, table2 WHERE
table1.id = table2.id;

$rs = $this->dbc->query($sql->createSelect());
while($row=$rs->fetch_array()){
$retVal[]=$row[table.fieldName] // doesnt work, $row[fieldName] //does
work
}

michael@greenquery.com

Hi,

Yes you can get the tablename from any table even without writing the
SQL.

$sql = "select * from tablea a1,tableb b1 where b1.id = a1.id";
$result = mysql_query($sql);

//read meta data
for ($i=0;$i<mysql_num_fields($result);$i++){
$field = mysql_fetch_field($result,$i);
$meta[$field->name] = $field->table;
}

// now loop throw the resultset like you normally do.
now you can check the column name in your meta data to get the table
name.

var_dump($meta);

I hope this helps you
//Michael

On 3 Dec., 21:23, bender <> wrote:
> Is possible to read variable using table.fieldName like in example?
>
> example query: SELECT table1.*, table2.* FROM teble1, table2 WHERE
> table1.id = table2.id;
>
> $rs = $this->dbc->query($sql->createSelect());
> while($row=$rs->fetch_array()){
> $retVal[]=$row[table.fieldName] // doesnt work, $row[fieldName] //does
> work
>
> }

michael@greenquery.com

Hi,

Yes you can get the tablename from any table even without writing the
SQL.

$sql = "select * from tablea a1,tableb b1 where b1.id = a1.id";
$result = mysql_query($sql);

//read meta data
for ($i=0;$i<mysql_num_fields($result);$i++){
$field = mysql_fetch_field($result,$i);
$meta[$field->name] = $field->table;
}

// now loop throw the resultset like you normally do.
now you can check the column name in your meta data to get the table
name.

var_dump($meta);

I hope this helps you
//Michael

On 3 Dec., 21:23, bender <> wrote:
> Is possible to read variable using table.fieldName like in example?
>
> example query: SELECT table1.*, table2.* FROM teble1, table2 WHERE
> table1.id = table2.id;
>
> $rs = $this->dbc->query($sql->createSelect());
> while($row=$rs->fetch_array()){
> $retVal[]=$row[table.fieldName] // doesnt work, $row[fieldName] //does
> work
>
> }

michael@greenquery.com

Hi,

Yes you can get the tablename from any table even without writing the
SQL.

$sql = "select * from tablea a1,tableb b1 where b1.id = a1.id";
$result = mysql_query($sql);

//read meta data
for ($i=0;$i<mysql_num_fields($result);$i++){
$field = mysql_fetch_field($result,$i);
$meta[$field->name] = $field->table;
}

// now loop throw the resultset like you normally do.
now you can check the column name in your meta data to get the table
name.

var_dump($meta);

I hope this helps you
//Michael

On 3 Dec., 21:23, bender <> wrote:
> Is possible to read variable using table.fieldName like in example?
>
> example query: SELECT table1.*, table2.* FROM teble1, table2 WHERE
> table1.id = table2.id;
>
> $rs = $this->dbc->query($sql->createSelect());
> while($row=$rs->fetch_array()){
> $retVal[]=$row[table.fieldName] // doesnt work, $row[fieldName] //does
> work
>
> }

michael@greenquery.com

Hi,

Yes you can get the tablename from any table even without writing the
SQL.

$sql = "select * from tablea a1,tableb b1 where b1.id = a1.id";
$result = mysql_query($sql);

//read meta data
for ($i=0;$i<mysql_num_fields($result);$i++){
$field = mysql_fetch_field($result,$i);
$meta[$field->name] = $field->table;
}

// now loop throw the resultset like you normally do.
now you can check the column name in your meta data to get the table
name.

var_dump($meta);

I hope this helps you
//Michael

On 3 Dec., 21:23, bender <> wrote:
> Is possible to read variable using table.fieldName like in example?
>
> example query: SELECT table1.*, table2.* FROM teble1, table2 WHERE
> table1.id = table2.id;
>
> $rs = $this->dbc->query($sql->createSelect());
> while($row=$rs->fetch_array()){
> $retVal[]=$row[table.fieldName] // doesnt work, $row[fieldName] //does
> work
>
> }

michael@greenquery.com

Hi,

Yes you can get the tablename from any table even without writing the
SQL.

$sql = "select * from tablea a1,tableb b1 where b1.id = a1.id";
$result = mysql_query($sql);

//read meta data
for ($i=0;$i<mysql_num_fields($result);$i++){
$field = mysql_fetch_field($result,$i);
$meta[$field->name] = $field->table;
}

// now loop throw the resultset like you normally do.
now you can check the column name in your meta data to get the table
name.

var_dump($meta);

I hope this helps you
//Michael

On 3 Dec., 21:23, bender <> wrote:
> Is possible to read variable using table.fieldName like in example?
>
> example query: SELECT table1.*, table2.* FROM teble1, table2 WHERE
> table1.id = table2.id;
>
> $rs = $this->dbc->query($sql->createSelect());
> while($row=$rs->fetch_array()){
> $retVal[]=$row[table.fieldName] // doesnt work, $row[fieldName] //does
> work
>
> }