[PHP-DB] Re: UPDATE query

2011-03-19 Thread Jim Giner
to be correct you really should NOT append the 1 to any phone number. That 1 is not actually part of the number, it is merely a tool used by land-line phones that triggers the long distance feature. If you use a cell phone, you already know that you don't use a '1' when making a

[PHP-DB] testing

2011-03-19 Thread Jim Giner
first time poster -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] error

2011-04-07 Thread Jim Giner
The two query statements are different - in one you quote $id and in the other you don't. It is definitely a mysql error so it's not the line you suggested. Karl DeSaulniers k...@designdrumm.com wrote in message news:6fe62364-f9fc-4612-8c5d-6ce48fc66...@designdrumm.com... I believe this line

[PHP-DB] Re: automactic email notification

2011-04-13 Thread Jim Giner
Without looking at your HUGE code stream, I'm curious what your question really is. If you know how to send an email, and you know how to update your table, then isn't your task simply to send an email after updating the table? I would make the email a function to get it out of the way and

Re: [PHP-DB] Re: automactic email notification

2011-04-13 Thread Jim Giner
Looking at all that code you already wrote, you're not that much of a newbie. Read up on functions. (A function is merely the same code you already run but it's set aside, out of the main execution path of your script, so that you can call it from anyplace that you need to execute that

[PHP-DB] Re: filter search

2011-04-19 Thread Jim Giner
First - I would change day,month,year to a date field called 'birthdate'. Then on the screen that the user chooses what to search for you let them enter 1 or 2 or 3 values: the 'name', the 'city' or the 'age' (in years). Then when you process that input, you determine what they entered - 1 or 2

[PHP-DB] Re: filter search

2011-04-19 Thread Jim Giner
No follow-up? I must have made complete sense!! :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: filter search

2011-04-20 Thread Jim Giner
Methinks you are correct. MAYBE I should have written the code too! Ken Kixmoeller kixjag...@comcast.net wrote in message news:banlktinmme9ws1ztrepum+fnmmsywan...@mail.gmail.com... On Tue, Apr 19, 2011 at 7:41 PM, Jim Giner jim.gi...@albanyhandball.com wrote:O No follow-up? I must have made

[PHP-DB] Re: Help with AVG()

2011-06-13 Thread Jim Giner
you have no WHERE clause in your query. Ron Piggott ron.pigg...@actsministries.org wrote in message news:F6C4EF096B4446CA8AECD201C1E86C39@RonPiggottPC... Hi Everyone I am trying to figure out how to write a SELECT query that will give me the average of `bible_anagrams`.`views` starting on the

[PHP-DB] Re: Help with AVG()

2011-06-14 Thread Jim Giner
Why not try setting vars to the date values you wish to select and use them in your where clause? You may have something wrong in this complex syntax. Something like: $st_date = today() ?? $end_date = $st_date less 7 days ?? Where rss_feed_date = $st_date and rss_feed_date = $end_date btw -

[PHP-DB] Re: mysql COUNT row results

2011-06-23 Thread Jim Giner
If you're looking for a count of ALL records, why do you want to append that to EACH record? Now if you're looking for a count of subscribers who have certain attributes (ie, unique groups of subscribers), then you would use a group by clause and include the attributes that define the group in

[PHP-DB] Re: radio form submission

2011-06-23 Thread Jim Giner
Try reading a good html reference on how radio buttons work. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: radio form submission

2011-06-23 Thread Jim Giner
If you put the 0-250kbps as the value= of your html input tag, php would give you that when you did this: $rb_picked = $_POST['post_tptest']. No need for a switch or anything to re-interpret what the user picked. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Re: radio form submission

2011-06-24 Thread Jim Giner
The error is pretty explicit - there is no field in your table called '250kbps'. What you should have is a field (column) called speed for example, with values from 1...5 or whatever. To the users they will only deal with actual speed values on their screen if you use the speeds as the value

[PHP-DB] Re: Listing parent ids

2011-07-28 Thread Jim Giner
Arno Kuhl a...@dotcontent.net wrote in message news:487F03135D2B452B89F22C95E278C7D4@point01... I have a table with an id and a parentid. If it's a top-level record the parentid is 0, otherwise it points to another record, and if that record isn't a top-level record its parentid points to

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

2011-07-28 Thread Jim Giner
Arno Kuhl a...@dotcontent.net wrote in message news:D349CC15D13F48DD8D4F6ED70062138C@point01... Hi Jim. I wanted the list of related parentids from current id to top-level (parentid=0). Ah - now that is a much different question! From your statement above, are you now saying you

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

2011-07-28 Thread Jim Giner
Arno Kuhl a...@dotcontent.net wrote in message news:DB930522404B4552B8A15AF991C57E30@point01... Hi Jim. Only one linked list of parentids. No siblings. Multiple records can have the same parentid, but that doesn't play a role. Okay. So you want only one 'family tree' at any given time, and

[PHP-DB] Re: clues to cache-like behavior

2011-08-09 Thread Jim Giner
So you're saying a page refresh in your browser doesn't cure the problem? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: clues to cache-like behavior

2011-08-10 Thread Jim Giner
With IE, a refresh is F5 or even better, ctrl-F5. Should always get the latest updates. Or you could add: header(Cache-Control: no-cache); at the beginning of your php code. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: clues to cache-like behavior

2011-08-10 Thread Jim Giner
HTH! One thing - you should remove it after doing your development so that users can take advantage of caching on their systems. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

2011-08-25 Thread Jim Giner
First glance: your 'if' needs '= =' not '=' -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Working with large datasets

2011-10-10 Thread Jim Giner
Toby Hart Dyke t...@hartdyke.com wrote in message news:00da01cc8768$ca9e9200$5fdbb600$@hartdyke.com... It sounds as though you don't have an index on the right field. 8 million records should be no problem if you have the right indexes applied, and you're not trying to do anything too

Re: [PHP-DB] Working with large datasets

2011-10-10 Thread Jim Giner
I don't do command line stuff so I may not be right in my thinking. If you are running a php query from a client, does the query get executed on the database server, or does all the data have to come down to you to be queried? -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Working with large datasets

2011-10-10 Thread Jim Giner
When you say machine, do you mean the client that you're sitting at, or the machine that hosts the data? As for doing it thru a web server, the amount of time Apache, et al, would consume is miniscule. The web interface would not be involved in the reading of the data or the processing, just

Re: [PHP-DB] Working with large datasets

2011-10-11 Thread Jim Giner
Exactly. That was my first guess - that his commandline request is first having to download 8M records which can take a long time. The OP's fear of overhead from apache... is not only unfounded, but would most definitely improve his response by simply running the query on the server and avoid

[PHP-DB] Re: Need some help with PHP coding

2011-10-12 Thread Jim Giner
What makes you think it's a PHP problem? It could be that you modified the location of the video file and the href= is wrong. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Need some help with PHP coding

2011-10-12 Thread Jim Giner
Looking at your site's webpage code, I do not see any reference to any .AVI files. If it's a PHP problem, you should be looking at the portion of your code that is supposed to be outputting that file and html during the build of this webpage. -- PHP Database Mailing List

[PHP-DB] Re: SELECT

2011-10-17 Thread Jim Giner
I would do it this way: Where $sel_d = (the day # you want) $sel_m = (the month # you want) The where clause would be: Where (start_month = $sel_m and start_day = $sel_d) and (end_month = $sel_m and end_day = $sel_d) Someone else will probably have something more elegant, but I

Re: [PHP-DB] SELECT

2011-10-18 Thread Jim Giner
Ron - Mike here is correct. I gave you a start, but it had a problem with it. Hope I didn't have you running around too much. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Exporting mySQL to Excel

2011-11-09 Thread Jim Giner
The problem you are describing is where the fields are not enclosed in quotes. Are you specifying to enclose alpha type fields in quotes, and leaving number-only fields without? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem with mysql and php

2011-11-29 Thread Jim Giner
Didn't the OP begin this very same subject a month ago? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Problem with mysql and php

2012-01-08 Thread Jim Giner
Sounds to me like you really need to study database design. 30 years of doing it professionally, never heard of a design that involved what you are suggesting. Good luck! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Receiving Error- Error: user account already exists..

2012-01-10 Thread Jim Giner
if (isset($_POST['Submit']) =='Register') I don't understand why you are using isset on your post vars. Since isset returns a boolean value, how can you compare that to a string? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: Multiple Access to Database

2012-01-15 Thread Jim Giner
aren't you talking about writing a couple of php scripts to present them with the appropriate abilities? This is a php list, so I'm thinking you are writing php code to provide access.You set up a security on the script which prevents one user from using the other's script. You can't

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Jim Giner
I agree with Martin's assessment. Took me awhile to always remember to have the date in the correct format. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Jim Giner
I think MySQL wants the date in -M-D format, did you try changing $Date = date('M d Y'); to $Date = date('Y-m-d'); - Matijn Tru dat. But mySql doesn't want the dashes embedded. The format string should be Ymd instead. -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Jim Giner
=== Martijn Jim - Is it just the date that is the problem? Yes. Tru dat. But mySql doesn't want the dashes embedded. The format string should be Ymd instead. That's what I am doing. No luck. Ethan * You're using a format with just Ymd in it (no dashes)? Can you post

Re: [PHP-DB] search of data base - again

2012-03-30 Thread Jim Giner
Jim Giner jim.gi...@albanyhandball.com wrote in message news:E44A0D84E492452DAB2BDEBC4C4B8A58@laptop2... === Martijn Jim - Is it just the date that is the problem? Yes. Tru dat. But mySql doesn't want the dashes embedded. The format string should be Ymd instead. That's

[PHP-DB] Re: foreach

2012-04-05 Thread Jim Giner
I don't know about others, but I can't make sense of this - way too much presented with no idea of what I am looking at - code or output. One thing: $_Request is not the same var as $_REQUEST. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Jim Giner
why don't you try it and see? (altho I suspect that using 'count' as the result field name might not work, and that having column names with spaces in them will require quotes around them.) Rikin Parekh riki...@gmail.com wrote in message

Re: [PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Jim Giner
Rikin Parekh riki...@gmail.com wrote in message news:fad9d02d-2add-4a31-b118-81d56183e...@gmail.com... This is the sample data provided to me. I need to query this data only. And column name can be without spaces. I need to know the query that will give me the result irrespective of the syntax

Re: [PHP-DB] Re: Need help with SQL Query

2012-04-13 Thread Jim Giner
Rikin Parekh rpare...@umd.edu wrote in message news:CALbBjtctPawe=qyuvqWZvG3nq_Tw7PwKoe-hhi5fkYGec=6...@mail.gmail.com... I got the answer. My query works perfectly fine. Earlier I had problems in configuring mySQL Workbench so I could not try. Thank you guys. Rikin No thanks necessary.

[PHP-DB] Re: [PHP] PHP Database Problems -- Code Snippets - Any more Ideas?

2012-05-04 Thread Jim Giner
I don't think posting the same voluminous code is going to generate any better responses. The suggestion to start over and make your insert/retrieve queries fool proof before starting to write some logic into your code was a very good one. Why don't you work on that so that any requests for

[PHP-DB] Re: Database Problems

2012-06-17 Thread Jim Giner
Ethan Rosenberg eth...@earthlink.net wrote in message news:0m5r005qyzrnm...@mta6.srv.hcvlny.cv.net... Dear List - The same query in a PHP program will only give me results for MedRec 10003 why the where 1 clause? Do you know what that is for? -- PHP Database Mailing List

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Jim Giner
Ethan Rosenberg eth...@earthlink.net wrote in message news:0m5s00mgd2bh7...@mta1.srv.hcvlny.cv.net... At 03:30 PM 6/17/2012, Jim Giner wrote: Ethan Rosenberg eth...@earthlink.net wrote in message news:0m5r005qyzrnm...@mta6.srv.hcvlny.cv.net... Dear List - The same query in a PHP

Re: [PHP-DB] Re: Database Problems

2012-06-17 Thread Jim Giner
Matijn Woudt tijn...@gmail.com wrote in message news:cac_gtup8fjuv7jyut89w2491nm-7zno8mrj3w0mep6totm2...@mail.gmail.com... On Sun, Jun 17, 2012 at 10:21 PM, Jim Giner jim.gi...@albanyhandball.com wrote: Ethan Rosenberg eth...@earthlink.net wrote in message news:0m5s00mgd2bh7...@mta1

[PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-24 Thread Jim Giner
At the risk of being unable to understand all the posts that are here already, here is some std. code that I use when I'm uploading a file. First - i capture the input field in a local var and all of its components in other local vars to make my coding easier later on. $inputfield =

Re: [PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-24 Thread Jim Giner
On 7/24/2012 12:05 PM, Graham H. wrote: Does the problem have anything to do with this: [tmp_name]= string(14) /tmp/phpcLtE6W So this: $file = $_FILES[file][tmp_name]; Would make $file == /tmp/phpcLtE6W I'm not sure if that's what you want. Seems more likely that you'd want it to be:

[PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-24 Thread Jim Giner
On 7/24/2012 4:16 AM, Brad wrote: $file = $_FILES['file']['name']; //$presql = CREATE TABLE IF NOT EXISTS (`$_SESSION[SESS_MEMBER_ID]_$file`); $presql = CREATE TABLE IF NOT EXISTS `$_SESSION[SESS_MEMBER_ID]_$file`;

Re: [PHP-DB] Re: Stuck trying to upload and grab file name

2012-07-24 Thread Jim Giner
On 7/24/2012 12:40 PM, Graham H. wrote: If by the line you mean: [tmp_name]= string(14) /tmp/phpcLtE6W That is from the bottom of this Pastie link: http://pastie.org/4317155 $file = $_FILES[file][tmp_name]; I meant the above line. -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Re: No data?

2012-07-26 Thread Jim Giner
Are you any closer to getting your solution to work yet? If not, could I ask for the general concept again? From what I can remember, You want to allow a user to upload a csv file which you will then put into a sql table. Additionally your code seems to be creating a new table for each file

Re: [PHP-DB] Re: No data?

2012-07-26 Thread Jim Giner
Not sure what you mean - Program reads array. What program is doing is utilizing the FILES element to get the info about the uploaded file and proceeds to finish the upload by moving it to a temporary folder of your creation. Once that is done you HAVE the file under whatever name you want

Re: [PHP-DB] Re: No data?

2012-07-27 Thread Jim Giner
On 7/27/2012 11:03 AM, Brad wrote: Even though my permissions are 777 in my /tmp I am trying to send the file to a tmp directory in my webroot and if I can even get it to create the file it has the wrong name of 'Array', and then it still does not update my database. ?php var_dump($_FILES);

Re: [PHP-DB] Re: Prepared Statements Insert Problem

2012-09-02 Thread Jim Giner
So do u have the revised code to show us? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Prepared Statements Insert Problem

2012-09-03 Thread Jim Giner
On 9/3/2012 2:44 AM, tamouse mailing lists wrote: On Sun, Sep 2, 2012 at 10:24 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: mysqli_stmt_bind_result(): Number of bind variables doesn't match number of fields in prepared statement What exactly is unclear about that? Actually

[PHP-DB] mysqli_connect ??

2012-09-07 Thread Jim Giner
Experimenting with prepared statements - trying out for the first time. I keep getting a fatal error on this statement: mysqli_connect(.) Message is: Fatal error: Call to undefined function mysqli_connect() in /home/albany/php/sqli_db_connect_select.php on line 6 My host is running php

Re: [PHP-DB] mysqli_connect ??

2012-09-07 Thread Jim Giner
No - they are not. :( On 9/7/2012 1:32 PM, Bastien Koert wrote: On Fri, Sep 7, 2012 at 10:54 AM, Jim Giner jim.gi...@albanyhandball.com wrote: Experimenting with prepared statements - trying out for the first time. I keep getting a fatal error on this statement: mysqli_connect

[PHP-DB] PDO user question

2012-09-08 Thread Jim Giner
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 thing that I'm curious about is

[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 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

Re: [PHP-DB] Another PDO ?

2012-09-10 Thread Jim Giner
in. That's my guess. On Mon, Sep 10, 2012 at 8:51 AM, Jim Giner jim.gi...@albanyhandball.comwrote: 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

Re: [PHP-DB] Another PDO ?

2012-09-10 Thread Jim Giner
On 9/10/2012 11:10 AM, Lester Caine wrote: 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

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

2012-09-10 Thread Jim Giner
On 9/10/2012 8:29 PM, Karl DeSaulniers wrote: On Sep 10, 2012, at 7:06 PM, Ethan Rosenberg, PhD wrote: Dear list - Here is my code: $sql3 = select max(Indx) from Visit3; $result7 = mysqli_query($cxn, $sql3); $row7 = mysqli_fetch_array($result7, MYSQLI_BOTH);

[PHP-DB] Re: Problems w/ insert

2012-09-10 Thread Jim Giner
On 9/10/2012 8:06 PM, Ethan Rosenberg, PhD wrote: Dear list - Here is my code: $sql3 = select max(Indx) from Visit3; $result7 = mysqli_query($cxn, $sql3); $row7 = mysqli_fetch_array($result7, MYSQLI_BOTH); $Indx = $row7[0]; $sql2 =

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

2012-09-10 Thread Jim Giner
On 9/11/2012 12:04 AM, Matt Pelmear wrote: Ethan, I am curious why you are using mysqli_stmt_bind_result() on a statement that is an INSERT query? I don't use mysqli, but as I read the documentation it seems to me that this method is intended to bind results from a SELECT query into variables

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

2012-09-10 Thread Jim Giner
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 you try a search on your question. I did and found an answer in the fifth result

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] 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

[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

[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.

[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.

[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] 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 Jim Giner
: On 11/25/2012 12:56 PM, 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: if(isset

[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] Re: Prepared Statements - Search

2012-12-03 Thread Jim Giner
On 12/3/2012 2:30 PM, Ethan Rosenberg, PhD wrote: Dear List - I am trying to use prepared statements with the following code: $allowed_fields = array ('Cust_Num' = 'i', 'Fname' = 's', 'Lname' = 's', 'Street' = 's','City'= 's', 'State' = 's', 'Zip' =

[PHP-DB] Re: Prepared Statements - Search

2012-12-03 Thread Jim Giner
On 12/3/2012 2:30 PM, Ethan Rosenberg, PhD wrote: Dear List - I am trying to use prepared statements with the following code: $allowed_fields = array ('Cust_Num' = 'i', 'Fname' = 's', 'Lname' = 's', 'Street' = 's','City'= 's', 'State' = 's', 'Zip' =

[PHP-DB] Re: Programs not running

2013-01-03 Thread Jim Giner
On 1/3/2013 7:35 PM, Ethan Rosenberg, PhD wrote: Dear List - I am running sid on my Lenovo desktop and squeeze on my Dell laptop. The php.ini files are the same. The programs are the same except foro the locatioln of the password file and of a file to be read for parameters. The programs run

Re: [PHP-DB] Programs not running

2013-01-04 Thread Jim Giner
On 01/03/2013 08:54 PM, Ethan Rosenberg, PhD wrote: = I can't answer because I do not understand. ?php phpinfo(); ? gives the correct output. Ethan - whatever do you mean the phpinfo gives the correct output? Do you mean that you compared every line and found them to match

Re: [PHP-DB] Programs not running

2013-01-04 Thread Jim Giner
Is the failing one a .php file? jg On Jan 3, 2013, at 11:54 PM, Ethan Rosenberg, PhD erosenb...@hygeiabiomedical.com wrote: On 01/03/2013 10:14 PM, Matt Pelmear wrote: In addition to Jim's comments, Have you checked to see whether the permissions on all files are appropriate on

[PHP-DB] Re: Programs not Running - SOLVED

2013-01-06 Thread Jim Giner
On 1/6/2013 7:17 PM, Ethan Rosenberg, PhD wrote: Dear List - Thanks to all for your help. The problem was in this piece of code: require '/var/www/pass.inc'; $db = Store; $cxn = mysqli_connect($host,$user,$password,$db); if ( !$cxn ) { die(

[PHP-DB] Re: Preventing repetition of a Form

2013-01-07 Thread Jim Giner
On 1/7/2013 7:00 PM, Ethan Rosenberg, PhD wrote: Dear list - I have a program [*pseudo code*]: if(!isset($_REQUEST[welcome_already_seen])) { initialize variables } $errors_array = array(); if($_REQUEST[welcome_already_seen]==

[PHP-DB] PDO ?

2013-01-15 Thread Jim Giner
Doing some conversion - looking for a solution. Currently I do something like this: while (list($var1,$var2) = mysql_fetch_array($qrslts)) { handle the vars } Is there something in the PDO functions that emulates this same ability? Some of my uses of the sql syntax have many more vars

[PHP-DB] Re: PDO ?

2013-01-15 Thread Jim Giner
Never Mind A little careful re-reading of the docs told me what I was doing wrong. I always use PDO::FETCH_ASSOC in my fetch statements. Discovered that I have to have numerical array results in order to utilize the List command. Voila! -- PHP Database Mailing List

[PHP-DB] pdo ?

2013-01-24 Thread Jim Giner
ok - new to using pdo functions, but I thought I had a handle on it. I'm writing out to my page an input tag with the following value in it: 49'ers I can confirm it by using my browser's view source to see that is exactly how it exists in the page. When I hit a submit button and my script

Re: [PHP-DB] pdo ?

2013-01-24 Thread Jim Giner
into your queries, I would recommend disabling it. -Matt On 01/24/2013 08:55 AM, Jim Giner wrote: ok - new to using pdo functions, but I thought I had a handle on it. I'm writing out to my page an input tag with the following value in it: 49'ers I can confirm it by using my browser's view source

Re: [PHP-DB] pdo ?

2013-01-24 Thread Jim Giner
On 1/24/2013 1:41 PM, Richard Quadling wrote: On 24 January 2013 17:48, Matt Pelmear mjpelm...@gmail.com wrote: On 01/24/2013 09:23 AM, Jim Giner wrote: On 1/24/2013 12:05 PM, Matt Pelmear wrote: http://stackoverflow.com/questions/5801951/does-php-auto-escapes-quotes-in-string-which

Re: [PHP-DB] pdo ?

2013-01-24 Thread Jim Giner
If you are using another web server or running PHP as FastCGI you may need to consider other options (changing the setting globally or doing a require_once() of your config changes?, or see the FastCGI example here: http://www.askapache.com/php/php-htaccess-tips-tricks.html) -Matt It sounds

Re: [PHP-DB] pdo ?

2013-01-24 Thread Jim Giner
On 1/24/2013 4:37 PM, Karl DeSaulniers wrote: On Jan 24, 2013, at 2:15 PM, Matt Pelmear wrote: On 01/24/2013 12:00 PM, Jim Giner wrote: On 1/24/2013 1:41 PM, Richard Quadling wrote: On 24 January 2013 17:48, Matt Pelmear mjpelm...@gmail.com wrote: On 01/24/2013 09:23 AM, Jim Giner wrote

Re: [PHP-DB] pdo ?

2013-01-24 Thread Jim Giner
On 1/24/2013 6:03 PM, Matt Pelmear wrote: On 01/24/2013 01:37 PM, Karl DeSaulniers wrote: On Jan 24, 2013, at 2:15 PM, Matt Pelmear wrote: On 01/24/2013 12:00 PM, Jim Giner wrote: On 1/24/2013 1:41 PM, Richard Quadling wrote: On 24 January 2013 17:48, Matt Pelmear mjpelm...@gmail.com wrote

Re: [PHP-DB] pdo ?

2013-01-24 Thread Jim Giner
On 1/24/2013 6:09 PM, Matt Pelmear wrote: On 01/24/2013 01:34 PM, Jim Giner wrote: If you are using another web server or running PHP as FastCGI you may need to consider other options (changing the setting globally or doing a require_once() of your config changes?, or see the FastCGI example

Re: [PHP-DB] pdo ?

2013-01-25 Thread Jim Giner
On 1/24/2013 7:07 PM, Matt Pelmear wrote: On 01/24/2013 04:02 PM, Jim Giner wrote: I took my 6 line override php.ini file and replicated (with a script) into all of my possible folders under my web root. NOt exactly an elegant solution, but with the script, easy to maintain. Honestly, you

Re: [PHP-DB] pdo ?

2013-01-25 Thread Jim Giner
On 1/25/2013 10:56 AM, Jim Giner wrote: On 1/24/2013 7:07 PM, Matt Pelmear wrote: On 01/24/2013 04:02 PM, Jim Giner wrote: I took my 6 line override php.ini file and replicated (with a script) into all of my possible folders under my web root. NOt exactly an elegant solution

[PHP-DB] Re: Processing Account Login

2013-02-07 Thread Jim Giner
On 2/6/2013 8:01 PM, Ron Piggott wrote: Hi Everyone When I login to PayPal a total of 3 web pages are used: 1 – A screen for the user to type in their user name password 2 – A screen saying “ Logging in “* 3 – My Welcome / Personalized Account Summary Screen * During the 2nd web page my PHP

[PHP-DB] Re: AJAX/Javascript??

2013-02-10 Thread Jim Giner
On 2/9/2013 10:51 PM, Ethan Rosenberg, PhD wrote: I know that this might be an Ajax/Javascript question. Hopefully you can help. I do not know of any other source for good info. I would like to be able to click on one field in a table, and retrieve the data in another field. Here is the

Re: [PHP-DB] Re: AJAX/Javascript??

2013-02-11 Thread Jim Giner
On 2/11/2013 10:08 AM, Michael Oki wrote: Create a form and add a submit button that will run a php file. The SQL query in the php file will have something like SELECT custName FROM table WHERE lname='$lname'; This will come after you have retrieved the data from a form like this $lname =

Re: [PHP-DB] Ajax

2013-02-21 Thread Jim Giner
On 2/21/2013 2:34 AM, Karl DeSaulniers wrote: Hi Ethan, With all due respect, I really wish I could help, but your structure of how your doing your html and php and javascript mix doesn't make sense enough for me to understand what it is your doing or how to help you. I copied and pasted your

  1   2   >