[PHP] Query to select every other record

2002-11-17 Thread Darren McPhee
Does anybody know of a SELECT QUERY that will select every other record of a table ? I want to do this so that I can display my products in 2 columns (I will also be using arrays of course). The first column would show the result of the first query starting at record 1. The second column would

[PHP] MYSQL and PHP Storing and retrieving images getting corrupted

2002-11-05 Thread Darren McPhee
I have written 2 programs (which are very common PHP programs) that A) Allows me to upload image files into a MYSQL database using a simple form. And B) Allows me to retrieve and display the image using a PHP script. This is my problem:- I can upload the images ok. I store the binary code,

[PHP] Images retrieved from MYSQL database using PHP becoming corrupted.

2002-11-03 Thread Darren McPhee
I have spent the last 3 days trying to figure this out. And will probably give up very soon. I have written 2 programs (which are very common PHP programs) that A) Allows me to upload image files into a MYSQL database using a simple form. And B) Allows me to retrieve and display the image using