[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 bits)

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

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 Dat

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 t

[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 upd

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 updat

Re: [PHP-DB] & update

2002-03-24 Thread David Christensen
Use single quotes around the string! Chris Payne wrote: > 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 an

Re: [PHP-DB] Speed Up Code?

2002-03-24 Thread David Christensen
The first thing I see, do you need all of the fields in your "SELECT *" statement? Jeff Oien wrote: > 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 > upl

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

2002-03-24 Thread Adam Royle
In your UPDATE query, should you have a WHERE clause? eg. UPDATE my_items SET name = '$update' WHERE ID = $ID OR do this $update = $name; instead of $update = "$name"; Try running the query on the command line (on *nix) or through phpmyAdmin or something to see if the query is actually wo

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 wise--lik