Re: Query Error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



From: "Robert Sossomon" <robert@xxxxxxxxxxxx>


> The errors as it prints are:
>
> The query I just ran was: select * from GCN_items where `item_num` =
> '%fm-a294%'
> The query I just ran was: Resource id #2
> 0

Those aren't errors; it's just what you asked the script to display. Your
query simply isn't returning any rows.

You should be using LIKE instead of the equal sign, since I assume you're
looking for a pattern.

select * from GCN_items where `item_num` LIKE '%fm-a294%'

otherwise you're looking for the literal string "%fm-a294%"

---John Holmes...

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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux