Topic awaiting preservation: PHP/mySQL problem — OZONE Asylum, home of the Mad Scientists

This page's ID: 12373

Topic awaiting preservation: PHP/mySQL problem (Page 1 of 1) $Pages that link to <a href="https://ozoneasylum.com/backlink?for=12373" title="Pages that link to Topic awaiting preservation: PHP/mySQL problem (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: PHP/mySQL problem <span class="small">(Page 1 of 1)</span>\$

Boudga Maniac (V) Mad Scientist From: Jacks raging bile duct.... Insane since: Mar 2000	posted 08-21-2002 04:02 I created a mySQl database and accidentally named one of the filed "desc" short for description....low and behold PHP errored out everytime I'd try to query that field. Is "desc" a reserved word in PHP? I changed it to "descr" and everything works flawlessly now.
genis Paranoid (IV) Inmate From: Dallas, TX Insane since: Aug 2002	posted 08-21-2002 04:27 I don't think so. I know it is a MySQL reserved word meaning Descending used for sorting.
Boudga Maniac (V) Mad Scientist From: Jacks raging bile duct.... Insane since: Mar 2000	posted 08-21-2002 04:58 Well that would make sense then why the queries failed...
GRUMBLE Paranoid (IV) Mad Scientist From: Omicron Persei 8 Insane since: Oct 2000	posted 08-21-2002 13:03 yes, its a reserved word in MySQL! for example: SELECT * FROM table ORDER BY date DESC sorts the query by the date descending. opposite would be ASC ascending. [This message has been edited by GRUMBLE (edited 08-21-2002).]

Topic awaiting preservation: PHP/mySQL problem (Page 1 of 1)