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 ''; echo ''; echo "HELLO"; echo ''; With Best Wishes Balwant Singh INDO ASIAN FUSEGEAR LTD. A-39, HOSIERY COMPLEX PHASE - II EXTN., NOIDA PH: +91 - 120 - 304

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 / 304222

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 with

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: Sent: Wednesday, May 31, 2000 2:

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 ses

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

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

Re: [PHP-DB] email question

2005-03-04 Thread Balwant Singh
if you don't know how to setup your mail server for restricted open > relaying, you should look 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 ge

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

Re: [PHP-DB] timestamp

2005-02-01 Thread Balwant Singh
orks fine on my system, so what version of php are you using > > and what is your operating system? > > > > graeme. > > > > Balwant Singh wrote: > > > >> i just copy your code and paste into a test file. > >> >> $timesta

RE: [PHP-DB] timestamp

2005-01-31 Thread Balwant Singh
i just copy your code and paste into a test file. with best wishes balwant On Tue, 2005-02-01 at 10:33, Bastien Koert wrote: > pls post relevant code > > bastien > > >From: Balwant Singh <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Bas

RE: [PHP-DB] timestamp

2005-01-31 Thread Balwant Singh
> $date = date("Y-m-d",strtotime($timestamp)); > > echo $date; > > ?> > > gave me this result > > 2005-01-28 > > Exactly as it should. > > Bastien > > >From: Balwant Singh <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTE

RE: [PHP-DB] timestamp

2005-01-30 Thread Balwant Singh
gt; $date = date("Y-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:

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

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