[PHP-DB] Question about database design

2007-10-24 Thread Jason Pruim
.* and I'll be writing the stuff to access that database with php 5. -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com [EMAIL PROTECTED]

Re: [PHP-DB] Question about database design

2007-10-24 Thread Jason Pruim
. If you I missed anything or you have more specific questions, feel free to email me on or off list. Cheers, Tim Tim McGeary '99, '06G Senior Systems Specialist Lehigh University 610-758-4998 [EMAIL PROTECTED] Jason Pruim wrote: I sent this to the MySQL list but didn't receive any

Re: [PHP-DB] Question about database design

2007-10-24 Thread Jason Pruim
with php 5. -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com [EMAIL PROTECTED] Express yourself with free Messenger emoticons. Get them today! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave

Re: [PHP-DB] PHP, MySQL and Lookups

2008-02-26 Thread Jason Pruim
check the mysql site for specifics on using update. Also... always be sure to escape your data or you are asking for trouble... That should be enough to get you started! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [EMAIL

[PHP-DB] Not updating certain fields in same row

2008-03-25 Thread Jason Pruim
. Which is what I am trying to avoid. Any ideas? -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [EMAIL PROTECTED]

Re: [PHP-DB] Not updating certain fields in same row

2008-03-25 Thread Jason Pruim
On Mar 25, 2008, at 1:09 PM, Daniel Brown wrote: On Tue, Mar 25, 2008 at 12:59 PM, Jason Pruim [EMAIL PROTECTED] wrote: Hi everyone, I am attempting to update a record for a login system while leaving certain fields untouched if they arn't changed, and am running into issues. [snip!] I

Re: [PHP-DB] Not updating certain fields in same row

2008-03-25 Thread Jason Pruim
at 11:59 AM, Jason Pruim [EMAIL PROTECTED] wrote: Hi everyone, I am attempting to update a record for a login system while leaving certain fields untouched if they arn't changed, and am running into issues. Basically what I want to do, is say I have these fields: Field1 Field2 Field3 Field4 I

Re: [PHP-DB] Not updating certain fields in same row

2008-03-25 Thread Jason Pruim
, Jason Pruim [EMAIL PROTECTED] wrote: the actual query I'm using is this: $chpwsql = UPDATE current SET customerName='$customerName', loginName='$loginName', loginPassword='$PW', email='$email', adminLevel='$adminLevel' WHERE Record='$Record1'; What it is doing now is if I don't set

Re: [PHP-DB] Not updating certain fields in same row

2008-03-27 Thread Jason Pruim
verified :) So Thanks! :) On Mar 25, 2008, at 12:59 PM, Jason Pruim wrote: Hi everyone, I am attempting to update a record for a login system while leaving certain fields untouched if they arn't changed, and am running into issues. Basically what I want to do, is say I have these fields

[PHP-DB] mysqli_stmt_bind_param question

2008-04-04 Thread Jason Pruim
can't figure this one out... RTFM's are appreciated, as long as M is defined! :) Thanks for taking the time to look! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [EMAIL PROTECTED]

Re: [PHP-DB] mysqli_stmt_bind_param question

2008-04-04 Thread Jason Pruim
with so many parameters. What do you mean by this? -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php database

2008-04-18 Thread Jason Pruim
? -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Timestamps

2008-04-30 Thread Jason Pruim
database it's storing a 0 in the timestamp field which is a int(10) field. I have googled, and searched manuals, but have not been able to figure out what is going on Any Ideas? -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com

Re: [PHP-DB] Timestamps

2008-04-30 Thread Jason Pruim
On Apr 30, 2008, at 11:35 AM, Stut wrote: On 30 Apr 2008, at 16:29, Jason Pruim wrote: Okay... So I know this should be simple... Trying to store a timestamp in a MySQL database... The timestamp I am making like so: $modifiedTimestamp = time(); and then just $sql = Update `mytable` set

Re: [PHP-DB] Timestamps

2008-05-01 Thread Jason Pruim
On Apr 30, 2008, at 5:03 PM, Philip Thompson wrote: On Apr 30, 2008, at 10:54 AM, Jason Pruim wrote: Hi Yves, Thanks for the tip, that worked, I think I'll use that from now on.. Just out of curiosity though, any idea why it wasn't working as I was writing it :) Did you try putting

Re: [PHP-DB] How to do a Newsletter

2008-05-01 Thread Jason Pruim
, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [EMAIL PROTECTED] -- PHP Database Mailing List (http

Re: [PHP-DB] How to do a Newsletter

2008-05-01 Thread Jason Pruim
run a query according to user criteria of newsletter and send it via email - Original Message From: Jason Pruim [EMAIL PROTECTED] To: Nasreen Laghari [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Thursday, May 1, 2008 5:03:43 PM Subject: Re: [PHP-DB] How to do a Newsletter That's

Re: [PHP-DB] Timestamps

2008-05-02 Thread Jason Pruim
/language.operators.execution.php I'll have to take a look at that and see what it says in a little bit. -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] Multi-level marketing system

2008-08-14 Thread Jason Pruim
And what precisely does this have to do with PHP or databases? I have a feeling if you google for MLM Systems you'll get more then you could ever want... -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com [EMAIL PROTECTED

[PHP-DB] Question about access rights in php/mysql

2008-08-26 Thread Jason Pruim
logins? One for the initial load which just has select privileges and a second for when they hit edit which then gives them update privileges? Or, should i just do 1 login with select, and update privileges? Any ideas or suggestions? Thanks! -- Jason Pruim Raoset Inc. Technology Manager

Re: [PHP-DB] Question about access rights in php/mysql

2008-08-26 Thread Jason Pruim
there to follow up on the web. I think though that I will go with the 1 login, with a simple variable like to described. Thanks Dan! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com [EMAIL PROTECTED]

[PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Jason Pruim
, it erases the info in the field. Anyone got a clue as to what is going on? :) Thanks for looking! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com [EMAIL PROTECTED]

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Jason Pruim
suggestion: you may want put mysql_real_escape_string() wrappers around all those $_POST[] fields to prevent SQL hijacking of your site. HTH, Yves -- Original Message -- Received: Wed, 27 Aug 2008 11:07:20 AM CDT From: Jason Pruim [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Jason Pruim
fine, if I DO disable it then they don't submit. I need to find a better to stop accidental editing rather then just input type=text disable On Wed, Aug 27, 2008 at 6:38 PM, Jason Pruim [EMAIL PROTECTED] wrote: On Aug 27, 2008, at 12:24 PM, Evert Lammerts wrote: Your index.php looks

Re: [PHP-DB] Kesalahan posting?

2008-08-27 Thread Jason Pruim
Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Jason Pruim
On Aug 27, 2008, at 12:48 PM, Jason Pruim wrote: For everyone that has helped me on this thank you! :) the solution was changing from: input type=text name=txtFName DISABLED to input type=text name=txtFName READONLY Read only fields still get passed with POST'ed info where as disabled

Re: [PHP-DB] solution reqd for summation of vertical columns in PHP

2008-09-13 Thread Jason Pruim
On Sep 13, 2008, at 10:05 PM, Vaibhav Informatics wrote: Please let me know if there is a simple method to total up the column values in Mysql database tables using php as in excel. I believe what you are looking for is count(fieldname) -- PHP Database Mailing List (http://www.php.net/)

[PHP-DB] Question about databases and foreign keys

2008-09-15 Thread Jason Pruim
the actual time, hopefully making the math part easier :) Do I need the foreign key and the 2 tables? Or should I just add the column's into the database since it will be for a small company? Ideas? Suggestions? Thanks! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287

Re: [PHP-DB] re:php debugging skills

2008-09-26 Thread Jason Pruim
with databases (Since this is the DB list :)) I'd recommend to echo out your db statements to make sure you are doing what you think you are doing... Can't tell you how many times that screwed me up... Just my experience, take it or leave it :) -- Jason Pruim Raoset Inc. Technology Manager

Re: [PHP-DB] re:php debugging skills

2008-09-26 Thread Jason Pruim
On Sep 26, 2008, at 1:17 PM, muhsin wrote: Jason Pruim wrote: On Sep 26, 2008, at 11:22 AM, muhsin wrote: Could you guys share your development setup, like what kinds of software (IDE's/Editors) you are using for developing php scripts? It might sound silly but I am just curios, as I just

Re: [PHP-DB] session variable in select query showing picture from database

2009-02-12 Thread Jason Pruim
On Feb 12, 2009, at 6:07 AM, Mika Jaaksi wrote: I'm trying to show picture from database. Everything works until I add variable into where part of the query. It works with plain number. example ...WHERE id=11... ...picture is shown on the page. Here's the code that retrieves the picture.

[PHP-DB] always the logic that messes me up.... Database fun!

2010-07-18 Thread Jason Pruim
Hi everyone! I'm trying to put together a completely database driven site so I can learn how to do it... I've gone to the extent of creating apache rewrite rules to redirect all non-existent files/folders to my script to see if it exists which works perfectly. Where I'm running into

Re: [PHP-DB] Parsing Tab Delimited file

2010-10-24 Thread Jason Pruim
On Oct 24, 2010, at 2:46 PM, Ethan Rosenberg wrote: Dear list - Thanks for all your help. I have a tab delimited file which I wish to import into a data base. In MySQL I can use the LOAD DATA command. As far as I know, that command cannot be used in PHP as a mysqli_query. As I

[PHP-DB] Working with large datasets

2011-10-10 Thread Jason Pruim
it keeps timing out the connection. Is there any advice for working with large datasets? I'm wanting this to be able to load quickly. Thanks in advance! Jason Pruim li...@pruimphotography.com -- 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 Jason Pruim
Jason Pruim pru...@gmail.com On Oct 10, 2011, at 2:20 PM, Jim Giner wrote: 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

Re: [PHP-DB] Working with large datasets

2011-10-10 Thread Jason Pruim
Jason Pruim pru...@gmail.com On Oct 10, 2011, at 2:42 PM, Jim Giner wrote: 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

Re: [PHP-DB] Working with large datasets

2011-10-10 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 10, 2011, at 5:27 PM, Thompson, Jimi wrote: I really think that you should try running it from the command line and see what the issues are. Get both Apache and php out of the way. I've seen some PHP scripts use up all the file handles (OS

[PHP-DB] Odd MySQL Problem...

2011-10-13 Thread Jason Pruim
Hey everyone,Have a weird issue that I can't seem to figure out...Using PHP to insert phone numbers into the site... I have the Area Code, Exchange, and then dynamically create the last 4 digits... Once it's inserted it's dropping the leading zero's... Here's some samples:Copied from

[PHP-DB] Problem with mysql and php

2011-11-28 Thread Jason Pruim
records, will be expanding that to many many more times that... To the tune of possibly a couple billion records... Any ideas? :) Jason Pruim li...@pruimphotography.com

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

2011-11-28 Thread Jason Pruim
Jason Pruim pru...@gmail.com On Nov 28, 2011, at 8:58 PM, Phil Dobbin wrote: On 29/11/11 01:38, Jason Pruim li...@pruimphotography.com wrote: Given the following 2 queries: SELECT DISTINCT areacode FROM main WHERE state = '{$query_exploded[0]}'; SELECT DISTINCT areacode FROM main

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

2011-11-29 Thread Jason Pruim
Jim, Similar yes... But this was specifically about replacing distinct with something since it was taking WAY to long... But it did evolve into a very similar conversation :) Jason Pruim pru...@gmail.com On Nov 29, 2011, at 6:25 PM, Jim Giner wrote: Didn't the OP begin this very same

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Jason Pruim
If you load up handleweight.php outside of the script does it load normally? Trying to pin down where the actual problem is. Jason Pruim 352.359.0002 On Mar 14, 2015, at 10:17 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: On 03/09/2015 08:27 AM, Ethan Rosenberg, PhD wrote

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Jason Pruim
instead of the entire site. Jason Pruim 352.359.0002 On Mar 15, 2015, at 2:40 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: On 03/15/2015 09:44 AM, Jason Pruim wrote: If you load up handleweight.php outside of the script does it load normally? Trying to pin down where