Hi Guys,
The following information is added to make my question clearer
The table schema is:
+---------------+--------------+------+-----+---------+----------------
+
| Field | Type | Null | Key | Default | Extra
|
+---------------+--------------+------+-----+---------+----------------
+
| requestID | int(15) | NO | PRI | NULL | auto_increment
|
| requestNum | varchar(255) | YES | | NULL |
|
| itemRequested | varchar(255) | YES | | NULL |
|
| quantity | int(15) | YES | | NULL |
|
| userEmail | varchar(255) | YES | | NULL |
|
| date | datetime | YES | | NULL |
|
| location | varchar(255) | YES | | NULL |
|
+---------------+--------------+------+-----+---------+----------------
+
And the table viewed may look like this:
+-----------+-------------+---------------+----------
+----------------------------+---------------------+--------------+
| requestID | requestNum | itemRequested | quantity |
userEmail | date | location |
+-----------+-------------+---------------+----------
+----------------------------+---------------------+--------------+
| 1 | 47569BZ | 03LH260 | 1 |
jo*@bloggs.co.uk | 0000-00-00 00:00:00 | Unknown |
| 2 | 47569BZ | 03LH459 | 1 |
jo*@bloggs.co.uk | 0000-00-00 00:00:00 | Unknown |
| 3 | 83284AD | 03LH260 | 1 |
jo*@bloggs.co.uk | 0000-00-00 00:00:00 | Unknown |
| 4 | 83284AD | 03LH459 | 1 |
jo*@bloggs.co.uk | 0000-00-00 00:00:00 | Unknown |
| 5 | 85669FJ | 03LH260 | 3 |
jo*@bloggs.co.uk | 2008-11-14 09:54:08 | Unknown |
| 6 | 85669FJ | 03LH459 | 7 |
jo*@bloggs.co.uk | 2008-11-14 09:54:08 | Unknown |
| 7 | 02429ZH | 03LH260 | 3 |
jo*@bloggs.co.uk | 2008-11-14 10:28:55 | Unknown |
| 8 | 02429ZH | 03LH459 | 7 |
jo*@bloggs.co.uk | 2008-11-14 10:28:55 | Unknown |
+-----------+-------------+---------------+----------
+----------------------------+---------------------+--------------+
Thanks