Hi
Can anyone shed some light on this problem?
The DB update only happens when I change the if(isset($submit)) to read
if(!isset($submit)).
Yes, I am using PHP 4.0.6 but have also tried with PHP 4.2.2, same problem.
Code snippet:
//HTML body
?php
if(isset($Sumbit)):
/*
I'm a little confused/worried about database transactions, persistent
connections and PHP.
I am worried that if I use persistent connections it might be possible
for more than one PHP script to be inside the same transaction at the
same time.
For example:
1- page1.php is a script that opens
I'm working on the same problem but I need to read the code, not write
it:, here are a few links and my code if you might help me in return:
http://www.experts-exchange.com/Web/Web_Languages/PHP/Q_20117420.html
my code:
mysql_db(); # connects to mysql
for($i = 0; $i sizeof($check); $i++) {
#
Could somebody explain to me how the ereg_replace function works?
For as for as I understand it replaces strings by a different string (as
explained on the php site) but what I don't understand is how the
following line creates real links:
$Content =
At 17:46 +0900 8/31/02, Jean-Christian Imbeault wrote:
I'm a little confused/worried about database transactions,
persistent connections and PHP.
I am worried that if I use persistent connections it might be
possible for more than one PHP script to be inside the same
transaction at the same
How can I use php to get the newest entry from mysql database? Ie, if I
make a timestamp and then I want to retrieve the last timestamp I made
how do I go about doing it? Any php or mysql documentation?
- Victor www.argilent.com
There might be a better way, but you can always do:
Select * from table order by timestampfield desc limit 1
HTH,
Jed
On the threshold of genius, Victor wrote:
How can I use php to get the newest entry from mysql database? Ie, if I
make a timestamp and then I want to retrieve the last
for($i = 0; $i sizeof($check); $i++) { # start repating query
# turn pictures in order delete capability off
mysql_query(UPDATE kodak_user_pictures
SET order=1
WHERE ID='$check[$i]') # turn off pictures
or die ('Unable to turn bit off '.mysql_error());
} # end repeat
You have an error in your
Yep, figured it just now, thanks anyway, ahhh.. You'd thing they put
reserved names right besides the damn mysql command in the manual. Alas
it shall not be so.
- Victor www.argilent.com
-Original Message-
From: Chris Knipe [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 31, 2002
Ahem. Why not check out the MySQL docs for reserved words (they _are_ right
there ...):
http://www.mysql.com/doc/en/Reserved_words.html
PHP Docs are for PHP. MySQL Docs are for MySQL. PHP != MySQL.
-Original Message-
From: victor [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 31,
I meant besides the UPDATE or SELECT or any filed that those words might
interfere with...
- Victor www.argilent.com
-Original Message-
From: Mark Charette [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 31, 2002 2:18 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] RE:
Then check the MySQL manual using the URL I posted!
PHP doesn't care about the hundred or so reserved MySQL words. MySQL does.
Perhaps you're confusing the two. Please check what I said:
PHP != MySQL
The documentation for each is separate. PHP has convenience functions for
talking to a MySQL
Hi,
I've tried the solution you gave to be able to see the line breaks of a blob
field of MySQL and it doesn't work.
Sorry, I'm a newbie to PHP MySQL. Can you imagine why it's not formatting
(eg. line breaks) the text?
Thanks in advance.
Jorge
Ray Black III [EMAIL PROTECTED] escreveu na
Paul Dubois wrote:
I am worried that if I use persistent connections it might be possible
for more than one PHP script to be inside the same transaction at the
same time.
Not at the *same* time, because although a persistent connect might be
used by more than one script, this will
Here is the code in config.inc.php
$cfgServers[$i]['host'] = 'mydomain.com'; // MySQL hostname
$cfgServers[$i]['port'] = ''; // MySQL port - leave
blank for default port
$cfgServers[$i]['socket']= ''; // Path to the socket -
leave blank for default
15 matches
Mail list logo