Has anyone seen a post on this issue? If not, can anyone offer any advice?
I have a TBL of users and I have created a search screen where you can type
in first or last name and it will retrieve the appropriate records. Here is
"Select * from STUDENTS WHERE FName LIKE '%" .$_REQUEST['searchit']. "%' OR
LName LIKE '%" .$_REQUEST['searchit']. "%' OR idStudent LIKE '%"
The statement works great for the most part. However, it is a bit sporadic.
For example, I type in my name (because I know I am in the DB and it will
NOT pull back any results. I even ran this command from the UNIX box
directly and it will not work.
So I have another page which pulls ALL records from another TBL and joins
the USER TBL and I AM LISTED!! Here is the statement for that page:
"Select * FROM CAMPREG INNER JOIN STUDENTS on STUDENTS.idStudent =
CAMPREG.idStudent ORDER BY LName;"
Again, the first one will NOT retrieve my name..the second one will list me
in the master list.