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: [PHP-DB] character problem with mssql

2003-12-03 Thread Ng Hwee Hwee
hi, i had the same problem a while ago with japanese characters. are you using a turkish OS or turkish application to insert your data? for me, what happened was i was given a file from a colleague who was using japanese OS and japanese version of excel. when he passed me the data, i opened it in

[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] character problem with mssql

2003-12-04 Thread Ng Hwee Hwee
l Message - From: "Gamze Başaran" <[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

Re: [PHP-DB] Re: Addslashes

2003-12-04 Thread Ng Hwee Hwee
OTECTED]> Sent: Thursday, December 04, 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 bu

[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 > HH > where $fieldName is retrieved from the database through: JH > Maybe magic_quotes_runtime is enabled? It will add slashes to data from JH > files and databa

Re: [PHP-DB] Slashes

2003-12-09 Thread Ng Hwee Hwee
y 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

Re: [PHP-DB] Slashes

2003-12-11 Thread Ng Hwee Hwee
r: 1064 : You have an error in your SQL syntax near 's Good!', col2 = 'YES', ' at line 15 (# 256). the value retrieved from the database is: It's Good! what happened?! thanx.. - Original Message - > Ng Hwee Hwee wrote: > > > just a quick ques

[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 01-De

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, verify

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 do

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 proble

[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? $word = split(" ", $keyword); $num_words = count($word); $word_str = ""; $criteria = ""; for ($i=0; $i<$num_words; $i++) { if ($i) $word_str .= "and colN

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 Sub

[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 an

[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 th

Re: [PHP-DB] Update Statement

2004-02-18 Thread Ng Hwee 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

[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

[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 = [BLOB

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

Re: [PHP-DB] BLOB

2004-03-15 Thread Ng Hwee Hwee
l Message - From: "Marcjon Louwersheimer" <[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 dat

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:

[PHP-DB] Rounding

2004-04-07 Thread Ng Hwee Hwee
Hi all, is there a way to do rounding up to the nearest tenth? can't use ROUND() cos i need something like this: 6.11 --> 6.2 6.15 --> 6.2 6.19 --> 6.2 6.20 --> 6.2 i know there is a ceil() function but that rounds up to the nearest integer.. i need one decimal place still.. I tried adding a

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

Re: [PHP-DB] Edit with notepad

2004-05-12 Thread Ng Hwee Hwee
ey want is what we're all about - > you have to take some responsibility for implementing snippets of code like > this ;-) > > Cheers - Neil > > At 10:39 11/05/2004 +, you wrote: > >Message-ID: <[EMAIL PROTECTED]> > >From: "Ng Hwee Hwee" <[EM

Re: [PHP-DB] Edit with notepad

2004-05-10 Thread Ng Hwee Hwee
t; At 07:41 10/05/2004 +0000, you wrote: > > >Message-ID: <[EMAIL PROTECTED]> > >From: "Ng Hwee Hwee" <[EMAIL PROTECTED]> > >To: "DBList" <[EMAIL PROTECTED]> > >Date: Mon, 10 May 2004 15:40:27 +0800 > >MIME-Version: 1.0 > >Conten

[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 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 programs don't allow it?? thanx for any

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

2004-05-10 Thread Ng Hwee Hwee
Original Message - From: "Uzi Klein" <[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]

[PHP-DB] Session

2004-04-26 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 brow

Re: [PHP-DB] Session

2004-04-27 Thread Ng Hwee Hwee
done wrong?? - 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

Re: [PHP-DB] Session

2004-04-27 Thread Ng Hwee Hwee
riginal Message - 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. > I

Re: [PHP-DB] Session

2004-04-27 Thread Ng Hwee Hwee
, April 27, 2004 6:07 PM Subject: Re: [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 > > beca

Re: [PHP-DB] Session

2004-04-27 Thread Ng Hwee Hwee
on > DATA is. Which means you should unset all session data after the desired > period of time. 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 > > >

[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
o the hardware.. does this apply to optimisation of tables? will this be bad for my server then? thank you so much. - Original Message - From: "Dynamix" <[EMAIL PROTECTED]> To: "Ng Hwee Hwee" <[EMAIL PROTECTED]>; "DBList" <[EMAIL PROTECTED]> Se

Re: [PHP-DB] Optimize Tables

2004-05-03 Thread Ng Hwee Hwee
that your echo statements will be reflected 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 Kl

[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 w

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 PROTE

[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 m

Re: [PHP-DB] Re: Multi search function (help)

2004-05-31 Thread Ng Hwee Hwee
hi.. your should just use if (empty($foo)) statements.. i did my search scripts like that too and they were wonderful! PS: besides $query, all the $variables are being posted from a form... $query = "select * from myTable where "; $query .= (!empty($typeS)) ? "Column1 =

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

2004-05-31 Thread Ng Hwee Hwee
ution 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 &g

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

2004-05-31 Thread Ng Hwee Hwee
anx 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

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

2004-05-31 Thread Ng Hwee Hwee
session just deleted from web server... > > I also guest that its a weak network that cause such problem. > > Otherwise I dont get any ideas. > > So whats ur solution then?? u change all session to cookie (I prefer not to > use cookie) > > >From Flame Xie xi Chuan &

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

2004-06-17 Thread Ng Hwee Hwee
hmm... what about something like this?? echo "; $query = "select code, name from table"; $result = mysql_query($query); while($array = mysql_fetch_array($result)) { echo "".$array["name"].""; } echo ""; hth - Original Message - From: "Cole Ashcraft" <[EMAIL PROTECTED]> To: <[EMA

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

2004-06-17 Thread Ng Hwee Hwee
MAIL PROTECTED]> 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, N

[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
al Message - 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: > >

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 Subj

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"]).) > >

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

2004-08-05 Thread Ng Hwee Hwee
tatement in a form > Well, this works: so you were all on the right track > > if($row['timeout']=="") > { > print ""; > }else{ > print $row["timeout"]; > } > > But now I get a parse error on the line >

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 > > DELE

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

Re: [PHP-DB] Deleting older records

2004-08-12 Thread Ng Hwee Hwee
; '$time'"; mysql_query($query); - Original Message - From: "Dylan Barber" <[EMAIL PROTECTED]> To: "'Ng Hwee Hwee'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, August 13, 2004 1:32 PM Subject: RE: [PHP-DB] Deleti

[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 repre

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 v

Re: [PHP-DB] Clicking on the Picture

2004-08-30 Thread Ng Hwee Hwee
what about this?? - 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, > > I have a Diagram that I need to upload to web page. > The diagram contains 3 pict

[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) af

[PHP-DB] Session Cache Limiter

2004-09-16 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 pr

[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. i.e the script to check if the values submitted is valid and the scripts to insert the data into the database are all in

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]&

[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

[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 listed

Re: [PHP-DB] Form Variables

2003-10-22 Thread Ng Hwee Hwee
riginal Message - From: "Jason Wong" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 22, 2003 4:03 PM Subject: Re: [PHP-DB] Form Variables > On Wednesday 22 October 2003 15:06, Ng Hwee Hwee wrote: > > > got an urgent problem.. it's rega

[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, c

[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, c

[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
om: "Jason 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 o

Re: [PHP-DB] Read file

2003-11-17 Thread Ng Hwee Hwee
"Michael Scappa" <[EMAIL 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

Re: Re: [PHP-DB] Read file

2003-11-18 Thread Ng Hwee Hwee
d xmlhttp.send > function to read remote XML files. (This will require MSXML2.6 or above) > > Hope that helps, I'm not really too sure what you are trying to do, even > with your description below - maybe a diagram would help us to understand > your problem ? > > Cheer

[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] 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 fo

[PHP-DB] Re: Subject: Web Printing

2005-03-31 Thread Ng Hwee Hwee
At 10:27 31/03/2005 +, you wrote: > >Message-ID: <[EMAIL PROTECTED]> > >From: "Ng Hwee Hwee" <[EMAIL PROTECTED]> > >To: "PHP DB List" > >Date: Thu, 31 Mar 2005 18:24:41 +0800 > >Subject: Web Printing > > > >Hi all, >

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

2005-03-31 Thread Ng Hwee Hwee
how PDF allows 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]>; "

Re: [PHP-DB] Subject: Web Printing

2005-04-01 Thread Ng Hwee Hwee
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" > >Date: Thu, 31 Mar

[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 have.

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
Hi! thank you so much for your help!! do you mean to do ob_get_contents() before i do a ob_end_flush()? but even if i'm successful in counting the number of "\n"s, HTML tags like ,,

[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 clic

Re: [PHP-DB] R6025 Error

2005-05-09 Thread Ng Hwee Hwee
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 with a R6025 error. What happened is that I

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" Sent: Tuesday, May 10, 2005 11:15 AM Subject: Re: [PHP-DB] R6025 Er

[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 he

[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

[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 w

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" Sent: M

Re: [PHP-DB] Subquery

2005-09-18 Thread Ng Hwee Hwee
From: "Bastien Koert" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; 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 PROTE

[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 | | pr

[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 ve

[PHP-DB] Defined Constants

2005-10-12 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 somethin

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" Sent: Thursday, October 13, 2005 2:28 PM Subject: RE: [PHP-DB] Defined Const

[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 u

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 th

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: &