hi there,
this time i've got another problem with my set of database-tables:
i created a database (containing 6 tables) and some html-sheets for the in-
and output. so far, so good.
some values should be added to ONE of those tables table by checking
checkboxes in a form.
okay, the checked values
I don't think you need to get into global variables unless you *really* need to. In
this case it
sounds as if you don't.
OK so you have an array of checked values, so what's next? You wanna get those
variables outta that
array in your process script, and perform whatever it is you want (inser
Hello,
my application works fine with IE, but running it on NC it takes on certain
connections forever to get a response from the server.
But here it comes... as soon as I click on another window for example
make Outlook the aktive window. NC connects in the backgroud fast as light!
So what
Similar yes, solution no... But it seem only to happen when I test on my
internal test enviroment, not when deployed on more serious installed
FreeBSD or Solaris servers. (Internally I use a Win2k Prof. installation
*sigh*)
/ LJ
-Original Message-
From: Andy [mailto:[EMAIL PROTECTED]]
Se
hello again,
russ gave me a wonderful tip, but now i'm standing in front of the next
problem:
if i try to insert these values out of the array into the table of the db,
i
probably don't know the correct way.
this is how i tried it:
/*
this works fine!
*/
foreach($werbeform as $key=>$val) {
echo "$
the foreach() structure is a loop and you can't use it to assign to a variable.
Please do read the manual as it really does help you if you re stuck!
http://uk.php.net/manual/en/control-structures.foreach.php
What you need to do is arrange the query around the loop itelse, so that the variables
> greeting from gray, rainy days in berlin
It's even greyer here in Cambridge UK!
Anyway:
Book Title: "Fast and Easy Web Development"
By: Julie C Meloni
URL: www.thickbook.com
Or on amazon.com:
http://www.amazon.com/exec/obidos/ASIN/076153055X/qid=1008083185/sr=2-1/ref=sr_2_75_1/002-6473897-58
Hi,
Having to manny indices to a table,does it effect the performance of a table.Like
a table having following structure
Name :
First name,
Second Name,
Third name,
Age,
Address.
Is it good here to have multiple indices like on only first name, only second
nam
Hello all,
I used to following test-script to analyze my problems with
sleeping-MySQL-pconnects:
Script:
...";
$res = query($sql);
echo "\">";
?>
Required file (database.php):
";
$username = "";
$password = "";
$database = "";
$connect = mysql_pconnect("$hostname","$usern
Hello,
I'm accessing DBASE files (*.dbf) through the ODBC API
of a PHP 4.6.0 module.
I can select information, I can insert information
but I can not delete neither update.
Here is my code and the associated error messages :
$connect_odbc=odbc_connect($Host,"","",SQL_CUR_USE_ODBC) or die("Erre
I'm trying to insert information into a datetime field in a MySQL
database with the following:
INSERT INTO thisdb (event) VALUES ((now() + 3600);
But it only works sometimes. Why sometimes? What would be a better way
of doing it?
--
PHP Database Mailing List (http://www.php.net/)
To unsub
helo,
i have site navigation, for example: you are here: home > music > jazz >
musicians.
i get this by put an 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]
Check out the php-navigation section at hotscripts.com. I found exactly that on there
a couple of
weeks back, it utilises cookies.
Cheers
Russ
On Tue, 11 Dec 2001 23:23:02 +0700 RSalomo <[EMAIL PROTECTED]> wrote:
> helo,
>
> i have site navigation, for example: you are here: home > music > j
How do I compile PHP to include postgreSQL support? Do I add a
switch of some sort during 'configure'? I'm using unix(Darwin
5.1).
regards,
Michael
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hi,
Check the description and the comments on
www.php.net/manual/en/features.persistent-connections.php
there is a very good explanation of this problem.
The basic idea is that mysql_pconnect() will not reuse connections opened by different
httpd processes. If you don't expect more
than 100 con
Can any body help.
When i use a dropdown list for input to my database it can't use the first
value. The rest of the values work fine.
this is the source of my list
Open
In behandeling
Afgehandeld
check my
Hi
Could you be more specific about the thing that it works only sometimes - when doesn't
it work and what happens then.
You can check and try the date_add() function but probably the problem is in your
query.
Dobromir Velev
Web Developer
http://www.websitepulse.com/
-Original Message--
>INSERT INTO thisdb (event) VALUES ((now() + 3600);
try rather VALUES (now() + INTERVAL 3600 SECOND)
charles lahlou
--
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 administrat
Hi Everyone,
I'm running a script that automatically reads lines from
/var/mail/myaccount, parses the lines then insert specific items into a
database this is in a loop
What i want to do is then delete the contents of the file, but not the file
itself...can you tell me the best way to do thi
BTW,
IN SQL ANSI, these functions are standard too? Don't they?
- ADDDATE(date1, INTERVAL value UNIT)
with UNIT = SECOND, HOUR_SECOND, DAY, and so on...
- MOD(value, modulo)
and its shortcut value%modulo
- Arithmetic operators such as && + ||
- Is it Better to use <> or !=
- Is the
Aha. That seems to work.
thanks,
bill
Charles Lahlou wrote:
> >INSERT INTO thisdb (event) VALUES ((now() + 3600);
>
> try rather VALUES (now() + INTERVAL 3600 SECOND)
>
> charles lahlou
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For
Anna,
Check the docs, but I believe if you fopen() with the "w" flag it
overwrites the contents.
Miles
At 05:03 PM 12/11/2001 +, DigitalKoala wrote:
>Hi Everyone,
>
>I'm running a script that automatically reads lines from
>/var/mail/myaccount, parses the lines then insert specific items i
Hi there everyone :-)
I have a question about Session usage. I am passing data from 1 page to another via
the toolbar (Forgot the method name, sorry :-) and then when the client clicks on "Add
to shopping cart" it adds it into a session to store the data for checkout or to
continue shopping.
Can anybody help me! I've been getting a error message like this for the last few days.
Warning: OCIStmtExecute: ORA-01722: invalid number on line 49
Array
Every time I try to enter a project using a HTML form
Line 49 in apparently the line that says:
$result = OCIExecute(ins_statement);
Below
Hi Markus
I assume you're using Apache with PHP installed as a DSO? If not ignore my
ramblings...
AFAIK, the persistent connections are per-process - i.e. each Apache process
gets its own [set of] persistent processes.
But when you connect to apache, you rarely get the same process as you go
On Tuesday 11 December 2001 20:16, Michael Hanna wrote:
> How do I compile PHP to include postgreSQL support? Do I add a
> switch of some sort during 'configure'? I'm using unix(Darwin
> 5.1).
Yes.
./configure --with-pgsql ... ...
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Same happens for me. I don't know if the problem is Windows (Microsoft is
able to do whatever, and you know, Microsoft is really dirty).
If anyone has a tip, please let us know.
_
Dario Fernando Escobar Risueño
Webmaster Telesat S.A.
[EMAIL PROTECTED]
Cali - Va
you're right. It only happens when I'm trying with my own server, not with
others.
Sure Microsoft has something to do with this.
_
Dario Fernando Escobar Risueño
Webmaster Telesat S.A.
[EMAIL PROTECTED]
Cali - Valle - Colombia
- Original Message -
From:
I suggest:
SELECTED>
-Original Message-
From: venomous [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 10:43 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] dropdlist doens''t work quite well
Can any body help.
When i use a dropdown list for input to my database it can't use th
as some of you may have noticed over the last few days, a new method of
spam protection has been implemented on lists.php.net.
if you post to one of the lists.php.net lists (via mail or the news
server at news.php.net) from a mail address that is not subscribed to
the mailing list, you will rece
I am having a problem designing a query on a mysql 3.23 database.
I have 2 tables - "member" and "movie".
The "member" table stores the people details, the "movie" table records the
movies they have seen (each record is one movie).
MEMBER
memberid int not null auto_increment primary key,
membern
The following will list movies seen by each member:
SELECT membername,movietitle FROM member,movie WHERE
member.memberid=movie.memberid
This one lists all members who have seen these 3 movies.
SELECT membername FROM member,movie WHERE member.memberid=movie.memberid &&
movietitle="Star Wars" && mo
Using simple test scripts, I'm connecting to a MySQL DB through PHP after
inputting info into a form and hitting submit. Something is putting three
records instead of one into the mySQL DB.
For instance:
the two variables are: $event_title and $event_desc. These are gotten from
the form submittin
Lynne,
1. Where are you testing for the action of the form?
2. What triggers the insert?
For more on this, have a look at the custom error tutorial put up by Julie
Meloni at http://www.thickbook.com
Right now it looks as if you are inserting a record every time the page
loads. So you would ge
Hi
where can I find pear.php
I install 'moregroupware' and comment about missing PEAR classes
thanks
--
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: [EM
I have been unable to get the mail() function to work.
my php.ini file has the following line in it:
SMTP = mail.attbi.com
my php script is as follows:
Every time I run this script, I receive "Mail could not be sent..."
Any thoughts?
--
PHP Database Mailing List (http://www.php.net/)
To un
not that has anything to do with databases directly...
in your line;
mail($email, "Test", $mesg, $from)
the "$from" var is not actually supposed to be an email address (RTFM) - it
is additional headers, so if you are trying to set the from address, use
$from = "From: ";
that might help
You want to use --with-pgsql=/usr/local/pgsql - but change this path to
point to where you installed PostgreSQL. If you compiled pgsql yourself and
didn't specify a path, the path I gave you there is the default I believe
and should work.
--Jon
At 07:16 AM 12/11/2001 -0500, Michael Hanna wro
38 matches
Mail list logo