[PHP-DB] Microsoft Access PHP

2002-07-04 Thread Daniel J Owen-Mcgee
Hi, I'm gleaning microsoft SQL from queries within a MS Access database, for insertion into my PHP pages. This has been working fine but the example below just refuses to work, SELECT ExamPapers.EPaperID, ExamPapers.EPapersText, ExamPapers.[Title of Paper], ExamPapers.Course,

[PHP-DB] Re: MySQL query from multiple tables

2002-07-04 Thread Matthew Crouch
it sounds like you may be serializing your SQL, in which case the following link might help. http://www.ashleyit.com/rs/jsrs/select/php/select.php Matthew Nock wrote: Hi All, I have a strange query which I need to build - I have looked at the JOIN and aliasing functions of mySQL but not

Re: [PHP-DB] Microsoft Access PHP

2002-07-04 Thread George Pitcher
Just a thought. Try putting quotes around the 'True'. George (no expert - not even a novice - yet) - Original Message - From: Daniel J Owen-Mcgee [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 04, 2002 2:29 PM Subject: [PHP-DB] Microsoft Access PHP Hi, I'm gleaning

[PHP-DB] Re:dBASE connectivity

2002-07-04 Thread Miles Thompson
Labrhas, If you echo $new_record, and $newrecord[name], what displays? I'm really trying to confirm that $new_record is an array, and that $new_record[name] contains what you expect. Is it possible that you have to assign like this: $new_record['name'] = 'xx'; which would put

[PHP-DB] PHP dBASE connectivity

2002-07-04 Thread labhras sammin
Hi I need to use PHP (ver 4 windows) to add a record to a dBase iv database. I can create, open, read and close a database but when I try to add a record I always get the following error: Warning: unexpected error in C:\php\phpstuff\addTest1.php on line 23 Here is the code [shortened] that I

Re: [PHP-DB] PHP dBASE connectivity

2002-07-04 Thread Miles Thompson
1. Please don't cross post. 2. Which line is #23? 3. Have you tested to ensure that you have a valid handle? ($db_num) 4. Have you tried adding error code to see the result of dbase_create(), dbase_open() 5. I seem to remember reading in the docs, a long time ago (2 yr) that the dbase functions

Re: [PHP-DB] PHP dBASE connectivity

2002-07-04 Thread labhras sammin
thanks for your help I have tested that everything works, valid handles, returned method values, etc. Line 23 is the dbase_add_record line. Do you know of anywhere there may be an example thanks Labhras Miles Thompson [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL

[PHP-DB] resizing images comming out of blobs

2002-07-04 Thread andy
Hi there, I am wondering how to resize an image which is stored in a mysql blob field. With files this workes just fine, but how to do this with the image comming from blob? Has anybody done this already? Thank you for any help on that, andy -- PHP Database Mailing List