mysql_assoc_array( question.(probably very simple)
Posted: Thu Aug 11, 2005 8:35 am
ok, am building a little php app for uni (this probably seems like a very noobish question ,but I only started php about a month ago )
Problem is, I am selecting data from a mysql database, and the query left-joins two tables. now, I have the same column-name in each table (u_id). When i try to spit out the associated value of u_id after putting the query result into an associated array, it gives me the value of the second u_id and not the first, which is not what I want.
How do I tell the array to select the first u_id column and not the second?
thanks,
Henry
Problem is, I am selecting data from a mysql database, and the query left-joins two tables. now, I have the same column-name in each table (u_id). When i try to spit out the associated value of u_id after putting the query result into an associated array, it gives me the value of the second u_id and not the first, which is not what I want.
How do I tell the array to select the first u_id column and not the second?
thanks,
Henry