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

ither... Using 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

Re: [PHP-DB] Reverse (or backward?) Infinity Loop

> > A reverse (or backward) loop! We need to get the last category and then > follow the ParentId until the 0 ParentId. Have anybody made this before > (I hope so)? > > Many Thanks, > Bruno B B Magalhaes --

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

--- > Mau kredit mobil baru/bekas dengan bunga rendah? > URL : http://fantastic.as/kreditmobil -- ~~ 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] Do You Need addslashes() When Using Bind Variables

iables and preparing the SQL 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] | O

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

at ZZZ, to which I was able to speak and explain > the situation. I attempted to explain the entire situation and that we > did not definitely know that they were not going to let us in to the > room until today. The counselor seemed to be understanding. I told her > that we are expecting to run the program next week and that we would > contact Ms. L if we are told that we can not.', 'Everyone (Consumers, > Parents and Staff) wishes to have the program by next week please help > us get up and running.', 'Attempt to start up the program next > session.', 'GMH, PgmLdr' ); > > MySQL said: > #1064 - You have an error in your SQL syntax. Check the manual that > corresponds to your MySQL server version for the right syntax to use > near 'Select Count(*) From 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://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

ove 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 | [EM

Re: [PHP-DB] mysql - image storing

ection attacks)... 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

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

ll me if this was happening to you or not... hth, 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/unsub.php

Re: [PHP-DB] JOIN problem

is : Depending on which database 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-

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

if anyone is interested. 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/unsub.php

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

password file on Unix boxes. 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/unsub.php

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

break; } } fclose( in_fileh ); exit( 0 ); } --- /etc/keyinfo.conf: # database 1 password db1_pass 6dioqlFq # database 2 db2_passxx55usp --- -- ~~

Re: [PHP-DB] Why not ?

e...) You almost certainly want to join 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 -- ~~

Re: [PHP-DB] comprehensive sql tutorial

database concepts. See (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-031

Re: [PHP-DB] GD Question

wsers work - each image is requested 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. Simon -- ~~~~~~ Simon Rees  | [EMAIL PROTECTED]  | ORA-03113: end-of-fil

Re: [PHP-DB] PHP Sessions

. 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/unsub.php

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

rt). 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/unsub.php

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

utor who will parse it and input 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 ~

Re: [PHP-DB] transactions

persist beyond 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.ne