[PHP-DB] RE: [PHP-WIN] Re: PHP Search DB Table

2010-12-14 Thread Oliver Kennedy
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

[PHP-DB] RE: [PHP-WIN] Re: PHP Search DB Table

2010-12-14 Thread Oliver Kennedy
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

[PHP-DB] PHP Search DB Table

2010-12-14 Thread Oliver Kennedy
Hello Everyone Apologies if I have not done this in the correct way, this is the first time I have turned to your for help so I am unaware if I have to submit this according to a certain protocol, if that is the case then please let me know and I will go through the proper channels. My probl