[PHP]dtabase problem

2002-09-24 Thread Thomas Edison Jr.
there is a problem in mysql database.there r two tables.one table is named as transactions and the other is named as the code.the transactions table has got the 12 fields which r the following 1.clientid int 2.date date 3.isinno text 4.debit int 5.credit int 6.desc text 7.dpid1 text

Re: [PHP] Calling info from mySQL inside flash

2002-09-09 Thread Thomas Edison Jr.
-Brad Thomas Edison Jr. wrote: I have a mySQL db, and a bunch of tables in it. What i want to do, is to pick up some data, and display in my Flash Movie. For example. I have a table with a list. Now on my main page, i display the total number of people in the list so far

[PHP] Calling info from mySQL inside flash

2002-09-08 Thread Thomas Edison Jr.
I have a mySQL db, and a bunch of tables in it. What i want to do, is to pick up some data, and display in my Flash Movie. For example. I have a table with a list. Now on my main page, i display the total number of people in the list so far (By counting the rows). Now i want to display the same

[PHP] Need a Web Host for php/mySQl

2002-08-13 Thread Thomas Edison Jr.
Glory, I'm looking for a new Web Hosting company, to host my sites. I had been with Aletia, but i'm experiencing some technical flaws with them, so i need a new one. Aletia is very economical, with $7.95 a month for 200 MB, 10 GB Bandwidth, sub-domains, dbs, and a hell a lot of goodies. so i

[PHP] PROBLEM

2002-08-01 Thread Thomas Edison Jr.
hi! i have a problem in my project.the problem is that suppose we have the date for the whole of the month and two different files r there. i have to pick one file of the current date that is say today and the other file of the yesterday.but the problem is that if the current date is monday then

[PHP] Picking up Data of Previous Date from Table

2002-07-29 Thread Thomas Edison Jr.
Glory! I have one Table (Transactions), having a Date Column, with date stored as -MM-DD I have another Table (Holdings), having a Date Column, with date stored as -MM-DD Now i'm joining the two tables, to get data from both the tables and display on the page. The query i'm using is

RE: [PHP] Stopping Multiple Entries in mySQL DB

2002-07-29 Thread Thomas Edison Jr.
Hi, Ok i cant actully do this. I have many multiple entries already in the table which i do not wish to delete. And it won't alter table with these multiple entries. So what i need is a PHP Engineered solution, where my PHP code would check for existing entries and deny entry Thanks, T.

[PHP] Resetting ID

2002-07-29 Thread Thomas Edison Jr.
Glory! I have a table, with 4 columns. One of the column is ID, a Primary Key, which has Auto_Increment set on it. Now i have a lot of rows deleted and a lot of duplicate rows that will be deleted, and all sorts of stuff happening in the table.. the result is, that the IDs have become

Re: [PHP] Submitting form in new window!

2002-07-29 Thread Thomas Edison Jr.
; var url = ./processForm.php?textfield= + textfield; window.open(url); } /SCRIPT OR just add this to your form tag. TARGET=_blank Thomas Edison Jr. [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Glory, Attach a javascri

[PHP] Stopping Multiple Entries in mySQL DB

2002-07-27 Thread Thomas Edison Jr.
Glory! I just want my Adding Into Database script to check if the Name/Country already exists, and if it does, it shouldn't be allowed. If some with Name : Jackson Country : USA exists in my DB, no one with same name/country should be able to add his name/country in the DB. Can anyone hint?

RE: [PHP] Inserting Processed Data from One Table 2 Another!

2002-07-26 Thread Thomas Edison Jr.
-Oorspronkelijk bericht- Van: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 24 juli 2002 9:02 Aan: [EMAIL PROTECTED] Onderwerp: [PHP] Inserting Processed Data from One Table 2 Another! Ok i have simple issue, i'm stuck at one point. I have a table

[PHP] Inserting Processed Data from One Table 2 Another!

2002-07-24 Thread Thomas Edison Jr.
Ok i have simple issue, i'm stuck at one point. I have a table Clientdetails which contains ClientID. I have created another table Authentication with 2 fields, ClientID and Password. I want to pick up the ClientID from table Clientdetails and insert ClientID and a Password i have generated

Re: [PHP] why my php can not get values from Form?

2002-07-18 Thread Thomas Edison Jr.
Simple.. just edit your php.ini file in your windows directory. Search for register_globals .. it will have Off in front of it.. switch it to On T. Edison jr. --- ram friend [EMAIL PROTECTED] wrote: hello, I have just installed apache+php4, but my php can not get values from form? what's

[PHP] Importing CSV File : 100000 Rows!

2002-07-17 Thread Thomas Edison Jr.
Hi, I have generated a .csv file from a .dat file using a VB program. Now this .csv file needs to be imported into my mySQL Database Table on the internet, using phpMyAdmin. The problem i'm facing is that the file, while uploading, stops somewhere in the middle. The upload just gets stuck.

Re: [PHP] Importing CSV File : 100000 Rows!

2002-07-17 Thread Thomas Edison Jr.
but the command on Linux is close if the file is called mydata.sql mysql \. C:\mydata.sql Hope this works Pradeep - Original Message - From: Thomas Edison Jr. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 10:50 AM Subject: [PHP] Importing CSV File

[PHP] Connecting LocalHost Remote mySQL DB

2002-07-12 Thread Thomas Edison Jr.
Glory! Let's say i got a bunch of Data in my mySQL Table on my localhost. I need all this Data uploaded on my mySQL on the Server/Internet. Now one way is to use phpMyAdmin, Export the original data on LocalHost to a .CSV file, then use the Server phpMyAdmin to upload the same .CSV file to the

Re: [PHP] Connecting LocalHost Remote mySQL DB

2002-07-12 Thread Thomas Edison Jr.
mySQL. Thanks, T. Edison Jr. --- Jason Wong [EMAIL PROTECTED] wrote: On Saturday 13 July 2002 13:45, Thomas Edison Jr. wrote: Glory! Let's say i got a bunch of Data in my mySQL Table on my localhost. I need all this Data uploaded on my mySQL on the Server/Internet. Now one way

[PHP] Submitting form in new window!

2002-07-09 Thread Thomas Edison Jr.
Hi, When i press the Submit button, i would like it to open in a new Javascript Windows with well-defined characteristics like size, width etc. I create a window.open function and gave the name of my PHP page .. but the Form Variables are not passing into it.. Thanks, T. Edison Jr. =

[PHP] Sending data in table, multiple rows, via mail()

2002-07-09 Thread Thomas Edison Jr.
Hi, Ok i have a bunch of rows in my table, with some data. I want my mail() function to be able to pick up the data from the rows and send to a specified email. Basicall let's say there are 3 fields, and 3 rows, the data sent in email should be something like : row1field1 : dkjhdkj row1field2

Re: [PHP] Sending data in table, multiple rows, via mail()

2002-07-09 Thread Thomas Edison Jr.
Thank you for your *extreme* kindness... I do not know where to begin to make this happen. I created a variable and ran the entire do while loop to read contents of the table and tried storing them in the variable, which could be used as Content of the mail. However, i just get the Last Row in

Re: [PHP] Submitting form in new window!

2002-07-09 Thread Thomas Edison Jr.
Hi, Ok, let me show some code : form name=\drama\ action=\add2cart.php\ method=post target=\blank\ input type=hidden name=sessid value= $PHPSESSID input type=hidden name=proid value= $result[vProID] input type=hidden name=proname value= $result[vProName] font color=#00

RE: [PHP] Sending data in table, multiple rows, via mail()

2002-07-09 Thread Thomas Edison Jr.
Hi, WOW... THANKS A LOT!! This actually did it .. i was on a slight wrong track.. $realcontent = ; while ($myrow = mysql_fetch_array($result)) { $realcontent .= $myrow['pid']br; $realcontent .= $myrow['nm']br; $realcontent .= $myrow['q']br; } Thanks, T. Edison Jr.

[PHP] Commit/Roll Back Transaction in PHP/mySQL

2002-07-09 Thread Thomas Edison Jr.
Glory! Im creating a .php file that will be uploading putting in data from a .csv file into mySQL Tables on the server. However, my problem is that if there is any kind of a problem during the transaction, i.e, system shut down, electricity problem, or any reason why the transaction is

[PHP] Exporting mySQL Table Data to .csv

2002-07-09 Thread Thomas Edison Jr.
Glory, I use phpMyAdmin which enables me to take dump of mySQL Table Data into Comma Seperated Values file (.csv) Now, i have to create such a program that accomplishes this, without using phpMyAdmin. Can someone guide me to this procedure.. Thanks, T. Edison Jr.

Re: [PHP] Submitting form in new window!

2002-07-09 Thread Thomas Edison Jr.
Glory, Attach a javascript event to the submit button Something like : input type=submit name=go onSubmit=wow(); Wherein wow() defines a the window.open function? and also attach the form values to the url. How do i do this? Because the 3 or 4 form fields i have, which are Hidden Fields,

[PHP] Software on web Accessing mySQL/PHP

2002-07-08 Thread Thomas Edison Jr.
Hi, Basically we have created a Software in Visual Basic. Now the software uses mySQL on the internet as Backend. However, our server does not allow Remote Host Connection, which means we cannot access our mySQL Database on the Internet by our Software on a local client. We need the mySQL

[PHP] PHP not working on Apache at XP Pro.

2002-06-25 Thread Thomas Edison Jr.
Glory! I've got Windows XP Pro OS. I installed and am running mySQL on that. However, PHP is not getting configured with Apache on it. I got the latest Apache, 1.3.24 or something, not the Version 2. Anyway, Apache runs perfectly on it. However, when i put in the required PHP lines in

[PHP] Apache 2.0 or 1.3 for php on windows XP ?

2002-06-10 Thread Thomas Edison Jr.
Glory! I have Windows XP Home Edition.. and i downloaded the latest PHP mySQL. I have Apache 1.3.19 earlier, which for some reason gives Service Apache Not Installed now even when everything is installed, on my windows XP. So i decided to get a new Apache Web Server. They have 2 versions

Re: [PHP] Apache 2.0 or 1.3 for php on windows XP ?

2002-06-10 Thread Thomas Edison Jr.
Ok... i'll go for 1.3.24 Thanks, T. Edison Jr. --- R'twick Niceorgaw [EMAIL PROTECTED] wrote: use apache 1.3.24.. php has experimental support for apache 2.0.x.. so don't trust it much - Original Message - From: Thomas Edison Jr. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent

[PHP] Uploaded File OverWriting Old File

2002-05-11 Thread Thomas Edison Jr.
Hi, If i have a filename room.jpg in my Upload Directory, and someone else comes and uploads a file by the same name, the previous room.jpg is overwritten by the new one. Any suggestions? This is the code i'm using : ?php $db = mysql_connect(localhost,user,pwd); mysql_select_db(dbname,$db);

Re: [PHP] File Type not working in Uploaded File

2002-05-11 Thread Thomas Edison Jr.
Hi, Ok there were a lot of mistakes in that code. IN fact i rubbed it off completely and am using a new code.. Everything works fine now, except that if the filename exists, any new file with the same name overwrites the old file.. What do i do about it? Here is the code i'm using : ?php

Re: [PHP] Uploaded File OverWriting Old File

2002-05-11 Thread Thomas Edison Jr.
= $img1_name+n; } And thanks a lot.. Thus Spake T. Edison Jr. !! --- Nick Wilson [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Thomas Edison Jr. declared Hi, If i have a filename room.jpg in my Upload Directory, and someone else comes

Re: [PHP] Uploaded File OverWriting Old File

2002-05-11 Thread Thomas Edison Jr.
Glory Power! I'm using the following code now... the Error is gone, but it's still overwriting the old file. It's not changing the name.. not doing anything, just uploading this new file and replacing the old one.. ?php $db = mysql_connect(localhost,use,pwd); mysql_select_db(dbname,$db);

Re: [PHP] Uploaded File OverWriting Old File

2002-05-11 Thread Thomas Edison Jr.
Glory! Well, I don't see any thing in your code that denotes the directory the images are going in? What about this : copy($img1, mjpalpics/$img1_name) or Die (Could not do); Sends the images to the mjpalpics Directory! 'path/to/img/img.jpg' exists and if so, name the upload img to

Re: [PHP] Uploaded File OverWriting Old File

2002-05-11 Thread Thomas Edison Jr.
Well thanks a bunch! --- Nick Wilson [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Thomas Edison Jr. declared Hmm... possibly when i say if(file_exists($img1_name)), he's looking for the file name in the Directory where the Images initially

RE: [PHP] Uploaded File OverWriting Old File

2002-05-11 Thread Thomas Edison Jr.
WOOO.. i did not know this was possible : file_exists(mjpalpics/$img1_name) And this might actually solve the whole issue!! Let me try this.. Thanks a BUNCH! T. Edison Jr. --- John Holmes [EMAIL PROTECTED] wrote: copy($img1, mjpalpics/$img1_name) or Die (Could not do); Sends the

Re: [PHP] Uploaded File OverWriting Old File

2002-05-11 Thread Thomas Edison Jr.
! T. Edison jr. --- Miguel Cruz [EMAIL PROTECTED] wrote: On Sat, 11 May 2002, Thomas Edison Jr. wrote: If i have a filename room.jpg in my Upload Directory, and someone else comes and uploads a file by the same name, the previous room.jpg is overwritten by the new one. Any suggestions

[PHP] File Type not working in Uploaded File

2002-05-10 Thread Thomas Edison Jr.
Hi, This is my upload form : form action=upload.php method=POST enctype=multipart/form-data p align=centerfont size=2 face=VerdanastrongPlease upload your file below:/p input type=file name=file size=30 pinput type=button name=submit type=submit Upload /form And this is part of my PHP

[PHP] importing .dat SQL Data into mySQL

2002-04-16 Thread Thomas Edison Jr.
Hi, I have a .dat file.. with some data like this : 02001IN00100213200207120020412200204122002041710002002041720020417 02002IN00100213200207220020415200204152002041810002002041820020418 02003IN00100213200207320020416200204162002041910002002041920020419

[PHP] Search Results, Per Page, Total Results!

2002-04-15 Thread Thomas Edison Jr.
Hi, I have a mySQL table on which i'm performing a search.. something like this : $sql_text = (SELECT * FROM searchtb where vCategory='$q' || vSubCategory='$q'); Now i want the Search Results to appear per page.. that is, maybe 15 Records per page should appear.. with something like this on

[PHP] Search Results, Per Page, Total Results...

2002-04-15 Thread Thomas Edison Jr.
Hi, I'm working on a search program that searches on a mySQL DB and gives back results.. something like this : $sql_text = (SELECT * FROM searchtb where vCategory='$q' || vSubCategory='$q'); What i want is that the results should be displayed PageWise.. that is, maybe 15 results per page.

[PHP] Searching a mySQL DB

2002-04-15 Thread Thomas Edison Jr.
I'm working on a search program that searches on a mySQL DB and gives back results. I have a table with a column vProName, which let's say, contains a record Basket Ball Game. Now what i want is that if someone searches for Game or Ball, even then this record should appear. Could someone guide

[PHP] Adding a in try.jpg!

2002-04-08 Thread Thomas Edison Jr.
I have a new very intriguing problem at hand. I have the name of my Images stored in my mySQL database in one column. Now when i pick the images, they are displayed as it as. However, they are the big images, and the thumbnails of those images are stored with an a at the end of thier names.

Re: [PHP] Adding a in try.jpg! Problems!

2002-04-08 Thread Thomas Edison Jr.
= eregi_replace('\.jpg$', 'a.jpg', $oldname); No point messing up your database; just use something like the above when you're outputting the image tags for the thumbnails. miguel On Mon, 8 Apr 2002, Thomas Edison Jr. wrote: I have a new very intriguing problem at hand. I have

Re: [PHP] Adding a in try.jpg! SOLVED!!

2002-04-08 Thread Thomas Edison Jr.
. --- Miguel Cruz [EMAIL PROTECTED] wrote: (untested) $newname = eregi_replace('\.jpg$', 'a.jpg', $oldname); No point messing up your database; just use something like the above when you're outputting the image tags for the thumbnails. miguel On Mon, 8 Apr 2002, Thomas Edison Jr. wrote

Re: [PHP] MS Access data = mySQL database

2002-03-26 Thread Thomas Edison Jr.
.. there is at www.hotscripts.com a php accessmysql converter, i tried it last year, but found it very buggy. cannot remember what it was called steven dowd - Original Message - From: Thomas Edison Jr. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 25, 2002 11:31 AM Subject: [PHP] MS

Re: [PHP] MS Access data = mySQL database

2002-03-26 Thread Thomas Edison Jr.
Thanks... actually the software DBTools from www.dbtools.com.br is excellent for the same purpose, as suggested by someone here. It does the needful pretty efficiently. Cheers! T. Edison Jr. --- Jon Farmer [EMAIL PROTECTED] wrote: Can anyone tell me how to convert/send data stored in an

Re: [PHP] Personal web server that runs PHP

2002-03-26 Thread Thomas Edison Jr.
Hi, Of course. The Personal Web Server that is available with Windows 98 as an Add-On totally supports PHP4. I have it configured on my system. I'm not sure if i know of a place where you can download it from.. But it's available as an Add-On with Windows 98 CD. If you look on the net, i'm

Re: [PHP] Personal web server that runs PHP

2002-03-26 Thread Thomas Edison Jr.
In fact, using Apache Win32 Module on a Windows 98 PC is a much better choice option rather then PWS. Apache server gives greater flexibility support. I don't see any reason why you should choose PWS over Apache Win32 for your Win 98 PC? T. Edison Jr. --- R'twick Niceorgaw [EMAIL

[PHP] MS Access data = mySQL database

2002-03-25 Thread Thomas Edison Jr.
Can anyone tell me how to convert/send data stored in an MS Access database to a mySQL table through PHP?? T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel :

[PHP] Error Handling!

2002-03-12 Thread Thomas Edison Jr.
I want errors reported on a page when the mail() function for any reason fails to send emails. FOr example, if there is a malformed email address or anything, and the mail is not sent, how can i catch the Error and Display it on the page? Thanks, T. Edison Jr. = Rahul S. Johari (Director)

[PHP] 5 Records per line

2002-03-11 Thread Thomas Edison Jr.
Hi, I would like to display 5 records per line on the Results page. Not seperated by a comma, but just seperated by Space. How can i do that? Thanks, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage :

Re: [PHP] 5 Records per line

2002-03-11 Thread Thomas Edison Jr.
line, there should be only 5 usernames, seperates by spaces. Like this : user1 user2 user3 user4 user5 user6 user7 user8 user9 user10 Can you help? Thanks, T. Edison jr. --- RIVES Sergio [EMAIL PROTECTED] wrote: may you give me more explanations ? thanx SR Thomas Edison Jr. a écrit : Hi

Re: [PHP] 5 Records per line

2002-03-11 Thread Thomas Edison Jr.
Hi, This is the code i'm using so far : ?php $db = mysql_connect(localhost,user,pass); mysql_select_db(mydb,$db); $result = mysql_query(SELECT * FROM sms ORDER BY ID DESC,$db); if ($myrow = mysql_fetch_array($result)) { do { echo(bfont color=#6ed8ff$myrow[num]/b br); } while ($myrow =

Re: [PHP] 5 Records per line

2002-03-11 Thread Thomas Edison Jr.
Hey THANKS! It worked.. just the way i wanted! Thank you so much. T. Edison Jr. --- RIVES Sergio [EMAIL PROTECTED] wrote: i don't know if it will work... i am quite a newbie in this stuff. Hope it could help you Thomas Edison Jr. a écrit : Hi, This is the code i'm using so

[PHP] Check @ in Record show Error in mail() !!

2002-03-11 Thread Thomas Edison Jr.
Hi, I'm using the following code to get Email Address stored in a table in my Database : ?php $db = mysql_connect(localhost,user,pass); mysql_select_db(mydb,$db); $result = mysql_query(SELECT * FROM sms where email!='' ORDER BY ID DESC,$db); if ($myrow = mysql_fetch_array($result)) { do {

Re: [PHP] phpMyAdmin

2002-03-11 Thread Thomas Edison Jr.
With the phpMyAdmin, you get a Config.inc file. You will have to change the parameters (username, password, database) etc., in order to access your phpMyAdmin. T. Edison Jr. --- Chuck \PUP\ Payne [EMAIL PROTECTED] wrote: I have a client that has install phpMyAdmin but can't get into he gets

[PHP] 5 Records in a row displayed!

2002-03-09 Thread Thomas Edison Jr.
Hi, I'm looking to display 5 records in one rows, from the database. What i mean is, basically, let's take the emails as an example. I have a table with 100s of email addresses. Now i want to display these email addresses on a page, but i want to display only 5 email adresses in one line, then

[PHP] Access Denied !!

2002-02-15 Thread Thomas Edison Jr.
Hi, I'm facing a rather tricky problem. The thing is, while connecting to the mySQL database using my php page, i get the acess denied error on only One Particular command, and on any other query, the same page, with the same login details works fine! For ex, this works fine : ?php $db =

RE: [PHP] Access Denied !! SOLVED!!

2002-02-15 Thread Thomas Edison Jr.
command directly into the MYSQL command line? -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 7:58 AM To: [EMAIL PROTECTED] Subject: [PHP] Access Denied !! Hi, I'm facing a rather tricky problem. The thing is, while

RE: [PHP] Re-Importing .CSV file into Database

2002-02-13 Thread Thomas Edison Jr.
Hi, Ok, considering the FULL PATH and the QUOTES thingy, this is the code i'm applying : ?php $db = mysql_connect(localhost,mydb,pwd); mysql_select_db(mydb,$db); $query = LOAD DATA INFILE 'D:\Apache Group\Apache\htdocs\mjimm\php3\tabledata\fanlist.csv' INTO fanlist_try FIELDS TERMINATED BY ','

Re: [PHP] Re-Importing .CSV file into Database

2002-02-13 Thread Thomas Edison Jr.
DL Neil, OK buddy, let me be more than frank with you.. i don't think i've been quite as confused and having the expression what the hell are you tryin 2 say on my lips in a while, as i had when i read your mail. Hmm.. i do hope u can help me though.. T. Edison jr. Further to David's

[PHP] Cheap, PHP, mySQL hosting!

2002-02-13 Thread Thomas Edison Jr.
Hi, Lookin for about 50 Megs with php4, mySQL and the works. Any economical hosts?? thanks.. t. edison jr __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- PHP General Mailing List

RE: [PHP] Re-Importing .CSV file into Database

2002-02-13 Thread Thomas Edison Jr.
Oh yes, definately. With the appropriate columns too. --- Rick Emery [EMAIL PROTECTED] wrote: Has fanlist_try table been created? -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 10:54 AM To: Jason Murray Cc: [EMAIL

RE: [PHP] Re-Importing .CSV file into Database

2002-02-13 Thread Thomas Edison Jr.
: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 11:09 AM To: Rick Emery Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Re-Importing .CSV file into Database Oh yes, definately. With the appropriate columns too. --- Rick Emery [EMAIL PROTECTED] wrote: Has

RE: [PHP] Re-Importing .CSV file into Database

2002-02-13 Thread Thomas Edison Jr.
and not: INTO table Darren Gamble Planner, Regional Services Shaw Cablesystems GP 630 - 3rd Avenue SW Calgary, Alberta, Canada T2P 4L4 (403) 781-4948 -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 9:54

Re: [PHP] Re-Importing .CSV file into Database

2002-02-13 Thread Thomas Edison Jr.
Val, quite frankly, i'm not quite sure i know what you're talking about. i don't think i know enum() function!! T. Edison jr. --- val petruchek [EMAIL PROTECTED] wrote: Hi Rick, Thanks for the support! This is the mySQL Table Structure : $sql = CREATE table fanlist_try (ID

Re: [PHP] Re-Importing .CSV file into Database

2002-02-13 Thread Thomas Edison Jr.
correctness Valentin Petruchek (aki Zliy Pes) *** Cut the beginning *** http://zliypes.com.ua mailto:[EMAIL PROTECTED] - Original Message - From: Thomas Edison Jr. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, February 13, 2002 7:36 PM Subject: Re

[PHP] Re-Importing .CSV file into Database

2002-02-12 Thread Thomas Edison Jr.
Glory! I have a bunch of .CSV (Microsoft Excel Comma Seperated Values) Files with me, whose data i want to put back into my mySQL database tables. How can i do that through php? or otherwise... thanks, T. Edison jr. = Rahul S. Johari (Director) **

RE: [PHP] Re-Importing .CSV file into Database

2002-02-12 Thread Thomas Edison Jr.
on the server and you have access to it, yes. If the file is on the client, then no -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 12:21 PM To: Rick Emery Subject: RE: [PHP] Re-Importing .CSV file into Database HI

RE: [PHP] Re-Importing .CSV file into Database

2002-02-12 Thread Thomas Edison Jr.
- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 12:21 PM To: Rick Emery Subject: RE: [PHP] Re-Importing .CSV file into Database HI, Thanks.. i will try this. But tell me, can this same be executed through a php page rather than the mySQL

[PHP] ReFilling mySQL Database with CSV file!!

2002-02-01 Thread Thomas Edison Jr.
I have to shift my site to a new location. I have enormous records in many tables in my database which will be needed 2 be shifted to. The 'phpMyAdmin' at my site allows me make dumps of the Data in the CSV format. I haven't done this before. These are the options it gives me : 1. Structure

Re: [PHP] Upload View Image : Database Thingy!!!!

2002-01-20 Thread Thomas Edison Jr.
Malte, Thanks a lot. I was going through the File Upload Functions in the manual and i think that's what they were talking about too. Now there's just one thing. I can run the upload scripts and get the image for display too. But like i mentioned, this is for a PenPal system, a database based

[PHP] Upload View Image

2002-01-19 Thread Thomas Edison Jr.
Hi, I have a penpal system running on a site. I want to add a feature wherein the person can upload his image and when somebody views the PenPal list, the uploaded image is shown next to his ad. Can we also control the Image Width Height? I mean when the Image is displayed, it should be in a

[PHP] Changing From Info in eMail!

2001-12-24 Thread Thomas Edison Jr.
Hi, I'm using the mail() function to send email. However, when the reciever recieves the email, my Servers name comes up in the From in his MailBox and also inside the email, even after defining the From: in the mail function. How do i change this From info?? This is what i'm using : mail($to,

RE: [PHP] Changing From Info in eMail! : SOLVED!!!

2001-12-24 Thread Thomas Edison Jr.
: $from); I had a similar problem because I didn't have everything in quotes. Ben -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Monday, December 24, 2001 10:36 AM To: [EMAIL PROTECTED] Subject: [PHP] Changing From Info in eMail! Hi, I'm

[PHP] Counting Views on records in DB!

2001-12-21 Thread Thomas Edison Jr.
Hi, I was just going through some Message Board system and noticed that there is a Views column which gives how many times the Message has been viewed. I created a similar message board, where Messages are stored in a MySQL DB Table. But i have no idea how to do this, that the number of times

Re: [PHP] Counting Views on records in DB!

2001-12-21 Thread Thomas Edison Jr.
Hi, UPDATE $table views=views+1 Umm.. can you be a little more specific. I couldn't make much sense, thought i could get the logic. Thanks. T. Edison jr. Hi, I was just going through some Message Board system and noticed that there is a Views column which gives how many times the

[PHP] PHP3 NOT being parsed for SSI!! HELP!!

2001-12-19 Thread Thomas Edison Jr.
Folks, I have a serious problem and i don't know what to do. We have a fixed template for each intranet page. Now the template consists of a header, a left navigation and a footer. The body would contain my pages content. What we are doing at present is that the header, the left navigation

[PHP] How to backup records in mySQL DB?

2001-12-19 Thread Thomas Edison Jr.
Hi, I'm having a touch situation on my hands. Last week one of my site was shut down in what the Hosting Company claimed to be a Policy Violation. However, it was found out later that it wasn't so and they had to re-host my site. Unfortunately, they erased my mySQL database with my account and

[PHP] How to backup records in mySQL DB?

2001-12-19 Thread Thomas Edison Jr.
Hi, I'm having a touch situation on my hands. Last week one of my site was shut down in what the Hosting Company claimed to be a Policy Violation. However, it was found out later that it wasn't so and they had to re-host my site. Unfortunately, they erased my mySQL database with my account and

[PHP] PHP script not paring in CGI!!!

2001-12-16 Thread Thomas Edison Jr.
Hi, I'm running a Solaris OS. I have written a CGO function to call common header footer for pages. All HTML pages are running well with it, however, a PHP3 page is not!! It's contents are not showing up. Nothing i showing up! What do i do? T. Edison jr. = Rahul S. Johari (Director)

[PHP] Help needed developing Logic!

2001-11-24 Thread Thomas Edison Jr.
Hi, I've made a PHP Chatroom and i need help developing the logic behind the Private Chat feature. I'll first explain briefly how my chat works. It's a very very simple Chat using just DB and nothing else. User enters.. his name,date goes into Chat. QueryString passes his name to main area

RE: [PHP] Resetting ID in mySQL DB

2001-11-19 Thread Thomas Edison Jr.
are entering into the DB. I don't know why really!! Thanks a bunch! Cheers Glory, Thomas Edison jr. --- Jack Dempsey [EMAIL PROTECTED] wrote: Thomas, The code i gave can't be copied directly in...you need to use it as a guide, but use your own variables... So, basically, whatever field you have

[PHP] Resetting ID in mySQL DB

2001-11-11 Thread Thomas Edison Jr.
the true Number of records after i delete the Empty/Blank Rows Duplicate Record Rows!! How can i do that! Please help! Cheers Glory, Thomas edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email

[PHP] Upgrading to Windows XP Whistler

2001-08-22 Thread Thomas Edison Jr.
be really good if someone can tell me what is gonna to happen. Also, i've been using Apache as the server, will i have to download a newer version of Apache for my windows XP? Thanks. Thomas Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc

Re: [PHP] HTTP Auth

2001-05-09 Thread Thomas Edison Jr.
Try using this : ?php $auth = false; // Assume user is not authenticated if (isset( $PHP_AUTH_USER ) isset($PHP_AUTH_PW)) { mysql_connect('localhost','root') or die ( 'Unable to connect to server.' ); mysql_select_db( 'myDB' ) or die ( 'Unable to select database.' );

[PHP] HTTP authentication : logout!!!

2001-05-07 Thread Thomas Edison Jr.
i'm using http authentication for my php pages (members area). Once you login correctly, than you can access anypage as the authentication box doesn't pop-up. Now i woul like to create a logout link after clicking on which, whenever you click on a page using auth, the auth box should pop-up

Re: [PHP] Sorry, what is PWS

2001-05-06 Thread Thomas Edison Jr.
PWS is Personal Web Server. It's a web server by Microsoft. Practically it's pretty easy to use. You can install it into any home PC using win98 and configure PHP on it to use. It supports ASP by default so you can do you ASP scripting using it. Latest version of PWS is 4.0! If u're looking for

[PHP] IIS instead of PWS!!! what else can i do..

2001-05-06 Thread Thomas Edison Jr.
i think i'm almost at the verge of giving up...somehow the PWS in my system is ruined forever...i'd done everything..and i mean *EVERYTHING*...but PHP just doesn't seem to be working with my PWS. In fact, even my ASP scripts are not working anymore on PWS. I've uninstalled reinstalled PWS twice

Re: [PHP] PHP on PWS not working!

2001-05-06 Thread Thomas Edison Jr.
1. Rename php.ini-dist to php.ini (if you haven't) 2. Simplify your script 3. Try changing your directory properties in PWS: Read/Execute/Scripts - try different combinations been there, done that, you could say. i think i've tried every possible humanly available option. my

Re: [PHP] PHP on PWS not working!

2001-05-06 Thread Thomas Edison Jr.
-dist to php.ini (if you haven't) 2. Simplify your script 3. Try changing your directory properties in PWS: Read/Execute/Scripts - try different combinations --- Thomas Edison Jr. [EMAIL PROTECTED] wrote: would you believe it, i did!! still not working. still giving the 500 Internal

Re: [PHP] IIS instead of PWS!!! what else can i do..

2001-05-06 Thread Thomas Edison Jr.
[EMAIL PROTECTED] wrote: You may want to try Xitami (www.imatix.com) as a fast/free/open source alternative to the Microsoft products. --zak - Original Message - From: Thomas Edison Jr. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 06, 2001 12:52 AM Subject: [PHP] IIS

Re: [PHP] IIS instead of PWS!!! what else can i do..

2001-05-06 Thread Thomas Edison Jr.
Why not install all three servers (IIS/Apache/Jrun) yeah, well i'm already doing that sir. only problem is, since few days my PWS is not working. Fortunately, just minutes ago i was able to fix it so that ASP is running perfectly on PWS now. Only PHP is not. So anyway, i guess i've dropped the

Re: [PHP] PHP on PWS not working!

2001-05-06 Thread Thomas Edison Jr.
right, i can change to the CGI version immideately, as it is i have the module ver installed on my Apache. Tell me something, to make it back to the CGI ver, the only thing i have to do is to give the path in my regedit as C:\php4\php.exe %s %s instead of what i was giving C:\php4\sapi\(the php

Re: [PHP] PHP on PWS not working! : WORKING NOW!!

2001-05-06 Thread Thomas Edison Jr.
thankx a lot sir, i guess your guessing worked real well...after 5 days of headbanging and trying everything, it workedi did what u said...removed all references to the isapi dll and converted the php module to php cgi and it's working on PWS. i guess i'm gonan use my apache server for the

Re: [PHP] IIS instead of PWS!!! what else can i do..

2001-05-06 Thread Thomas Edison Jr.
Already Did sir! and am as happy as u would've been. finally i can test http authentication 2. Cheers, T. Edison jr. We're out of our medicines and out of our minds... --- MaD dUCK [EMAIL PROTECTED] wrote: also sprach Thomas Edison Jr. (on Sat, 05 May 2001 11:52:34PM -0700): i think i'm

Re: [PHP] PHP on PWS not working!

2001-05-05 Thread Thomas Edison Jr.
nothing does seem to work...i don't know what the hell is the problem!! i did put this : C:\\php\\sapi\\php4isapi.dll in the regedit file and it looks great. everything is just so by the book. where the hell am i going wrong!! can't understand what's different here that was not before coz it

Re: [PHP] PHP on PWS not working!

2001-05-05 Thread Thomas Edison Jr.
directory? I think I had to do that even though it wasn't in the directions Data Driven Design P.O. Box 1084 Holly Hill, Florida 32125-1084 http://www.datadrivendesign.com http://www.rossidesigns.net - Original Message - From: Thomas Edison Jr. [EMAIL PROTECTED] To: Data Driven

[PHP] HELP!! PHP not working Suddenly!!!

2001-05-04 Thread Thomas Edison Jr.
gosh, i just downloaded the new PHP file from www.php.net, the file i downloaded is : *** PHP 4.0.5 [4,590Kb] - 30 April 2001 (CGI binary plus server API versions for Apache, AOLserver, ISAPI and NSAPI. MySQL support built-in, many extensions included, packaged as zip) *** i'm using win98 PWS

  1   2   >