Try adding 'distinct' before the field you are selecting.
-Lisi
At 01:42 AM 6/8/02 +0100, Georgie Casey wrote:
>Is there any SQL command that will return a list of *unique* entries from a
>fied. ie only repeat one for duplicates
>
>i have a database of products, each having a category, and obvio
If you are on Windows you can just point to your ISP's SMTP server in your
.ini file.
At 11:02 AM 6/10/02 +0200, Dib, Walid (MED, Stagiaire GEMS) wrote:
>Hello
>
>I want to test the mail() function locally, i'm using esays php, how can I
>do that?
>thanks
>
>Walid
>
>
>
>--
>PHP Database Mailing
Hi there,
I have some db records starting with a ' E.g: 'Aimburu
Now I am wondering how to retrieve this records. without a addslashes it
returns an error. So I did add a slash, but then it does not find this
record.
I tryed this query:
...like '\'Aimburu %' ...
Do I have to change this db e
Hi NG Users,
I have sent this message to php.general too, but didn't get any response
there. It looks like this is all to new for most of the readers... Since
LDAP is some kind of db too, I thaught I'd send it to php.db...
I'm implementing some php 4.2.x code to manipulate Microsofts Active
Dire
Hi there,
I have some data in one table which I have to move to another. No I thought
of a mysqldump with a where clause. The problem though is, that it also
tryes to insert the ID which is a autoinc. primary key and already in use by
another record. How can I produce a insert statement withouth
I want to test a value that was typed into a form, but I don't want the case
to be a problem, how can I get around this??
This is what I have now:
function calculate_tax($OrderedByState,$ShipState)
{
global $totalPrice;
//tax calculation
$taxRate = "0.05";
if ($OrderedByState=="MA" && $ShipS
PLEASE IGNORE!
Thanks!
"James Kupernik" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I want to test a value that was typed into a form, but I don't want the
case
> to be a problem, how can I get around this??
>
> This is what I have now:
>
> function calcu
Use strtolower() on all entries from the form, so you can compare them (in lowercase)
without worry about whether the user entered "MA", "ma", "Ma", or "mA".
Martin
>>> "James Kupernik" <[EMAIL PROTECTED]> 06/11/02 10:15AM >>>
I want to test a value that was typed into a form, but I don't want
on 6/11/02 10:15 AM, James Kupernik at [EMAIL PROTECTED] appended the
following bits to my mbox:
> I want to test a value that was typed into a form, but I don't want the case
> to be a problem, how can I get around this??
This isn't a database related question, so it should probably be posted t
> have you tried yet?
>
> $ad = ldap_connect('ldaps://your.ldap.server', 636);
> $bound = ldap_bind($ad, 'somebinddn', 'somepasswd');
>
> worked "out of the box", using it manage over 20,000 users at a
> university...can authenticate and change passwords, etc.
>
Sure, I tried this. Do you pos
I am getting this error with a new install of PHP4.2.1 and Zend
Optimizer 1.3.1:
The file '/tmp/phpr4WYQY' must be in the database directory or be
readable by all
I just updated PHP and the Zend Optimizer, and it had worked previously
with PHP4.1.2,
Any ideas??
Thanks
--
PHP Database Mai
hi to all,
how can I set up a timer that will tell me how long a query takes to run.
for example, if I run the following query, I would like to know how long it
takes.
$query_prism = "INSERT INTO prism_rec_status(prism_rec_id) select 150bk.ID
from 150bk
WHERE PHY_ST='IN' Or PHY_ST
You could probably use:
$start = time();
//run query
$end = time();
and then compare start and end. I don't know how time() formats the time,
but that's probably on PHP.net.
-Natalie
-Original Message-
From: Natividad Castro [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 11, 2002 1:2
Just set one variable $var1=time(); before you call mysql_query and then subtract it
from time(); after the query. That will be the number of seconds. If you need better
precision you can use milliseconds too:
$t1 = getmicrotime();
$result_query = mysql_query($query_prism);
echo "Execution Time
oopsss... I should put the getmicrotime() function... sorry, here it is:
function getmicrotime(){
list($usec, $sec) = explode(" ",microtime());
return ((float)$usec + (float)$sec);
}
-Original Message-
From: Ryan Jameson (USA)
Sent: Tuesday, June 11, 2002 11:22 AM
To: [E
Hi there,
I have some data in one table which I have to move to another. No I thought
of a mysqldump with a where clause. The problem though is, that it also
tryes to insert the ID which is a autoinc. primary key and already in use by
another record. How can I produce a insert statement withouth
Hi there,
I have some data in one table which I have to move to another. No I thought
of a mysqldump with a where clause. The problem though is, that it also
tryes to insert the ID which is a autoinc. primary key and already in use by
another record. How can I produce a insert statement withouth
Hi there,
I have some data in one table which I have to move to another. No I thought
of a mysqldump with a where clause. The problem though is, that it also
tryes to insert the ID which is a autoinc. primary key and already in use by
another record. How can I produce a insert statement withouth
[snip]
I have some data in one table which I have to move to another. No I thought
of a mysqldump with a where clause. The problem though is, that it also
tryes to insert the ID which is a autoinc. primary key and already in use by
another record. How can I produce a insert statement withouth the
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] says...
> I am getting this error with a new install of PHP4.2.1 and Zend
> Optimizer 1.3.1:
>
> The file '/tmp/phpr4WYQY' must be in the database directory or be
> readable by all
>
> I just updated PHP and the Zend Optimizer, and it had worke
> hi to all,
> how can I set up a timer that will tell me how long a query takes to run.
> for example, if I run the following query, I would like to know how long
it
> takes.
[...]
> Thanks in advanced
> Nato
I don't remember where I 've found this snippet, but it works well.
$TIMER_START = e
21 matches
Mail list logo