It would be easier and faster to convert your string to lower case, than
perform the upper operation on every entry in the database. Also, just to
point it out, your code is very vulnerable to SQL injection.
But the suggestion is right, dump the query to make sure its correct, and
check for mysql errors post query execution. Also num results its helpful :)
On Aug 9, 2011 10:22 AM, "Dajka Tamas" <viper@xxxxxxxxxxx> wrote:
> Why not trying this:
>
> $q = "SELECT * FROM news_items WHERE upper('headline') LIKE
'%".$find."%'";
>
> echo $q;
>
> $data = mysql_query($q);
> ...
>
> And try running the echoed query in phpmyadmin, etc.
>
> Cheers,
>
> Tamas
>
> -----Original Message-----
> From: David Green [mailto:simpill@xxxxxxxxx]
> Sent: Tuesday, August 09, 2011 4:14 PM
> To: php-general@xxxxxxxxxxxxx
> Subject: 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
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
