RE: [PHP-DB] Email Encryption?

2002-11-15 Thread Aaron Wolski
is supposed to simplify their lives not complicate :( Aaron -Original Message- From: Cal Evans [mailto:cal@;calevans.com] Sent: November 15, 2002 11:54 AM To: Aaron Wolski; 'Hutchins, Richard'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Email Encryption? Instead of emailing them

RE: [PHP-DB] Email Encryption?

2002-11-15 Thread Aaron Wolski
PROTECTED] Subject: RE: [PHP-DB] Email Encryption? Can you explain how e-mail fits into the Admin solution? What is the e-mail used for? Setting up the accounts/passwords or sending the account/password to the user? > -Original Message- > From: Aaron Wolski [mailto:aaronjw@;martekb

RE: [PHP-DB] Email Encryption?

2002-11-15 Thread Aaron Wolski
layed logins details and reek havoc on the store, etc. *shrugs* Sadly this isn't open for debate as a solutions IS required. Any thoughts? Aaron -Original Message- From: Jason Vincent [mailto:jayv@;nortelnetworks.com] Sent: November 15, 2002 11:42 AM To: Aaron Wolski; [EMAIL

RE: [PHP-DB] Email Encryption?

2002-11-15 Thread Aaron Wolski
Just thinking here.. PGP is not an option as it would mean EACH user being setup would need the company's public key to decrypt. Not possible as they setup a few hundred accounts each month. Hmm.. anything else? Argh :( Aaron -Original Message- From: Aaron Wolski [mailto:aa

[PHP-DB] Email Encryption?

2002-11-15 Thread Aaron Wolski
Sorry for the off topic guys.. But I've just been informed that an application we developed for a client whereby they use an Admin tool to setup user accounts into their store needs to have the login (username and password) encrypted. I am thinking PGP for this but to be honest I've never re

RE: [PHP-DB] serious help with linking data together...

2002-11-15 Thread Aaron Wolski
By George I think I may have got it! Code: Keyword Search Engine Count

RE: [PHP-DB] serious help with linking data together...

2002-11-15 Thread Aaron Wolski
-Original Message- From: Jason Vincent [mailto:jayv@;nortelnetworks.com] Sent: November 15, 2002 8:51 AM To: Aaron Wolski; [EMAIL

RE: [PHP-DB] checking for 0 results? edit

2002-11-15 Thread Aaron Wolski
Doh! Edit: if (mysql_num_rows($sql) == 0) { Aaron -Original Message- From: Aaron Wolski [mailto:aaronjw@;martekbiz.com] Sent: November 15, 2002 8:42 AM To: 'Snijders, Mark'; 'Jonathan Narong'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] checking for 0 results? Or you

RE: [PHP-DB] checking for 0 results?

2002-11-15 Thread Aaron Wolski
Or you can skip a step like: $sql = "select * from ietsfuckingfriday"; if (mysql_num_rows($result) == 0) { do_something(); } else { do_anotherthing(); } Aaron -Original Message- From: Snijders, Mark [mailto:Mark.Snijders@;atosorigin.com] Sent: November 15, 2002 8:26

[PHP-DB] serious help with linking data together...

2002-11-14 Thread Aaron Wolski
Hey all, Been trying too figure this out all day. First off I'll explain what I am TRYING to do. I am creating a Search Engine Tracking Report that lists keywords and the Search Engines used on that keyword along with the count total for that search Engine - example: Keyword S

RE: [PHP-DB] Best reporting Tool

2002-11-14 Thread Aaron Wolski
I have to agree on the PDF. Currently my host does not provide for PDF capabilities as of yet but I believe they are going to be compiling with support for PDF soon. When they do, look out. The success of some of our commercial apps will rise for sure as this reporting options becomes available.

RE: [PHP-DB] date()

2002-11-13 Thread Aaron Wolski
$date = date("m:d:y", $myrow[datefield]); Will produce: 11:13:02 http://www.php.net/manual/en/function.date.php Aaron -Original Message- From: Edward Peloke [mailto:epeloke@;echoman.com] Sent: November 13, 2002 4:27 PM To: Php-Db Subject: [PHP-DB] date() I have a date field in my my

RE: [PHP-DB] Difference between 2 dates.. thoughts?

2002-11-13 Thread Aaron Wolski
Ok, Thanks for your input. I know very little about how to manipulate MySQL so this out to be fun and very slow going :-( Thanks! Aaron -Original Message- From: Jason Vincent [mailto:jayv@;nortelnetworks.com] Sent: November 13, 2002 12:34 PM To: Aaron Wolski; [EMAIL PROTECTED

RE: [PHP-DB] Difference between 2 dates.. thoughts?

2002-11-13 Thread Aaron Wolski
Message- From: Jason Vincent [mailto:jayv@;nortelnetworks.com] Sent: November 13, 2002 12:24 PM To: Aaron Wolski; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Difference between 2 dates.. thoughts? You should be able to do this at the database level - of course you never said what database that is

[PHP-DB] Difference between 2 dates.. thoughts?

2002-11-13 Thread Aaron Wolski
Hi All, First off I have a query like this: SELECT dateinserted FROM SiteTrackingTable; Now. in this query any number of results could be returned 10 or 1000, etc. Is it possible to take the dateinserted value from the first record and then from the last record and perform some calculation

[PHP-DB] How to do this..

2002-11-12 Thread Aaron Wolski
Hi All, Need a little help with something. I've created a Search Engine Tracking tool that allows me to measure ROI from users that comes form search engines using specific keywords.. My problem is I forgot to capture a multiple of different "identifies" that tell me where the keyword is. T

[PHP-DB] Argh!!!! Help with something o-f-f-t-o-p-i-c

2002-11-07 Thread Aaron Wolski
Sorry for the OT post y'all.. but I can't find this answer - well not without major major code information that I can't figure out! Basic? I have a series of checkbox arrays like: These are for different records in my DB. Now... I want to check (javascript - this is the off topic part

[PHP-DB] first Array value duplicating..

2002-11-07 Thread Aaron Wolski
Hi All, In a form I have checkboxes associated with order records. The checkboxes are for deleting order records (should a client choose to do so). It looks like this: Now.. when the process button is pressed the information is carried off to the

RE: [PHP-DB] Imploding an array?

2002-11-06 Thread Aaron Wolski
Ok... This is the code I have setup: for ($i=0;$i -Original Message- > From: Rasmus Lerdorf [mailto:rasmus@;php.net] > Sent: Wednesday, November 06, 2002 2:16 PM > To: Aaron Wolski > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Imploding an array? > > > You su

[PHP-DB] Imploding an array?

2002-11-06 Thread Aaron Wolski
Hey all, Can't seem to figure out why this won't work: $test = implode(",", $order_index[$i]); When I print_r() the variable I have values so I know that works. Any thoughts on this? Thanks. Aaron

RE: [PHP-DB] Idea as to why this query won't work as expected?

2002-11-05 Thread Aaron Wolski
at you want is: > > select * FROM OrderTable WHERE submitted=1 AND > dateinserted>='1036386000' AND dateinserted<='1036502796' AND > ( order_status='Shipped' OR order_status='Not Shipped' ) > > HTH > Ignatius J. Reilly >

[PHP-DB] Idea as to why this query won't work as expected?

2002-11-05 Thread Aaron Wolski
Hi All, I have a query like: select * FROM OrderTable WHERE submitted=1 AND dateinserted>='1036386000' AND dateinserted<='1036502796' AND order_status='Shipped' OR order_status='Not Shipped' Now.. if I omit the "AND order_status='Shipped' OR order_status='Not Shipped'" part the query works

FW: [PHP-DB] COOKIE problem... URGENTLY NEEDED HELP - BEGGING

2002-11-01 Thread Aaron Wolski
Hi Guys, I'm begging here.. ANYONE have a clue. I can searchinbg and searching but I see nothing that's helping me. Anyone had issues like this before? Thanka!!! Aaron -Original Message----- From: Aaron Wolski [mailto:aaronjw@;martekbiz.com] Sent: Friday, November 01, 2002 1

[PHP-DB] COOKIE problem... URGENTLY NEEDED HELP

2002-11-01 Thread Aaron Wolski
Hi All, Ok.. just went live with a site that 'appeared' to work wonderfuylly. However, now it seems I cannot read a cookie in a secure area (https) when it was set in a non-secure area (http). Any clue on how to get this universally to work? Really really need help with this. Arg. T

RE: [PHP-DB] Re: cookie trouble

2002-10-31 Thread Aaron Wolski
You cannot reverse the encryption of an md5 hash. Nor should you want to. You don't want to know their password which is why you encrypt it. When you seyup an account you convert the password to an md5 has(I assume you have done so). When they log back in.. You convert the password to an md5 hash

RE: [PHP-DB] Add column to a table

2002-10-31 Thread Aaron Wolski
ALTER TABLE TableName ADD COLUMN columnParametersHere E.g: ALTER TABLE UserTable ADD COLUMN userName varchar(255); Aaron > -Original Message- > From: Shaun Thornburgh [mailto:shaun@;mania.plus.com] > Sent: Thursday, October 31, 2002 7:39 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Ad

[PHP-DB] URGET HELP : Logic Help - for first record do_this for each record after do_that

2002-10-25 Thread Aaron Wolski
Hey guys, Not really off topic as this involves some Db work as I have to query the DB. Got a logic problem that was jumped dumped on me from UPS (dummys!). Basically I need to pull some records out of a database and for the first record do_this logic and for each record after in the array do_s

RE: [PHP-DB] Credit Card Info & Cryptography

2002-10-23 Thread Aaron Wolski
Maybe you do, Bt I run a _client_dictates_the_development_requirments business. It not not be that expensive but to some clients who are trying to give it a go it can mean a lot. Am I to tell them I won't accept their business? No - what I am to do is provide them with the best alternative which

RE: [PHP-DB] Credit Card Info & Cryptography

2002-10-23 Thread Aaron Wolski
Well.. Isn't that the ideal. I agree in theory, however, not all clients are willing to shell for the Payment Processor Services if they are just starting ou tin e-commerce and don't know what kind of volume to expect. Thery is wonderful, however, practicle must preside. Aaron -Original Mes

RE: [PHP-DB] Credit Card Info & Cryptography

2002-10-23 Thread Aaron Wolski
Well... You can use PGPG/GNPGP for this or you can develop your own RSA encryption - if you understand/have the know how. A former programmer of mine who worked for a Security firm developed the base-line code which was originally written in C then transferred into Perl. He was greatful enough to

RE: [PHP-DB] catalog system

2002-10-21 Thread Aaron Wolski
Agreed! It sure is. Aaron -Original Message- From: John W. Holmes [mailto:holmes072000@;charter.net] Sent: Monday, October 21, 2002 12:51 PM To: 'Sparks'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] catalog system > If someone will point me to the Nubee-forum, I will gladly go. http://fo

RE: [PHP-DB] catalog system

2002-10-21 Thread Aaron Wolski
Build you own. Does no one want to 'work' for their projects these days? *shrug* Aaron -Original Message- From: Sparks [mailto:alex@;paychoice.com] Sent: Monday, October 21, 2002 9:29 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] catalog system Greetings, I'm looking for a cataloging

RE: [PHP-DB] echo printing a cookie

2002-10-15 Thread Aaron Wolski
If (isset($_COOKIE[cookiename]) { echo 'Your cookie is: '.$_COOKIE[cookiename].' '; } -Original Message- From: Steve Dodkins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 9:22 AM To: Php-Db (E-mail) Subject: [PHP-DB] echo printing a cookie Hi I'm trying to print

[PHP-DB] Need help with time calculation for a tracking system - it DOES involve DB work :)

2002-10-04 Thread Aaron Wolski
Hey all... Working on a time calculation for a tracking system.. time ON the apge.. time OFF the page type of thing.. Anyway.. everything as far as entering the time values, etc is working correctly except the calculation is NOT working as it should!!! here is my code for the calculation /*

RE: [PHP-DB] Function help....

2002-10-03 Thread Aaron Wolski
Why don't you just try it and see? Aaron -Original Message- From: Rodrigo [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 1:41 PM To: PHP Subject: [PHP-DB] Function help Hi people, i wanna know from you if this is the way to complete a filed with zeros "0"... if i typ

[PHP-DB] how to disable PHPSESSID from posting in URL

2002-10-01 Thread Aaron Wolski
Hey all, I KNOW this is not a Db related question but I really need some ideas here. I don't want the URL to display this info. I never notcied this being displayed before but all of a sudden it seemed to pop-up. I don't host my own server so any access to the php.ini file is not possible. Any

RE: [PHP-DB] how can I do?

2002-09-19 Thread Aaron Wolski
SELECT * from SomeTable where dateinserted>$start_date AND dateinserted<$end_date Dateinserted is the date stamp column in your table. Aaron -Original Message- From: Meltem Demirkus [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 19, 2002 8:36 AM To: [EMAIL PROTECTED]; [EMAIL PROT

[PHP-DB] randomizing amounts of html displayed

2002-09-12 Thread Aaron Wolski
Hi All.. Quick question and perhaps a suggestion/solution requst to the above topic. My brain is just not working :( I have a HTML table with 5 rows of data. I would like to randomly display 3 of the 5 rows when the page is accessed. For example: Row 1 Row 2 Row 3 Row 4 Row 5 When

RE: [PHP-DB] strange behavior

2002-09-12 Thread Aaron Wolski
Hi There, I don't know if this is the actual problem.. But in your form action it looks off. action="index.php? Would produce something that looks like: index.php?123455667784332 What I think you WANT to do is... action="index.php?SID= When I need to put php code into a url (form or

[PHP-DB] PHP in a javascript function with DB calls.

2002-09-10 Thread Aaron Wolski
Hi All, I HOPE this is the right place for this.. if not I am sorry!!! I'm hoping someone can put me on a clear path of how to do what I am asking here. I Have a shopping cart... and in this shopping cart I want to feature some items in a pop_up window when the user is ready to check out - if

<    1   2