RE: [PHP-DB] Variables in MySQL Insert Queries

2001-08-24 Thread KSchneider
plague -- unfortunately i don't have the beginnings of this thread, but if your code below is verbatim, it looks as though you are missing the mysql_query() statement. that should drop your information. kate -Original Message- From: plague [mailto:[EMAIL PROTECTED]] Sent:

Re: [PHP-DB] Newbie: Modify - Delete entries

2001-08-17 Thread KSchneider
Sébastien, modify and delete submit buttons would probably be your best bet. my usual modus operandi is to send an id number (or other qualifying criteria) to the next page (often i use the very same page so as to not have to re-write the form). ex: modify: send id in an input hidden

Re: [PHP-DB] list entries alphabetically

2001-08-15 Thread KSchneider
$query = SELECT * FROM table WHERE field = 'criteria' ORDER BY field; $result = mysql_query(db,$query); this sort order is ascending. to get descending order, use: ORDER BY field DESC you should, however, go to the previously recommended site for a tutorial. your questions will be answered in