Re: [PHP-DB] HTML Tables in PHP...

2005-09-25 Thread balwant singh
all html tags should be in single quote when used in php like echo 'table align=center width=80%'; echo 'trtd align=center'; echo HELLO; echo '/td/tr/table'; With Best Wishes Balwant Singh INDO ASIAN FUSEGEAR LTD. A-39, HOSIERY COMPLEX PHASE - II EXTN., NOIDA PH: +91

Re: [PHP-DB] A question with php.ini

2005-09-22 Thread balwant singh
as well (default: sendmail -t -i). sendmail_path = path-to-sendmail -t -i -f (your email id) hope it will work for you With Best Wishes Balwant Singh INDO ASIAN FUSEGEAR LTD. A-39, HOSIERY COMPLEX PHASE - II EXTN., NOIDA PH: +91 - 120 - 3048140 / 304 FAX: +91 - 120

Re: [PHP-DB] Duplicate record

2005-07-30 Thread balwant singh
in my opinion you can do the following: 1) once the user submitted the form, redirect to a new page OR 2) may have a unique column in database to avoid duplication like userid etc. With Best Wishes Balwant Singh INDO ASIAN FUSEGEAR LTD. A-39, HOSIERY COMPLEX PHASE

Re: [PHP-DB] floats

2005-07-19 Thread balwant singh
i run this query at my end, its running... pls check whether you gave the field names properly. With Best Wishes Balwant Singh blackwater dev wrote: I am running a query on MySQL: select * from cars where id =52 It returns the row and I can see that gas mileage is saved as a float

Re: [PHP-DB] General UPDATE question

2005-06-17 Thread balwant singh
it will update all rows which fulfills the criteria. With Best Wishes Balwant Singh INDO ASIAN FUSEGEAR LTD. A-39, HOSIERY COMPLEX PHASE - II EXTN., NOIDA PH: +91 - 120 - 2568 472 / 093 -098 FAX: +91 - 120 - 2568 473 WEB : www.indoasian.com Ron Piggott wrote: Does

[PHP-DB] Re newbie question

2005-04-15 Thread Balwant Singh
i am doing the following for inserting values in MYSQL DB through PHP. $a = hello; $b = 1; $query = INSERT INTO tablename (a, b) VALUES ('$a', '$b'); try this with best wishes balwant - Original Message - From: Kenn Murrah [EMAIL PROTECTED] To: php-db@lists.php.net Sent: Wednesday,

Re: [PHP-DB] PHP Sessions

2005-04-14 Thread Balwant Singh
i also want to buy this book. but could not find it in India. If anybody help me out. with best wishes balwant On Thu, 2005-04-14 at 15:10, Maerlyn wrote: Hi, you might consider buying Peter Moulding's PHP Black Book. Among other things it tells much about DBs, sessions and storing

Re: [PHP-DB] email question

2005-03-04 Thread Balwant Singh
at another PHP package (i.e. PEAR) that will authenticate when sending emails. On Mar 2, 2005, at 3:54 AM, Balwant Singh wrote: can anybody guide me how i can get subscribed to PHP-DEV forum. excuse me, i am asking one off the list question. i want to use PHP to send email. my

[PHP-DB] email question

2005-03-04 Thread Balwant Singh
can anybody guide me how i can get subscribed to PHP-DEV forum. excuse me, i am asking one off the list question. i want to use PHP to send email. my webserver has linux OS but we are using POP3 for sending emails (on Windows OS). May pls. inform all the setting needs to be done for sending an

[PHP-DB] GD2 library

2005-03-04 Thread Balwant Singh
Sorry I am asking a question which is not directly linked to this forum but i am confident that many of you have the answer for it. i am using PHP 4.2.2 with GD 1.63. now i want to upgrade the GD1.63 to GD2. i have installed the GD2 in my system but still my system is showing GD 1.63. May pls.

[PHP-DB] email question

2005-03-02 Thread Balwant Singh
can anybody guide me how i can get subscribed to PHP-DEV forum. excuse me, i am asking one off the list question. i want to use PHP to send email. my webserver has linux OS but we are using POP3 for sending emails (on Windows OS). May pls. inform all the setting needs to be done for sending an

Re: [PHP-DB] timestamp

2005-02-01 Thread Balwant Singh
. Balwant Singh wrote: i just copy your code and paste into a test file. ? $timestamp = Fri Jan 28 19:53:09 2005; $date = date(Y-m-d,strtotime($timestamp)); echo $date; ? with best wishes balwant On Tue, 2005-02-01 at 10:33, Bastien Koert wrote: pls post

RE: [PHP-DB] timestamp

2005-01-31 Thread Balwant Singh
,strtotime($timestamp)); echo $date; ? gave me this result 2005-01-28 Exactly as it should. Bastien From: Balwant Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Bastien Koert [EMAIL PROTECTED] CC: php-db@lists.php.net Subject: RE: [PHP-DB] timestamp Date: 31 Jan 2005 10:02

RE: [PHP-DB] timestamp

2005-01-31 Thread Balwant Singh
i just copy your code and paste into a test file. ? $timestamp = Fri Jan 28 19:53:09 2005; $date = date(Y-m-d,strtotime($timestamp)); echo $date; ? with best wishes balwant On Tue, 2005-02-01 at 10:33, Bastien Koert wrote: pls post relevant code bastien From: Balwant Singh [EMAIL

RE: [PHP-DB] timestamp

2005-01-30 Thread Balwant Singh
-m-d,strtotime($timestamp)); Best thing to use if you want to do calcs on date/time data is to use the unix time stamp...translates the timestamp into seconds since 01-01-1970...Much simpler to use in sql queries Bastien From: Balwant Singh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED

[PHP-DB] timestamp

2005-01-29 Thread Balwant Singh
i am facing a problem i have timestamp in string format -- Fri Jan 28 19:53:09 2005 now i want to get the date from it. is it possible? pls. help. on using strftime(%D,$timestamp) it is giving 01/01/70. May pls. help me. Also pls. let me know whether calculation can be done in mysql on this

Re: [PHP-DB] if statement

2005-01-28 Thread Balwant Singh
i may be wrong but as i understand that you want to check whether a array holds any value or not -- for this u can use COUNT function of array which will count the values of the array. with best wishes balwant On Sat, 2005-01-29 at 06:29, Craig Hoffman wrote: Hi There, I am trying to write

Re: [PHP-DB] Re: Excel to MySQL

2005-01-25 Thread Balwant Singh
As suggested by David, save the excel file as CSV file then you can insert the data into database through command like LOAD INFILE for MYSQL with best wishes balwant On Tue, 2005-01-25 at 12:34, David Robley wrote: On Tuesday 25 January 2005 08:07, Novice Learner wrote: Hello, I have

[PHP-DB] MYSQL

2004-12-21 Thread Balwant Singh
hi to all, may somebody guide me on the following: I want to retrieve data from MYSQL and then want that PHP do calculation - substract a particular field from its previous row. i.e. suppose i have two field named DATE, STOCK and have 10 rows. Now i want that STOCK on the 10th row should be