[PHP-DB] Duplicates

2002-10-23 Thread Chris Grigor
Howdi all, How can you list the contents of a table and skip duplicate Dates?? eg select Date from table_name where name = 'Test'; |Date| 2000-01-01 2000-01-02 2000-01-02 --- How would you get rid of this

Re: [PHP-DB] Duplicates

2002-10-23 Thread Jeffrey_N_Dyke
select distinct Date from table_name where name = 'Test'; Jeff Chris Grigor

RE: [PHP-DB] Duplicates

2002-10-23 Thread Snijders, Mark
select date from table_name where name='test' GROUP BY date -Original Message- From: Chris Grigor [mailto:chris;calibre.co.za] Sent: woensdag 23 oktober 2002 14:04 To: PHP Gen; PHP DB Subject: [PHP-DB] Duplicates Howdi all, How can you list the contents of a table and skip duplicate

[PHP-DB] Re: [PHP] Duplicates

2002-10-23 Thread Justin French
Check out DISTINCT in the MySQL manual SELECT DISTINCT(yourdatecolumn) * FROM tablename WHERE .. or something like that Justin on 23/10/02 10:04 PM, Chris Grigor ([EMAIL PROTECTED]) wrote: Howdi all, How can you list the contents of a table and skip duplicate Dates?? eg

RE: [PHP-DB] Security

2002-10-23 Thread Peter Lovatt
check http://www.mysql.com/doc/en/Miscellaneous_functions.html it covers a number of options Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net tel. 0121-242-1473

[PHP-DB] Print data

2002-10-23 Thread José Moreira
hello, at my company we have several network printers and i was was wondering if it's possible to print directly to them using PHP, instead of showing on the screen or both ... to gain more control on what is printed, because of the nasty browsers header and footer ... whom i now how to remove ...

Re: [PHP-DB] Print data

2002-10-23 Thread Jeffrey_N_Dyke
I think this is only available as an option if you are running on windows based hardward, but if you are...i know i've seen it in the manual. José Moreira

[PHP-DB] Echo Command Thanks

2002-10-23 Thread Chris Payne
Hi there everyone, Thank you all for your responses to my question about the best way to end a PHP command (Or use Echo to print HTML). My gut feeling was it should be ok, it's just that *To me* it is MUCH easier to follow code which doesn't contain echo table width=50 etc . I much prefer to

[PHP-DB] MySQL crypt test...

2002-10-23 Thread NIPP, SCOTT V (SBCSI)
I am having trouble with a canned calendar application and I think that maybe the problem is the crypt function. Does anyone know of a good way to test the crypt function? I need to figure out somehow if this is the source of the problem or not. Thanks. Scott Nipp Phone: (214)

[PHP-DB] PHP mail + MySQL

2002-10-23 Thread Maarten Verheijen Mysql en PHP-maillijst
Dear Readers, Is there anybody who nows about a php-script which can be used to download email from a pop-account and then put the e-mailmessages and their attachments into a MySQL database. I want to use it to create a database of all e-mailmessages send to our company. This will greatly help

[PHP-DB] Re: PHP and databases? ...without MySQL and such

2002-10-23 Thread Richard Allsebrook
You can use the Microsoft ODBC Text driver to access flat files and perform SQL Queries on it - can be REALLY slow on big files though (no indexes) :( Alternatively - write a script that pulls the flat file into a proper database table :) Hope this helps -- Richard Allsebrook Applications and

[PHP-DB] Re: [PHP] Re: PHP and databases? ...without MySQL and such

2002-10-23 Thread Geoff Hankerson
Youc use xml files as well as an alternative Richard Allsebrook wrote: You can use the Microsoft ODBC Text driver to access flat files and perform SQL Queries on it - can be REALLY slow on big files though (no indexes) :( Alternatively - write a script that pulls the flat file into a proper

[PHP-DB] Re: [PHP] PHP and databases? ...without MySQL and such

2002-10-23 Thread Maxim Maletsky
Darren Henderson [EMAIL PROTECTED] wrote... : 1. Anything more than just one single PHP file made in your text editor. Not sure what you mean by this. If I write a single suite of data handling routines then it doesn't matter if I have one or 10,000 pages using it. I meant a file to write

[PHP-DB] loading includes

2002-10-23 Thread Mignon Hunter
Here's one that will shake your head, mine's about shook off. Basic problem: new site works on my box but not on dev server. Both boxes have Apache and php loaded. New site is not loading includes and dynamic data. The old site copy on dev server has some main pages that include some files

Re: [PHP-DB] Print data

2002-10-23 Thread 1LT John W. Holmes
hello, at my company we have several network printers and i was was wondering if it's possible to print directly to them using PHP, instead of showing on the screen or both ... to gain more control on what is printed, because of the nasty browsers header and footer ... whom i now how to

[PHP-DB] Function that outputs at line xxx

2002-10-23 Thread Peter Beckman
Hey -- I'm writing a database error handler function in PHP, and I want it to tell me at what line in what script the error occurred. Is this possible? I know it happens when PHP hits a warning or a fatal error, but is it possible to do in a live script? Or is there a global variable which

Re: [PHP-DB] Function that outputs at line xxx

2002-10-23 Thread 1LT John W. Holmes
__LINE__ and __FILE__ should work. ---John Holmes... - Original Message - From: Peter Beckman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 3:00 PM Subject: [PHP-DB] Function that outputs at line xxx Hey -- I'm writing a database error handler function in

[PHP-DB] mysql_affected_cols() ??? or equivalent?

2002-10-23 Thread Peter Beckman
Is it possible to find out how many columns from a row were updated in a single update SQL command? For example: $x = mysql_query(update users set un={$un},pw={$pw},ln={$ln},fn={$fn} where id={$id}); And the function (something like mysql_affected_cols()) would return 0 if everything stayed

Re: [PHP-DB] Function that outputs at line xxx

2002-10-23 Thread 1LT John W. Holmes
Yeah, I understand what your asking. I don't know of any method to get the line number a function was called on, from within the function. You may have to pass __LINE__ and __FILE__ in your db_query() function, or whatever it is. ---John Holmes... - Original Message - From: Peter

RE: [PHP-DB] PHP and databases? ...without MySQL and such

2002-10-23 Thread Negretti, John (CCI-San Diego)
PHP-nites, I want to thank you all for your insight on PHP and database options, particularly to FLAT FILES. Many of you commented on using MySQL or Oracle and such, commenting how better it would be. I STRONGLY agree that using MySQL or any DMBS database application is a FAR better options.

[PHP-DB] Credit Card Info Cryptography

2002-10-23 Thread Doaldo Navai Junior
Suppose I sell some products online and get user's credit card info via SSL connection. Isn't there any method (free, preferably) of ASSYMETRIC (Public key) cryptography I can use with PHP to store this data in a db?? Or is there any other good option instead of this? TIA, Doaldo -- PHP

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

RE: [PHP-DB] Credit Card Info Cryptography

2002-10-23 Thread Ryan Jameson (USA)
Since your goal is to encrypt the card number in the database you'll naturally need a way to decrypt it as well. At that point it seems your concern is that your database will be compromised. That can be avoided easily by creating a single private key and using your own algorithm to encrypt

Re: [PHP-DB] Credit Card Info Cryptography

2002-10-23 Thread 1LT John W. Holmes
When ever I see easy, encrypt, and credit card in the same sentence, it makes me worry. Don't store credit card numbers. Charge them once and don't save it anywhere. ---John Holmes... - Original Message - From: Ryan Jameson (USA) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday,

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

Re: [PHP-DB] Credit Card Info Cryptography

2002-10-23 Thread 1LT John W. Holmes
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. They aren't that expensive and usually come with all of the scripts you

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 Ryan Jameson (USA)
OFFTOPIC :-) You have a good point, I just assumed that decision had already been made. Here's :a visual representation of my point. To hide A by turning it into B using algorithm object C and only someone with key D can see it. C.encrypt(A,D) = B; C.decrypt(B,D) = A; If anyone has either

[PHP-DB] TOO MANY CONNECTIONS!!

2002-10-23 Thread Georgie Casey
Im getting a too many connections error in my PHP pages at http://www.free-ringtones.tv. I presume this is from the MySQL server, and I know I access the database a lot for each page. So whats the solution to this?? Write scripts that create static html pages that update every 20 minutes or so??

Re: [PHP-DB] TOO MANY CONNECTIONS!!

2002-10-23 Thread Micah Stevens
Send me the code around the lines that are giving errors.. Doesn't look like a MySQL error to me. -Micah At 10:18 PM 10/23/2002 +0100, Georgie Casey wrote: Im getting a too many connections error in my PHP pages at http://www.free-ringtones.tv. I presume this is from the MySQL server, and I

RE: [PHP-DB] Credit Card Info Cryptography

2002-10-23 Thread Peter Beckman
How about encrypting the credit card with a secret word that the user chooses? Or obsfucate it by encrypting their credit card using str_rot13(base64_encode(str_rot13($lastname).$lastname.$email.$firstname)) as the key? Sure, if someone gets your code and your DB, those credit card numbers

Re: [PHP-DB] TOO MANY CONNECTIONS!!

2002-10-23 Thread Duncan Hill
On Wed, Oct 23, 2002 at 10:18:07PM +0100, Georgie Casey wrote: Im getting a too many connections error in my PHP pages at http://www.free-ringtones.tv. I presume this is from the MySQL server, and I know I access the database a lot for each page. So whats the solution to MySQL has a default of

[PHP-DB] Re: TOO MANY CONNECTIONS!!

2002-10-23 Thread Manuel Lemos
Hello, On 10/23/2002 06:18 PM, Georgie Casey wrote: Im getting a too many connections error in my PHP pages at http://www.free-ringtones.tv. I presume this is from the MySQL server, and I know I access the database a lot for each page. So whats the solution to this?? Write scripts that create

[PHP-DB] checking data from a flash movie at my domain for an insert

2002-10-23 Thread rolf vreijdenberger
is it possible to make sure data that will be inserted into a database is from a flash movie ( a game) residing on my domain? The data will be linked to prizes, so I want to be able to make sure that nobody executes a script and provides false data. The security measures I have now are encrypting

Re: [PHP-DB] Credit Card Info Cryptography

2002-10-23 Thread Jim Hunter
There is a simple alternative that you might not be aware of, and that is use Advantage Database (I am assuming that you are using MySQL right now). You can get a free version to try and it provides encryption at the table level. There is a PHP interface for it and everything can be found at www

[PHP-DB] Adding 1 day to date/datetime/timestamp?

2002-10-23 Thread Leif K-Brooks
I need to add one day to a datetime/date/timestamp field. How would I do this? (sorry for the n00b-ish question...) I'm using mysql. -- The above message is encrypted with double rot13 encoding. Any unauthorized attempt to decrypt it will be prosecuted to the full extent of the law. --

RE: [PHP-DB] Adding 1 day to date/datetime/timestamp?

2002-10-23 Thread John W. Holmes
I need to add one day to a datetime/date/timestamp field. How would I do this? (sorry for the n00b-ish question...) I'm using mysql. SELECT your_column + INTERVAL 1 DAY FROM your_table; ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Re:Re: [PHP-DB] Print data

2002-10-23 Thread xde7ori
hy, i'm having a problem with printing the data from a html or php page... how can i solve this problem ? I mean when i'm using frames they appear or like a view with scrollbar or there is an option to print them singulary. I want to print in a format that i want..like a report ... thanks