Re: [PHP-DB] Problem with PDO exceptions

2009-03-07 Thread Kesavan Rengarajan
I think it is a bug. I have seen this happening at work (PDO not throwing exception when executing a query on a non existing table) News on iPhone: http://trk7.com/mob On 08/03/2009, at 6:44 AM, Daniel Carrera wrote: Hello, I have MySQL 5.1 and PHP 5.2. For some reason PDO is not throwi

Re: [PHP-DB] PDO and PostgreSQL - RAISE NOTICE

2009-10-04 Thread Kesavan Rengarajan
Hi, Query returns an iterable object (thanks to the comments in the php site) and that's why when you do a dump you just see the String, If you just want to get one row from the resultset you can get it like this: $stat = $sql->query('SELECT * FROM public.test_info()')->fetch(); More informa

Re: [PHP-DB] Re: Search function query

2009-11-01 Thread Kesavan Rengarajan
Please have a look at this page: http://imysql.cn/docs/MySQL_51_en/ch12s07.html . Hope that is helpful. Sent from my iPhone On 02/11/2009, at 1:45 AM, Ron Piggott wrote: I have found the concept I am looking for on the mySQL web site: SELECT MATCH('Content') AGAINST ('keyword1 keyword2'

Re: [PHP-DB] Re: Search function query

2009-11-01 Thread Kesavan Rengarajan
iption` , `keywords` ) AGAINST ( 'postcard' ) AS Relevance FROM store_product_profile WHERE MATCH ( `product_name` , `product_description` , `keywords` ) AGAINST ( 'postcard' IN BOOLEAN MODE ) HAVING Relevance > 0.2 ORDER BY Relevance DESC -Original Message- From: Kesav

Re: [PHP-DB] Re: Search function query

2009-11-01 Thread Kesavan Rengarajan
e: Yes. All the search results have a '0' relevance result. When I created the FULLTEXT index I made all three fields one index with the keyname "customer_search" --- is my query wrong, should I be using 'customer_search'? Ron -Original M

Re: [PHP-DB] unlink problems

2009-11-25 Thread Kesavan Rengarajan
Looks like the PDF is not in the admin directory. Try to use the full path to the PDF file and also check the permissions on the file. Sent from my iPhone On 25/11/2009, at 9:22 PM, Neil Jackson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I use the following to delete a file o

Re: [PHP-DB] How to use PHP to fill in existing pdf document

2010-05-01 Thread Kesavan Rengarajan
Search for pdflib or fpdf. They help you with generating PDF files from a php script. Sent from my iPhone On 02/05/2010, at 7:28 AM, listread wrote: Yes, we can first ask the user to fill in a form, but then comes the part I don't understand - how to covert it to pdf. It would be best if

Re: [PHP-DB] how to upgrade php in linux

2010-05-03 Thread Kesavan Rengarajan
Add DAG and RPMForge repos (google for how to) and try to do a yum install.Compiling from source might not be the best option if you are new to Linux. Sent from my iPhone On 03/05/2010, at 10:57 PM, Chaitanya Yanamadala > wrote: hai david the rpm available is for this is the one which i

Re: [PHP-DB] how to upgrade php in linux

2010-05-04 Thread Kesavan Rengarajan
As someone else mentioned in the list, try the remi repository. If you still want to compile from source, then this is what you do to search for packages: yum search packagename So you would be doing: yum search gcc and then install the missing package before compiling php. You may have to

Re: [PHP-DB] Need help with HTML form errors

2010-07-04 Thread Kesavan Rengarajan
Hi, Those are notices not warnings(meaning they can be ignored sometimes, search for error_reporting in the PHP manual). In your example, if you do not wish ignore the notices, then initialize the different variables to some value. Sent from my iPhone On 04/07/2010, at 6:30 PM, nagendra p

Re: [PHP-DB] Re: LEFT JOIN query help

2010-07-18 Thread Kesavan Rengarajan
Change 'NOT LIKE' to 'NOT IN' in the outer query. Sent from my iPhone On 19/07/2010, at 4:15 AM, "Ron Piggott" wrote: > > I am still working on this query and wondering if I should be taking a > different approach --- to use a sub query to figure out which questions > have been answered and th