?
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
. 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
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
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
.
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
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
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
? 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
;
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
;
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
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
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:
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
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
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
/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
.
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
-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
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
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
. 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
) 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
.
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
) {$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
24 matches
Mail list logo