Re: [PHP-DB] Manipulating Blob Fields

2008-02-14 Thread julian
Hi Alan, Sorry not writing to help you out. I am trying to do something like you, but with pdf files. I am no expert on mysql but I just can't manage to store a pdf file in a blob field. Any hints or experiences to share ?? I use a sequence of prepared statements, no rocket science precisel

Re: [PHP-DB] Manipulating Blob Fields

2008-02-14 Thread julian
After some research I found a workaround, not a solution. Diggin in www.php.net I found the following (potential) bug apparently resolved time ago http://bugs.php.net/bug.php?id=35155 in relation to Bug #35155 prepared statement with blob field does not work Which is exactly what it is

Re: [PHP-DB] Manipulating Blob Fields

2008-02-14 Thread OKi98
Original Message Subject: Re: [PHP-DB] Manipulating Blob Fields From: julian <[EMAIL PROTECTED]> To: [email protected] Date: 14.2.2008 11:24 After some research I found a workaround, not a solution. Diggin in www.php.net I found the following (potential) bug apparently res

[PHP-DB] Trying to paginate a code but having trouble.

2008-02-14 Thread Chris Carter
Hi, I am trying to paginate this to display just 4 results and use options for pagination. Please help. '.$a.' '.$b.' Name: '.$c.' Price: '.$d.' '; $i++; } ?> Thanks in advance, Chris --

Re: [PHP-DB] Trying to paginate a code but having trouble.

2008-02-14 Thread Chris
Chris Carter wrote: Hi, I am trying to paginate this to display just 4 results and use options for pagination. Please help. You need to use LIMIT offset, number. eg: limit 50, 10 <- start at position 50, get 10 records. http://dev.mysql.com/doc/refman/5.0/en/select.html To make this wor