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 ron.pigg...@actsministries.org 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

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

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] 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 dr.virus.in...@gmail.com wrote: hai david the rpm available is

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 listr...@cze.com 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

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 n...@webcoza.co.za wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I use the following

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 ron.pigg...@actsministries.org wrote: I have found the concept I am looking for on the mySQL web site: SELECT

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

2009-11-01 Thread Kesavan Rengarajan
` , `product_description` , `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: Kesavan Rengarajan k...@trk7.com

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

2009-11-01 Thread Kesavan Rengarajan
wrote: 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 Message- From: Kesavan Rengarajan k

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

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 daniel.carr...@theingots.org wrote: Hello, I have MySQL 5.1 and PHP 5.2. For