On Tuesday 11 June 2002 14:04, George Pitcher wrote:
Suman,
Firstly, it's a bit longer than necessary.
Make your form a 'POST' rather than 'GET' and you'll hide your query and
?php
echo $fname;
?
will then be the equivalent.
That requires 'register_globals' to be enabled, which for
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
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 List
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
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
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
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
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 the case
to be a
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 to
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 possibly
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
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
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
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 hrExecution
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:
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 worked
21 matches
Mail list logo