Re: [PHP-DB] Dates - Best Approach

If you are using unix-like OSes then you could write a program or a script using (PHP, perl, bash, csh even C) whatever it suits you and use cron daemon to run it every month. This script should query the database and find out if is needed to be sent. The alternative (not the suggested so

Re: [PHP-DB] pdo_mysql segfault error

Well this is not the proper list for these kind of questions but since you posted know that you should include the apache compile time options. Well I think that you should recompile apache, because mysql support is probably compiled in and since you upgraded mysql you should compile apache

Re: [PHP-DB] showing warnings

Hi i have added index on both columns but still same warning is issued by mysql then what i do now John Mertic <[EMAIL PROTECTED]> wrote: Is the table 'Mobile_Tunes' indexed at all? If not, you may want to consider adding one at least one 'Tune_Type' and another on 'Tune_Name'. Joh

Re: [PHP-DB] showing warnings

Hi i have added index on both columns but still same warning is issued by mysql then what i do now? BYE John Mertic <[EMAIL PROTECTED]> wrote: Is the table 'Mobile_Tunes' indexed at all? If not, you may want to consider adding one at least one 'Tune_Type

Re: [PHP-DB] showing warnings

Run the query through MySQL directly prepending EXPLAIN to the query and attach the results here. John On 9/10/07, Asim <[EMAIL PROTECTED]> wrote: > Hi > > i have added index on both columns but still same warning is issued by mysql > > then what i do now > > John Mertic <[EMAIL PROTECTED]> wrote

[PHP-DB] ? "SELECT TABLE" Command

Hi, I've got a PHP program I wrote a year or so ago with the oddest line of code. I know I didn't come up with it myself; I must have adapted it from a book or something, but I have checked all the books it could have come from and could not find it in any of them, nor can I find any such command

[PHP-DB] mssql_connect not working from command line

I had cronjobs running fine on Linux which included a file which called mssql_connect. Today when I run the cronjob script directly from the command line, I get: PHP Fatal error: Call to undefined function mssql_connect() in /the/included/file.php on line # Fatal error: Call to undefined fun

Re: [PHP-DB] ? "SELECT TABLE" Command

Please fix your reply-to address. It is an SQL query (probably MySQL, but perhaps SQLite or possibly even PGSQL or mSQL): The line after $query should tell you what uses it ;) $query="SELECT TABLE $tablename;"; if (mysql_query($query, $link)) { echo($indent."The table, '$tablen

Re: [PHP-DB] mssql_connect not working from command line

However, a web page that includes the same file with the mssql_connect call still works fine, and now it makes sense that I see mssql is still enabled in phpinfo. The apache version of the php.ini file is different to the cli version. Make sure you are looking at the right one. On debian I

Re: [PHP-DB] ? "SELECT TABLE" Command

Chris wrote (in news:[EMAIL PROTECTED]): > > It is an SQL query (probably MySQL, but perhaps SQLite or possibly even PGSQL or mSQL): > > The line after $query should tell you what uses it ;) Sorry, I meant the book may have been about any of those; I was skimming through a bunch of SQL books at t

[PHP-DB] showing warnings

Hi this result is shown by mysql on running command prompt mysql> explain SELECT Tune_Name,Tune_Type FROM Mobile_Tunes; +--+--+---+--+-+--+--+---+ | table| type | possible_keys | key | key_len | ref | rows | Extra | +-