RE: [PHP-DB] How to access a MS Access DB

2003-03-03 Thread Beverly Steiner
, MeetingDate FROM meeting;; $sql_result = odbc_prepare($connection, $sql) || die(cannot prepare result); Any help would be greatly appreciated, Beverly Steiner [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Confusing Date...

2003-03-03 Thread Beverly Steiner
Doug, I know it works if you send the date as -mm-dd. For example yesterday, March 2, 2003 would be 2003-03-02 -- Beverly Steiner [EMAIL PROTECTED] -Original Message- From: Doug Coning [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 5:29 PM To: [EMAIL

RE: [PHP-DB] Confusing Date...

2003-03-03 Thread Beverly Steiner
Doug, Here's an example of how to format the date: $date = 3/2/2003; $good_date= date(Y-m-d, strtotime($date)); -- Beverly Steiner [EMAIL PROTECTED] -Original Message- From: Doug Coning [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 5:38 PM To: [EMAIL

RE: [PHP-DB] Update MD5 field

2003-03-04 Thread Beverly Steiner
Daniela, Why do you want to keep a calculated field inside your database? -- Beverly Steiner [EMAIL PROTECTED] -Original Message- From: Dani Matielo [mailto:[EMAIL PROTECTED] Sent: Monday, March 03, 2003 10:18 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Update MD5

RE: [PHP-DB] mysql statement: two tables, two comparisons

2003-03-06 Thread Beverly Steiner
; -- Beverly Steiner [EMAIL PROTECTED] -Original Message- From: Jason End [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 8:52 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] mysql statement: two tables, two comparisons I'm looking for a mysql select statement that does the following

RE: [PHP-DB] I need some help with php code please

2003-03-07 Thread Beverly Steiner
) { echo trtd class='headblack'The file type is not correct. We only accept MP3 files./td/tr; } -- Beverly Steiner [EMAIL PROTECTED] -Original Message- From: Stephen K Knight [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2003 12:50 AM To: [EMAIL PROTECTED

RE: [PHP-DB] Searchform to results.php

2003-03-07 Thread Beverly Steiner
sensitive. In order to do the select you need to quote the table name: SELECT * FROM 'Member'. Case doesn't matter on Windows. Bev -- Beverly Steiner [EMAIL PROTECTED] -Original Message- From: Jonathan Villa [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2003 1:38 PM

RE: [PHP-DB] ODBC

2003-03-07 Thread Beverly Steiner
result); -- Beverly Steiner [EMAIL PROTECTED] -Original Message- From: Kiswa [mailto:[EMAIL PROTECTED] Sent: Friday, March 07, 2003 3:24 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] ODBC Hi. Is their anyway to connect to a Access Db using only the filesystem like

RE: [PHP-DB] Database design

2003-03-10 Thread Beverly Steiner
a joining table between the User (or whatever table contains the client info.) table and the Clinical_Data table. -- Beverly Steiner [EMAIL PROTECTED] -Original Message- From: shaun [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 8:53 AM To: [EMAIL PROTECTED

[PHP-DB] problem connecting w/ODBC

2003-03-14 Thread Beverly Steiner
have any ideas of what I should do so I can access a database through ODBC? -- Beverly Steiner [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] storing files in database

2003-03-18 Thread Beverly Steiner
the best solution. Bev -- Beverly Steiner [EMAIL PROTECTED] -Original Message- From: Michiel van Heusden [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 8:25 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] storing files in database is there any possibility using PHP 4

FW: [PHP-DB] problem connecting w/ODBC

2003-03-18 Thread Beverly Steiner
-INST and PHP-DB lists. -- Beverly Steiner [EMAIL PROTECTED] -Original Message- From: Beverly Steiner [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 7:13 PM To: PHPDB Subject: [PHP-DB] problem connecting w/ODBC Hello, I am having problems accessing

RE: [PHP-DB] Not seeing whats wrong with code

2003-03-20 Thread Beverly Steiner
Mike, Try mysql_fetch_array instead of mysql_fetch_row -- Beverly Steiner [EMAIL PROTECTED] -Original Message- From: Mike Delorme [mailto:[EMAIL PROTECTED] Sent: Thursday, March 20, 2003 12:01 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Not seeing whats wrong

RE: [PHP-DB] problem connecting w/ODBC

2003-03-21 Thread Beverly Steiner
Problem fixed! Thank you to David who pointed out that I had my variables switched in the in the odbc_exec and odbc_cursor lines. For ODBC, the connection variable comes first (the opposite of MySQL). Bev -- Beverly Steiner [EMAIL PROTECTED] -Original Message