Hey,

Im stumped, i have tried everything and the nearest i can get is a ambiguity error message.

Basically, without pasting loads of code.

Page 1 get a ID to search for. This is sent to the next page in a function, lets call this function F1.

I want to display the contents of field ID, User of table Fault and field Status of table FaultAction, where ID = F1.

ID is the Pkey of both tables.

SELECT f.id, f.user, fa.`field status` FROM Fault AS f, FaultAction AS fa WHERE f.ID='$F1';

Or something like that? I suspect the ambiguity was over "ID", of which there were two: one in each table.

This is what i can deduct as the real code from what you said.... the problem i get is that if it doesn't actualyl do the filter search, it just displays all the records that are in the faultaction table, and changes (in the oputput) all the faultIDs to the searched criteria

So if i search for fault ID 12,
it will display all the records in the table (regardless of matching the criteria) and display the ID value as whatever number you searched for (stress stress pull hair out)

[the code]

("SELECT f.FaultID, f.ReporterUsername, f.FaultType, fa.Status FROM fault AS f, faultaction AS fa WHERE f.FaultID='".$frm_search."'") or die(mysql_error());


but at least it is looking in the second table

Do you have a table called 'fa'?

no, i have a table called faultaction where i was assigning the faultaction table the prefix fa.

anyway.. i have sorted that problem, but now i have another.

It combines the tables, but now it doesn't actually filter the search.

When u put say 31 in the search. It outputs all the records in the talbe (regardless whether they match the criteria or not) and also displays in the FaultID columm, 31 for every record.

He doesn't need to. I was suggesting aliasing each using AS.

Snipped: Well, should it be "WHERE fa.FaultID='".$frm_search."'", then? Which table are you trying to filter against? You see, my suggestion was to alias fault AS f and faultaction AS fa, so fa.FaultID is the FaultID field from "faultaction ", while f.FaultID is the FaultID from "fault".

Is that any clearer?
Dan

Snipped: Ah, right. I'm with you. Just select fa.FaultID instead. f.FaultID is going to be 31 in every case, since you actually stipulated that in your WHERE clause :).

Frustrating when it does exactly what you tell it to, instead of exactly what you mean, isn't it?