Re: [PHP-DB] question on

2004-05-13 Thread Michael Forbes
Interesting idea. Since I'm convinced that javascript is the bastard offspring of Bill Gates, Larry Ellison, and Baalzebub, can I sue too? :) Hengameh wrote: Well I am suing Java script to capture the selected item and make it the value of my input box. But my problem is how to access this info

Re: [PHP-DB] Linux/PHP/Access Database - oh boy :(

2004-05-13 Thread Michael Forbes
I'm glad you found a solution to your problem-- how big a stick did it require? I actually learned a LOT just reading that thread (although I'm an Access guru who came to PHP/MySQL by way of conversion to zealotry, I've never used PHP against an Access back-end). Many thanks to those who cont

Re: [PHP-DB] Linux/PHP/Access Database - oh boy :(

2004-05-13 Thread Michael Forbes
I'm glad you found a solution to your problem-- how big a stick did it require? I actually learned a LOT just reading that thread (although I'm an Access guru who came to PHP/MySQL by way of conversion to zealotry, I've never used PHP against an Access back-end). Many thanks to those who cont

[PHP-DB] Re: upload files into MySQL database

2004-05-11 Thread Michael Forbes
I've not run into this problem before, but the solution seems obvious: replace your filename spaces with underscores, or get rid of them completely. -Mike Forbes Phpdiscuss - Php Newsgroups And Mailing Lists wrote: Hello, I have problem for downloading files from MySQL database. Although I st

Re: [PHP-DB] Edit with notepad

2004-05-11 Thread Michael Forbes
Why not just provide them with two different links to the document-- one version includes the tag, the other doesn't. -Mike Forbes Ng Hwee Hwee wrote: hi, header("Content-type: application/vnd-ms.word"); is not what my customers want. They may or may not want to save it in their harddisk.. but

[PHP-DB] Re: Dynamic Email Address in an HTML table

2004-05-09 Thread Michael Forbes
Two alternatives: One is to store the entire string "" in your field. The other is to just store the field, but concat the string together when you echo/print it. i.e.,: print ""; Phpdiscuss - Php Newsgroups And Mailing Lists wrote: Hello, I have a page displaying the results of a query fr

[PHP-DB] Re: SQL question!

2004-05-03 Thread Michael Forbes
What you wrote will give you the list of users who also happen to have comments. What you really want is more like this: SELECT Users.ID, Users.UserName, Comments.Description FROM Users LEFT JOIN Comments ON Users.ID = Comments.UserID; (note that you'll need to have the UserID foreign key in you

Re: [PHP-DB] - Delete records in an Access DB

2004-05-03 Thread Michael Forbes
. -Original Message----- From: Michael Forbes [mailto:[EMAIL PROTECTED] Sent: Monday, May 03, 2004 07:00 To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] - Delete records in an Access DB Nope. Access' version of SQL is a slight bit different from ANSI SQL. All he needs to do in his statement i

[PHP-DB] Re: The usual problem

2004-05-03 Thread Michael Forbes
If your ID is an autoincremented field, try not including it in your insert statement. I.E.: $sql = "INSERT INTO underskrifter (type, navn, epost, tid, ip, domain, sted) " . " VALUES ('$_POST[type]', '$_POST[navn]', '$_POST[epost]', '$tid', '$ip', '$host', '$_POST[sted]' );" -Mike Forbes Ma

Re: [PHP-DB] - Delete records in an Access DB

2004-05-03 Thread Michael Forbes
Nope. Access' version of SQL is a slight bit different from ANSI SQL. All he needs to do in his statement is change it to this: $query="DELETE * FROM Test_Table WHERE name='franco';"; (notice the wildcard in there-- Access isn't smart enough to realize that the deletion of any information in