[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.
.com/desdev/mx/flash/articles/flashmx_php.html > > HTH > -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 e

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

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

Re: [PHP] Submitting form in new window!

2002-07-29 Thread Thomas Edison Jr.
essForm.php?textfield=" + > textfield; > > window.open(url); > } > > > OR > > just add this to your form tag. > TARGET="_blank" > > > "Thomas Edison Jr." <[EMAIL PROTECTED]> wrote > in message > [EMAIL P

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

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. Edi

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

[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.
fetch_assoc($result)) { > $code = generateRandomString(8); > mysql_query("INSERT INTO authentication (id, pass) > VALUES > ($myrow[clientid], '".$code."'"); > }; > > Hope this helped you ! > > Greetz, > Wouter > &g

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

2002-07-23 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 ge

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?

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

2002-07-17 Thread Thomas Edison Jr.
> I use Windows 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]

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

Re: [PHP] Connecting LocalHost & Remote mySQL DB

2002-07-12 Thread Thomas Edison Jr.
bsite 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 Dat

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

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 : 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, contain values coming in from $myrow[stu

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

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

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']"; > $realcontent .= "$myrow['nm']"; > $realcontent .= "$myrow['q']"; > } > Thanks, T. Edi

Re: [PHP] Submitting form in new window!

2002-07-09 Thread Thomas Edison Jr.
Hi, Ok, let me show some code : Quantity This is the SUBMIT button that submits the form alongwith the Form Variables to a file called "Add2Cart.php" !! But this file simply opens in an unadministered new window. i would like to use the window.open function, or whatever ca

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 m

[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

[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. = R

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

[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 httpd.conf

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 E

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

Re: [PHP] Uploaded File OverWriting Old File

2002-05-11 Thread Thomas Edison Jr.
Glory! 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 &quo

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");

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 >

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 im

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.. "256000") and ($img1_type != "image/pjpeg") or ($img1_type != "image/jpeg"))

Re: [PHP] Uploaded File OverWriting Old File

2002-05-11 Thread Thomas Edison Jr.
_name = $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 "

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 : Thank y

[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 : Thank you for adding you details. The following has been added to the Dat

[PHP] File Type not working in Uploaded File

2002-05-10 Thread Thomas Edison Jr.
Hi, This is my upload form : Please upload your file below: Upload And this is part of my PHP coding, that handles the Upload. Basically the problem is, that my code is not recognising the File Type! I have specified "image/jpeg" as the file type, but even then it does not upload A

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

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

[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

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

2002-04-08 Thread Thomas Edison Jr.
en > 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 the name of my Images stored in my mySQL > > database in one

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

2002-04-08 Thread Thomas Edison Jr.
g$', '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 v

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

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 PROTECT

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

Re: [PHP] MS Access data => mySQL database

2002-03-26 Thread Thomas Edison Jr.
e answer for you if you want to do it > completly with php, but it gets you > to the basic area, and transfers the data.. > > there is at www.hotscripts.com a php access>mysql > converter, i tried it last > year, but found it very buggy. cannot remember what > it was cal

[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 : 9

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

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

[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 : $myrow[email] "); } while ($myrow = mysql_fetch_array($result)); } else { echo "Sorry, no records matching your criteria were found!"; } ?> But there are some records where the user has enter

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

Re: [PHP] 5 Records per line

2002-03-11 Thread Thomas Edison Jr.
Hi, This is the code i'm using so far : $myrow[num] "); } while ($myrow = mysql_fetch_array($result)); } else { echo "Sorry, no records matching your criteria were found!"; } ?> But this displays all records one per line... T. Edison Jr. = Rahul S. Johari (Director) *

Re: [PHP] 5 Records per line

2002-03-11 Thread Thomas Edison Jr.
n one 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 > > &

[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 : http://www.abraxa

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

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

2002-02-15 Thread Thomas Edison Jr.
oad Data! Thank! T. Edison Jr. --- Rick Emery <[EMAIL PROTECTED]> wrote: > Thomas, > What happens when you enter the LOAD DATA INFILE > command directly into the > MYSQL command line? > > -Original Message- > From: Thomas Edison Jr. > [mailto:[EMAIL PROTECTED

[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 : But this giv

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

2002-02-13 Thread Thomas Edison Jr.
- 'male' > and 'female' > > the main reason to use it (instead of MySQL) is > speed. The next one could be > data correctness > > Valentin Petruchek (aki Zliy Pes) > *** Cut the beginning *** > http://zliypes.com.ua > mailto:[EMAIL PROTECTED] >

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_tr

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

2002-02-13 Thread Thomas Edison Jr.
x is: > > INTO TABLE > > and not: > > INTO > > > Darren Gamble > Planner, Regional Services > Shaw Cablesystems GP > 630 - 3rd Avenue SW > Calgary, Alberta, Canada > T2P 4L4 > (403) 781-4948 > > > -Origi

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

2002-02-13 Thread Thomas Edison Jr.
file i'm using... Thanks, T. Edison jr. --- Rick Emery <[EMAIL PROTECTED]> wrote: > Thomas, > > Can you provide your table structure and about a > dozen lines from your file? > > I'd like to experiment with it on my machine. > > We WILL get th

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

[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 (http://www.php.

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 comm

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 : And this is the error i'm getting : error:You have an error in your SQL syntax near 'fanlist_try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED' at line 1 So... what's the problem??

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

2002-02-12 Thread Thomas Edison Jr.
ERMINATED BY '\n' "; > > mysql_query($query) or die("error:". mysql_error()); > > -Original Message- > From: Thomas Edison Jr. > [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 12, 2002 1:11 PM > To: [EMAIL PROTECTED] > Subject: RE: [PH

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

2002-02-12 Thread Thomas Edison Jr.
; The file is located 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

[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) ** A

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

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 Pe

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

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

2001-12-24 Thread Thomas Edison Jr.
quot;, "From: $from"); > > instead of : > > mail($to, $subject, $message, "From: $from"); > > I had a similar problem because I didn't have > everything in quotes. > > Ben > > -Original Message- > From: Thomas Edison Jr. > [mailt

[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($

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

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

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

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

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

RE: [PHP] Resetting ID in mySQL DB

2001-11-19 Thread Thomas Edison Jr.
7;s defeating that and empty records 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 gu

[PHP] Resetting ID in mySQL DB

2001-11-11 Thread Thomas Edison Jr.
the entire IDs to reflect 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.

[PHP] Upgrading to Windows XP "Whistler"

2001-08-22 Thread Thomas Edison Jr.
7;m muchly new at this thing so it'd 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) **

Re: [PHP] HTTP Auth

2001-05-09 Thread Thomas Edison Jr.
Try using this : works excellent on any browser, apache server with PHP module. T. Edison jr. --- gary <[EMAIL PROTECTED]> wrote: > Im having a problem with Authentication uisng > $PHP_AUTH_USER and > $PHP_AUTH_PASSWORD works fine connecting via > netscape but automatically > set to false w

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

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 20

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 M

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

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

2001-05-05 Thread Thomas Edison Jr.
s, T. Edison jr. --- Zak Greant <[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." <

Re: [PHP] PHP on PWS not working!

2001-05-05 Thread Thomas Edison Jr.
ome ideas: > 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 > > > --- "Thomas Edison Jr." <[EMAIL PROTECTED]> > wrote: > &

Re: [PHP] PHP on PWS not working!

2001-05-05 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 \inetpub\www

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

2001-05-05 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] Sorry, what is "PWS"

2001-05-05 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

Re: [PHP] PHP on PWS not working!

2001-05-05 Thread Thomas Edison Jr.
4ts.dll to your windows/system > 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

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 w

Re: [PHP] PHP on PWS not working!

2001-05-04 Thread Thomas Edison Jr.
gn.com > http://www.rossidesigns.net > - Original Message - > From: Thomas Edison Jr. <[EMAIL PROTECTED]> > To: Data Driven Design <[EMAIL PROTECTED]> > Sent: Friday, May 04, 2001 2:33 PM > Subject: Re: [PHP] PHP on PWS not working! > > > > Did bot

  1   2   >