Posted by shorty on 11/21/25 11:24

After a customer enters data into a table, and then leaves the
website.

All I want to do is sort (numerically) a particular column in the
table, and then resave the table, ready for its next use.

>shorty wrote:
>> The following piece of code has worked in the past but any ideas why
>> it does not work now ???
>>
>> $sql = mysql_query("ALTER TABLE `words` ORDER BY `counter` DESC");
>>
>
>So what are you trying to do? Maybe you meant
>SELECT * FROM `words` ORDER BY `counter` DESC?
>
>> The code that is above it, also uses the same database, username,
>> password etc and works fine.
>>
>> The mysql scheme privilges are set to 'select' and 'update'
>
>See you used ALTER not SELECT or UPDATE.
>
>Regards
>Stefan
>
>>
>>

[Back to original message]