[PHP-DB] IF Clause in Left Join

to output the final results of my query to a new table. I'd be extremely grateful for any help anyone can provide. Thanks. Keith -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] New Table Creation with PHP Variables

to accomplish this task? Thanks for your help. Keith -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: New Table Creation with PHP Variables

field1, field2, field3, IF(o.product_type='course', o.product_id, NULL) AS field4, field5, field6, field7 FROM table1 as a, table2 as o; Is this right? Thank you for your help. Keith - Original Message - From: Keith Spiller larent...@hosthive.com To: php_db php-db@lists.php.net Sent

[PHP-DB] Credit Card Encryption

Hi Everyone, I'm trying to determine the best method to store credit card numbers in a mysql database. As yet I have been unable to determine whether I should use MySQL AES, DES or a PHP encryption method. I would greatly appreciate any advice you guys could offer. Thanks. Keith

Re: [PHP-DB] Credit Card Encryption

Thanks for the information, especially the PCI Complancy link and info. Keith - Original Message - From: Bastien Koert To: Keith Spiller ; php-db@lists.php.net Sent: Tuesday, December 18, 2007 9:41 PM Subject: RE: [PHP-DB] Credit Card Encryption Think very carefully about

Re: [PHP-DB] Credit Card Encryption

id (which could even be a unique and hidden value stored via AES in the mysql db). What are your thoughts? Keith - Original Message - From: Bastien Koert [EMAIL PROTECTED] To: Keith Spiller [EMAIL PROTECTED]; php-db@lists.php.net Sent: Tuesday, December 18, 2007 9:41 PM Subject: RE

[PHP-DB] Individual Array Entries

... Please help. Thank you. Keith -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Individual Array Entries

: $days[$theday] = array($thelink,linked-day); But it only displays the last event. Keith -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Sorting Multidimensional Array

Hi, RE: Sorting Multidimensional Array I'm trying to sort a multidimensional array. The data was taken from a mysql query: $myrow = mysql_fetch_row($result) { query[] = $myrow; } The purpose is to retrieve the table data and manually add a record, then sort ASC by the startdate which is

[PHP-DB] MySQL Query

with a WHERE clause that would find just the orphan instances. Thanks, Keith

[PHP-DB] Complex Left Join

, m.year FROM directors as d, members as m WHERE d.directorid = m.directorid AND m.year = '2006' ORDER BY d.lname, d.mname, d.fname; Thank you for your help... Keith

[PHP-DB] unexplained delay between db connection and db write operations

); ? I will greatly appreciate any suggestions. Thanks, Keith -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Passing an ADO Recordset by Reference

Does anyone know how to pass an ADO Recordset by reference to a COM object member function in PHP v4.3.6? eg. This is my best guess... dies horribly :( $AComObject = new COM(AServer.AObject); $AADORecordSet = new COM(ADODB.Recordset); // I wrap the ADO Recordset as a Variant... read on Zend

[PHP-DB] Simple Question... Complex Answer?

Dear All, How do I pass an ADO Recordset by reference to a COM object function in PHP v4.3.4? Cheers, Keith. ps. I posted a much more long-winded version of this earlier but it was screwed up in the Newsgroup somehow, (probably my fault). eg. My best guess... dies horribly :( $AComObject

[PHP-DB] Passing Parameters By Reference to a COM Object function... Nasty!

Dear All, I've got a nasty little problem here I hope someone can help me... I'm doing a job which requires me to use a 3rd party COM component to connect to a MSSQL Server. This works by calling Stored Procedures in the MSSQL DB and returning them in an ADO RecordSet. The VB Declaration of the

[PHP-DB] Determining if checkbox is selected in PHP

I'm storing the values from a groups of checkboxes in an array keyword[], but $_POST['keyword'] is undefined if none of the checkboxes is checked. I tried using in_array() with $_POST to determine if any of the group of 'keyword' checkboxes is checked, but can't get it to work; does anyone have

[PHP-DB] MySQL error message...

; a href='?bord=$bord' target='_top'What They Do/a; } else { echo nbsp; a href='$path' target='$target'$myrow[2]/abr\n; } } ? Any help would be unendingly appreciated... Keith -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

[PHP-DB] Php Thumbnail Gallery

Hello, Can anyone recommend a pure php solution for thumbnail image creation and photo gallery script? Everywhere I look the scripts require either GD, NetPBM or ImageMagick. Is it not possible to build an thumbnail app without these tools? Thank you for any help... Larentium -- PHP

[PHP-DB] File Upload ---Thanks!

, January 6, 2003, at 01:16 AM, Steve Khou wrote: It looks like a directory-write error. Try chmodding the uploads directory to 777. -Original Message- From: J. Keith Tew [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 05, 2003 8:41 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Flat File Upload

[PHP-DB] Flat File Upload..HELP!

I know this is not technically a DB question but thought someone may be able to help with this. I have tried everything I could think of to make this script work but I keep getting the error message below. I've even changed the permissions on the files and the folders affected to allow full

[PHP-DB] Form TextArea Formatting

Hello, I've created a web form that includes a textarea input box called MessageText. The data from this form will be inserted into a mysql table. My problem is that the form users will be inserting formatted text into this textarea and I need to be able to transfer the formatting as well as the

Re: [PHP-DB] Form TextArea Formatting

the Textarea, but it is also later displayed back in the Textarea and these to lines work perfectly for new lines, indents and spaces. Larentium - Original Message - From: Keith Spiller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 09, 2002 4:01 AM Subject: [PHP-DB] Form TextArea

[PHP-DB] PHP htaccess username grab

as the session is active... Any help or advice would be greatly appreciated. Keith [EMAIL PROTECTED]

RE: [PHP-DB] Kudos

. Viva la open source! Keith Vance Vance Consulting LLC www.vanceconsulting.net (206) 355-2399 Try my open source PHP authentication system, Rampart by visiting http://rampart.sourceforge.net/. Commercial support is available at, http://www.vanceconsulting.net/support/. On Fri, 30 Aug 2002, Peter

[PHP-DB] Output of curl to an array.

ssl_txn_id=---- ssl_approval_code=00 I need each of the lines to be turned into a variable. Any ideas as to how I might go about this? Thanks, Keith Posehn -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Alter Table / ADD col_name

Many thanks. regards keith Miles Thompson [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Keith, You're building it upside down! If your design relies on adding columns to store data you will quickly run out of columns. More typically when you sub

[PHP-DB] processing data from mysql queries with php

if this is the correct solution or not. Any ideas? Thanks, Keith -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

[PHP-DB] PHP/SQL search engine help (newbie)

Keith -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP-DB] PHP/SQL search engine help (newbie)

good and allows me to put in some nice animated flash sequences. Thanks for the help though. Keith Miles Thompson [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... If this is targetted at the Windows platform, why not use Windows own help engine ...

[PHP-DB] gzip image files

); encode it $gzdata = gzencode($data); where to write $fp = fopen('kunden/zip/'.$name.'.gz', w); write it fwrite($fp, $gzdata); fclose($fp); what happens is the name gets included in the gz but written to it is only kunden/example.png Can anyone help ?? thanks in advance regards keith -- PHP Database

Re: [PHP-DB] gzip image files

= gzencode($data, 9); $fp = fopen(bigfile.txt.gz, w); fwrite($fp, $gzdata); fclose($fp); ? Regards, Andrey Hristov IcyGEN Corporation http://www.icygen.com BALANCED SOLUTIONS - Original Message - From: Keith Whyman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November

Re: [PHP-DB] gzip image files

http://www.icygen.com BALANCED SOLUTIONS - Original Message - From: Keith Whyman [EMAIL PROTECTED] To: Andrey Hristov [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, November 27, 2001 5:06 PM Subject: Re: [PHP-DB] gzip image files and if i use $filename = 'kunden

Re: [PHP-DB] mysqlimport

command... Keith - Original Message - From: Keith Spiller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 13, 2001 6:51 PM Subject: [PHP-DB] mysqlimport Hello, I'm trying to use: passthru(mysqlimport --replace --fields-terminated-by=\| --user=testuser -- password

[PHP-DB] mysqlimport

echo $output I get '126' or '127'. But the process does not work. I have also tried using system and exec commands. Any suggestions? Thanks, Keith

[PHP-DB] Proper Case Conversion

convert to proper case. Does any one know of a way to do this, or a script that will accomplish it? Or, is there a mysql command that can handle the matter for me? Thanks, Keith

[PHP-DB] Opps: Proper Case NOT lower case

to convert text strings between upper and lower case, but I was unable to find anything that can convert to proper case. Does any one know of a way to do this, or a script that will accomplish it? Or, is there a mysql command that can handle the matter for me? Thanks, Keith

[PHP-DB] Warning: Page has Expired

, rather than expecting my viewers to learn to do without it. Keith Spiller [EMAIL PROTECTED]

Re: [PHP-DB] Re: Warning: Page has Expired

to GET? There must be a way... Keith - Original Message - From: Jonathan Hilgeman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 11, 2001 9:33 AM Subject: [PHP-DB] Re: Warning: Page has Expired You can also change your form to use the GET method instead. That works

Re: [PHP-DB] Connecting to MySQL

table in the mysql database. - Jonathan -Original Message- From: Keith Whyman [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 21, 2001 7:52 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Connecting to MySQL Can anyone help with this problem ! user name should just be keith

[PHP-DB] Connecting to MySQL

Can anyone help with this problem ! user name should just be keith but the @localhost gets added and then I can't connect ??? Warning: MySQL Connection Failed: Access denied for user: 'keith@localhost' (Using password: YES) in /usr/var/www/www.happy.de/html/cms/test.php on line 23 Problem

Re: [PHP-DB] Variable variables ! - help

I've got a loop which includes the following coming from mySQL if ($art_nr1 != '') { $i++; echo " td input type=\"hidden\" name=\"art_nr_$1\" value=\"$art_nr1\" input type=\"text\" name=\"quant$i\" size=\"3\" maxlength=\"5\" /td "; I've now got the following

Re: [PHP-DB] Variable variables ! - help

sorry I don't think I explained that very clearly ! The first loop's on a page which works fine, and it's in a form with article numbers and then an input field for quantites ! It's the next page that's giving me headaches ! The user submitted the form with all article numbers and some with a

Re: [PHP-DB] Variable variables ! - help

driving me up the bloody wall ! I'm sure it's something simple ! This works fine for ($i=1; $i50; $i++) : $varid = "quant".$i ; if ($$varid != "") { echo " input type=hidden name=\"art_nr\" value=\"$art_nr_1\" input type=hidden name=\"quantity\" value=\"$quant1\" "; } but the moment I change

[PHP-DB] array awry

active] = $myrow[4]; } Keith aka Larentium

[PHP-DB] Join causing Error?

qorder",$db); Works perfectly? Keith Spiller a.k.a. Larentium

[PHP-DB] Php FAQ, QA or Knowledge Base

Can anyone recommend a good FAQ, QA or Knowledge Base script written in PHP? Preferably one with an administration section and a queue for questions to be answered. Larentium