List:General Discussion« Previous MessageNext Message »
From:Marty Smith Date:June 9 2004 6:47pm
Subject:Not getting matching records
View as plain text  
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
the statement:

 

"Select * from STUDENTS WHERE FName LIKE '%" .$_REQUEST['searchit']. "%' OR
LName LIKE '%" .$_REQUEST['searchit']. "%' OR  idStudent LIKE '%"
.$_REQUEST['searchit']. "%'"

 

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.

 

Help :-)

 


Thread
Not getting matching recordsMarty Smith9 Jun
RE: Not getting matching recordsDean Urmson10 Jun
RE: Not getting matching recordsDean Urmson10 Jun
RE: Not getting matching recordsDean Urmson10 Jun
  • RE: Not getting matching recordsDean Urmson10 Jun