Re: [PHP-DB] Re: Formatting

2012-11-26 Thread Karl DeSaulniers
Ethan, is this valid PHP? What is the ampersand for? What is it doing? Just curious. $args[] = $_POST[$k]; // Note the addition of the ampersand here Karl On Nov 26, 2012, at 12:14 AM, Matt Pelmear wrote: FYI, this really is not the appropriate mailing list for these types of questions.

RE: [PHP-DB] Re: Formatting

2012-11-26 Thread Ford, Mike
-Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: 26 November 2012 08:48 To: php-db@lists.php.net Subject: Re: [PHP-DB] Re: Formatting Ethan, is this valid PHP? What is the ampersand for? What is it doing? Just curious. $args[] = $_POST[$k]; // Note

[PHP-DB] Formatting - Solved

2012-11-26 Thread Ethan Rosenberg, PhD
Dear list Here is the answer ORIGINAL centerbSearch Results/b/centerbr / center !-- This is the block that prints about one screen full down bellow the Search Results header -- table border=4 cellpadding=5 cellspacing=55 rules=all frame=box style=table-layout: fixed; tr

[PHP-DB] Re: Formatting - Solved

2012-11-26 Thread Jim Giner
On 11/26/2012 1:04 PM, Ethan Rosenberg, PhD wrote: Dear list Here is the answer ORIGINAL centerbSearch Results/b/centerbr / center !-- This is the block that prints about one screen full down bellow the Search Results header -- table border=4 cellpadding=5 cellspacing=55 rules=all

[PHP-DB] CSV storage InnoDB?

2012-11-26 Thread Karl DeSaulniers
Hello all, Quick question. What is the best way to store a comma separated list of discount codes in a InnoDB? Text, varchar, blob, ? I want to be able to store discount codes offered to users in their profile, in their cart, etc. So I am thinking of storing the codes as a comma separated

[PHP-DB] mysqli_bind_result

2012-11-26 Thread Ethan Rosenberg, PhD
Dear List - Here is some code: $sql13 = SELECT * FROM Intake3 WHERE MedRec = ?; $stmt = mysqli_stmt_init($cxn); mysqli_stmt_prepare( $stmt, $sql13 ); $_SESSION['stmt'] = $stmt; $args = array(); $args[0] = $_POST['MR'];

Re: [PHP-DB] CSV storage InnoDB?

2012-11-26 Thread Bastien
Bastien Koert On 2012-11-26, at 7:43 PM, Karl DeSaulniers k...@designdrumm.com wrote: Hello all, Quick question. What is the best way to store a comma separated list of discount codes in a InnoDB? Text, varchar, blob, ? I want to be able to store discount codes offered to users in

Re: [PHP-DB] CSV storage InnoDB?

2012-11-26 Thread Karl DeSaulniers
On Nov 26, 2012, at 7:29 PM, Bastien wrote: Bastien Koert On 2012-11-26, at 7:43 PM, Karl DeSaulniers k...@designdrumm.com wrote: Hello all, Quick question. What is the best way to store a comma separated list of discount codes in a InnoDB? Text, varchar, blob, ? I want to be able to

Re: [PHP-DB] CSV storage InnoDB?

2012-11-26 Thread Karl DeSaulniers
On Nov 26, 2012, at 8:01 PM, Karl DeSaulniers wrote: On Nov 26, 2012, at 7:29 PM, Bastien wrote: Bastien Koert On 2012-11-26, at 7:43 PM, Karl DeSaulniers k...@designdrumm.com wrote: Hello all, Quick question. What is the best way to store a comma separated list of discount codes

Re: [PHP-DB] CSV storage InnoDB?

2012-11-26 Thread Javier Romero
Unsuscribe me please. Thanks El 26/11/12 23:01, Karl DeSaulniers escribió: On Nov 26, 2012, at 7:29 PM, Bastien wrote: Bastien Koert On 2012-11-26, at 7:43 PM, Karl DeSaulniers k...@designdrumm.com wrote: Hello all, Quick question. What is the best way to store a comma separated list

Re: [PHP-DB] mysqli_bind_result

2012-11-26 Thread tamouse mailing lists
On Mon, Nov 26, 2012 at 7:28 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - Here is some code: $sql13 = SELECT * FROM Intake3 WHERE MedRec = ?; $stmt = mysqli_stmt_init($cxn); mysqli_stmt_prepare( $stmt, $sql13 );

Re: [PHP-DB] CSV storage InnoDB?

2012-11-26 Thread Matt Pelmear
Karl, Typically I would do this as multiple rows rather than comma-separated data in one field. If you go this route, you may consider adding an unsigned int primary key (with auto increment) on the discounts table so you consume less storage space and can do joins more quickly.

Re: [PHP-DB] CSV storage InnoDB?

2012-11-26 Thread tamouse mailing lists
On Mon, Nov 26, 2012 at 8:10 PM, Karl DeSaulniers k...@designdrumm.com wrote: On Nov 26, 2012, at 8:01 PM, Karl DeSaulniers wrote: On Nov 26, 2012, at 7:29 PM, Bastien wrote: Bastien Koert On 2012-11-26, at 7:43 PM, Karl DeSaulniers k...@designdrumm.com wrote: Hello all, Quick

Re: [PHP-DB] CSV storage InnoDB?

2012-11-26 Thread Karl DeSaulniers
On Nov 26, 2012, at 9:22 PM, tamouse mailing lists wrote: On Mon, Nov 26, 2012 at 8:10 PM, Karl DeSaulniers k...@designdrumm.com wrote: On Nov 26, 2012, at 8:01 PM, Karl DeSaulniers wrote: On Nov 26, 2012, at 7:29 PM, Bastien wrote: Bastien Koert On 2012-11-26, at 7:43 PM, Karl

Re: [PHP-DB] CSV storage InnoDB?

2012-11-26 Thread Matt Pelmear
BLOB and TEXT are basically the same thing, except that BLOB can be used for storing binary data (like an image). You would only need one additional table to do what I was describing, but if you're dead-set on using a comma separated list then TEXT or LONGTEXT is probably what you want,

Re: [PHP-DB] CSV storage InnoDB? - Solved

2012-11-26 Thread Karl DeSaulniers
You have a valid point there Matt. Not dead set. Table it is. Thanks guys. Best, Karl On Nov 27, 2012, at 12:30 AM, Matt Pelmear wrote: BLOB and TEXT are basically the same thing, except that BLOB can be used for storing binary data (like an image). You would only need one additional