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

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

Re: [PHP-DB] question on select

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

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

[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 a href='mailto:[EMAIL PROTECTED]' in your field. The other is to just store the field, but concat the string together when you echo/print it. i.e.,: print a href='mailto:$recordset[email]'; Phpdiscuss - Php Newsgroups And Mailing Lists

[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

[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

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

2004-05-03 Thread Michael Forbes
- 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 is change it to this: $query