.* 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]
.
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
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
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
. 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]
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
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
, 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
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
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]
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
?
--
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
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
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
, 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
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
/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
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
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
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]
, 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]
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
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
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
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
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/)
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
42 matches
Mail list logo