[PHP-DB] storing PDF in a database

2002-03-24 Thread Alain DESEINE
Hello, For many different reasons, like security ans soĆ¹me other one, i need to store PDF files in a database. - Does anybody have already do this ? - What kind of field type should i use (image filed type ???) ? I'm currently using an ASE 12 (64 bits) SYBASE server on a HP-UX 11.00 (64

Re: [PHP-DB] Re: Again Select then update

2002-03-24 Thread Bill Morrow
On Sat, Mar 23, 2002 at 11:46:36PM -0800, Jen Downey wrote: Hi all again! As Bill Morrow stated (in a private e-mail) I needed to use SET name = \$update\; instead of SET name = $update; It has stopped giving the error but it isn't updating the table. Am I doing something wrong? line 4

Re: [PHP-DB] storing PDF in a database

2002-03-24 Thread Jason Cox
You'd want to use a BLOB field to store it. It would be stored as raw data in the db. For an example, go find a tutorial on how to store images in the database. It would work the same way. Jason Cox - Original Message - From: Alain DESEINE [EMAIL PROTECTED] To: [EMAIL PROTECTED]

[PHP-DB] Getting date range from mySQL

2002-03-24 Thread Alvin Ang
Hi ppl, I want to retrieve data from a transaction table using the date range, i stored date in mmdd format, but when in Jan~Sep the date stored is mdd only, now i want to search the database from a certain date range. Can anyone advise me how to do it? Thanks! Alvin Ang -- PHP

Re: [PHP-DB] Re: Again Select then update

2002-03-24 Thread Jen Downey
Hi Bill, No it isn't the latest it is updated with the quotes and slashes in the script. I have found that even if I put my name Jen as $update it still wont update the table. $update = Jen There is no error and the script acts like it work fine without updating. I just did a test.php script

[PHP-DB] Speed Up Code?

2002-03-24 Thread Jeff Oien
Here is some code I have for an index page of people who post charts on the Web, kind of like Yahoo Photos or something. It displays the album title, number of images and date of last upload. The page takes about 5-6 seconds to load which is all in the queries I'm sure. Is there a way I can make

[PHP-DB] update

2002-03-24 Thread Chris Payne
Hi there, I have a system for updating whereby you select the country/continent from a db then edit the record and update it and it works perfectly - that is until there is a in the update $country set - so if it says Africa it updates fine, but if $country = Asia The Orient it doesn't

Re: [PHP-DB] update

2002-03-24 Thread Chris Payne
Looking at the below, I think it might be spaces in the query - how can I rectify this? Thanks :-) Chris Hi there, I have a system for updating whereby you select the country/continent from a db then edit the record and update it and it works perfectly - that is until there is a in the

Re: [PHP-DB] storing PDF in a database

2002-03-24 Thread Kevin Won
I have the same need for all sorts of doc types w/ m$ sql server. The wrox 'professional sql server programming' talks about this issue of storing file type data in a table row briefly, leaving me disheartned. basically, the summation of the issue is it's a really bad idea performance