Hi all,
I have to tables A and B.
They boyh have a column with the same name.
Now, I wrote this MySQL statement performing a left join.
This results in a data set with rows consisting of 2 columns of the same
name, in which the date is stored when the record was last altered. This
column is called "last_altered".
Later on in my script I'm calling the value of this column with php.
$query="select * from tblA LEFT JOIN ....";
$resultID=mysql_query($query);
while ($result_row=mysql_fetch_array($resultID))
{
echo "$result_row[column with the same name]";
}
Well, this works without any php or mysql errors, but it is giving me the
data back of that column wich I don't wanna have...It returns the
"last_altered" date of tblB in stead of tblA.
A solution might be te exclude the second column (the wrong one) from the
select statement in the query.
Anybody knows how this can be done?? Or are there other solutions?
thx
Wilbert Enserink
-------------------------
Pas de Deux
Van Mierisstraat 25
2526 NM Den Haag
tel 070 4450855
fax 070 4450852
http://www.pdd.nl
[EMAIL PROTECTED]
-------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
