Re: [PHP-DB] Dates - adding to unix 86400 seconds not equal nextday

gmdate doesn't cause this anomaly. Apologies if this is what you're discussing and the issue is when the DST switch takes place... cheers Simon -- Simon Rees | -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Executing SQL query with ODBC

for your business and corporate URL : http://attractive.as/hostmania -- Mau kredit mobil baru/bekas dengan bunga rendah? URL : http://fantastic.as/kreditmobil -- ~~ Simon Rees | [EMAIL

Re: [PHP-DB] Do You Need addslashes() When Using Bind Variables

statements ahead of time, do you still need to call addslashes() before binding the strings to the bind variables? Thanks in advance. Francis -- ~~ Simon Rees | [EMAIL PROTECTED] | ORA-03113: end-of-file on communication channel

Re: [PHP-DB] Problem with an insert query

Attendance WHERE Session = 1, Select Cou [/QUOTE PHPMYADMIN RESULTS] -- ~~ Simon Rees | [EMAIL PROTECTED] | ORA-03113: end-of-file on communication channel ~~ -- PHP Database Mailing List (http

Re: [PHP-DB] Problem with an insert query

and are using the mysqli library. See: http://www.php.net/manual/en/function.mysqli-prepare.php Note, this is a common technique in database programming but one which MySQL is only just starting to adopt... Simon -- ~~ Simon Rees | [EMAIL

Re: [PHP-DB] mysql - image storing

)... cheers Simon -- ~~ Simon Rees  | [EMAIL PROTECTED]  | ORA-03113: end-of-file on communication channel ~~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] IIS, PHP, and session data

-- ~~ Simon Rees | [EMAIL PROTECTED] | ORA-03113: end-of-file on communication channel ~~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] JOIN problem

you're using you may be able to do this: SELECT a.username FROM table1 a WHERE a.username NOT IN ( SELECT b.username FROM table2 b ) cheers Simon -- ~~ Simon Rees  | [EMAIL PROTECTED]  | ORA-03113: end-of-file on communication channel

Re: [PHP-DB] password in md5 to connect to mysql instead of clear password

-- ~~ Simon Rees  | [EMAIL PROTECTED]  | ORA-03113: end-of-file on communication channel ~~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] password in md5 to connect to mysql instead of clear password

-- ~~ Simon Rees  | [EMAIL PROTECTED]  | ORA-03113: end-of-file on communication channel ~~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: password in md5 to connect to mysql instead of clear password

# database 2 db2_passxx55usp --- -- ~~ Simon Rees  | [EMAIL PROTECTED]  | ORA-03113: end-of-file on communication channel ~~ -- PHP Database Mailing List (http

Re: [PHP-DB] Why not ?

the two tables as well but without knowing your database it is impossible for me to say how. If you are using an older mysql version what you want to do is probably impossible in one statement. Simon -- ~~ Simon Rees  | [EMAIL PROTECTED]  | ORA

Re: [PHP-DB] comprehensive sql tutorial

(for MySQL) http://dev.mysql.com/doc/ or (for Oracle - requires OTN membership which is free) http://oraclesvca2.oracle.com/docs/cd/B14117_01/index.htm cheers Simon -- ~~ Simon Rees | [EMAIL PROTECTED] | ORA-03113: end-of-file on communication

Re: [PHP-DB] GD Question

as a separate file. Put your image code in a separate script and request it in the src attribute of your html image tags. e.g. img src=display_image.php Simon -- ~~ Simon Rees  | [EMAIL PROTECTED]  | ORA-03113: end-of-file on communication

Re: [PHP-DB] PHP Sessions

-- ~~ Simon Rees | [EMAIL PROTECTED] | ORA-03113: end-of-file on communication channel ~~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: SQL or array ?

the CPU time taken by various parts of the script. I've used Xdebug for profiling and found it useful. Have a look at http://www.php.net/debugger for this and other options (I assume the other debuggers have profiling support). Simon -- ~~ Simon

Re: [PHP-DB] printf() in a variable, or alternative to printf()

into their database. Use sprintf see: http://uk2.php.net/manual/en/function.sprintf.php Si -- ~~ Simon Rees | [EMAIL PROTECTED] | ORA-03113: end-of-file on communication channel ~~ -- PHP Database

Re: [PHP-DB] transactions

the execution of a script. cheers Simon -- ~~ Simon Rees | [EMAIL PROTECTED] | ORA-03113: end-of-file on communication channel ~~ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit