Re: [PHP-DB] escape characters

2004-03-21 Thread Filip de Waard
On Mar 22, 2004, at 5:30 AM, matthew perry wrote: I am trying to allow my users to enter quotes in their strings. For instance instead of writing:2 inch rod, they can write 2 " rod. The problem is, of course, that " ends the string and all that is saved is any value before the ". How do

[PHP-DB] escape characters

2004-03-21 Thread matthew perry
I am trying to allow my users to enter quotes in their strings. For instance instead of writing:2 inch rod, they can write 2 " rod. The problem is, of course, that " ends the string and all that is saved is any value before the ". How do I get around this without using textarea? -- PHP D

Re: [PHP-DB] Store a File (any type) in MySQL

2004-03-21 Thread Bruno Santos
Daniel Crespo wrote: Hi everybody... Anyone knows how to store a file (any type) in MySQL? Thanks hello MySql has binary field types, but, are they long (in size) enough for your file ? if the file is small, i guess you could store the data in the mysql field, but, and if files are user c

[PHP-DB] Store a File (any type) in MySQL

2004-03-21 Thread Daniel Crespo
Hi everybody... Anyone knows how to store a file (any type) in MySQL? Thanks -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Insert an image in a Mysql table

2004-03-21 Thread Filip de Waard
On Mar 21, 2004, at 9:19 PM, Stuart Gilbert wrote: Filip de Waard wrote: On Mar 21, 2004, at 8:44 AM, Stuart Gilbert wrote: Filip de Waard wrote: On Mar 20, 2004, at 3:11 PM, charalambos nicolaou wrote: Hi, I have created a MySQL table with a blob field and I don’t know how to insert an

Re: [PHP-DB] An if-statement in a "while(list("

2004-03-21 Thread Bruno Ferreira
Henning Olsen wrote: I have a search on my page, which presents all the adresses one after all. I would like to present a graphic icon representing the mailaddress, but only when ther IS a mailaddress. Not everyone has a mail address. But I cant put an if-statement in the "while(list(..." Any sugg

Re: [PHP-DB] Insert an image in a Mysql table

2004-03-21 Thread Filip de Waard
On Mar 21, 2004, at 8:44 AM, Stuart Gilbert wrote: Filip de Waard wrote: On Mar 20, 2004, at 3:11 PM, charalambos nicolaou wrote: Hi, I have created a MySQL table with a blob field and I don’t know how to insert an image to it. Help me please because I am going crazy. Use your filesystem in

[PHP-DB] An if-statement in a "while(list("

2004-03-21 Thread Henning Olsen
Hello I have a search on my page, which presents all the adresses one after all. I would like to present a graphic icon representing the mailaddress, but only when ther IS a mailaddress. Not everyone has a mail address. But I cant put an if-statement in the "while(list(..." Any suggestione to me o

[PHP-DB] Re: Date Manipulation

2004-03-21 Thread Jimmy Brock
$days = 35; $day = $day + $days; //calculate the new date $calcDate = date($output, mktime (0,0,0,$month,$day,$year)); No need for a 2nd query...jus' insert the variable $calcDate into a column in your table Hope this helps, Jimmy Brock "Shannon Doyle" <[EMAIL PROTECTED]> wrote in message news

Re: [PHP-DB] Date Manipulation

2004-03-21 Thread John W. Holmes
) VALUES (20040321, 20040321 + INTERVAL 35 DAY) -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Date Manipulation

2004-03-21 Thread Shannon Doyle
Hi People, Need some assistance in the following scenario:- Inserting a date into the database that is entered into a form by the site visitor. - This is easy enough. However I now need to use the same date that has been entered by the site visitor add 35 days and then insert into another table.

Re: [PHP-DB] Problem, please help!

2004-03-21 Thread John
> try writing it like > $sql = "UPDATE round1 > SET game1='" . $game1 . "', > game2='" . $game2 . "', > game3='" . $game3 . "', > game4='" . $game4 . "', > game5='" . $game2 . "', > game6='" . $game6 . "', > game7='" .

Re: [PHP-DB] Insert an image in a Mysql table

2004-03-21 Thread John
> > I have created a MySQL table with a blob field and I don’t know how > > to insert an image to it. Help me please because I am going crazy. > I store in the blob not an image but the string: img[]=path/file.jpg&description=&var[]= etc and so on for any number of images and corresponding de