[PHP-DB] Erratic isset()

2002-08-31 Thread simon
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)): /*

[PHP-DB] transactions and persitent connections

2002-08-31 Thread Jean-Christian Imbeault
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

RE: [PHP-DB] How to pass multiple checkbox values thru form??

2002-08-31 Thread victor
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++) { #

[PHP-DB] ereg_replace

2002-08-31 Thread Prodoc
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 =

Re: [PHP-DB] transactions and persitent connections

2002-08-31 Thread Paul DuBois
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

[PHP-DB] newest entry in db

2002-08-31 Thread Victor
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

Re: [PHP-DB] newest entry in db

2002-08-31 Thread Jed Verity
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

[PHP-DB] why do i get this error please tell me?

2002-08-31 Thread Victor
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

[PHP-DB] RE: [PHP] why do i get this error please tell me?

2002-08-31 Thread victor
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

[PHP-DB] RE: [PHP] why do i get this error please tell me?

2002-08-31 Thread Mark Charette
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,

RE: [PHP-DB] RE: [PHP] why do i get this error please tell me?

2002-08-31 Thread victor
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:

[PHP-DB] RE: [PHP] RE: [PHP-DB] RE: [PHP] why do i get this error please tell me?

2002-08-31 Thread Mark Charette
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

Re: [PHP-DB] Wrapping problems

2002-08-31 Thread Jorge Pinto Leite
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

Re: [PHP-DB] transactions and persitent connections

2002-08-31 Thread Jean-Christian Imbeault
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

[PHP-DB] Configuring www.phpmyadmin/config.inc.php

2002-08-31 Thread Russell Griechen
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