Re: [PHP-DB] Can't open SQLite DB... but only when using mod_php??

Well the directory that houses the database should be writable. Running the script from command line it gives you write access probably but it won't work using mod_php because the web server probably can't write. Try it and give us some feedback. -- Thodoris O/H Chris έγραψε: Markus

Re: [PHP-DB] Can't open SQLite DB... but only when using mod_php??

and after can read file formats 1,2 and 3. Is you database format new?| | -- Thodoris O/H Markus Wolff έγραψε: Chris schrieb: It can't be file permissions, I've even tried to set the database file to 777... no change at all. My guess is still permissions. If you try a raw fopen instead of using

[PHP-DB] Build a form that returns to the parent window

the pop-up window does not returm to the parent window something. I searched through the web and nothing seems to do the magic for me. Please any suggestions would be welcome cause I have been working on this for several hours as we speak. -- Thodoris -- PHP Database Mailing List (http

Re: [PHP-DB] Can't open SQLite DB... but only when using mod_php??

sqlite you should recompile your apache against the new sqlite. Hope this do some magic for you cause I have run out of ideas. | -- Thodoris O/H Markus Wolff έγραψε: Hi Thodoris, I've checked on one of the three boxes now and the SQLite version used by both the commandline client and PDO

[PHP-DB] Problems with character encoding

the trick for me. Does anybody have previous experience concerning charset encoding in order to help me. Thanks in advance. PS: I am writing in sreadsheet format using Spreadsheet_Excel_Writer pear module* * -- Thodoris

Re: [PHP-DB] multiple tables and correct select statement

statement is that you should try to execute your queries using the command line client or any other that you use before putting it in use in order to find out what's wrong. -- Thodoris O/H Jas ??: Hello all, I receive an error of the following: The used SELECT statements have a different number

Re: [PHP-DB] parameters not working under PDO

or post full source if you keep having trouble. -- Thodoris

Re: [PHP-DB] How can I get MySQL protocol information with PDO?

status. A list of some of the the attributes can be found in the link above or in the section of Predefined Constants list in: http://www.php.net/manual/en/ref.pdo.php -- Thodoris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] How can I get MySQL protocol information with PDO?

O/H Kazuhiro IIzuka ??: Thanks Thodoris. But this is not things I desired.I've already read php manual and known about PDO::getAttribute() before I post my question. When I get to server version,I can use $dbh-getAttribute(PDO:: ATTR_SERVER_VERSION),but there are no attribute about

Re: [PHP-DB] character set collation

Why don't you try replication instead of exporting / importing data?? -- Thodoris O/H elk dolk ??: Hi everybody, 1- I have created a database in the remote server and I have the same database in my local machine ,which is configured as IIS server. 2- MySQL

Re: [PHP-DB] explode () and mySQL query

); $query .= $keys; This is the reference in the manual: http://gr2.php.net/manual/en/function.implode.php -- Thodoris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Wrong results with ORDER BY DESC

-community via TCP/IP Any help would be greatly appreciated. These are fresh so you shouldn't be having a problem. -- Thodoris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] authentication verification

but it would be a session id. However have in mind that you may have more control over sessions because you can configure your server to make great deal of things like say eliminate all sessions every say 5 minutes. I don't know if this was much of a help. -- Thodoris -- PHP Database Mailing List

Re: [PHP-DB] One field or a new table?

you separate them. This is probably slower if the collectibles are few in number but I think it gets better when their number increases badly. Tell us what you think. -- Thodoris O/H Hussein Jafferjee ??: Hey Guys, I have been developing for a while and never found the best solution

Re: [PHP-DB] PDO prepared statements and value list for MySQL IN

= implode(',',$pre_contents); or $contents = 'mystring'; -- Thodoris

Re: [PHP-DB] PDO prepared statements and value list for MySQL IN

O/H TK ??: At 03:21 AM 7/9/2008, Thodoris wrote: At 04:16 PM 7/8/2008, Philip Thompson wrote: On Jul 8, 2008, at 11:55 AM, TK wrote: I'd like to use a PDO prepared statement to perform a MySQL query that uses the IN function. I.e.: $stmt = $pdo-prepare(' select

Re: [PHP-DB] Question about databases and foreign keys

-foreign-key-constraints.html -- Thodoris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] MySQL stored procedures OUT or INOUT parameters

=== I think that the manual is quite clear on this: http://dev.mysql.com/doc/refman/5.1/en/call.html You use a way to query the database like PDO or mysqli and you wite sql. Is there something specific that you want to ask? -- Thodoris -- PHP

Re: [PHP-DB] MySQL Query Timeout program in PHP

-- J.A. van Zanen -- Thodoris

Re: [PHP-DB] pagination php mysql

. Second is speediest but it can have more failures because are session vars or cookies. It depends of your control errors and also the visits profile. I wouldn't bet on that I think it depends on the case. Hope it helps, -- Thodoris

Re: [PHP-DB] Building additional modules after installing core modules

practice. -- Thodoris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Copying Data From One Table To Another Table

://dev.mysql.com/doc/refman/5.0/en/insert-select.html Not to mention that you don't even need PHP for that. You just need to open a client and make the query. -- Thodoris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Copying Data From One Table To Another Table

$result3=mssql_query($query3) or die (The query has failed); snip http://dev.mysql.com/doc/refman/5.0/en/insert-select.html Ah - the OP isn't using mysql, it's ms-sql. Oups didn't notice that :-) . -- Thodoris

Re: [PHP-DB] trying to get pecl and phpize to build oci8

I have Fedoara 2.6.27.5-37.fc9.i686 that has perl: This is perl, v5.10.0 built for i386-linux-thread-multi I searched the entire system and found neither pecl or phpize Although this not a php question try: yum install php-devel -- Thodoris -- PHP Database Mailing List

Re: [PHP-DB] Multiple Update SQL Statements Execution

. -- Thodoris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: [PHP] PDO buffered query problem

as far as I can recall. -- Thodoris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Problem with PDO Mysql and FETCH::ASSOC

. Have you changed the schema in the meantime? -- Thodoris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php