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
select distinct Date from table_name where name = 'Test';
Jeff
Chris Grigor
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
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
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
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 ...
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
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
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)
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
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
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
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
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
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
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
__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
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
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
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.
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
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
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
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,
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
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
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
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
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??
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
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
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
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
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
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
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.
--
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:
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
38 matches
Mail list logo