i am using mySQL, and am trying to search in to multiple tables and retrieve the data.
Problem is, how do i identify, that from which table the result is coming from?
I have tried using
mysql_tablename($result, $i)
where $result is the $result = mysql_db_query ..... blah .. (executes the select statement)
and $i is the loop increment within the FOR loop which gets the data from the db.
i.e. for ($i=0; $i<$num_of_rows; $i++) ....
but the mysql_tablename() for some reason is only giving me the 'ID' number of the data retrieved.. the auto_increment i have in my table.
