[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

[PHP-DB] Formatting

2012-11-25 Thread Ethan Rosenberg, PhD
Dear list - When I run the following code, the results are preceded by at least one screen full of blank lines. I am showing you a large code block since I do not know where the error is: if(isset($_REQUEST['Sex']) trim($_POST['Sex']) != '' ) { if ($_REQUEST['Sex'] === 0)

[PHP-DB] Re: Formatting

2012-11-25 Thread Jim Giner
On 11/25/2012 12:46 PM, Ethan Rosenberg, PhD wrote: Dear list - When I run the following code, the results are preceded by at least one screen full of blank lines. I am showing you a large code block since I do not know where the error is: if(isset($_REQUEST['Sex']) trim($_POST['Sex']) !=

Re: [PHP-DB] Re: Formatting

2012-11-25 Thread Ethan Rosenberg, PhD
List - Any more ideas. = Keep on debugging jg Jim - I've been at this for a few weeks, and am stuck. Thanks for all your help. Ethan + On Nov 25, 2012, at 1:59 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: On 11/25/2012 12:56 PM, Jim Giner wrote: On

Re: [PHP-DB] Re: Formatting

2012-11-25 Thread Karl DeSaulniers
On Nov 25, 2012, at 11:56 AM, Jim Giner wrote: On 11/25/2012 12:46 PM, Ethan Rosenberg, PhD wrote: Dear list - When I run the following code, the results are preceded by at least one screen full of blank lines. I am showing you a large code block since I do not know where the error is:

Re: [PHP-DB] Re: Formatting

2012-11-25 Thread tamouse mailing lists
On Sun, Nov 25, 2012 at 4:40 PM, Karl DeSaulniers k...@designdrumm.com wrote: Your also using a combination of th and td. I am thinking that you have columns and that they lay next to each other. Lose the th and just use td Hmm, well, no, it looks like the table header columns are in fact just

Re: [PHP-DB] Re: Formatting

2012-11-25 Thread Karl DeSaulniers
On Nov 25, 2012, at 6:25 PM, tamouse mailing lists wrote: On Sun, Nov 25, 2012 at 4:40 PM, Karl DeSaulniers k...@designdrumm.com wrote: Your also using a combination of th and td. I am thinking that you have columns and that they lay next to each other. Lose the th and just use td Hmm,

Re: [PHP-DB] Re: Formatting

2012-11-25 Thread Jim Giner
On 11/25/2012 5:39 PM, Ethan Rosenberg, PhD wrote: List - Any more ideas. = Keep on debugging jg Jim - I've been at this for a few weeks, and am stuck. Thanks for all your help. Ethan + On Nov 25, 2012, at 1:59 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote:

Re: [PHP-DB] Re: Formatting

2012-11-25 Thread Matt Pelmear
FYI, this really is not the appropriate mailing list for these types of questions. Are you positive they are empty lines? i.e., are they in the html code of the page, or only appear as empty space in the rendered page? If they are just in the rendered page, in addition to losing the /div in

Re: [PHP-DB] Debugger

2012-10-25 Thread tamouse mailing lists
On Wed, Oct 24, 2012 at 7:20 PM, Christopher Jones christopher.jo...@oracle.com wrote: On 10/24/2012 05:02 PM, Ethan Rosenberg, PhD wrote: Dear list - A. Is anyone aware of a debugger that: 1] will step thru the code, 2] will stop at a point that input is requested [eg, form] and allow

[PHP-DB] Debugger

2012-10-24 Thread Ethan Rosenberg, PhD
Dear list - A. Is anyone aware of a debugger that: 1] will step thru the code, 2] will stop at a point that input is requested [eg, form] and allow input? B. Aptana gives the following message: 'Launching Firefox' internal server has failed. Server configuration null not found. Advice

Re: [PHP-DB] Debugger

2012-10-24 Thread Jonathan Sundquist
Do you have xdebug installed? - The cold winds are rising On Oct 24, 2012 7:02 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear list - A. Is anyone aware of a debugger that: 1] will step thru the code, 2] will stop at a point that input is requested [eg, form] and

Re: [PHP-DB] Debugger

2012-10-24 Thread Christopher Jones
On 10/24/2012 05:02 PM, Ethan Rosenberg, PhD wrote: Dear list - A. Is anyone aware of a debugger that: 1] will step thru the code, 2] will stop at a point that input is requested [eg, form] and allow input? B. Aptana gives the following message: 'Launching Firefox' internal server has

[PHP-DB] Need some opinions on solution

2012-10-17 Thread Bastien Koert
Hi All, Below is a situation I ran into recently. To me, the decision made shows how to not solve a problem but merely compound the issue. Scenario: There is an app currently running on a highly loaded 4.11 MySQL db. Customers are complaining about the slow performance. The app has 3 important

Re: [PHP-DB] Need some opinions on solution

2012-10-17 Thread tamouse mailing lists
On Wed, Oct 17, 2012 at 10:53 PM, Bastien Koert phps...@gmail.com wrote: Hi All, Below is a situation I ran into recently. To me, the decision made shows how to not solve a problem but merely compound the issue. Scenario: There is an app currently running on a highly loaded 4.11 MySQL db.

Re: [PHP-DB] Re: Program Dies

2012-10-16 Thread tamouse mailing lists
On Mon, Oct 15, 2012 at 11:14 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 10/14/2012 5:57 PM, Ethan Rosenberg, PhD wrote: Dear List - Thank you ever so much for all your help. I apologize in advance for dumping all this code on you. I cannot get any debugger to work for me [see

Re: [PHP-DB] Re: Program Dies

2012-10-16 Thread tamouse mailing lists
On Tue, Oct 16, 2012 at 9:53 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: snip form with an empty action= attribute simply calls the same URL as given. I use this all the time for testing and for localhost one-page apps, but is a Very Bad Idea ™ for a real on-the-internet

[PHP-DB] Re: Program Dies

2012-10-15 Thread Jim Giner
On 10/14/2012 5:57 PM, Ethan Rosenberg, PhD wrote: Dear List - Thank you ever so much for all your help. I apologize in advance for dumping all this code on you. I cannot get any debugger to work for me [see my separate email on debuggers]. I placed numerous echo and print_r statements in the

[PHP-DB] Debuggers

2012-10-14 Thread Ethan Rosenberg, PhD
Dear list. I am running Debian 6 (sid) and Firefox 15.0 I have three debuggers: Firebug - I have never been able to make it step thru the code. Aptana - Aptana Firefox extension launching...please wait. Never goes beyond this point. Netbeans - 1]Will only give a Java debugger. 2] No

[PHP-DB] Program Dies

2012-10-14 Thread Ethan Rosenberg, PhD
Dear List - Thank you ever so much for all your help. I apologize in advance for dumping all this code on you. I cannot get any debugger to work for me [see my separate email on debuggers]. I placed numerous echo and print_r statements in the code, and could not find the error. The

Re: [PHP-DB] Debuggers

2012-10-14 Thread Bastien
Bastien Koert On 2012-10-14, at 5:57 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear list. I am running Debian 6 (sid) and Firefox 15.0 I have three debuggers: Firebug - I have never been able to make it step thru the code. Aptana - Aptana Firefox extension

Re: [PHP-DB] Program Dies

2012-10-14 Thread Matijn Woudt
On Sun, Oct 14, 2012 at 11:57 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: Dear List - Thank you ever so much for all your help. I apologize in advance for dumping all this code on you. I cannot get any debugger to work for me [see my separate email on debuggers]. I

Re: [PHP-DB] Program Dies

2012-10-14 Thread Karl DeSaulniers
On Oct 14, 2012, at 4:57 PM, Ethan Rosenberg, PhD wrote: Dear List - Thank you ever so much for all your help. I apologize in advance for dumping all this code on you. I cannot get any debugger to work for me [see my separate email on debuggers]. I placed numerous echo and print_r

[PHP-DB] Re: MySQL, stored procedures, SIGNAL/RESIGNAL

2012-10-08 Thread Marco Baumgartl
Just for the archive: problem was caused because the query returned multiple result sets (which is not supported by PDO). If the stored procedures only return one result set, everything works fine. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] DB Modeling . Help!

2012-10-05 Thread Bruno Sandivilli
Hi, some week's ago i was having a querying problem, it was i nightmare. Now i'm i have the same modeling problem. But his time i've stopped to think before. Right Here we go: It's 'simple'. I have a simple datagrid (5 columns x 50 rows). Each row have a label and the 5 columns values.How can i

[PHP-DB] MySQL, stored procedures, SIGNAL/RESIGNAL

2012-09-28 Thread Marco Baumgartl
Hi! I'm currently developing an application which makes heave use of stored procedures, stored functions and MySQL's SIGNAL/RESIGNAL feature. Everything works great if I call only one stored procedure. But if I call a stored procedure which calls another stored procedure or function,

Re: [PHP-DB] Prepared Statements - Select - Bind Parameters w/ correction

2012-09-28 Thread Matt Pelmear
$stmt = mysqli_stmt_prepare( $cxn, $sql12 );// line 507 //Warning: mysqli_stmt_prepare() expects parameter 1 to be mysqli_stmt, object given in /var/www/x5.php on line 507 $cxn is not a mysqli_stmt. Are you perhaps passing the mysqli database resource instead of the statement? See

[PHP-DB] Activating the mysql_clear_password plugin

2012-09-27 Thread Pierre-Gildas MILLON
Hi everyone, I need to use the mysql_clear_password plugin. I'm using the CentOS php 5.3.3 and manually recompiled the mysql mysqli extensions with the Oracle MySQL 5.5 libraries. According to the MySQL documentation (

Re: [PHP-DB] Activating the mysql_clear_password plugin

2012-09-27 Thread Niel Archer
Hi everyone, I need to use the mysql_clear_password plugin. I'm using the CentOS php 5.3.3 and manually recompiled the mysql mysqli extensions with the Oracle MySQL 5.5 libraries. According to the MySQL documentation (

Re: [PHP-DB] Activating the mysql_clear_password plugin

2012-09-27 Thread Niel Archer
Hi You could try using mysqli_options(), but I do not know if that supports this setting yet. The PHP documentation does not mention it, and I am unable to test it myself at the moment. Just occured to me, even if the setting is not directly supported yet, you can create a separate

[PHP-DB] Prepared Statements - Select - Bind Parameters

2012-09-27 Thread Ethan Rosenberg, PhD
Dear list - Thanks to all for your help. I hope [??] that this question will solve all the remaining problems. So that we are on the same page, here is what was previously stated. mysqli_stmt_bind_param expects three variables, in this order mysqli_stmt_bind_param($stmt, num, $a, $b,

Re: [PHP-DB] Activating the mysql_clear_password plugin

2012-09-27 Thread Pierre-Gildas MILLON
Hi, Many thanks for your quick answer. I tried what you suggest by modifying the phpMyAdmin code and it works great ! Thank you very much ! Le 27/09/2012 17:55, Niel Archer a écrit : Hi You could try using mysqli_options(), but I do not know if that supports this setting yet. The PHP

[PHP-DB] Prepared Statements - Select - Bind Parameters w/ correction

2012-09-27 Thread Ethan Rosenberg, PhD
Dear list - SEE CORRECTION IN $_POST VARIABLE BELOW. Thanks to all for your help. I hope [??] that this question will solve all the remaining problems. So that we are on the same page, here is what was previously stated. mysqli_stmt_bind_param expects three variables, in this order

[PHP-DB] Re: Prepared Statements - Select - Bind Parameters w/ correction

2012-09-27 Thread Jim Giner
On 9/27/2012 12:40 PM, Ethan Rosenberg, PhD wrote: Dear list - SEE CORRECTION IN $_POST VARIABLE BELOW. Thanks to all for your help. I hope [??] that this question will solve all the remaining problems. So that we are on the same page, here is what was previously stated.

Re: [PHP-DB] Prepared Statements - Select - Bind Parameters w/ correction

2012-09-27 Thread Matt Pelmear
Ethan, Please accept my apologies for the minor errors in the untested code I previously provided for your edification. Consider the following tested code: ?php /* CREATE TABLE test (id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT, data INT UNSIGNED); INSERT INTO test (data) VALUES

[PHP-DB] Re: [PHP] Vulnerability Announced in phpMyAdmin

2012-09-26 Thread tamouse mailing lists
On Tue, Sep 25, 2012 at 3:20 PM, Daniel Brown danbr...@php.net wrote: Just a three-list cross-post to bring it to everyone's attention at once, in case you weren't already aware. It was announced today that a compromised SourceForge mirror was distributing a malicious file with the

[PHP-DB] php code for sending SMS

2012-09-26 Thread Dr Vijay Kumar
I wish to send a SMS to a mobile no. thru PHP/HTML. Any suggestions Please? -- Dr Vijay Kumar, E 9/18 Vasant Vihar, New Delhi-110 057 Ph: 09868 11 5354, 011-2615 4488 Email :Dr Vijay Kumarvaibhavinformat...@gmail.com

[PHP-DB] Re: [PHP] Vulnerability Announced in phpMyAdmin

2012-09-26 Thread Daniel Fenn
Thank you for the heads up. On 9/26/12, tamouse mailing lists tamouse.li...@gmail.com wrote: On Tue, Sep 25, 2012 at 3:20 PM, Daniel Brown danbr...@php.net wrote: Just a three-list cross-post to bring it to everyone's attention at once, in case you weren't already aware. It was announced

Re: [PHP-DB] php code for sending SMS

2012-09-26 Thread tamouse mailing lists
On Wed, Sep 26, 2012 at 1:18 AM, Dr Vijay Kumar vaibhavinformat...@gmail.com wrote: I wish to send a SMS to a mobile no. thru PHP/HTML. Any suggestions Please? Try an email - SMS gateway? http://en.wikipedia.org/wiki/List_of_SMS_gateways -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] opening error messages in a new window

2012-09-26 Thread Dr Vijay Kumar
In filling a form, error messages should come in a new widow while retaining the form filled on the screen. Coding in php is required. -- Dr Vijay Kumar, E 9/18 Vasant Vihar, New Delhi-110 057 Ph: 09868 11 5354, 011-2615 4488 Email :Dr Vijay Kumarvaibhavinformat...@gmail.com

[PHP-DB] Re: opening error messages in a new window

2012-09-26 Thread Jim Giner
On 9/26/2012 4:41 AM, Dr Vijay Kumar wrote: In filling a form, error messages should come in a new widow while retaining the form filled on the screen. Coding in php is required. If I read your rather terse message correctly, you are looking for a way to provide error responses to the user

Re: [PHP-DB] opening error messages in a new window

2012-09-26 Thread Jim Giner
On 9/26/2012 9:35 AM, Jimi Thompson wrote: So tell the error message to open in a target=_blank On Wed, Sep 26, 2012 at 3:41 AM, Dr Vijay Kumar vaibhavinformat...@gmail.com wrote: In filling a form, error messages should come in a new widow while retaining the form filled on the screen.

Re: [PHP-DB] opening error messages in a new window

2012-09-26 Thread Matijn Woudt
On Wed, Sep 26, 2012 at 10:41 AM, Dr Vijay Kumar vaibhavinformat...@gmail.com wrote: In filling a form, error messages should come in a new widow while retaining the form filled on the screen. Coding in php is required. -- PHP can't do anything 'onscreen'. If you want to do anything

[PHP-DB] Vulnerability Announced in phpMyAdmin

2012-09-25 Thread Daniel Brown
Afternoon, folks; Just a three-list cross-post to bring it to everyone's attention at once, in case you weren't already aware. It was announced today that a compromised SourceForge mirror was distributing a malicious file with the phpMyAdmin package that allows an attacker to arbitrarily

[PHP-DB] Re: Unsubscribe me Please

2012-09-24 Thread Daniel Brown
On Fri, Sep 21, 2012 at 11:17 PM, Sam js...@yahoo.com wrote: I saw where you did it for others. I will just block your address thx Sent from Sam's IPad And yet you missed that I said I wouldn't be doing it in lieu of following the obvious unsubscription instructions. Please do block all

Re: [PHP-DB] Why the sudden dis-interest?

2012-09-23 Thread Govinda
What's with all the people suddenly wanting to unsubscribe? Did they suddenly become experts - no longer needing the community for support? Or did they suddenly discover they had actually enlisted for the influx of emails they were getting and wanted to stop them? Sure seems odd

[PHP-DB] Why the sudden dis-interest?

2012-09-21 Thread Jim Giner
What's with all the people suddenly wanting to unsubscribe? Did they suddenly become experts - no longer needing the community for support? Or did they suddenly discover they had actually enlisted for the influx of emails they were getting and wanted to stop them? Sure seems odd -- PHP

Re: [PHP-DB] Why the sudden dis-interest?

2012-09-21 Thread Rikin Parekh
I am happy with this community. I get a lot of new things to learn daily. On Fri, Sep 21, 2012 at 10:07 AM, Jim Giner jim.gi...@albanyhandball.comwrote: What's with all the people suddenly wanting to unsubscribe? Did they suddenly become experts - no longer needing the community for support?

Re: [PHP-DB] Why the sudden dis-interest?

2012-09-21 Thread tebz_jeyam navam
I feel the same, I'm happy to receive all this emails as sometimes I'm able to help them and I learn new things Jey -- -Original Message- From: Rikin Parekh riki...@gmail.com Date: Fri, 21 Sep 2012 14:14:03 To: jim.gi...@albanyhandball.com Cc: php-db@lists.php.net

Re: [PHP-DB] Unsubscribe me please

2012-09-21 Thread Daniel Brown
On Thu, Sep 20, 2012 at 9:29 PM, Alan Vickers alanvick...@cox.net wrote: Please remove me, too. Thanks! Please follow the unsubscription instructions as posted all over, included in the foot of every single list message, and as I posted twice in this thread yesterday. -- /Daniel P. Brown

Re: [PHP-DB] Prepared Statements - Select

2012-09-21 Thread Matt Pelmear
Ethan, I believe the root of your problem is that you are passing $bind3 as a string to mysqli_stmt_bind_param() where the function was expecting multiple arguments. Let's say $binder = array( 'one', 'two', 'three' ); // I'll call this $arguments in my example below and $typer = array(

Re: [PHP-DB] Why the sudden dis-interest?

2012-09-21 Thread tamouse mailing lists
Some of them may not end up being PHP + DB programmers? Or joined under mistaken expectations? Or thought it might be a good idea at the time and ended up doing something else? Lots of possible reasons. Given the inability of the folk to figure out *how* to unsubscribe, I'd suspect rather limited

Re: [PHP-DB] Why the sudden dis-interest?

2012-09-21 Thread David McGlone
On Friday, September 21, 2012 10:07:56 AM Jim Giner wrote: What's with all the people suddenly wanting to unsubscribe? Did they suddenly become experts - no longer needing the community for support? Or did they suddenly discover they had actually enlisted for the influx of emails they were

RE: [PHP-DB] Unsubscribe me please

2012-09-20 Thread Michel BUYSE
Unsubscribe me too m...@marvol.be -Oorspronkelijk bericht- Van: Paul Clark [mailto:p...@leckytech.com] Verzonden: donderdag 20 september 2012 7:13 Aan: php-db@lists.php.net Onderwerp: Re: [PHP-DB] Unsubscribe me please Unsubscribe me too leckyt...@gmail.com On 19 September 2012 23:43,

Re: [PHP-DB] Unsubscribe me please

2012-09-20 Thread Richard
Me too Sent from my iPad On Sep 19, 2012, at 9:18 PM, Michel BUYSE m...@marvol.be wrote: Unsubscribe me too m...@marvol.be -Oorspronkelijk bericht- Van: Paul Clark [mailto:p...@leckytech.com] Verzonden: donderdag 20 september 2012 7:13 Aan: php-db@lists.php.net Onderwerp: Re:

[PHP-DB] Unsubscribe me please

2012-09-20 Thread WHealy
Me too (whe...@eircom.ie) *** The information contained in this e-mail and any files transmitted with it is confidential and may be subject to legal professional privilege. It is intended solely for the use of the addressee(s). If

Re: [PHP-DB] Re: Many columns (as FK) vs 3x more Columns (in the same table)

2012-09-20 Thread Bruno Sandivilli
We are getting closer. But I'll give some image to better ilustrate: http://177.71.185.219/stable/anexos/505b18fc713f8imagem.png this is my table in Flex, the fields are in portuguese so 'ignore' it. 2012/9/19 Matt Pelmear mjpelm...@gmail.com Bruno, This schema layout seems a little odd

Re: [PHP-DB] Unsubscribe me please

2012-09-20 Thread Daniel Brown
On Wed, Sep 19, 2012 at 6:43 PM, Graham H. mene...@gmail.com wrote: Hi, I tried unsubscribing from the list, but I was unsuccessful, I believe because when I subscribed I cleverly added +php to the end of my email address (for Gmail filtering). Could I be removed please? Thanks. No

Re: [PHP-DB] Unsubscribe me please

2012-09-20 Thread Daniel Brown
On Thu, Sep 20, 2012 at 11:51 AM, Valentin Nedkov mana...@bds.bg wrote: Hello, please, unsubscribe me too. Sure. It seems no one knows the unsubscription instructions. So, for all others: From your subscribed email address, send a blank message to

Re: [PHP-DB] Unsubscribe me please

2012-09-20 Thread tamouse mailing lists
On Thu, Sep 20, 2012 at 3:37 AM, whe...@eircom.ie wrote: Me too (whe...@eircom.ie) *** The information contained in this e-mail and any files transmitted with it is confidential and may be subject to legal professional

Re: [PHP-DB] Unsubscribe me please

2012-09-20 Thread Alan Vickers
Please remove me, too. Thanks! On Thu, Sep 20, 2012 at 8:43 AM, Daniel Brown danbr...@php.net wrote: On Wed, Sep 19, 2012 at 6:43 PM, Graham H. mene...@gmail.com wrote: Hi, I tried unsubscribing from the list, but I was unsuccessful, I believe because when I subscribed I cleverly added

[PHP-DB] Re: Many columns (as FK) vs 3x more Columns (in the same table)

2012-09-19 Thread Bruno Sandivilli
Anyone? Please. 2012/9/18 Bruno Sandivilli bruno.sandivi...@gmail.com Hi, i strugling to decide what is the best choice: I have a 15 row x 3 columns Flash DataGrid, it means, for each row i have 3 values. To represent this in my Database, I could: 1. Create 2 Tables : A Values table -

Re: [PHP-DB] Re: Many columns (as FK) vs 3x more Columns (in the same table)

2012-09-19 Thread Matt Pelmear
I'm a little confused here. You have a 15x3x3 set of data to display in a 3 column, 15 row datagrid? Are you displaying a single value in each cell of the datagrid, or all 3 values for the cell? How many variables are needed to uniquely select a piece of data from that 3-dimensional space?

[PHP-DB] Re: Many columns (as FK) vs 3x more Columns (in the same table)

2012-09-19 Thread Jim Giner
On 9/18/2012 8:52 AM, Bruno Sandivilli wrote: Hi, i strugling to decide what is the best choice: I have a 15 row x 3 columns Flash DataGrid, it means, for each row i have 3 values. To represent this in my Database, I could: 1. Create 2 Tables : A Values table - with 3 columns ; and a Bill

[PHP-DB] Re: Many columns (as FK) vs 3x more Columns (in the same table)

2012-09-19 Thread Jim Giner
On 9/19/2012 3:12 PM, Jim Giner wrote: On 9/18/2012 8:52 AM, Bruno Sandivilli wrote: Hi, i strugling to decide what is the best choice: I have a 15 row x 3 columns Flash DataGrid, it means, for each row i have 3 values. To represent this in my Database, I could: 1. Create 2 Tables : A

Re: [PHP-DB] Re: Many columns (as FK) vs 3x more Columns (in the same table)

2012-09-19 Thread Bruno Sandivilli
Sorry for the lack of explanation. Again: I have to model a bill table. The bill have 20 fields. But for each field we have: *registered* value, *billed *value and* total value.* So i've created an *bill* table with *20 *fields (representing the bill fields, like: consumption, demand, etc ),

Re: [PHP-DB] Re: Many columns (as FK) vs 3x more Columns (in the same table)

2012-09-19 Thread Matt Pelmear
Bruno, This schema layout seems a little odd to me. Maybe I'm just misunderstanding the use. Correct me if I'm wrong here: Each row in the bill table is a customer? (or some other lookup value for which you're generating the data grid?) I assume the 15 fields from your original message are

[PHP-DB] Unsubscribe me please

2012-09-19 Thread Graham H.
Hi, I tried unsubscribing from the list, but I was unsuccessful, I believe because when I subscribed I cleverly added +php to the end of my email address (for Gmail filtering). Could I be removed please? Thanks. -- Graham Holtslander Computer Systems Technologist www.graham.holtslander.com

[PHP-DB] Prepared Statements - Select

2012-09-19 Thread Ethan Rosenberg, PhD
Dear List - Thanks to all for your responses. Here is another one I wish to accomplish the following mysqli_stmt_bind_param($stmt, 'sis', $_POST['Site'], $_POST['MedRec'], $_POST['Sex']); This statemnt was hand coded. I wish to be able to generalize it. Therefore - $sql11 =

Re: [PHP-DB] Unsubscribe me please

2012-09-19 Thread Paul Clark
Unsubscribe me too leckyt...@gmail.com On 19 September 2012 23:43, Graham H. mene...@gmail.com wrote: Hi, I tried unsubscribing from the list, but I was unsuccessful, I believe because when I subscribed I cleverly added +php to the end of my email address (for Gmail filtering). Could I be

[PHP-DB] Many columns (as FK) vs 3x more Columns (in the same table)

2012-09-18 Thread Bruno Sandivilli
Hi, i strugling to decide what is the best choice: I have a 15 row x 3 columns Flash DataGrid, it means, for each row i have 3 values. To represent this in my Database, I could: 1. Create 2 Tables : A Values table - with 3 columns ; and a Bill table (with 15 foreign keys, each one

[PHP-DB] Prepared Statements - Search

2012-09-13 Thread Ethan Rosenberg, PhD
Dear List - Here is another problem I am having with prepared statements. The last one was INSERT, this one is SELECT. Here is the database: mysql describe Intake3; ++-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra |

Re: [PHP-DB] Prepared Statements - Search

2012-09-13 Thread Fjalar Sigurðarson
Does the list of the SELECT fields not have to match the variables you are binding? E.g. if you do not include MedRec in your SELECT then you have no MedRec data to bind from your $sql11 variable to the $MedRec varable and then nothing to print there... or what? Am I just fabulating? :). Cheers,

Re: [PHP-DB] Re: Problems w/ insert -- SOLVED!!!

2012-09-13 Thread Ethan Rosenberg, PhD
Dear list - Thanks to all. It now works! The problem, as you correctly noted, was the erroneous inclusion of the bind-results statement. Removed that and it worked!! Thanks again! Ethan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Re: Problems w/ insert -- SOLVED!!!

2012-09-13 Thread Jim Giner
On 9/13/2012 9:15 PM, Ethan Rosenberg, PhD wrote: Dear list - Thanks to all. It now works! The problem, as you correctly noted, was the erroneous inclusion of the bind-results statement. Removed that and it worked!! Thanks again! Ethan Methinks Ethan is thanking the group for assistance

[PHP-DB] Prepared Statements - Search -- SOLVED!!!

2012-09-13 Thread Ethan Rosenberg, PhD
Dear List - -- THANKS TO ALL. See below -- Here is another problem I am having with prepared statements. The last one was INSERT, this one is SELECT. Here is the database: mysql describe Intake3; ++-+--+-+-+---+ | Field | Type| Null | Key |

[PHP-DB] Unsubscribing

2012-09-11 Thread Aaron Wood - Slurpy Studios
Hello, I have been trying to unsubscribe from this list, but it doesn't seem to be stopping - could you look into it for me and take me off the list? Many thanks! Aaron Wood

Re: [PHP-DB] Re: Adding entry to /dev

2012-09-11 Thread tamouse mailing lists
On Mon, Sep 10, 2012 at 11:27 PM, Jim Giner jim.gi...@albanyhandball.com wrote: On 9/10/2012 7:41 PM, Ethan Rosenberg, PhD wrote: Dear list - How do I add a new entry to /dev; eg, /dev/sdb? Thanks, Ethan Rosenberg Ethan, Sometimes google is great at answering this kind of stuff. Did

confirm subscribe to php-db@lists.php.net

2012-09-11 Thread php-db-help
Hi! This is the ezmlm program. I'm managing the php-db@lists.php.net mailing list. I'm working for my owner, who can be reached at php-db-ow...@lists.php.net. To confirm that you would like arch...@mail-archive.com added to the php-db mailing list, please send an empty reply to this

Re: [PHP-DB] Unsubscribing

2012-09-11 Thread Daniel Brown
On Tue, Sep 11, 2012 at 3:37 AM, Aaron Wood - Slurpy Studios aa...@slurpystudios.com wrote: Hello, I have been trying to unsubscribe from this list, but it doesn't seem to be stopping - could you look into it for me and take me off the list? I've removed you from php-db@lists.php.net

[PHP-DB] Another PDO ?

2012-09-10 Thread Jim Giner
Reading up on the pdostatement class. Wondering what the intent of the columnCount function is. I mean, aren't the number of columns in a result known when you write the query? Granted, you might have some very complex query that you may not know the number, but for most queries you will

[PHP-DB] Re: PDO user question

2012-09-10 Thread Jim Giner
On 9/8/2012 2:02 PM, Jim Giner wrote: I finally delved into learning how I was going to replace my MYSQL calls with a different interface. Had to go with PDO since my hoster doesn't support MYSQLI for my plan. I've had some success with querying using pdo and prepared statements as well. One

Re: [PHP-DB] Another PDO ?

2012-09-10 Thread Bastien Koert
On Mon, Sep 10, 2012 at 9:48 AM, Jim Giner jim.gi...@albanyhandball.com wrote: Reading up on the pdostatement class. Wondering what the intent of the columnCount function is. I mean, aren't the number of columns in a result known when you write the query? Granted, you might have some very

Re: [PHP-DB] Another PDO ?

2012-09-10 Thread Jim Giner
On 9/10/2012 10:49 AM, Bastien Koert wrote: On Mon, Sep 10, 2012 at 9:48 AM, Jim Giner jim.gi...@albanyhandball.com wrote: Reading up on the pdostatement class. Wondering what the intent of the columnCount function is. I mean, aren't the number of columns in a result known when you write the

Re: [PHP-DB] Another PDO ?

2012-09-10 Thread Graham H.
I think it's so that you could write functions as generically as possible. So you don't have to pass in the number of columns or hard code in values for number of columns, you can dynamically check the column count for each result set that gets passed in. That's my guess. On Mon, Sep 10, 2012 at

Re: [PHP-DB] Another PDO ?

2012-09-10 Thread Jim Giner
On 9/10/2012 10:53 AM, Graham H. wrote: I think it's so that you could write functions as generically as possible. So you don't have to pass in the number of columns or hard code in values for number of columns, you can dynamically check the column count for each result set that gets passed in.

Re: [PHP-DB] Another PDO ?

2012-09-10 Thread Bruno Sandivilli
Imagine if you are building a generic database framework, so you (dont have, but) can generalize your queries functions and abstract some tables info. 2012/9/10 Graham H. mene...@gmail.com I think it's so that you could write functions as generically as possible. So you don't have to pass in

Re: [PHP-DB] Another PDO ?

2012-09-10 Thread Lester Caine
Jim Giner wrote: On 9/10/2012 10:49 AM, Bastien Koert wrote: On Mon, Sep 10, 2012 at 9:48 AM, Jim Giner jim.gi...@albanyhandball.com wrote: Reading up on the pdostatement class. Wondering what the intent of the columnCount function is. I mean, aren't the number of columns in a result known

<    2   3   4   5   6   7   8   9   10   11   >