[PHP] Re: [PHP-DB] Querying for MAX

2002-06-12 Thread Srinivasan Ramakrishnan
Hi César, As others have obviously pointed out using MAX() is the way to go. Need I mention that you can also insert values of your own making into an auto_increment column as long as they are not already used by some other record. In your case since you have old records with IDs of their own ma

[PHP] Quiz questions on PHP

2001-11-18 Thread Srinivasan Ramakrishnan
Hi, I'm preparing a quiz on PHP for some programmers. I was wondering if there are good questions that I can use instead of inventing my own. I'm also evaluating any quizzing software out there that will allow me to conduct it. Actually I'm in the process of throwing together a script to do that

[PHP] MySQL query

2001-10-18 Thread Srinivasan Ramakrishnan
Hi all, I'm looking at the following scenario: I have MySQL two tables with usernames in both of them, I need to get usernames(A) - usernames(B) In Oracle I would use: SELECT username FROM user MINUS SELECT username FROM task_assignment Since MySQL does not support MINUS, I tried using the foll

Re: [PHP] changing to a different file in browser

2001-07-05 Thread Srinivasan Ramakrishnan
You have 2 options: a) Send a HTTP redirect header based on the condition b) Conditionally include the contents of the page instead of actually redirecting -Srini -- http://www.sriniram.com http://symonds.net/~sriniram - Original Message - From: "Brad Wright" <[EMAIL PROTECTED]> To: "PH

[PHP] Execing a command in safe mode

2001-07-04 Thread Srinivasan Ramakrishnan
Hi, I need to execute a command on my web host's machine. However they have safe mode enabled. PHP Version 4.0.3pl1 runs as a module on Apache. >From php.ini ; Safe Mode safe_mode = On safe_mode_exec_dir = /etc/php4/execdir Will a symlink located in safe_mode_exe