Re: [PHP-DB] ODBC support

er information. 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

rder']; if (! $sort_order) {$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://w

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

could create an IPSec (or maybe an SSH) 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 (ht

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

he DB.php file. 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://w

Re: [PHP-DB] SQL Server Query Failed

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

Re: [PHP-DB] MySql query

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] OK, ahí voy...

as to what you'll do next. 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

ost you my own brute-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] An if-statement in a "while(list("

" Any suggestione to me on showing a graphic with a link when $mail is different from null? Build the inside of your loop like this... print("$navn "); if ( $mail!='' ) then [print the icon here] else echo "$mail"; Bruno Ferreira --- [Th

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

e that as well into your 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 s

Re: [PHP-DB] PHP Arrays

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 t

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

o PHP 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] get rid of the HTML tags

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: http:

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

e') --> Enter's three rows 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?

Re: [PHP-DB] using a define value

uot;.ERROR."._$myerror.""; 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] Multiple work mySql database search.

ORs like this: Searching for all words in a field: WHERE (field LIKE '%something% AND field LIKE '%other_thing') Searching for any of the words in a field: [read above in the previous question] 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] Linux/PHP/Access Database - oh boy :(

em in the Firebird db (SELECT from 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] Image / file uploader

tc action=\"$_SERVER[PHP_SELF]\" etcetc"; 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://

Re: [PHP-DB] looking for a variable

er IN? No :\ What did you want to do with that number? 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] date and time problem

2004 02:00 (probably because we are 2 hours ahead of GMT) Any ideas please? Thanks K Well, a solution could easily be arranged to use both fields, but really, the best thing to do is to just use a DATETIME field in MySQL instead of using both DATE and TIME fields. That will save you a lo

Re: [PHP-DB] undefined function

sql.dll" isn't commented out. Things should go back to normal. 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

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

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

tension 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 unsubscri

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

ate("Y/m/d"); You 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 Declu

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

eral queries at once? any workaround? 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-

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

mi hits per day. 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