Re: [PHP-DB] Email confirmation?

2003-06-11 Thread Bruno Gimenes Pereti
Keep the context of the email in a variable, add the details of the product in each loop. Then you can call mail() with the complete order information. PS. Don´t you think it´s better to query the db only once asking the details for all the products ordered? Bruno Pereti. - Original Message

[PHP-DB] SQL question!

2002-06-27 Thread Bruno Gimenes Pereti
but it´s something I really need to know. Thank´s Bruno Gimenes Pereti. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Replacing * with %

2002-01-15 Thread Bruno Gimenes Pereti
Hi Markus, I think you forgot to assign the value of ereg_replace to a variable. I made this test and it worked: ? $t = 'abc*cde*'; printf(%s\n, ereg_replace(\*, \%, $t)); // or $result = ereg_replace(\*, \%, $t); ? Hope it helps, Bruno Pereti. - Original Message - From: Markus

Re: [PHP-DB] Re: MySQL/PHP and the case of Good Lord, that's a lot of statements

2002-01-15 Thread Bruno Gimenes Pereti
Uoh, It's a big one... Some thougths I had while reading your e-mail: - There is an option in php.ini where you can disable error messages (someone wrote to the list, it might be in the archive). And I found in my php.ini now the error_reporting option, maybe you could set it to E_ALL to see if

[PHP-DB] MySQL table recovery.

2001-12-06 Thread Bruno Gimenes Pereti
Hello, Is there a way to rollback a 'delete from table;' command in MySQL 3.23.36-1? Yes I did it... I pressed enter instead of backspace. Did I lost my table content? I have no backup of this especific database. PS: I didn't close the connection with the database yet. Thank for any help, even

Re: [PHP-DB] MySQL table recovery.

2001-12-06 Thread Bruno Gimenes Pereti
Hi Jon, Thank you. I don't even know how to work with transaction in mysql. No problem, just more work. It is a table that store all comments done in my site. It's also sent to my e-mail. Thank's again. Bruno. - Original Message - From: Jon Farmer [EMAIL PROTECTED] To: Bruno Gimenes

Re: [PHP-DB] Ms SQL.

2001-11-22 Thread Bruno Gimenes Pereti
and the PHP support was built in so I guess that it's a recompile. How do I do that ? Matt Bruno Gimenes Pereti wrote: Hi matthew,Bruno Gimenes Pereti wrote: Hi matthew, you probably don't have the file php_mssql.so in your extension dir, do you? 2 options: - compile php

[PHP-DB] image content in mail().

2001-11-14 Thread Bruno Gimenes Pereti
Hi, Who can I send an HTML e-mail with a image with mail()? Can PHP encode the image for me? Thank's Bruno. -- 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,

Re: [PHP-DB] Oracle via php under windows 2k

2001-11-14 Thread Bruno Gimenes Pereti
I don't use oracle with my windows php but in my extensions directory there is a php_oci8.dll. Do you have it? did you uncomment the line in your php.ini? If you installed your php from the installer, probably you don't have this file. download the zipped file from www.php.net and extract the

Re: [PHP-DB] Problem with include()

2001-11-13 Thread Bruno Gimenes Pereti
Try this way: in your php script: $foo = something; include(path/file.php); print $bar; in your file.php (included): globals $foo; $bar = $foo. working; I think this example will help... Bruno. - Original Message - From: TorrentUK [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent:

Re: [PHP-DB] any extra work need to make php mysql function available?

2001-10-31 Thread Bruno Gimenes Pereti
uncomment the line that enables the extension in your php.ini: extension=mysql.so if it don't work verify the line extension_dir = /usr/lib/php4 and if the file mysql.so is in this directory. Bruno Gimenes Pereti. - Original Message - From: JIM [EMAIL PROTECTED] To: [EMAIL PROTECTED

Re: [PHP-DB] Variables in a loop

2001-10-30 Thread Bruno Gimenes Pereti
try form... input name=a[] value=.. input name=a[] value=.. input name=a[] value=.. input name=a[] value=.. and for ($i=1; $i=10; $i++) { $tab[$i]=$a[$i] ;} This way $a will be a array. Hope it helps Bruno Gimenes Pereti. - Original Message - From: LeTortorec, Jean-Louis [EMAIL

Re: [PHP-DB] PHP query on date field

2001-10-30 Thread Bruno Gimenes Pereti
understand what I mean :-) Bruno Gimenes Pereti. - Original Message - From: Jason [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 30, 2001 3:31 PM Subject: [PHP-DB] PHP query on date field Here is my problem once again... =P I am wondering if I should change the date table

Re: [PHP-DB] PHP query on date field

2001-10-30 Thread Bruno Gimenes Pereti
. {Hope this helps} else {tell us}. Bruno Gimenes Pereti. - Original Message - From: Big Nickel [EMAIL PROTECTED] To: Bruno Gimenes Pereti [EMAIL PROTECTED] Sent: Tuesday, October 30, 2001 4:02 PM Subject: Re: [PHP-DB] PHP query on date field I apologize... there really isn't any error

Re: [PHP-DB] PHP query on date field

2001-10-30 Thread Bruno Gimenes Pereti
Hi again Jason, I think Jason Wong got the problem I missed, it's the date format. If you tested like I sad in the last mail you already found it. When you query: SELECT * FROM ads WHERE date = '%$date%'; you get an empty result. So, that's the solution... Bruno Gimenes Pereti. What

Re: [PHP-DB] getting results from INSERT

2001-10-26 Thread Bruno Gimenes Pereti
I think you want this. $sql = INSERT INTO table (cod, nome, email) VALUES ('', '$nome', '$email'); $result = mysql_query($sql); $cod = mysql_insert_id(); The $cod is the primery key. Hope it helps. Bruno Gimenes Pereti. - Original Message - From: Matt Stewart [EMAIL PROTECTED

[PHP-DB] PHP Paradox.

2001-10-25 Thread Bruno Gimenes Pereti
Paradox] Não foi possível abrir PARADOX.NET., SQL state S1000 in SQLConnect in c:\inetpub\wwwroot\odbc.php on line 2 Please, I'm desperate. Thank's. Bruno Gimenes Pereti. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e

Re: [PHP-DB] array-problems

2001-10-24 Thread Bruno Gimenes Pereti
It looks like you need only one array, $date[begin] = $date[end]. Let's see, I think it'll work. I'll write it in your code then you try: $i=0; $result = mysql_query (SELECT DISTINCT date FROM linktracker WHERE name LIKE '$PHP_AUTH_USER' ORDER BY date); if ($row = mysql_fetch_array($result)) {