Use a Select Distinct. query. See www.mysql.com/doc for more info
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send blank email to [EMAIL PROTECTED]
- Original Message -
From: Chris Payne
To: [EMAIL PROTECTED]
hello,
i have got a table table1:
CREATE TABLE table1
(
id bigint(20) unsigned DEFAULT '0' NOT NULL auto_increment,
refer varchar(255) NOT NULL,
aantal int(9) DEFAULT '1' NOT NULL,
time int(10) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
UNIQUE id (id)
);
now i insert about 200
try
form...
input name=a[] value=..
input name=a[] value=..
input name=a[] value=..
input name=a[] value=..
and
for ($i=1; $i=10; $i++) { $tab[$i]=$a[$i] ;}
This way $a will be a array.
Hope it helps
Bruno Gimenes Pereti.
- Original Message -
From: LeTortorec, Jean-Louis [EMAIL
Hi Greetings from http://www.absolutelypsychic.com I hope you are doing well.
Our site has Professional, Ethical, and Accurate Psychics, Astrologers and
Tarot Card readers that have been tested by management to assure
authenticity. Our readers do not promise any false prophesies nor do they
Hello,
Can i use mysql for automated processes?
do $query every hour.
Tnx,
Bas
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
in Unix, set-up a cron job.
In Windows, set-up an AT job.
-Original Message-
From: Bas Jobsen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 9:36 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] automated processes in mysql
Hello,
Can i use mysql for automated processes?
do
Hello there,
I hope I am not disturbing anyone. I have a question.
I am using Advantage Database, I would like to know If PHP supports this
database format.
My email address is
[EMAIL PROTECTED]
Thank you for your help
Regards
Luis
--
PHP Database Mailing List
mySQL does not include native support to launch queries at a specific
interval. In the mySQL manual, I found the following application:
mysqltop.tar.gz: Sends a query in a fixed time interval to the server and
shows the resulting table. By Thomas Wana.
-Original Message-
From: Bas
www.Aerotaxi.net
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
Don't quote me on this but the ./configure command when compiling/re-compiling php
should be run
one level up from the dir you wish to make the action occur in. (One above
/path/to/php4.0.6/bin
so: ./bin/configure with --this with --that
I have cc'd this to the php-db list to make sure this
Here is my problem once again... =P I am wondering if I should change the
date table to something other than date... maybe something like date_1?
Would doing that resolve my issue, because of the fact that the date
variable in php is function? Thanks in advance...
Jason
/* Form to supply
If you have a string that is the name of an input field, you can do one of
3 things:
Ex:
$sName = input.$i; //result = input1
$sName = input.$i; //result = input2
etc...
1: Variable Variables
$value = $$sName;
2: If you posted the form
$value = $HTTP_POST_VARS[$sName];
3: If you used GET
Hi Jason,
What is the error message, in what line? I really can't find any error...
Just one standarlization point: why do you use ( ) when printing BR and
not in every other printing. For me, it's easyer to debug if every thing
that do the same thing is writen the same way.
Other thing out of
What I use to do is to print the sql and try it in the command line to know
it I'm constructing it correctly.
$sql = select foo from bar...;
print $sqlbr\n; ## add this line
execute your script and copy the line to the mysql command line. If the
result is what you expect it should be working.
First, I agree with Bruno concerning putting print all on one line, as you
and I discussed previously Jason.
Second, keep using DATE data type in mySQL. Simply specify to the user how
the date is to be entered on the form. DATE is maintained in mySQL as
-MM-DD.
User that
-Original
On Wednesday 31 October 2001 01:31 am, Jason wrote:
Here is my problem once again... =P I am wondering if I should change
the date table to something other than date... maybe something like
date_1? Would doing that resolve my issue, because of the fact that
the date variable in php is
Get a look at the PHP manual on www.php.net or mirror,
annoted version,
command : system,
there is a good example.
regards
B.
le jeu 25-10-2001 à 12:46, Ric Manalac a écrit :
hi,
i'm a newbiew php developer. i'm trying to
execute a system command in one of my
php scripts. what i would
Isn't date a reserved word that should not be used as a field name? It
appeared that what was asked was if he should change the name of his field
from date to date_1. It should definitely be changed if it is now called
date.
Jason Wong [EMAIL PROTECTED] said:
On Wednesday 31 October 2001
On Wednesday 31 October 2001 02:57 am, [EMAIL PROTECTED] wrote:
Isn't date a reserved word that should not be used as a field name?
It appeared that what was asked was if he should change the name of
his field from date to date_1. It should definitely be changed if it
is now called date.
Hi again Jason,
I think Jason Wong got the problem I missed, it's the date format. If you
tested like I sad in the last mail you already found it. When you query:
SELECT * FROM ads WHERE date = '%$date%';
you get an empty result.
So, that's the solution...
Bruno Gimenes Pereti.
What is the
Ok well I have made the changes and tested it out but using the search
string 10/15/2001 still provided no results... here is the script that
parses the date for entry into the database...
$date = (date(m/d/Y)) ; #this date is used in the online database
$A = (date(A));
$Hou = (date(H));
if
Jason,
date(H) converts to a 24-hour clock. That is, 00 is 12 mid-night, 01 is 1
AM, 13 is 1 PM, 14 is 2 PM, 23 is 11 PM, etc.
I do not understand the reasons for your computation that, say 00, is 10 PM.
-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October
Rick,
This portion of the site was done by a previous employee and well you
know the expression.. If its not broke don't fix it. Well now that I
cannot query the db by the date it is now broke and I am still figuring out
how MySQL is taking entries to the db so I figured this bit of
Just to clear some things up... so instead of the long winded bit of code
that was previously setup to change the format of the date for the date
field in the db, I should use the 2 lines of code? Definately skeptical on
this one... but you know more about this than I.
Rick Emery [EMAIL
This is what I'm saying...
I encourage you to try it and experiment.
-Original Message-
From: Jason [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 30, 2001 2:51 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PHP query on date field
Just to clear some things up... so instead of the
On Wednesday 31 October 2001 04:34 am, Jason wrote:
This portion of the site was done by a previous employee and well
you know the expression.. If its not broke don't fix it. Well now
that I cannot query the db by the date it is now broke and I am still
figuring out how MySQL is taking
Please could some take a look at this code and tell me why when I take my IF
statements out of the function and put in them in the same place where I
call the function from they work, but as soon as I replace them with the
function name they don't?
Appreciate any help.
torrent
Here's the
The date field is varchar. And I believe it is for daylight savings. I am
trying out a couple of things on a test date field so I will get back with
you guys after I try your suggestions. And by the way I sincerely appriciate
all the help you and Rick are giving me. Thanks again,
jason
Jason Wong
On Tue, 30 Oct 2001, TorrentUK wrote:
SNIP
you either need to pass the variables to the function or use global
variables in the function see
http://www.php.net/manual/en/language.variables.scope.php
Here's the code...
// Define the rating's filter
?php
function RatingFilter () {
I'm new to PHP but one thing I think might be happening is that maybe the
changes aren't being made to a global (I'm a Java programmer) $sql so they
aren't being kept. Does it actually break or is it not appending the
additional string? I'd try printing out the $sql and see what you're
getting
Yep, that'll be it.
Thanks for the help. :)
torrent
Charles F. McKnight [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
On Tue, 30 Oct 2001, TorrentUK wrote:
SNIP
you either need to pass the variables to the function or use global
variables in the
?php
/*
Hi,
I'm new to PHP and am having trouble understanding how to use PHP
sessions. My book tells in near the beginning how to start them and register
session variables, but I can't figure out how to destroy a session or later
read those session variables. I'm also trying to do this
hi all,
i am using redhat. i am able to run php script thro' webpage. but, failed to
use mysql functions in php. is there any extra work need to initialize these
functions?
my code and error are shown as below,
code
?
echo text generated by php br\n;
echo $rmnum;
You do not need to destroy session variables. You can
session_unregister() them, if you'd like.
$session_start();
$foo = Hi;
session_register(foo);
Next page...
if (isset($foo))
{
echo $foo; // will print Hi if done correctly
session_unregister(foo);
}
Sessions are automatically
On Wednesday 31 October 2001 05:11 am, Jason wrote:
The date field is varchar. And I believe it is for daylight savings.
I am trying out a couple of things on a test date field so I will get
back with you guys after I try your suggestions. And by the way I
sincerely appriciate all the help
hi,
i found very strange problem on mysql query. here is my code and result...
very strange!
pls help ...! thanks,
* code ***
?
$link=mysql_pconnect(192.168.0.101, chaze, apple) or die (failed);
mysql_select_db(stjohn);
$query=select * from user a, data b where a.room_num =
On Wednesday 31 October 2001 14:42 pm, JIM wrote:
hi,
i found very strange problem on mysql query. here is my code and
result... very strange!
pls help ...! thanks,
[snip]
printf(%s %s $sbr, $row-name, $row-room_num,
$row-update_time);
printf(%s %s $sbr, $row-name,
TO THE 9 BEST PORN SITES ON THE WEB
http://www.geocities.com/horstyqse/
JUST CLICK THE ABOVE LINK TO GET YOUR
FREE HARDCORE ACCEESS
AND I'LL SEE YOU INSIDE
WARNING: This site contains explicit sexual material.
You must be 18 or older to proceed.
To be taken off this
38 matches
Mail list logo