Re: [PHP] PHP and xemacs

2003-01-23 Thread Faisal Abdullah
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- ~~ Faisal Abdullah [EMAIL PROTECTED] Systems Developer Magnifix Sdn. Bhd. Tel : 603-4142 1775

[PHP] OOP

2002-12-12 Thread Faisal Abdullah
Hi guys, It goes something like this: class Myclass extends GtkWindow { var $run_xpm; var $pixmap; var $mask; function Myclass() { $this-run_xpm = array(bla, bla); $this-GtkWindow(GTK_WINDOW_TOPLEVEL); $this-connect(destroy, array($this, shutdown)); $this-set_title(Run);

Re: [PHP] Error in retrieving a BLOB from DB.

2002-11-27 Thread Faisal Abdullah
://www.php.net/unsub.php -- ~~ Faisal Abdullah [EMAIL PROTECTED] Systems Developer Magnifix Sdn. Bhd. Tel : 603-4142 1775 Fax : 603-4142 1550 ~~ Isn't it time you

[PHP] Do i need triggers for this?

2002-11-25 Thread Faisal Abdullah
Hi guys, Lets say I have a table called 'employees', and another table called 'training_history'. Lets say I need to delete an employee, I would also have to delete his record in the 'training_history' table. Which is the best way to go about this? Controlling it at application level? Or should

Re: [PHP] Do i need triggers for this?

2002-11-25 Thread Faisal Abdullah
So, yes, I'd do this at an application level... although I have no idea what triggers are :) It does pretty much the same, only at the database level. The application doesn't have to know. All the application needs to know is to delete the id in the 'employee' table. Triggers will do the

RE: [PHP] Group by YEAR in date

2002-10-29 Thread Faisal Abdullah
Thanks guys. It worked. Regards, Faisal -Original Message- From: 1LT John W. Holmes [mailto:holmes072000;charter.net] Sent: Monday, October 28, 2002 10:17 PM To: Faisal Abdullah; [EMAIL PROTECTED] Subject: Re: [PHP] Group by YEAR in date I have a table (postgres), with a date

[PHP] Sample Meeting Management System

2002-10-29 Thread Faisal Abdullah
Hi people, Do you know where I can look at a free meeting management system? Nothing too fancy, just something that does the job. Thanks. Regards, Faisal __ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:

RE: [PHP] A newbie on Board!

2002-10-28 Thread Faisal Abdullah
You should probably check whether you environment variables are all set. try phpinfo(), and see under Environment Variables. Check for: ORACLE_SID ORACLE_HOME LD_LIBRARY_PATH ORACLE_TERM ORA_NLS33 If they aren't there, you should set them up. Regards, Faisal -Original Message- From:

RE: [PHP] error connecting to oracle.

2002-10-28 Thread Faisal Abdullah
undefined function means PHP doesn't know where to get the function from. You probably didn't configure oci_8 libraries correctly. Try phpinfo(), and see under the configuration. Check whether oci8 is available. Regards Faisal -Original Message- From: Subodh Gupta

RE: [PHP] error connecting to oracle.

2002-10-28 Thread Faisal Abdullah
// change this to whatever your extention directory is. Regards, Faisal -Original Message- From: Subodh Gupta [mailto:Subodh.Gupta;seepz.tcs.co.in] Sent: Monday, October 28, 2002 5:35 PM To: Faisal Abdullah; [EMAIL PROTECTED] Subject: RE: [PHP] error connecting to oracle. I checked up

RE: [PHP] error connecting to oracle.

2002-10-28 Thread Faisal Abdullah
: Faisal Abdullah [mailto:faisal;magnifix.com.my] Sent: Monday, October 28, 2002 6:13 PM To: Subodh Gupta; [EMAIL PROTECTED] Subject: RE: [PHP] error connecting to oracle. Where was it listed? In the 'configure command' section? Or the 'configuration' section? If its available in the 'configure

RE: [PHP] error connecting to oracle.

2002-10-28 Thread Faisal Abdullah
- From: Subodh Gupta [mailto:Subodh.Gupta;seepz.tcs.co.in] Sent: Monday, October 28, 2002 5:56 PM To: Faisal Abdullah; [EMAIL PROTECTED] Subject: RE: [PHP] error connecting to oracle. There is no entry of oracle in any section. The rest of things which you have pointed out are already

FW: [PHP] error connecting to oracle.

2002-10-28 Thread Faisal Abdullah
-Original Message- From: Gerald Roehrbein/Pctdmn [mailto:groehrbein;bigfoot.com] Sent: Monday, October 28, 2002 10:50 AM To: Subodh Gupta Cc: [EMAIL PROTECTED] Subject: RE: [PHP] error connecting to oracle. Hello, at Solaris and Windows NT it's first necessary

[PHP] Group by YEAR in date

2002-10-28 Thread Faisal Abdullah
Hi people, I have a table (postgres), with a date field (-mm-dd). How do I group by year? 'select sum(profit) from loan group by apply_date' would group by the DAY, not year. Thanks. Regards, Faisal __ -- PHP General Mailing List (http://www.php.net/)

RE: [PHP] OCIFetchInto: OCI8 problem

2002-10-14 Thread Faisal Abdullah
I added a little $counter in the while loop. The count shows 2. But why do I only get one value? Thanks, Faisal -Original Message- From: Faisal Abdullah [mailto:[EMAIL PROTECTED]] Sent: Monday, October 14, 2002 9:55 AM To: [EMAIL PROTECTED] Subject: [PHP] OCIFetchInto: OCI8 problem

[PHP] OCIFetchInto: OCI8 problem

2002-10-13 Thread Faisal Abdullah
Hi ppl. I have something which seems really odd. I run a SQL query, which is supposed to return 2 rows, but instead, it returns one with OCIFetchInto(). I used the exact same query in SQL*Plus, and It returns 2 rows like I want them. Here's the code. if(!$iDBConn = OCILogon(DB_USER, DB_PASS,

[PHP] Example script : Employee schedule

2002-09-25 Thread Faisal Abdullah
Hi people. Does anyone happen to know whether there is a sample script/application out there which can tell me (and everyone else in the organisation) of what john doe is doing, and where when he's doing it? I don't know a proper name for this type of application, therefor I haven't found

RE: [PHP] SQL : left join from multiple tables

2002-09-24 Thread Faisal Abdullah
Thanks for the help. I got it working. I used SQL92, instead of Oracle's sql standard. I just hate to recode when migrating to mysql or postgresql. Sincerely, Faisal -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 7:33 PM To: 'Faisal

[PHP] Function: return multple values

2002-09-23 Thread Faisal Abdullah
Hi people. Is it possible to return multiple values in a function. For instance, i want to do something like this: function calculate_money($sum) { // some hanky panky calculations return $type; return $amount; } Thanks! Sincerely, Faisal __ -- PHP

[PHP] SQL : left join from multiple tables

2002-09-23 Thread Faisal Abdullah
Hi again people! How's it goin? Here's the question How do I do left joins from multiple tables? I want to do something like this: select a.name, b.department, c.position from emp a left join dept b on a.staffno = b.staffno left join position c on a.staffno = c.staffno where staffno = $staffno;

[PHP] Auto-increment value

2002-09-18 Thread Faisal Abdullah
Hi people, I have a table with a column called ID (auto-increment). Is it possible to know the value of ID, right after inserting a row? I'm using postgresql. Thanks. Sincerely, Faisal __ -- PHP General Mailing List (http://www.php.net/) To

RE: [PHP] Auto-increment value

2002-09-18 Thread Faisal Abdullah
mysql_insert_id( [link id] ). regards Scott Faisal Abdullah wrote: Hi people, I have a table with a column called ID (auto-increment). Is it possible to know the value of ID, right after inserting a row? I'm using postgresql. Thanks. Sincerely, Faisal

RE: [PHP] Auto-increment value

2002-09-18 Thread Faisal Abdullah
insert/nextval(), before my select statement finishes processing? Would I get a 5? Sincerely, Faisal -Original Message- From: Faisal Abdullah [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 6:37 PM To: PHP Subject: RE: [PHP] Auto-increment value I tried that. It gives me

RE: [PHP] Auto-increment value

2002-09-18 Thread Faisal Abdullah
it (SELECT ||LAST_INSERT_ID())| Faisal Abdullah wrote: Would a select last_value from sequence_name do any good? Is there a possibility that I get a value from the outcome of a nextval by another session? Meaning, I do an insert 1, 2, 3, 4 A 'select last_value from sequence_name' should give me '4

RE: [PHP] Auto-increment value

2002-09-18 Thread Faisal Abdullah
There is a similar one for postgresql as well: pg_last_oid() . I tried that. It gives me 24807, instead of 5. Or is oid is a reference to something else, which would lead me to the '5' i'm looking for? -- snip snip -- if($result = pg_exec($db, $sql)) { $query = success;

RE: [PHP] Auto-increment value

2002-09-18 Thread Faisal Abdullah
19, 2002 5:35 AM To: Faisal Abdullah Cc: Marek Kilimajer; PHP Subject: Re: [PHP] Auto-increment value Dear Faisal Abdullah, Once you wrote about RE: [PHP] Auto-increment value: There is a similar one for postgresql as well: pg_last_oid() . I tried that. It gives me 24807, instead of 5

Re: [PHP] newbie: using sessions

2002-03-12 Thread Faisal Abdullah
Have you started session? And you have to register session variables as well. Try this: session_start(); $session_login = $HTTP_POST_VARS['login']; session_register(session_login); At the other page, where you want to output the variable, you must also start session. session_start(); echo

Re: [PHP] deleting records in mysql

2002-03-12 Thread Faisal Abdullah
The web interfaces probably failed to receive the ID of the row you wish to delete. What's the error message? Does the ID of the row you wish to delete appear in the Delete Link in the web interface? Regards, Faisal On Tuesday 12 March 2002 17:35, you wrote: Hi to all, just want to ask why

Re: [PHP] Re: Variables within a string

2002-03-12 Thread Faisal Abdullah
I love your example.. But if you don't know where the data came from then it's not secure. Consider a real-life example. Robin Hood steals the Sheriff's ATM card, and the Sheriff stupidly enough has written the PIN onto the back of the card. Now Robin can go and withdraw all the money from

Re: [PHP] Hi How to convert the time from mysql(DATETIME) table to the format DD/MM/YYYY HH:MM AM or PM in PHP?

2002-03-12 Thread Faisal Abdullah
Try date(d/m/Y h:m A); On Tuesday 12 March 2002 18:29, Balaji Ankem wrote: Hi, I have stored the date and time in mysql table with DATETIME type. I want to change it in to DD/MM/ HH:MM AM or PM. How can I do this? Thanks in advance Balaji -- PHP General Mailing

Re: [PHP] newbie: using sessions

2002-03-12 Thread Faisal Abdullah
Don't you have to assign the login value to the session variable first? session_start(); $login = $HTTP_POST_VARS(login); session_register(login); How are you using you're session? Are you registering the variable for later use? session_start(); session_register(login); $login =

Re: [PHP] File Upload

2002-03-11 Thread Faisal Abdullah
if(!userfile) echo ERROR; $filelocation=/tmp; Does C:\tmp exist? copy($userfile, $filelocation) The message I get in my browser is: Warning: Unable to open 'C:\\Documents and Settings\\vlad\\Desktop\\satellite\\florida.jpg' for reading: No such file or directory in

Re: [PHP] File Upload

2002-03-11 Thread Faisal Abdullah
Warning: Unable to open 'C:\\Documents and Settings\\vlad\\Desktop\\satellite\\florida.jpg' for reading: No such file or directory in /var/www/kulchitski/btl/_talkroom_submit.php on line 15 Well it says Unable to open. My guess is the file u want to upload doesn't exist. What do u use