> -----Original Message-----
> From: David Green [mailto:simp...@gmail.com]
> Sent: Tuesday, August 09, 2011 10:14 AM
> To: php-general@lists.php.net
> Subject: [PHP] Struggling with MySQL query
> 
> Hi
> 
> I have a simple from which uses the post method to get to my page
> script
> results.php
> 
> in results.php I have
> 
> $find=$_POST["find"]; //this works perfectly, echo $find gives me the
> search
> term as entered
> 
> I then connect to mysql and select the db successfully.
> 
> After that, I have the following:
> 
> $find = strtoupper($find);
> $find = strip_tags($find);
> $find = trim($find);
> 
> $data = mysql_query("SELECT * FROM news_items WHERE upper('headline')
> LIKE
> '%$find%'");
> 
> while($result = mysql_fetch_array($data)) { //etc
> 
> I get no error messages, but no results to work with either.  It
> returns a
> "no results" message that I put in further on in the script.  A casual
> look
> at the db shows that I should be getting results.  I'm pretty sure that
> the
> problem is in the query, but for the life of me I can't see the
> problem.
> 
> Kind regards
> David


Suggestion:

$query = "SELECT * FROM news_items WHERE UPPER(headline) LIKE
'%".mysql_real_escape_string($find)."%' ";
$result = mysql_query($query);

//Check your syntax display any errors.
Echo mysql_error();
Echo mysql_errno();

If(mysql_num_rows($result)>= 1) {
        While($row = mysql_fetch_assoc($result))
        {       
                print_r($row);
        }
}else{
Echo 'nothing to show';
}









-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to