just put the variables from the form into the mail() function
On Wed, 2002-10-02 at 23:11, Shoulder to Shoulder Farm wrote:
> Sorry all, this IS off topic, but I always receive faster answers from
> this group :-o!
> How can I send e-mail from PHP with the content of a submitted form.
> Thanks,
Sorry all, this IS off topic, but I always receive faster answers from
this group :-o!
How can I send e-mail from PHP with the content of a submitted form.
Thanks, Taj
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
If it's on MySQL, then the problem is that it doesn't support nested queries
:)
If it's on something else, i'm afraid i don't know :/
Back to MySQL, you can get around that by doing your "select author_code
from authorxcat" component query, then put the results into 'x', 'y', 'z'
format, then do
hi,
i have a function that returns a cursor. how do i get at it in php?
here's my function:
create function test3 (INTEGER) RETURNS refcursor AS '
DECLARE
cursor1 CURSOR FOR select description FROM t0040stock_item WHERE
stock_number = $1;
BEGIN
open cursor1;
return (cursor1);
END;
' LANGUA
Are tables able to be indexed?
How should the key be applied here?
This is from Jay Greenspan's great Mysql/Php book.
I looked for error disclaimers.
I think it us just transposed ???
Is this a typo? In primary and key indexes
" key stage _user_map_key "
drop table if exists user_stage_map ;
> New MySQL is out I noticed (4.0.4). Is there any way to make it work
> correctly with PHP? I haven't seen any modules for download or
comments
> about this issue.
>
> I'm just wondering if there is some modifications I can make or if I'm
> just
> stuck with MySQL 3.x until something new is re
> I am fighting a time issue(don't we all). I have a online poll set up.
I
> need a way to stop a person from
> submitting more than once an hour. As of now I have the time ..
mktime(
> ) .. being stored in a database along
> with the users IP.
>
> I want to be able to say if 1 hour has passed fr
This is not a safe way to do it unless you are locking the table,
getting max value, doing insert with value retrieved, and then unlocking
table. Reason being is that two scripts (or more) running at the same
time can retrieve the same max() value and try to insert it.
---John Holmes...
> -O
Try this
http://www.mydomain.com/phpmyadmin/ and be ready with your password.
Russell Griechen
> You should ask if your ISP has not already installed a phpMyAdmin that you
> can use - save you the bother.
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://
for mySQL, the table would look like...
CREATE TABLE polls(
pollID INT NOT NULL AUTO_INCREMENT,
ipAddress VARCHAR (50) NULL,
insertTime DATETIME NULL,
etc...
PRIMARY KEY (pollID)
);
===
the code would look like...
$statement = "se
Leo Hotmail wrote:
>
> I've installed Linux Red Hat 7.1 with php 4 and have the this libraries in
>/usr/lib/php4
>
> pgsql.so
> ldap.so
> imap.so
>
> but I need Microsoft SQL Library: mssql70.so
>
> how can I install it?
freetds.org has a library that will allow you to connect to mssql 7
You can select max(aifield) immediately after the insert. :-)
<>< Ryan
-Original Message-
From: Stéphane [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 11:57 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Retrieve auto_increment value after an insert with
ODBC
Hi,
I use php
Hi,
I use php and db2 database. I wonder if there is a way to retrieve the
value of an auto-increment id after an insert query.
(Like mysql_insert_id on MySQL database.)
The temporary solution is to select record with the same values than the
insert.
Any others solutions?
--
PHP Database Ma
yeah - the mktime function is returning unix style time (seconds since 1970)
which is why only the last few numbers are changing. I would recommend
letting the database decide who is able to submit... i.e.
select * from database where lastSubmitDate > 'now()- 1 hour' and IP =
'$ipaddress'
if th
Hello all,
I am fighting a time issue(don't we all). I have a online poll set up. I
need a way to stop a person from
submitting more than once an hour. As of now I have the time .. mktime(
) .. being stored in a database along
with the users IP.
I want to be able to say if 1 hour has passed from
---> mysql_result($result_category_id, 0, $i);
I think it is compaigning about the '$i' of course we don't know
what that is set to, so cannot help much. I would say it might not like it
when '$i' is equal to 0... :-)
-Brad
> Hello guys.
>
> The scenery: I've got an array with some values st
Hello guys.
The scenery: I've got an array with some values stored in it. I want to
retrieve the id code each value is associated to. So I just do the following:
for ($i=0; $i";
}
I'm getting the following in my browser (There are some comments I just
added):
Arquitectura 2 //This is th
You need the FreeTDS connection library (it works wonders for us):
Goto www.freetds.org
Download it
Configure, make, make install it
Edit your freetds config file to your needs
Add the --with-sybase=/path/to/freetds to your PHP configure line
yes, I know that says sybase, but trust me, it works.
I've installed Linux Red Hat 7.1 with php 4 and have the this libraries in
/usr/lib/php4
pgsql.so
ldap.so
imap.so
but I need Microsoft SQL Library: mssql70.so
how can I install it?
Leo
I have connected successfully to an MSSQL server, as can be seen by the
following generated list of existing tables:
http://webworks.ie/200210/
When I try to select from those tables, I get errors, as seen here:
http://webworks.ie/200210/newhomes.php
The source of the above is here:
http://webw
I have connected successfully to an MSSQL server, as can be seen by the
following generated list of existing tables:
http://webworks.ie/200210/
When I try to select from those tables, I get errors, as seen here:
http://webworks.ie/200210/newhomes.php
The source of the above is here:
http://webw
I would use JOIN syntax - then change your join type based on what you want
to see in the results...(INNER JOIN, LEFT JOIN, RIGHT JOIN, LEFT OUTER etc.)
SELECT updates.MODELCODE, SETNO, FRPICNO, TOPICNO, CPOSTDATE, MODELNAME,
ZIPFILENAME, TOTPICS FROM updates
LEFT JOIN models ON updates.MODELCODE
hi all
this query:
SELECT updates.MODELCODE, SETNO, FRPICNO, TOPICNO, CPOSTDATE, MODELNAME,
ZIPFILENAME, TOTPICS FROM updates, models WHERE updates.MODELCODE =
models.MODELCODE AND CPOSTDATE <= CURDATE() AND CPOSTDATE >= ( CURDATE() -
14 ) ORDER BY CPOSTDATE
LIMIT 0, 30
worked perfectly until t
hi all
this query:
SELECT updates.MODELCODE, SETNO, FRPICNO, TOPICNO, CPOSTDATE, MODELNAME,
ZIPFILENAME, TOTPICS FROM updates, models WHERE updates.MODELCODE =
models.MODELCODE AND CPOSTDATE <= CURDATE() AND CPOSTDATE >= ( CURDATE() -
14 ) ORDER BY CPOSTDATE
LIMIT 0, 30
worked perfectly until t
if you are using mysql, it doesn't support the sub-select.
"Wilmar Perez"
Hello guys
Does anybody have a clue on what wrong with the following sentence?
select author_code from author where author_code not in
(select author_code from authorxcat);
Thanks
***
Well, I'm not the best qualified to answer this question but here goes my
best shot (Guru's watch me here make sure I don't screw this up).
Starting with Apache. Apache does not actually process your *.php files.
There is another engine that takes care of that called Zend. There are a
couple lin
You should ask if your ISP has not already installed a phpMyAdmin that you
can use - save you the bother.
-Original Message-
From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 9:57 AM
To: 'Brett Lathrope'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Noob
search around for phpmyadmin on google
Adam
On Wed, 2 Oct 2002, Brett Lathrope wrote:
>
> Ok, here's my scenario...
>
> My Web Host has all Root Admin control over MySQL and PHP configs (but they
> are setup well no complaints there)...I simply have access to 1 DB (alrea
Give phpMyAdmin a try...
http://www.phpmyadmin.net/
-Original Message-
From: Brett Lathrope [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 02, 2002 8:55 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Noob questions...
Ok, here's my scenario...
My Web Host has all Root Admin
Ok, here's my scenario...
My Web Host has all Root Admin control over MySQL and PHP configs (but they
are setup well no complaints there)...I simply have access to 1 DB (already
created) that I can do what I want with (create/delete/update tables).
I'm VERY comfortable in Windows, C/C++, Delphi
Hi there,
Wonder if someone could help me, I have not touched PHP in a while now so a little
rusty.
What i have is a news page now the news story is disaplayed when someone clicks the
item from the home page, which then loads a news page, but the problem I am having is
when the news page load
Hi there,
Wonder if someone could help me, I have not touched PHP in a while now so a little
rusty.
What i have is a news page now the news story is disaplayed when someone clicks the
item from the home page, which then loads a news page, but the problem I am having is
when the news page load
New MySQL is out I noticed (4.0.4). Is there any way to make it work
correctly with PHP? I haven't seen any modules for download or comments
about this issue.
I'm just wondering if there is some modifications I can make or if I'm just
stuck with MySQL 3.x until something new is released by the
Hello List for the first time,
I am very new to php but impressed from what i've seen so far. I managed to
configure php w/ mysql and db2 do some selects, inserts ...
What I am inerested in is what are all those mod_php* and php_* on the
distribution's CDs e.g. if they are installed how do i ge
Hello List for the first time,
I am very new to php but impressed from what i've seen so far. I managed to
configure php w/ mysql and db2 do some selects, inserts ...
What I am inerested in is what are all those mod_php* and php_* on the
distribution's CDs e.g. if they are installed how do i ge
36 matches
Mail list logo