RE: [PHP-DB] change coldfusion to mysql/php

2008-05-08 Thread Gary Wardell
Hi, I don't know of a tool, although there may be one. If the pages are really simple I would think that it wouldn't be that hard to redo them by hand. Gary -Original Message- From: Koller Michel [mailto:[EMAIL PROTECTED] Sent: Thu, May 08, 2008 7:26 AM To:

RE: [PHP-DB] Parse error: syntax error, unexpected T_ELSE

2008-04-15 Thread Gary Wardell
Hi, I suggest you echo $del_str to see exactly what your query is. There may be something unexpected in $_GET['Id']. Echo the whole query so you can see everything in context. Gary -Original Message- From: Javier Viegas [mailto:[EMAIL PROTECTED] Sent: Tue, April 15, 2008 5:56 PM

RE: [PHP-DB] webserver script to localhost MySQL?

2008-03-22 Thread Gary Wardell
] Sent: Sat, March 22, 2008 4:53 AM To: Gary Wardell; Subject: Re: [PHP-DB] webserver script to localhost MySQL? thanks. I removed the additional ' at the end and get this error (adding the echo as suggested)

RE: [PHP-DB] Help with JOIN query

2008-03-06 Thread Gary Wardell
Hi, The way I think I'd approach it is to use an outer join where table a is joined to a subquery where the subquery returns only the max timestamp from table b. Gary -Original Message- From: Graham Cossey [mailto:[EMAIL PROTECTED] Sent: Thu, March 06, 2008 5:17 PM To: J. Hill;

RE: [PHP-DB] Help with JOIN query

2008-03-06 Thread Gary Wardell
Ahh, to bad, I started using it with 5.0. I'm also a long time user of SQL Server. Sorry if I caused confusion. Gary -- PHP Database Mailing List ( To unsubscribe, visit:

RE: [PHP-DB] Help with JOIN query

2008-03-06 Thread Gary Wardell
, March 06, 2008 6:33 PM To: Gary Wardell; Subject: Re: [PHP-DB] Help with JOIN query On Thu, Mar 6, 2008 at 10:59 PM, Gary Wardell [EMAIL PROTECTED] wrote: Ahh, to bad, I started using it with 5.0. I'm also a long time user of SQL Server. Sorry if I caused

RE: [PHP-DB] independent session data for multiple browser windows

2008-02-20 Thread Gary Wardell
They'll be accessing different account records in different windows. I keep track of the current account id in the session data, as well as a number of other account-specific items. Once I was made aware of the multiple-window requirement, and started looking more closely at sessions, it

RE: [PHP-DB] Password decryption

2008-02-17 Thread Gary Wardell
Hi, Note from the manual: PASSWORD() encryption is one-way (not reversible). Also note: === Note The PASSWORD() function is used by the authentication system in MySQL Server; you should not use it in your own applications. For that

RE: [PHP-DB] Importing CSV files to MySql Db issue.

2008-02-17 Thread Gary Wardell
Chris, If you're using spaces for enclosing then I'm sure you're not handling something properly. Chris,Carter,[EMAIL PROTECTED] -- 3 records Chris Carter,[EMAIL PROTECTED] -- 2 records Don't you mean: Chris,Carter,[EMAIL PROTECTED] -- 3 *fields* Chris Carter,[EMAIL PROTECTED] -- 2

RE: [PHP-DB] odbc_connect - urgent

2008-01-10 Thread Gary Wardell
Hi, You didn't mention which OS this is on. If it's Windows, there is another factor. The timeout in ODBC and OLEDB refer to the time the server on the other end takes to complete the operation. This is independent of the timeout set at the socket layer. So, you could set the ODBC timeout

RE: [PHP-DB] align

2008-01-01 Thread Gary Wardell
Or even if it's not in a table, put a div around it and use: style= text-align: right or equivalent css Of course this assumes he's using html to display it. Gary -Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Tue, January 01, 2008 11:21 AM To: arafat

RE: [PHP-DB] Credit Card Encryption

2007-12-19 Thread Gary Wardell
Hmm, This is kind of throwing a new twist on things. When it comes to liability, who is liable, the merchant running the system, the develper that created the system, or both? If the develper is included, would that be mitigated in that he created the system to the merchant's specifications?

RE: [PHP-DB] Credit Card Encryption

2007-12-18 Thread Gary Wardell
And if you do store it, don't store it on the websderver. Make sure it's on another server behind another firewall. You don't want someone that hacks into your web server to have ready access to your database. I think AES is supposed to be the best, then 3DES is next. (That's 3DES, or

RE: [PHP-DB] UPDATE syntax

2007-12-13 Thread Gary Wardell
Hi, I'm a beginner at PHP and MySql but a long time MS SQL server user. Maybe it should be `advertisements`.`displayed` instead? I just did a test and my Query browser doesn't like `` but likes `interestcodes`.`id`. Notice the quotes (accents) on each side to the period. Gary

RE: [PHP-DB] Form mail() problem

2007-12-09 Thread Gary Wardell
Hi, This is an SMTP error, not a PHP error. Since you imply the PHP code hasn't changed then something else must have changed. First verify that the to address, [EMAIL PROTECTED] is still good buy sending and e-mail to it. If that checks out OK, than check with the mail server administrator.