Okay, thank you all again for your input, I have tried a number of suggestions
to work out what is happening. Just to reiterate here is the search form which
is on a different page.
Search by Client ID
shown below is the datasearch.php page
';
echo $term . '';
$result = mysql_query($q
Oliver Kennedy wrote:
$query = "SELECT * FROM clients WHERE clientid = '%".$term"%'";
$query = "SELECT * FROM clients WHERE clientid = '%".$term."%'";
Note missing '.'
But that should be the same as
$query = "SELECT * FROM clients WHERE clientid LIKE '".$term."'";
--
Lester Caine - G8HFL
-
David, Sascha thank you both for your help. Using the query
$query = "SELECT * FROM clients WHERE clientid = '$term'";
echo $query . '';
$result = mysql_query($query);
as suggested printed out the below
SELECT * FROM clients WHERE clientid = ''
This seems to indicate that it is not seeing
David wrote:
>
> Oliver Kennedy wrote:
> > ...
> > I have a very simple database consisting of 1 table, I want users here
> to
> > be able to use a search function to query the database in order to
> return
> > the information on a client by a specific ID number if it is in the
> > database.
> > .