Still no joy with WHERE clase

ginadee

Thank you liquid child but your suggestion gives no results!
If you have it working then perhpas you will give me a clue.

Is there anyone else who can help?

liquidchild

I have a userlogin table that contains the following fields:

username, password, lastlogin, privilege.

This table has three entries where there usernames are sgr, dwo and jsm.

On the command prompt if i perform the query:

SELECT * FROM userlogin WHERE username LIKE '%s%';

it returns the details for sgr and jsm - because of the %s% - make sure you have the ' ' if your field is a text field!

Try performing this query on the command prompt direct - if you are using MySql. See what happens then. If the field is of type number then let me know.

Hope this helps

ginadee

Liquid child
well I can do it from a direct query but my users fill in a form -and they may no know the full name so I am using the LIKE statement and that is where I am having the problems
The text box on the form is called "search" and this according to my MySQL manual is changed into a variable $search automatically by PHP when the form is processed, but it does not work with LIKE
If I put in a full name and use = '$search' it works.

But please keep trying I am grateful

liquidchild

I am not aware of php automatically making it a variable. Have you done the following, or tried the following:

$temp = $POST['search'];
$temp = $GET['search'];

Obviously you only use one or the other depending on how the form is being submitted. If you are using less than 4.1.0, you need to use HTTP_GET_VARS etc.

you would then use $temp in your query, and not search. But make sure you referenence it correctly. I.e using $this->temp
if required.

Try this,

Cheers

ginadee

Liquidchild
Yes PHP automatically makes a variable from a text box name.
So if your text box name is "usrlogin" PHP will make a variable on the fly when it parses the script.

Anyway here is the WHERE clause that works on arbitary text entered into a form

$resultID = mysql_query("SELECT name, contacts, details FROM pbfamembers WHERE name LIKE '%$search%'", $linkID);

$resultID is the variable name for the query and

$linkID is a declared variable which stores all my login information (host, userID, password etc)
name is the name of the column on which I am searching
search is the name of the text box into which the users type the search text (i.e. part of a name) in html that would appear as
<input type="text" name="search" size="50"> (it only works on certain types such as text and text area so don't use it everywhere)
When the submit button is clicked PHP parses the script and makes a variable $search
And it works! I know because I have just done it.
Thanks for your support and I hope the above helps you too.