MySQL Query - Result Table Name

Question

When I query a mysql database in PHP, I can not figure out how to specify the table of the field in the result set.

For example, I would like to do the following:

$row = mysql_fetch_assoc($result);

$row["table.FIELD"];

But, can not figure out how. Surely, it is able to happen somehow.

EDIT: I have checked documentation, and have found nothing. I am not sure if I was understood at first... I know how to get the value of a field in a row from a result set. But, I would like to be able to get the value of a field in a row by specifying the name of the table in front of that field.

$row["FIELD"]; vs $row["table.FIELD"];

From the above line, I would like to do the latter.

Thanks,

Steve

Itay Moav -Malimovka · Accepted Answer · 2010-01-21 02:23:09Z

2

You get it as $row[field_name],
And if you have two fields with same name but from different tables, You must add at least to one of them table.field AS somthing_else

SELECT t1.id,t2.id AS 't2_id' ....
...
...
var_dump($row);

will give $row['id'],$row['t2_id']

While if you don't use the AS you will get only $row['id'] (one value was lost).

answered Jan 21, 2010 at 2:23

Itay Moav -Malimovka

53.8k68 gold badges198 silver badges292 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ksofa2 · Accepted Answer · 2010-01-21 02:17:33Z

1

It's most likely in $row['FIELD'], depending on how you structured your SQL statement.

Try print_r( $row ) to see everything that's in the array.

answered Jan 21, 2010 at 2:17

ksofa2

742 bronze badges

Comments

Alix Axel · Accepted Answer · 2010-01-21 02:17:45Z

-1

The documentation explains how to do what you want, check the examples.

answered Jan 21, 2010 at 2:17

Alix Axel

155k100 gold badges406 silver badges509 bronze badges

1 Comment

jpeltoniemi Over a year ago

RTFM is rarely a good answer to a question this specific. The OP was asking if there is a native way to include table names in results in order to avoid collisions with names from joined tables. The answer is: there is regrettably no native way - use aliases.

Collectives™ on Stack Overflow

MySQL Query - Result Table Name

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related