Closed Thread Icon

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 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 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 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 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).]

« BackwardsOnwards »

Show Forum Drop Down Menu