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

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 with

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

2003-03-18 Thread Beverly Steiner
er? I have posted to the PHP-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 ha

RE: [PHP-DB] storing files in database

2003-03-18 Thread Beverly Steiner
t 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-DB] problem connecting w/ODBC

2003-03-14 Thread Beverly Steiner
ram files\apache group\apache\htdocs\test4.php on line 17 Couldn't execute query Anyone 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] Database design

2003-03-10 Thread Beverly Steiner
ate 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 PROT

RE: [PHP-DB] ODBC

2003-03-07 Thread Beverly Steiner
ing"; $result = odbc_exec($connection, $sql) || die("cannot prepare 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] ODB

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

2003-03-07 Thread Beverly Steiner
s not case 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 PROTEC

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

2003-03-07 Thread Beverly Steiner
mail($mailto, $mail_subject, $msg, $from, $replyto); } else { echo "Error - There was a problem uploading your file."; $continue = "no"; } } // *** end of if (is_file("$root_dir/$folder/$filename"

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

2003-03-06 Thread Beverly Steiner
BY Expert.Name"; ---------- 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 statemen

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

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] How to access a MS Access DB

2003-03-03 Thread Beverly Steiner
pen database"); $sql = "SELECT MeeetingTitle, 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