[PHP-DB] Re: [PHP-WIN] Need Help with 2 MYSQL Table

2015-04-25 Thread Richard Quadling
On 25 April 2015 at 06:13, Guru nagendra802...@gmail.com wrote: Hi All, Hope everyone is doing well. I need some help regarding a project. I have a huge list of customers in a ledger in a mysql table (Table A). And in another table I have their names and their ID number (Table B). What I

Re: [PHP-DB] Lost data after space in PHP variables

2015-02-19 Thread Richard Quadling
are automatically converted to _ by PHP. This is documented at http://php.net/manual/en/language.variables.external.php -- Richard Quadling

Re: [PHP-DB] Code Security

2015-02-05 Thread Richard Quadling
) - not perfect as they can be reversed to access the code in a form. 3 - Don't use PHP. -- Richard Quadling

Re: [PHP-DB] MS Access Connection with database password

2014-06-05 Thread Richard Quadling
it regularly and extract data from it so I need to connect to the database with the password set. Any help or hints are deeply appreciated! /Kjell -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Richard Quadling Twitter

Re: [PHP-DB] Re: Problem with query

2013-06-23 Thread Richard Quadling
) but are wrong. Newbie is confused. Please explain. Try ... $sql10 = select Balance, Payments, Charges, Date from Charges where Cust_Num = {$_SESSION['Cust_Num']} order by Date; -- Richard Quadling Twitter : @RQuadling EE : http://e-e.com/M_248814.html Zend : http

Re: [PHP-DB] Problem wkith Query

2013-06-23 Thread Richard Quadling
) but are wrong. Newbie is confused. Please explain. Try ... $sql10 = select Balance, Payments, Charges, Date from Charges where Cust_Num = {$_SESSION['Cust_Num']} order by Date; -- Richard Quadling Twitter : @RQuadling EE : http://e-e.com/M_248814.html Zend : http

[PHP-DB] Wanted : Solid/documented/tests Nested Set Model class for mySQL.

2013-06-06 Thread Richard Quadling
lazy and looking for a good recommendation. I've done searches on google, et al, but looking for recommendations from real use, rather than this looks good. Ta. -- Richard Quadling Twitter : @RQuadling EE : http://e-e.com/M_248814.html Zend : http://bit.ly/9O8vFY

Re: [PHP-DB] Sorting a PHP array

2013-05-18 Thread Richard Quadling
://ca1.php.net/manual/en/function.array-multisort.php Bastien I learned something. Never read up on this function. Could be useful someday -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Richard Quadling Twitter

Re: [PHP-DB] pdo ?

2013-01-24 Thread Richard Quadling
containing PHP and one other directory. Load them via your browser. See the settings for the magic_ and see where the php.ini configuration file is being loaded. It may be that your ini file is completely ignored! -- Richard Quadling Twitter : @RQuadling EE : http://e-e.com/M_248814.html

[PHP-DB] MySQLi binding params and results and where in a loop they should be placed.

2012-08-13 Thread Richard Quadling
of a prepared statement, making it both a little vague and pointless (excluding the OBVIOUS advantage of sql injection protection - I'm using prepared statements mainly for that reason). -- Richard Quadling Twitter : EE : Zend : Fantasy Shopper @RQuadling : http://e-e.com/M_248814.html : http://bit.ly

Re: [PHP-DB] Exporting mySQL to Excel

2011-11-09 Thread Richard Quadling
running inside Amazon's cloud services. I also Putty to create the tunnel and map the connection to allow the GoodData client to gather data from the mysql server for further reporting at GoodData. -- Richard Quadling Twitter : EE : Zend : PHPDoc : Fantasy Shopper @RQuadling : e-e.com/M_248814.html

Re: [PHP-DB] Exporting mySQL to Excel

2011-11-09 Thread Richard Quadling
have tab characters in your data), then this is a slight upgrade to CSV. -- Richard Quadling Twitter : EE : Zend : PHPDoc : Fantasy Shopper @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea : fan.sh/6/370 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit

Re: [PHP-DB] Re: Using MySQLi (OOP) to call a stored procedure with INOUT and OUT parameters.

2011-09-13 Thread Richard Quadling
On 13 September 2011 04:21, Ross McKay ro...@zeta.org.au wrote: On Mon, 12 Sep 2011 21:18:34 +0100, Richard Quadling wrote: I'm just trying to get PHP to talk to a stored procedure which has IN, INOUT and OUT parameters. [...] You'll probably need to trick it into returning a row with your

[PHP-DB] Using MySQLi (OOP) to call a stored procedure with INOUT and OUT parameters.

2011-09-12 Thread Richard Quadling
missing something obvious. Any help please? Regards, Richard. P.S. I'm coming from MSSQL using the MS SQL Server Driver for PHP via PDO, so a very different experience. -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea

Re: [PHP-DB] Re: MYSQLi fetch corrupting bound variables

2011-08-25 Thread Richard Quadling
then the above test will pass. -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Listing parent ids

2011-07-28 Thread Richard Quadling
-1) -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Listing parent ids

2011-07-28 Thread Richard Quadling
And http://www.amazon.co.uk/exec/obidos/ASIN/1558609202/onlinepricecouk -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Listing parent ids

2011-07-28 Thread Richard Quadling
query will be enough to interact with the tree at any level, in any direction, for more or less any purpose. Richard Quadling -- Thanks Richard. Your reference is exactly what I was looking for. I'm just busy reading a sitepoint article about adjacent lists vs the niftily titled modified

Re: [PHP-DB] Re: Listing parent ids

2011-07-28 Thread Richard Quadling
. -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] how does this regular expression works

2011-07-14 Thread Richard Quadling
when to escape is just like learning a new language. You only need to escape anything if you need it to be a literal character. e.g. something.html vs something\.html -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea -- PHP

Re: [PHP-DB] how does this regular expression works

2011-07-14 Thread Richard Quadling
as possible, expanding as needed (lazy) «*?» Match the characters “/head” literally «/head» Created with RegexBuddy -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] problem in connecting to mysql from php

2011-06-13 Thread Richard Quadling
. -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: problem in connecting to mysql from php

2011-06-13 Thread Richard Quadling
line, ... If php-SAPI.ini exists (where SAPI is used SAPI, so the filename is e.g. php-cli.ini or php-apache.ini), it's used instead of php.ini. SAPI name can be determined by php_sapi_name(). Richard. -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly

Re: [PHP-DB] Re: problem in connecting to mysql from php

2011-06-13 Thread Richard Quadling
, 2011 at 7:36 PM, Richard Quadling rquadl...@gmail.com wrote: On 13 June 2011 14:12, C0mf0rtably Numb 08.kus...@gmail.com wrote: Any help? On Mon, Jun 13, 2011 at 5:38 PM, C0mf0rtably Numb 08.kus...@gmail.comwrote: Hello everyone, I am in the process of learning php and I was trying

Re: [PHP-DB] Converting from PHP4 to php5

2011-06-03 Thread Richard Quadling
new features of PHP5. This could involve moving from PHP4 procedural code to PHP5 OOP. This could require a significant investment in time (and therefore money), depending upon the project. And may not be necessary. Richard. -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e

Re: [PHP-DB] Converting from PHP4 to php5

2011-06-02 Thread Richard Quadling
, Marc Hall HallMarc Websites 610.446.3346 http://www.hallmarcwebsites.com/ But advertising your services is OK? -- Richard Quadling Twitter : EE : Zend : PHPDoc @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Pause While-loop when waiting for function call to complete

2011-04-24 Thread Richard Quadling
the do/while is complete. ? -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP-WIN] Need Help with PHP Mails

2011-04-04 Thread Richard Quadling
use HTMLMimeMail5 (now called RMail) from phpguru.com. PHPMailer is another tool that does a similar job. It may be better, I've just never used it. Regards, Richard. P.S. Guru? Really? -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database

[PHP-DB] Re: [PHP-WIN] Need Help with PHP Mails

2011-04-04 Thread Richard Quadling
2011/4/4 Guru™ nagendra802...@gmail.com: Hi Richard, I am using simple PHP mail function but, I am unable to send an email to myself. What I want is when the user click on submit button I should get an email with the form data. 2011/4/4 Richard Quadling rquadl...@gmail.com 2011/4/4 Guru

[PHP-DB] Re: [PHP-WIN] Need Help with PHP Mails

2011-04-04 Thread Richard Quadling
); ? 2011/4/4 Richard Quadling rquadl...@gmail.com 2011/4/4 Guru™ nagendra802...@gmail.com: Hi Richard, I am using simple PHP mail function but, I am unable to send an email to myself. What I want is when the user click on submit button I should get an email with the form data. 2011/4/4

[PHP-DB] Stored Procedures, Dynamic SQL or static SQL and testing.

2011-03-26 Thread Richard Quadling
this mainly relates to SPs). Does using a different RDBMS make a difference to the SQL coding style you'd use? This isn't for any sort of thesis, just trying to see what the general consensus is of those that reply. Thanks for answering. Richard Quadling. -- Richard Quadling Twitter : EE : Zend

Re: [PHP-DB] UPDATE IF

2011-03-14 Thread Richard Quadling
IDColumn = ID something like that? -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Error while inserting data into mysql

2011-03-01 Thread Richard Quadling
. It is attempting to write to a mysql table. One of the columns you've coded for doesn't exist. Maybe. Can you show us the table structure and the exact SQL statement you are executing please? Richard. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP

[PHP-DB] Re: [PHP-WIN] Re: Error while inserting data into mysql

2011-03-01 Thread Richard Quadling
what column in the table is scloth100_qty? I can't find it. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP-WIN] Re: Error while inserting data into mysql

2011-03-01 Thread Richard Quadling
are ... |scloth100_totamt|int(20)|Yes|NULL |scloth100_utp|int(20)|Yes|NULL |scloth100_val|int(20)|Yes|NULL |scloth100_vatp|int(20)|Yes|NULL |scloth100_vatr|int(10)|Yes|NULL |scloth100|varchar(100)|Yes|NULL No scloth100_qty. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html

Re: [PHP-DB] 2nd Pair of eyes please

2011-01-27 Thread Richard Quadling
would be useful. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Getting Results

2011-01-21 Thread Richard Quadling
and previous row to the current row in a result set, where a single table is essentially bound 3 times, but with the CTE, additional optimization seems to be in play and work a LOT faster overall. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP

Re: [PHP-DB] Re: Getting Results

2011-01-21 Thread Richard Quadling
, Richard. [1] http://msdn.microsoft.com/en-us/library/ms188366.aspx -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP] Problems w/ goto

2010-12-17 Thread Richard Quadling
/unsub.php And have you seen all the sad faces ... : { on http://docs.php.net/manual/en/control-structures.goto.php#92763 Can't be good for them. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] NULL to 0 result

2010-12-15 Thread Richard Quadling
`, `reference` Normally COUNT() will count NULLs, but as you are grouping by the counted column, nulls would be in their own row. Richard. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] NULL values

2010-12-04 Thread Richard Quadling
” http://www.TheVerseOfTheDay.info http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#function_isnull where isnull(column, '') 'value' -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Re: ezmlm warning

2010-11-05 Thread Richard Quadling
you simply send a blank email.  Moments later, you should receive a copy of the original email --- and usually that will come through, by request. Or you can use the news.php.net site to read the message. http://news.php.net/php.db/47430 -- Richard Quadling Twitter : EE : Zend @RQuadling : e

Re: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Richard Quadling
it which of the available sites the medical record is for and insert it (along with any other user supplied data). The integrity is preserved by the DB. Just doing my job, sir! Richard. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database

Re: [PHP-DB] Parsing Tab Delimited file

2010-10-26 Thread Richard Quadling
. But that's assuming you aren't using a mysql tool to import the data directly. (I do a BULK INSERT in MS SQL). -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] Books

2010-10-19 Thread Richard Quadling
. I use MS SQL, so I have MS BOL (Books OnLine). My JS work is done mainly using PrototypeJS, so there manual is online. And of course, there is the PHP manual at docs.php.net. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing

Re: [PHP-DB] session expiration

2010-09-28 Thread Richard Quadling
session_cache_expire() before you call session_start(). -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] formatting a word doc using php ?

2010-09-20 Thread Richard Quadling
, then the third party class and finally the COM. Richard. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] SELECT / ORDER BY

2010-09-13 Thread Richard Quadling
are grouping by `bible_concordance_words`.`word`, there really is never going to be a duplicate. So, there is no need to order by anything else. So, ORDER BY `bible_concordance_words`.`word` ASC is all you should need. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html

[PHP-DB] Re: [PHP-WIN] Select the specific user data from the database

2010-09-06 Thread Richard Quadling
a table was far easier. Richard. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Is this syntax is correct?

2010-09-06 Thread Richard Quadling
password, sure. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] COUNT() query help

2010-08-13 Thread Richard Quadling
` LIKE '$letter%' GROUP BY `bible_concordance_words`.`word`, ORDER BY `word` ASC -- Richard Quadling. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] input statement in php

2010-07-27 Thread Richard Quadling
(STDIN, %s\t%s\t%s\n)) { print_r($userinfo); } ? STDIN is a predefined resource, so no need to fopen()/fclose() it. Hope this helps. Regards, Richard Quadling. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Email validation

2010-06-29 Thread Richard Quadling
. As for the MX part, PHP has the getmxrr() function for this task - http://docs.php.net/manual/en/function.getmxrr.php There are also a lot of user notes covering email address validation. Richard. -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http

Re: [PHP-DB] Major Cookie Problem

2010-05-13 Thread Richard Quadling
On 13 May 2010 12:32, Barry Zimmerman barryzi...@googlemail.com wrote: setcookie('peg', 'YES', 'time()+190', '', 0); Can you try removing the quotes from around the expire parameter. setcookie('peg', 'YES', time()+190, '', 0); Richard -- - Richard Quadling Standing on the shoulders

Re: [PHP-DB] PDO include table name prefixes in FETCH_ASSOC

2010-03-25 Thread Richard Quadling
Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php I use MS SQL and have used other DBs. I've never seen the table name as part of the column name in a result set on any of them. -- - Richard Quadling Standing on the shoulders of some very clever

Re: [PHP-DB] PDO include table name prefixes in FETCH_ASSOC

2010-03-24 Thread Richard Quadling
. -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com/M_248814.html EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498r=213474731 ZOPA : http://uk.zopa.com

Re: [PHP-DB] Using mssql serial command in PHP 5.3

2010-02-18 Thread Richard Quadling
SQL Server 2005 Driver for PHP and Microsoft SQL Server 2008 Native Client for more info. The Native Client download for x86 is http://go.microsoft.com/fwlink/?LinkId=123717clcid=0x409 -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts

Re: [PHP-DB] PHP Objects and SQL Results

2010-02-13 Thread Richard Quadling
? Thanks, Paul You can use mysql_result() (http://docs.php.net/manual/en/function.mysql-result.php) to read a specific row from the result set. But you could also use the SQL WHERE or LIMIT clause to only retrieve the specific row or rows you wanted. -- - Richard Quadling Standing

Re: [PHP-DB] Storing Images #2

2010-02-05 Thread Richard Quadling
type. $imgData = getimagesize(IMAGES_LOCATION . $imgName); // Send appropriate image header. header(Content-type: {$imgData['mime']}); // Send the image. readfile(IMAGES_LOCATION . $imgName); // Done. exit(); ? -- - Richard Quadling Standing on the shoulders of some very clever giants! EE

Re: [PHP-DB] Storing images

2010-02-03 Thread Richard Quadling
probably work. But ... /home/sites/your_site/public_html/getImage.php /home/sites/your_site/hidden_images/image1.jpg Now, there is no way I can load image1.jpg from my browser. I have to use getImage.php, which I assume would require me to login or authenticate myself in some way. -- - Richard

Re: [PHP-DB] Storing images

2010-02-03 Thread Richard Quadling
, Karl On Feb 3, 2010, at 10:14 AM, Richard Quadling wrote: On 3 February 2010 16:07, Karl DeSaulniers k...@designdrumm.com wrote: Thank you all for your numerous responses. I hear you loud and clear. I was wanting to see if it would be less of a burden on the server and secure my images

Re: [PHP-DB] Storing images

2010-02-03 Thread Richard Quadling
, Thanks, Karl On Feb 3, 2010, at 10:31 AM, Richard Quadling wrote: If you have any writers, then you need to introduce a locking mechanism or some other protection. Karl DeSaulniers Design Drumm http://designdrumm.com Take a read at what started in http://marc.info/?l=php-dbm

Re: [PHP-DB] MIME Alternatimve Emails

2010-01-30 Thread Richard Quadling
/static/Rmail Though, you'll probably find PHPMailer is the most commonly used class at http://phpmailer.worxware.com/ -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com/M_248814.html EE4Free : http://www.experts-exchange.com

Re: [PHP-DB] MIME Alternatimve Emails

2010-01-30 Thread Richard Quadling
it was just the new header info I was plugging in so to do the whole checking if a user can receive HTML emails or text. Any thoughts on what order I should be putting the headers I have? TIA, Karl On Jan 30, 2010, at 7:13 AM, Richard Quadling wrote: On 30 January 2010 13:04, Karl DeSaulniers k

Re: [PHP-DB] FW: semaphores WAS: [PHP-DB] Automatic logoff

2010-01-29 Thread Richard Quadling
= the_datetime_I_read_when_I_started_editing_the_row But I don't like that method. It is first saves wins, rather than locking. -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com/M_248814.html EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp Zend Certified

Re: [PHP-DB] Automatic logoff

2010-01-28 Thread Richard Quadling
8:14 AM, Richard Quadling wrote: The technique I've used in the past is semaphore locking, where the semaphore contains the session and the expected expiry time. Follow this. User a starts the process of editing a record. Set the semaphore where there is :   a - no existing semaphore

Re: [PHP-DB] Automatic logoff

2010-01-28 Thread Richard Quadling
On 28 January 2010 20:29, listread listr...@cze.com wrote: Richard, One more question (for now):   Are there advantages to using a separate table for locking, rather than specifying a lock column in the table you want to lock the row in? - Ron On 1/28/2010 5:47 AM, Richard Quadling wrote

Re: [PHP-DB] FW: semaphores WAS: [PHP-DB] Automatic logoff

2010-01-28 Thread Richard Quadling
. And this also helped to clarify: http://stackoverflow.com/questions/62814/difference-between-binary-semaphor e-and-mutex Ha! Toilets. -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com/M_248814.html EE4Free : http://www.experts

Re: [PHP-DB] Automatic logoff

2010-01-27 Thread Richard Quadling
this to your own needs. -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com/M_248814.html EE4Free : http://www.experts-exchange.com/becomeAnExpert.jsp Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498r=213474731 ZOPA

Re: [PHP-DB] Im seeking a solution to check for duplicate entries with an other sequence

2010-01-12 Thread Richard Quadling
2010/1/11 Richard Quadling rquadl...@googlemail.com: 2010/1/11 omar zorgui omarzor...@gmail.com: $sentences[] = this is a example sentence; $sentences[] = a this is example sentence; $sentences[] = example this is a sentence; $sentences[] = this is a example sentence for a function; ?php

Re: [PHP-DB] Im seeking a solution to check for duplicate entries with an other sequence

2010-01-11 Thread Richard Quadling
($Reduced); ? outputs ... Array ( [0] = this is a example sentence [3] = this is a example sentence for a function ) -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com/M_248814.html Zend Certified Engineer : http://zend.com

Re: [PHP-DB] printf and unsecable char

2010-01-05 Thread Richard Quadling
)); ? outputs ... nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;Hello, world! -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com/M_248814.html Zend Certified Engineer : http://zend.com/zce.php?c

Re: [PHP-DB] unlink problems

2009-11-26 Thread Richard Quadling
the script it. So, ./$filename should probably be ../tenders/$filename maybe. Regards, Richard. -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com/M_248814.html Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498r=213474731

Re: [PHP-DB] Multiple instances of mysql_connect() in single PHP document.

2009-11-12 Thread Richard Quadling
, $password, true); // Is NOT the same connection as $conn1 mysql_select_db($db1, $conn1); // Points to db1 for connection1 mysql_select_db($db2, $conn2); // Points to db2 for connection2 -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com

Re: [PHP-DB] Multiple instances of mysql_connect() in single PHP document.

2009-11-12 Thread Richard Quadling
connections using the same server and credentials - results in 1 real connection. $db_material = mysql_connect(localhost, root, secret, true); $db_labor = mysql_connect(localhost, root, secret, true); should fix it. -- - Richard Quadling Standing on the shoulders of some very clever giants! EE

Re: [PHP-DB] Multiple instances of mysql_connect() in single PHP document.

2009-11-11 Thread Richard Quadling
Alias.Column FROM Database.Table.Column AS Alias sort of thing. -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com/M_248814.html Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498r=213474731 ZOPA : http://uk.zopa.com

Re: [PHP-DB] Does PHP5 support querying an MS Access MDE file?

2009-11-03 Thread Richard Quadling
. Tim Legg -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php If you have the MS Access ODBC driver installed, then have you tried accessing the MDE as an MDB? -- - Richard Quadling Standing on the shoulders of some very clever

Re: [PHP-DB] Does PHP5 support querying an MS Access MDE file?

2009-11-03 Thread Richard Quadling
(*.mdb)};Dbq=$mdbFilename, $user, $password); ? Thanks for looking this over, Tim Legg -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com/M_248814.html Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498r

[PHP-DB] How exactly do I get UTF-8 data into SQL Server on Windows via ODBC SQL Native Client 10.0?

2009-10-07 Thread Richard Quadling
it can't be that difficult. I'm not in a position to try PHP6 yet. Any suggestions would be gratefully received. Regards, Richard Quadling. CREATE TABLE [dbo].[Phones_Directory]( [UniqueID] [int] IDENTITY(1,1) NOT NULL, [PhoneNumber] [varchar](20) NOT NULL, [Recipient

Re: [PHP-DB] scheduler

2009-09-23 Thread Richard Quadling
are the same for the task scheduler. -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com/M_248814.html Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498r=213474731 ZOPA : http://uk.zopa.com/member/RQuadling -- PHP Database

Re: [PHP-DB] scheduler

2009-09-23 Thread Richard Quadling
. -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http://www.experts-exchange.com/M_248814.html Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498r=213474731 ZOPA : http://uk.zopa.com/member/RQuadling -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Re: Need help-Send email

2009-09-14 Thread Richard Quadling
. Using getmxrr() is bypassing the local relay step and going direct. Obviously, you have to handle all the errors, retries, etc. But you can also step through the servers if one is offline or whaterver. -- - Richard Quadling Standing on the shoulders of some very clever giants! EE : http

Re: [PHP-DB] Image_Problem

2009-07-23 Thread Richard Quadling
... $pi = Imagejpeg($pic,pic.jpg); echo $pi; to ... imagejpeg($pic); -- - Richard Quadling Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498r=213474731 Standing on the shoulders of some very clever giants! ZOPA : http://uk.zopa.com/member/RQuadling -- PHP Database Mailing List

Re: [PHP-DB] Cant get Mysql stored procedure to work.

2009-07-14 Thread Richard Quadling
/unsub.php If your stored procedure has in and out parameters, maybe the mysqli::prepare() method may be of more use. -- - Richard Quadling Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498r=213474731 Standing on the shoulders of some very clever giants! ZOPA : http://uk.zopa.com

[PHP-DB] Re: [PHP-WIN] Which ORM tool for Windows with Microsoft SQL Server 7/2000/2005.

2009-04-20 Thread Richard Quadling
one of those native DB adapters and make them work with the sql server for PHP driver. Andi -Original Message- From: David Sceppa [mailto:david.sce...@microsoft.com] Sent: Sunday, April 19, 2009 5:18 PM To: Richard Quadling Cc: php-db@lists.php.net; php-wind...@lists.php.net; php

[PHP-DB] Re: php-win-which-orm-tool-for-windows-with.html

2009-04-15 Thread Richard Quadling
you're interested, I'll post my progress to the outlet mailing list at: http://groups.google.com/group/outlet-orm Any help/suggestions would be appreciated. Regards, Richard Quadling. Feel free to redistribute this email if you want. Alvaro Carrasco Thank you to Alvaro

[PHP-DB] Which ORM tool for Windows with Microsoft SQL Server 7/2000/2005.

2009-04-14 Thread Richard Quadling
. Is there anyone capable of getting the Microsoft driver PDO aware? Any help/suggestions would be appreciated. Regards, Richard Quadling. -- - Richard Quadling Zend Certified Engineer : http://zend.com/zce.php?c=ZEND002498r=213474731 Standing on the shoulders of some very clever giants! -- PHP

[PHP-DB] Getting a date from MS SQL in the correct format.

2001-04-02 Thread Richard Quadling
n the mean time, I've had to use DATEPART to pull the three bits in separately and add a bit to the PHP templates to add them all together. Ideally I want just the value as CCYYMMDD. Regards, Richard Quadling. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL