Re: [PHP-DB] Urgent! Installing PHP 4 on 64-bit machines

2007-03-08 Thread Ng Hwee Hwee
/AppPools/Enable32bitAppOnWin64 1 3) reinstall IIS So sorry, this isn't even a PHP problem. My apologise for posting to the wrong mailing list! Thank you to all who helped! :o) Best regards, Hwee Hwee - Original Message - From: Chris [EMAIL PROTECTED] To: Ng Hwee Hwee [EMAIL PROTECTED

[PHP-DB] Urgent! Installing PHP 4 on 64-bit machines

2007-03-06 Thread Ng Hwee Hwee
Hi, I need urgent help. Have anyone successfully installed PHP 4 MySQL 4.0 on 64-bit Windows? Is there any issues that I need to look out for? Thank you. Please help me!! Best regards, Hwee Hwee

Re: [PHP-DB] Urgent! Installing PHP 4 on 64-bit machines

2007-03-06 Thread Ng Hwee Hwee
Hi Niel, The problem is my customer bought the hardware and the OS and we are supposed to install PHP4 and MySQL4.0 on the IIS that came with their Windows Server 2003... So I can't influence the decision on whether it should be a 32-bit or 64-bit machine. Given a choice, of course I won't

Re: [PHP-DB] Urgent! Installing PHP 4 on 64-bit machines

2007-03-06 Thread Ng Hwee Hwee
Hi Chris, Have you tried installing them? Are you getting an error? Nobody's going to be able to help without that information. They will run in 32bit mode, but they should work fine (32 bit binaries work on a 64 bit processor, they don't work the other way around). The situation is such

[PHP-DB] Defined Constants

2005-10-13 Thread Ng Hwee Hwee
Hi all, just a very simple question. my form has the following define statements and select box: define(JOVIAL, likes to joke alot); define(CHEERFUL, always wears a smile on his face); define(ADVENTUROUS, likes sports and plays well too); define(MYSTERIOUS, there's always something to discover

Re: [PHP-DB] Defined Constants

2005-10-13 Thread Ng Hwee Hwee
this works like a charm!!! thanks alot!!! :o) - Original Message - From: Matthias Willerich [EMAIL PROTECTED] To: Ng Hwee Hwee [EMAIL PROTECTED]; PHP DB List php-db@lists.php.net Sent: Thursday, October 13, 2005 2:28 PM Subject: RE: [PHP-DB] Defined Constants 2 possibilities: either

[PHP-DB] Convert String to Array

2005-09-29 Thread Ng Hwee Hwee
Hi guys, this looks like a very simple problem but i really have no idea how to do it.. please help me! thanks! my MySQL database has a table of which 2 fields are as follow T100FieldNmT100Value == = vehMdlCd[0] MER vehMdlCd[1] LEX

[PHP-DB] Programming Design

2005-09-20 Thread Ng Hwee Hwee
Hi all, my company is trying to generate a programming standardization document and i'll like to consult you guys on some basic terminologies. please advise me if the following is true -- jobs | |

[PHP-DB] Subquery

2005-09-18 Thread Ng Hwee Hwee
hi, can some one enlighten me on what is wrong with my query? I want to set the fax number of all the employees of a particular company to the company's fax number. This is because the employees do not have personal fax machines, thus instead of just leaving T020FaxNo blank, I want to update it

Re: [PHP-DB] Subquery

2005-09-18 Thread Ng Hwee Hwee
thanks but it doesn't work =( is it because i'm on MySQL version 3.23? i have an error 1064 when running it... hwee - Original Message - From: Nandar [EMAIL PROTECTED] To: Ng Hwee Hwee [EMAIL PROTECTED]; PHP DB List php-db@lists.php.net Sent: Monday, September 19, 2005 11:02 AM Subject

Re: [PHP-DB] Subquery

2005-09-18 Thread Ng Hwee Hwee
: Bastien Koert [EMAIL PROTECTED] To: [EMAIL PROTECTED]; php-db@lists.php.net Sent: Monday, September 19, 2005 11:30 AM Subject: RE: [PHP-DB] Subquery only versions 4.1 and above support subqueries... bastien From: Ng Hwee Hwee [EMAIL PROTECTED] To: PHP DB List php-db@lists.php.net Subject

[PHP-DB] PHP XML

2005-07-29 Thread Ng Hwee Hwee
Hi all, My customer gave me an .xsd file and I need to generate an HTML form for him. He will then fill in the values of the elements and then post it into my database. I'm using PHP4.3 and MySQL3.23. Can someone point me to resources where i can accomplish this? Thank you!! Look forward to

[PHP-DB] PHP, MySQL, XML books recommendation

2005-07-29 Thread Ng Hwee Hwee
hi guys, any recommendation on good books or resources for me? I'm totally clueless about XML but would love to pick it up now. Any one can give me titles of good books? thanks!! look forward to hear from you, hwee

Re: [PHP-DB] R6025 Error

2005-05-10 Thread Ng Hwee Hwee
hi all, this R6025 error is driving me nuts!!! anyone who can help me? thanx a million!! warmest wishes, hwee - Original Message - From: Ng Hwee Hwee [EMAIL PROTECTED] To: PHP DB List php-db@lists.php.net Sent: Tuesday, May 10, 2005 11:15 AM Subject: Re: [PHP-DB] R6025 Error hi

[PHP-DB] R6025 Error

2005-05-09 Thread Ng Hwee Hwee
Hi all, I'm having a problem with a R6025 error. What happened is that I have a table generated using MySQL and PHP that displays all the registered customers. On the table header, i allow them to click on some links that can sort the table according to their preference. Sometimes, when users

Re: [PHP-DB] R6025 Error

2005-05-09 Thread Ng Hwee Hwee
Subject: RE: [PHP-DB] R6025 Error Can you also send us the output generated by PHP? Ie the output HTML... Jos -Original Message- From: Ng Hwee Hwee [mailto:[EMAIL PROTECTED] Sent: 09 May 2005 10:48 To: PHP DB List Subject: [PHP-DB] R6025 Error Hi all, I'm having a problem

[PHP-DB] Counting HTML Lines

2005-04-15 Thread Ng Hwee Hwee
Hi all, is there a way to count how many lines of screen output has HTML render? below is a sample of what i'm trying to do.. i'm trying to generate a table with the Remarks column containing data type TEXT which may have a few lines. therefore, i cannot just count how many rows of records i

Re: [PHP-DB] Counting HTML Lines

2005-04-15 Thread Ng Hwee Hwee
hi! thanx for your reply. i cannot count the number of \n because sometimes the inputted text is very long without any \n, but because it is inside a cell that has a linited width, HTML will automatically push it to the next line, right? in this case, there won't be a count for \n. hwee -

Re: [PHP-DB] Counting HTML Lines

2005-04-15 Thread Ng Hwee Hwee
. -- Regards, Jyrki Laurila On 4/15/05, Ng Hwee Hwee [EMAIL PROTECTED] wrote: hi! thanx for your reply. i cannot count the number of \n because sometimes the inputted text is very long without any \n, but because it is inside a cell that has a linited width, HTML will automatically push

Re: [PHP-DB] Subject: Web Printing

2005-04-01 Thread Ng Hwee Hwee
@lists.php.net Sent: Friday, April 01, 2005 4:52 PM Subject: [PHP-DB] Subject: Web Printing At 10:27 31/03/2005 +, you wrote: Message-ID: [EMAIL PROTECTED] From: Ng Hwee Hwee [EMAIL PROTECTED] To: PHP DB List php-db@lists.php.net Date: Thu, 31 Mar 2005 18:24:41 +0800 MIME-Version: 1.0 Content

[PHP-DB] Web Printing

2005-03-31 Thread Ng Hwee Hwee
Hi all, i am very perplexed now and i hope you guys can help me. i am reading 50,000 records from mySQL database and i need to print them out in a report format. However, i also need to print a page number through PHP on all the pages (for example, Page 1 of 200) and display a header and a

[PHP-DB] Re: Subject: Web Printing

2005-03-31 Thread Ng Hwee Hwee
: Message-ID: [EMAIL PROTECTED] From: Ng Hwee Hwee [EMAIL PROTECTED] To: PHP DB List php-db@lists.php.net Date: Thu, 31 Mar 2005 18:24:41 +0800 Subject: Web Printing Hi all, i know i can print out a header and footer using HTML thead and tfoot. However, the tfoot doesn't always stay

Re: [PHP-DB] Re: Subject: Web Printing

2005-03-31 Thread Ng Hwee Hwee
me to get my page number and total number of pages intermingled with my main contents. =( please advise.. thanks s much! hwee - Original Message - From: Mark Cain [EMAIL PROTECTED] To: Ng Hwee Hwee [EMAIL PROTECTED]; PHP DB List php-db@lists.php.net Sent: Friday, April 01, 2005 12

[PHP-DB] Statistic Graph Tool

2005-03-29 Thread Ng Hwee Hwee
Hi all, i'm looking for a php tool that allows me to retrieve data from mySQL, calculate some statistics and then generate a graph (preferably 3D and beautifully generated). i read about JpGraph. are there other recommendations or advice? thank you so much! hwee -- PHP Database Mailing List

[PHP-DB] PHP Crystal Report

2004-12-12 Thread Ng Hwee Hwee
Hi all, can someone kindly direct me to resources on generating reports using Crystal Report 10 through PHP 4.3.4 and MySQL 4.0.22 database? thank you. best regards, hwee

Re: [PHP-DB] Form action

2004-10-12 Thread Ng Hwee Hwee
hi, i can use Method (1) and include the validation file instead of prepending it to the whole form. then it would centralise my form submission and also does not make my debugging process too messy, right? - Original Message - From: Shahmat Dahlan [EMAIL PROTECTED] To: Ng Hwee Hwee

[PHP-DB] Form action

2004-10-10 Thread Ng Hwee Hwee
Hi all, i'm designing a lot of forms and would like to know the standard practice. which of the following will be advisable? 1) form action is $PHP_SELF i.e. form name=form01 action=?=$PHP_SELF;? method=post i.e the script to check if the values submitted is valid and the scripts to

[PHP-DB] Session Cache Limiter

2004-09-17 Thread Ng Hwee Hwee
Hi, has anyone used session_cache_limiter('must-revalidate') before to solve the problem on Warning: Page Expire..? i saw it on some websites, tried it and it worked for me.. but i never come across this word officially in any books or sites.. Can someone kindly direct me to something that

[PHP-DB] Print

2004-09-09 Thread Ng Hwee Hwee
Hi, I have a pressing problem with regards to printing. My situation is as follows: 1) I have a form in a table format with the following headers: | No. | Date | Contents | Remarks | 2) the fields under Contents and Remarks are textareas to allow users to type as much as they want. 3) after

Re: [PHP-DB] Webpage response to selection $_POST

2004-08-30 Thread Ng Hwee Hwee
hi... to what i know, the $_POST variables get passed to apage.php only... if you have a redirect to another page inside apage.php, the $_POST variables will not be passed to the next page. you may need to register your $_POST as session variables inside apage.php first or you append your $_POST

Re: [PHP-DB] Clicking on the Picture

2004-08-30 Thread Ng Hwee Hwee
what about this?? a href=# onclick=location.href='page2.php' img src=picture.gif width=100 height=100 border=0 /a - Original Message - From: Feroz [EMAIL PROTECTED] To: Php-Db [EMAIL PROTECTED] Sent: Tuesday, August 31, 2004 11:07 AM Subject: [PHP-DB] Clicking on the Picture Hi,

[PHP-DB] Date Conversion

2004-08-18 Thread Ng Hwee Hwee
Hi all, can someone kindly point me to a resource that converts all kinds of possible date inputs into MySQL format of -MM-DD? example of formats to be converted includes: d/m/yy d/m/ d/mm/yy d/mm/yyy dd/mm/yy dd/mm/yyy d/mmm/yy d/mmm/ dd/mmm/yy dd/mmm/ yy - 2 digit

Re: [PHP-DB] Deleting older records

2004-08-12 Thread Ng Hwee Hwee
what was the error?? - Original Message - From: Dylan Barber [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 13, 2004 1:08 PM Subject: [PHP-DB] Deleting older records I have a tracking database but I only need things in it for about an hour I tried this DELETE * FROM

Re: [PHP-DB] Deleting older records

2004-08-12 Thread Ng Hwee Hwee
try DELETE FROM `tblDownloadTrack` WHERE `timestamp` TIME_TO_SEC( NOW( ) ) - Original Message - From: Dylan Barber [EMAIL PROTECTED] To: 'Ng Hwee Hwee' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, August 13, 2004 1:17 PM Subject: RE: [PHP-DB] Deleting older records 1064 - You

Re: [PHP-DB] Deleting older records

2004-08-12 Thread Ng Hwee Hwee
PROTECTED] To: 'Ng Hwee Hwee' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, August 13, 2004 1:32 PM Subject: RE: [PHP-DB] Deleting older records Okay closer but the query doesn't seem to return anything Query DELETE FROM `tblDownloadTrack` WHERE TIME_TO_SEC(`timestamp`) TIME_TO_SEC( NOW

Re: [PHP-DB] Php if statement in a form

2004-08-05 Thread Ng Hwee Hwee
what about this? if(empty($row[timeout])) - Original Message - From: Doug Thompson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, August 06, 2004 10:18 AM Subject: Re: [PHP-DB] Php if statement in a form if (is_null($row[timeout]).) [EMAIL

Re: [PHP-DB] Php if statement in a form

2004-08-05 Thread Ng Hwee Hwee
: Ng Hwee Hwee [mailto:[EMAIL PROTECTED] Sent: Friday, 6 August 2004 12:30 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Php if statement in a form what about this? if(empty($row[timeout])) - Original Message - From: Doug Thompson [EMAIL PROTECTED] To: [EMAIL PROTECTED

[PHP-DB] Regular Expression

2004-08-04 Thread Ng Hwee Hwee
Hi all, I somehow just couldn't get my regular expression syntax correct. Will you please help me? some examples of my valid string is: sinx0401-001-45 hkgx0403-020-12 jktx0402-000-01 bkkx0407-013-44 the definition is: 1st 4 characters - can only be sinx or hkgx or bkkx or jktx next 4

Re: [PHP-DB] Regular Expression

2004-08-04 Thread Ng Hwee Hwee
- From: John Holmes [EMAIL PROTECTED] To: Ng Hwee Hwee [EMAIL PROTECTED] Cc: PHP DB List [EMAIL PROTECTED] Sent: Thursday, August 05, 2004 10:22 AM Subject: Re: [PHP-DB] Regular Expression Ng Hwee Hwee wrote: Hi all, I somehow just couldn't get my regular expression syntax correct

Re: [PHP-DB] Regular Expression

2004-08-04 Thread Ng Hwee Hwee
thanx a million!! you really saved my day!! :o) hwee - Original Message - From: John Holmes [EMAIL PROTECTED] To: Ng Hwee Hwee [EMAIL PROTECTED] Cc: PHP DB List [EMAIL PROTECTED] Sent: Thursday, August 05, 2004 11:05 AM Subject: Re: [PHP-DB] Regular Expression Ng Hwee Hwee wrote

Re: [PHP-DB] Dropdown menus from DB query

2004-06-17 Thread Ng Hwee Hwee
hmm... what about something like this?? echo select name=\dropdown\; $query = select code, name from table; $result = mysql_query($query); while($array = mysql_fetch_array($result)) { echo option value=\.$array[code].\.$array[name]./option; } echo /select; hth - Original Message

Re: [PHP-DB] Dropdown menus from DB query

2004-06-17 Thread Ng Hwee Hwee
] Sent: Friday, June 18, 2004 9:23 AM Subject: Re: [PHP-DB] Dropdown menus from DB query Thanks. I think I can work from this. Just to let you know, it generates a parse error ( I think its because of the quotes). Cole On Thu, 2004-06-17 at 18:09, Ng Hwee Hwee wrote: hmm... what about

[PHP-DB] $_Session vs $_Cookie

2004-05-31 Thread Ng Hwee Hwee
Hi all, I have a problem: my $_SESSION variables and $_COOKIE variables get destroyed very often, even though my clients are actively browsing the site (that means, the variables should not be garbage collected). Our guess is that the network connections are weak. My server is in Singapore but

Re: [PHP-DB] Re: $_Session vs $_Cookie

2004-05-31 Thread Ng Hwee Hwee
may not lie in my gc_maxlifetime value?? please correct me if I'm wrong! thanx thanx! - Original Message - From: Torsten Roehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 31, 2004 5:33 PM Subject: [PHP-DB] Re: $_Session vs $_Cookie Ng Hwee Hwee [EMAIL PROTECTED] wrote

Re: [PHP-DB] Re: $_Session vs $_Cookie

2004-05-31 Thread Ng Hwee Hwee
a million!! - Original Message - From: Torsten Roehr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 31, 2004 6:19 PM Subject: Re: [PHP-DB] Re: $_Session vs $_Cookie Ng Hwee Hwee [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] hi.. the situation is like this: my

Re: [PHP-DB] Re: $_Session vs $_Cookie

2004-05-31 Thread Ng Hwee Hwee
as recommended by Torsten and the others, maybe we should use the database to save our sessions.. I do not have time to explore the PEAR packages but they look like a good long-term solution. By the way, do you use VPN? Hwee - Original Message - From: Sukanto Kho [EMAIL PROTECTED] To: Ng Hwee

[PHP-DB] Version Upgrade

2004-05-20 Thread Ng Hwee Hwee
Hi all, I'm running on PHP 4.2.2 and MySQL 3.23.54 I would like to do an upgrade... What would be the highest version number that I can upgrade to without causing any possible conflict? I'm thinking of upgrading to PHP 4.2.3 and MySQL 4.0.4 because they have some features that I need. But I

Re: [PHP-DB] Version Upgrade

2004-05-20 Thread Ng Hwee Hwee
hi all, Sorry, I meant to say PHP 4.3. Will it be very different from PHP4.2.2 that my programs may perform strangely if I upgrade to PHP4.3? many thanks, Hwee - Original Message - From: Gary Every [EMAIL PROTECTED] To: Ng Hwee Hwee [EMAIL PROTECTED] Sent: Thursday, May 20, 2004 9:23

Re: [PHP-DB] Edit with notepad

2004-05-12 Thread Ng Hwee Hwee
At 10:39 11/05/2004 +, you wrote: Message-ID: [EMAIL PROTECTED] From: Ng Hwee Hwee [EMAIL PROTECTED] To: DBList [EMAIL PROTECTED] Date: Tue, 11 May 2004 09:25:08 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit Subject: Re

Re: [PHP-DB] Edit with notepad

2004-05-10 Thread Ng Hwee Hwee
2:25 AM Subject: [PHP-DB] Re: Subject: Edit with notepad Send before any content, an MS-Word header : header(Content-type: application/vnd-ms.word); Then output your HTML. Cheers - Neil. At 07:41 10/05/2004 +, you wrote: Message-ID: [EMAIL PROTECTED] From: Ng Hwee Hwee [EMAIL

[PHP-DB] Edit with notepad

2004-05-10 Thread Ng Hwee Hwee
Hi My customers would like to save my php outputs in a word document file and so I have added a meta tag META NAME=ProgID CONTENT=word.document in my php files. However, my File-Edit button in IE6 is greyed out. why? i see that other php files on other websites allow Edit, why is it that my

Re: [PHP-DB] Re: Edit with notepad

2004-05-10 Thread Ng Hwee Hwee
[EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 10, 2004 4:45 PM Subject: [PHP-DB] Re: Edit with notepad Try to set session.cache_limiter to private Ng Hwee Hwee [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi My customers would like to save my php outputs in a word

[PHP-DB] Optimize Tables

2004-05-03 Thread Ng Hwee Hwee
Hi, Is there a way to create a schedule to optimise my MySQL tables automatically? The overhead of some of my tables can reach 355,548 bytes over 3 working days! Please help me! Thanks. Hwee

Re: [PHP-DB] Optimize Tables

2004-05-03 Thread Ng Hwee Hwee
in an email to me? thanx.. i'm totally new to cron jobs, but thanx to sebastian's link on crontab, i'm a little bit more knowledgable now! haha.. would appreciate more insights! thanx! - Original Message - From: Uzi Klein [EMAIL PROTECTED] To: 'Ng Hwee Hwee' [EMAIL PROTECTED]; 'DBList

[PHP-DB] Session

2004-04-27 Thread Ng Hwee Hwee
Hi, I have a problem with my session variables. I set them using for e.g., $_SESSION[user]=$name; However, because of weak network links, somehow my $_SESSION variables get unset. Is there a way to still keep the session variables even though the network is unstable?? i.e. as long as my

Re: [PHP-DB] Session

2004-04-27 Thread Ng Hwee Hwee
?? - Original Message - From: Wendell Frohwein [EMAIL PROTECTED] To: 'Ng Hwee Hwee' [EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 3:00 PM Subject: RE: [PHP-DB] Session Im sure you can store the session ID in a cookie. Then this will save all your variables. I hope this helps. Wendell

Re: [PHP-DB] Session

2004-04-27 Thread Ng Hwee Hwee
- From: Mikael Grön [EMAIL PROTECTED] To: Ng Hwee Hwee [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 3:54 PM Subject: Re: [PHP-DB] Session Session objects has nothing to do with weak network connections. If your sessions gets un-set, it's most probably because you forgot

Re: [PHP-DB] Session

2004-04-27 Thread Ng Hwee Hwee
: [PHP-DB] Session Ng Hwee Hwee [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] thanx Mike, i'm sure i have session_start() on all my pages. Why I'm so confident is because my session gets unset occassionally and not everytime. i cannot find a pattern and so

Re: [PHP-DB] Session

2004-04-27 Thread Ng Hwee Hwee
. Maybe it's easier for you to use a ready-made package like PEAR::Auth or PEAR::LiveUser: http://pear.php.net/package/Auth http://pear.php.net/package/LiveUser Hope this helps, Regards, Torsten Ng Hwee Hwee [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi Torsten

Re: [PHP-DB] Rounding

2004-04-07 Thread Ng Hwee Hwee
whoa! thanks so much! you guys are smart! hahaha.. i just love this list and all the helpful souls out there! :o) - Original Message - From: Larry E. Ullman [EMAIL PROTECTED] To: Ng Hwee Hwee [EMAIL PROTECTED] Cc: DBList [EMAIL PROTECTED] Sent: Thursday, April 08, 2004 10:06 AM Subject

Re: [PHP-DB] BLOB

2004-03-16 Thread Ng Hwee Hwee
hi, i've read the blob document in MySQL manual and i know it is similar to a text field and can store large amount of binary data..however, in phpMyAdmin 2.5.4, i can't see the contents of my blob fields... how do you view it? sorry for my ignorance.. hwee - Original Message - From:

Re: [PHP-DB] BLOB

2004-03-15 Thread Ng Hwee Hwee
[EMAIL PROTECTED] To: Ng Hwee Hwee [EMAIL PROTECTED] Sent: Monday, March 15, 2004 4:38 PM Subject: Re: [PHP-DB] BLOB Store the passwords using the md5() function. When inserting the password into the database, use md5($password). It will convert the password to a encrypted form using one way

Re: [PHP-DB] BLOB

2004-03-14 Thread Ng Hwee Hwee
hi all.. thank you so much for your help! i tried out the all the different syntax and the following works perfectly SELECT * FROM `MEMBER` WHERE `PASSWD` = thanx, amanda! btw, i was trying to store the encryted password in the database but i do not want anyone who has the right to see the

[PHP-DB] BLOB

2004-03-11 Thread Ng Hwee Hwee
Hi all, how do i find out if a BLOB field in my table is NULL? i tried: SELECT * FROM `MEMBER` WHERE `PASSWD` is NULL however, although there is one entry in my table that has nothing in my PASSWD field, the result set is empty.. how come? how do i search for entries that has password =

[PHP-DB] MySQL Update and Sort Queries

2004-02-19 Thread Ng Hwee Hwee
hi all, 1) Question on UPDATE My situation is this: I want to update Table1 with values that can be found in Table2.. in short, I would like to do the following: $query = update Table1, Table2 set Table1.field1 = Table2.field2 where Table1.no = Table2.no; however,

Re: [PHP-DB] Update Statement

2004-02-18 Thread Ng Hwee Hwee
- Original Message - From: Ricardo Lopes [EMAIL PROTECTED] To: Ng Hwee Hwee [EMAIL PROTECTED] Cc: PHP DB [EMAIL PROTECTED] Sent: Wednesday, February 18, 2004 5:41 PM Subject: Re: [PHP-DB] Update Statement you could use: for ($i=0; $i max; $i++) { mysql_query(update Table1

[PHP-DB] Update Statement

2004-02-17 Thread Ng Hwee Hwee
hi all, I would like to do the following: update Table1, Table2 set Table1.field1 = Table2.field2 where Table1.no = Table2.no however, i found that multiple updates can only work for MySQL version 4.0.4 but mine is 3.23.54... can anyone enlighten me on how I can achieve the same results with

[PHP-DB] Optimize Table

2004-02-12 Thread Ng Hwee Hwee
Hi all I read that it is neccessary and good to optimize my DB tables frequently.. I am using phpMyAdmin-2.5.4 to maintain my database and the program showed me that my overhead for some tables is over 5000. Can i know when would be good for me to optimise my tables? For example, once I have

Re: [PHP-DB] Search Query

2003-12-18 Thread Ng Hwee Hwee
thanx Mike for your help!! appreciatively, hh - Original Message - From: Ford, Mike [LSS] [EMAIL PROTECTED] To: 'Ng Hwee Hwee' [EMAIL PROTECTED]; DBList [EMAIL PROTECTED] Sent: Thursday, December 18, 2003 6:06 PM Subject: RE: [PHP-DB] Search Query On 18 December 2003 05:26, Ng Hwee

[PHP-DB] Search Query

2003-12-17 Thread Ng Hwee Hwee
Dear all, i need help with my search query statement.. what is wrong with my code? snip $word = split( , $keyword); $num_words = count($word); $word_str = ; $criteria = ; for ($i=0; $i$num_words; $i++) { if ($i) $word_str .= and colName

Re: [PHP-DB] Problem with PHP_AUTH_USER

2003-12-15 Thread Ng Hwee Hwee
hi, i think $PHP_AUTH_USER will only get unset the next time session_start() is called. try to use a header(location: ...) to direct your logout page to your index page and then print $PHP_AUTH_USER right after session_start().. by right, you should not have any value... i faced the same problem

Re: [PHP-DB] Shift_JIS Character Set

2003-12-12 Thread Ng Hwee Hwee
yes, and that's why i'm appealing for help on how to stripslashes when it comes to the Shift_JIS character set... will really appreciate advises! thanx lots! - Original Message - OK, if you *know* that the data has been through addslashes() (or equivalent eg magic_quotes_gpc) then

Re: [PHP-DB] Slashes

2003-12-11 Thread Ng Hwee Hwee
the database is: It's Good! what happened?! thanx.. - Original Message - Ng Hwee Hwee wrote: just a quick question.. does it mean, i don't have to worry that my user may type any commands in my text field that may hurt my system since magic_quotes_gpc is on? Heh...of course

[PHP-DB] Shift_JIS Character Set

2003-12-11 Thread Ng Hwee Hwee
Hi, i've read the following comment on PHP.net and found it very troubling because my database has Shift_JIS japanese words and my forms allow japanese input as well, so, does anyone know how can I stripslashes correctly when it comes to Japanese text? thanx thanx! hash at samurai dot fm

Re: [PHP-DB] Shift_JIS Character Set

2003-12-11 Thread Ng Hwee Hwee
thanks for your reply.. i'm doing a form (form.php) 1) user comes to form.php 2) user enters details and press submit 3) details get passed to form action verify.php 4) verify.php puts all the $_POST into an array $formVars 5) verify.php session_register(formVars) 6) if there is an error,

[PHP-DB] Slashes

2003-12-09 Thread Ng Hwee Hwee
hi all, i need help on my slashes.. i saw php.net say: Do not use addslashes() on strings that have already been escaped with magic_quotes_gpc as you'll then do double escaping. with that, i also did not do a stripslashes when i retrieve my data, since my magic_quotes_gpc is on.. but why is

Re: [PHP-DB] Slashes

2003-12-09 Thread Ng Hwee Hwee
Hi John, thanx!... HH but why is it that I still get a backslash HH before an occurrence of a single-quote? HH for example, HH td width=630 height=6? echo $fieldName; ?/td HH where $fieldName is retrieved from the database through: JH Maybe magic_quotes_runtime is enabled? It will add

Re: [PHP-DB] Slashes

2003-12-09 Thread Ng Hwee Hwee
type any commands in my text field that may hurt my system since magic_quotes_gpc is on? - Original Message - From: John W. Holmes [EMAIL PROTECTED] To: Ng Hwee Hwee [EMAIL PROTECTED] Cc: DBList [EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 12:05 PM Subject: Re: [PHP-DB] Slashes

Re: [PHP-DB] character problem with mssql

2003-12-04 Thread Ng Hwee Hwee
: Gamze Baaran [EMAIL PROTECTED] To: Ng Hwee Hwee [EMAIL PROTECTED] Sent: Thursday, December 04, 2003 3:17 PM Subject: RE: [PHP-DB] character problem with mssql Hi; First of all thanks for your concern. No I'm not use an turkish application. I write a program with php,phplib and my database must

Re: [PHP-DB] Re: Addslashes

2003-12-04 Thread Ng Hwee Hwee
, 2003 2:26 PM Subject: [PHP-DB] Re: Addslashes It's the magic quotes setting. Try setting magic_quote_gpc to off. Also, try turning magic_quotes_runtime off. Ng Hwee Hwee wrote: hi all, i'm really buffled by what i got and would appreciate any help possible! although i addslashes

[PHP-DB] Addslashes

2003-12-03 Thread Ng Hwee Hwee
hi all, i'm really buffled by what i got and would appreciate any help possible! although i addslashes and stripslashes, i still get a backslash ( \ ) character infront of a single inverted comma ( ' ) and also whenever an amberscend ( ) appears... please help! thanx thanx.. for example: in

Re: [PHP-DB] Read file

2003-11-20 Thread Ng Hwee Hwee
hi neil, this is indeed a very helpful piece of code and advice.. thank you so much! if this took you 30 minutes to write, it would have taken me a day to learn XML, and start writing! this code looks complicated for a young programmer like me ;p.. i'll need time to read up on XML and get back to

Re: Re: [PHP-DB] Read file

2003-11-18 Thread Ng Hwee Hwee
are trying to do, even with your description below - maybe a diagram would help us to understand your problem ? Cheers - Neil At 15:00 18/11/2003 +, Ng Hwee Hwee From: Ng Hwee Hwee [EMAIL PROTECTED] To: Michael Scappa [EMAIL PROTECTED], [EMAIL PROTECTED] Date: Tue, 18 Nov 2003 10:27:26

[PHP-DB] Read file

2003-11-17 Thread Ng Hwee Hwee
hi all, can anyone enlighten me on how i can use PHP to read the contents of a file from the client's machine?? for eg, the client has a CSV file in his MyDocuments directory, how can I read the contents and publish them on the web? thank you lots! Hwee Hwee

Re: [PHP-DB] Read file

2003-11-17 Thread Ng Hwee Hwee
Wong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 9:54 AM Subject: Re: [PHP-DB] Read file On Tuesday 18 November 2003 09:29, Ng Hwee Hwee wrote: can anyone enlighten me on how i can use PHP to read the contents of a file from the client's machine?? for eg

Re: [PHP-DB] Read file

2003-11-17 Thread Ng Hwee Hwee
PROTECTED] To: 'Ng Hwee Hwee' [EMAIL PROTECTED] Sent: Tuesday, November 18, 2003 10:01 AM Subject: RE: [PHP-DB] Read file If you are publishing it on the web, it has to get to the server eventually, so your answer is no. There is really no way around it. If the file is often used, pump it into a DB

[PHP-DB] mail function

2003-10-30 Thread Ng Hwee Hwee
hi all, i need to use a mail() function to send a job application to my inbox when an applicant goes online and complete the application form. However, when the contents of a certain field is very long, the message i get in my inbox is truncated! can anyone help me please? i've tried word wrap,

[PHP-DB] mail function

2003-10-30 Thread Ng Hwee Hwee
hi all, i need to use a mail() function to send a job application to my inbox when an applicant goes online and complete the application form. However, when the contents of a certain field is very long, the message i get in my inbox is truncated! can anyone help me please? i've tried word wrap,

[PHP-DB] Form Variables

2003-10-22 Thread Ng Hwee Hwee
Hi all, got an urgent problem.. it's regarding forms. my system works like this.. 1) user on page1 fills up form 2) upon clicking submit button, it will go to verify.php to verify if the entries are correct 3) if there is any errors, verify.php brings user back to page1 with all the errors