What about reading the row to get the columns, then resetting back to the first row with mysql_data_seek() so you can re-read the whole set? Rob. -----Original Message----- From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of Daniel Israel Sent: 30 December 2007 18:33 To: php-objects@xxxxxxxxxxxxxxx Subject: PHP/MySQL question Hi all, Happy New Year. I'm working on an application and had a couple of related PHP/MySQL questions. 1. When I do a MySQL query, is there a way to get the returned columns in the query without fetching a row? Currently, what I'm doing is fetching a row of data and getting the keys from the array. I'd like to do it without fetching the row. Is this possible? 2. If #1 above is indeed possible, is this only possible when I get returned rows or can I do it when there are no matching rows in the query? Thanks for any help! -D. Israel dan@xxxxxxxx http://www.customcodebydan.com AIM: JudoDanIzz *********************************************************************************** Any opinions expressed in email are those of the individual and not necessarily those of the company. This email and any files transmitted with it are confidential and solely for the use of the intended recipient or entity to whom they are addressed. It may contain material protected by attorney-client privilege. If you are not the intended recipient, or a person responsible for delivering to the intended recipient, be advised that you have received this email in error and that any use is strictly prohibited. Random House Group + 44 (0) 20 7840 8400 http://www.randomhouse.co.uk http://www.booksattransworld.co.uk http://www.kidsatrandomhouse.co.uk Generic email address - enquiries@xxxxxxxxxxxxxxxxx Name & Registered Office: THE RANDOM HOUSE GROUP LIMITED 20 VAUXHALL BRIDGE ROAD LONDON SW1V 2SA Random House Group Ltd is registered in the United Kingdom with company No. 00954009, VAT number 102838980 ***********************************************************************************
