Re: [PHP-DB] multiple queries in the same request

2005-06-20 Thread Bruno Ferreira
? You can't send multiple queries in an SQL statement. You can just split that in two separates queries. It's not really slower by any practical means because the DB system would have to execute them both anyway. -- Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus

Re: [PHP-DB] multiple queries in the same request

2005-06-20 Thread Bruno Ferreira
. the chance that two pairs of queries will run consecutively is imense. Then you need to use transactions, which fill your purpose :) I presume you're using MySQL or Postgres, google for START TRANSACTION and COMMIT. -- Bruno Ferreira

Re: [PHP-DB] Issue with date() function...

2005-06-10 Thread Bruno Ferreira
database system doesn't like using - as a separator in dates, thus thinking it's a minus sign and doing the appropriate math. Just use slashes and you'll probably be OK. -- Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Ora 10g, PHP 4 and Apache 2

2004-12-29 Thread Bruno Ferreira
is deprecated, and that php_oci8.dll (or .so, in your case) should be used. See http://www.php.net/manual/en/ref.oracle.php, that's were I looked. -- Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] undefined function

2004-05-21 Thread Bruno Ferreira
. Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] undefined function

2004-05-21 Thread Bruno Ferreira
Miguel Guirao wrote: First, I do not have that line in my php.ini file. In what section should I add it? Anywhere, but best place as long as organization is concerned would be under the Dynamic extensions label. Bruno Ferreira PS - You should check the default php.ini that comes

Re: [PHP-DB] Linux/PHP/Access Database - oh boy :(

2004-05-12 Thread Bruno Ferreira
one side, INSERT into the other). Should be pretty painless to do this every once in a while. Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] looking for a variable

2004-05-06 Thread Bruno Ferreira
? Maybe there is some other way around Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Image / file uploader

2004-04-29 Thread Bruno Ferreira
; When you're using an associative array inside a string, you don't need to put quotes refer to its textual index. Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] using a define value

2004-04-20 Thread Bruno Ferreira
; It not works. Does now ;) Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql multi-row insert limitations?

2004-04-16 Thread Bruno Ferreira
in the database? The limit is probably set somewhere else, like the size of the string that you can pass to mysql_query() or something similar. Even then, why don't you just split the records in blocks of X and insert them one block at a time? Bruno Ferreira --- [This E-mail scanned

Re: [PHP-DB] get rid of the HTML tags

2004-04-12 Thread Bruno Ferreira
Bruno Braga wrote: Is there any function that retrieves only the string without the html tags?! -- Hello world this is a test link with a image strip_tags() --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] Large Arrays in a batch procedure

2004-04-08 Thread Bruno Ferreira
involved here, you just use some SQL interface to your server... Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] PHP Arrays

2004-04-04 Thread Bruno Ferreira
Martin Oettinger wrote: Does anyone know up to which level arrays in variables are possible? Is there a limit? $foo[1][2][3][4][5][6] ... ? I feel the right answer is why do you ask? It's either some very complex thing you're doing there, or you're doing it the wrong way :) Bruno

Re: [PHP-DB] v4.2.3 compliant sybase_set_message_handler

2004-03-24 Thread Bruno Ferreira
PHP 4.2 sources. Anyway, I should mention that you're treading on very thin ground there... there's a lot that can go wrong :) Bruno Ferreira PS - I am not a PHP-source programmer, so someone here might have better advice than mine. --- [This E-mail scanned for viruses by Declude Virus

Re: [PHP-DB] An if-statement in a while(list(

2004-03-21 Thread Bruno Ferreira
/a; Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] OK, ahí voy...

2004-03-18 Thread Bruno Ferreira
. Spamming the same questions to several lists doesn't help the matter, either. Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Processing a fetched external page

2004-03-18 Thread Bruno Ferreira
-force get all text from a webpage script :) Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] SQL Server Query Failed

2004-03-17 Thread Bruno Ferreira
david wrote: Hello there! I have just about driven myself crazy with an odd intermittent problem. [snip] I'd first start by turning on all logging I could in the SQL server so that I could see what's happening straight from the horse's mouth... Bruno Ferreira --- [This E-mail scanned

Re: [PHP-DB] MySql query

2004-03-17 Thread Bruno Ferreira
Matt Matijevich wrote: This is probably a question for for a mysql list but I figured someone out here knows the answer. [snip] SELECT * FROM sometable WHERE 1 SELECT * FROM sometable Just that :) (do I hear you slapping your forehead? :) Bruno Ferreira. --- [This E-mail scanned for viruses

Re: [PHP-DB] How to redirect after a valid login

2004-03-15 Thread Bruno Ferreira
. Look into that, and replace require() and include() with require_once() and include_once() to avoid this kind of conflict. Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] Sending a hashed password on mysql_connect

2004-03-14 Thread Bruno Ferreira
) tunnel to the other machine and redirect it to a local port. As far as I can tell, there's no way to create a secure MySQL connection via PHP... Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] ODBC support

2004-03-11 Thread Bruno Ferreira
. Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Sort Order Description

2004-03-11 Thread Bruno Ferreira
) {$sort_order = desc;} First things first. That code (it seems to me) is vulnerable to SQL injection. Better fix that first... Bruno Ferreira --- [This E-mail scanned for viruses by Declude Virus] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net