View Single Post
Old May 24th, 2004, 11:41 AM
sencee sencee is offline
Authorized User
Join Date: May 2004
Location: Blackpool, Lancashire, United Kingdom.
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to sencee Send a message via AIM to sencee Send a message via MSN to sencee Send a message via Yahoo to sencee

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