Re: [PHP-WIN] Solved - Re: [PHP-WIN] ORDER BY is not sorting

2007-08-03 Thread Armando
#x27;]. '' There might be some issues regarding permissons of MySQL. Have you tried doing another sql-select statement on another table? Best regards /Gustav Wiberg -Original Message- From: Mark Abrams [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 01, 2007 12:50 AM

RE: [PHP-WIN] Solved - Re: [PHP-WIN] ORDER BY is not sorting

2007-08-01 Thread Tom Hearn
e_name"] or $_POST["table_name"]? Cheers, Tom Hearn Software Engineer N Software http://www.nsoftware.com -Original Message- From: Mark Abrams [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 01, 2007 9:59 AM To: php-windows@lists.php.net Subject: [PHP-WIN] Solved - Re:

[PHP-WIN] Solved - Re: [PHP-WIN] ORDER BY is not sorting

2007-08-01 Thread Mark Abrams
ons of MySQL. Have you tried doing another sql-select statement on another table? Best regards /Gustav Wiberg -Original Message- From: Mark Abrams [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 01, 2007 12:50 AM To: php-windows@lists.php.net Subject: Re: [PHP-WIN] ORDER BY i

RE: [PHP-WIN] ORDER BY is not sorting

2007-08-01 Thread Luis Moreira (ESI-GSQP)
not being applied... Luis -Original Message- From: M. Sokolewicz [mailto:[EMAIL PROTECTED] Sent: quarta-feira, 1 de Agosto de 2007 11:24 To: Gustav Wiberg Cc: 'Mark Abrams'; 'php-windows@lists.php.net' Subject: Re: [PHP-WIN] ORDER BY is not sorting Gustav Wiberg wrote: &

Re: [PHP-WIN] ORDER BY is not sorting

2007-08-01 Thread M. Sokolewicz
From: Mark Abrams [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 01, 2007 12:50 AM To: php-windows@lists.php.net Subject: Re: [PHP-WIN] ORDER BY is not sorting Is mysql_fetch_array the proper function to access sorted data?The problem is consistent on my test server and my ISPs my

Re: [PHP-WIN] ORDER BY is not sorting

2007-08-01 Thread Aleksandar Vojnovic
What kind of field is the keyID? is it int, char, varchar? - Aleksander Mark Abrams wrote: Is mysql_fetch_array the proper function to access sorted data?The problem is consistent on my test server and my ISPs mySQL DB. rowID is the primary key. Do I need to have an index attribute on a

RE: [PHP-WIN] ORDER BY is not sorting

2007-07-31 Thread Gustav Wiberg
Best regards /Gustav Wiberg -Original Message- From: Mark Abrams [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 01, 2007 12:50 AM To: php-windows@lists.php.net Subject: Re: [PHP-WIN] ORDER BY is not sorting Is mysql_fetch_array the proper function to access sorted data?

Re: [PHP-WIN] ORDER BY is not sorting

2007-07-31 Thread Mark Abrams
Is mysql_fetch_array the proper function to access sorted data?The problem is consistent on my test server and my ISPs mySQL DB. rowID is the primary key. Do I need to have an index attribute on a field I want to sort? <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] >I can'

Re: [PHP-WIN] ORDER BY is not sorting

2007-07-31 Thread tg-php
Spaces would affect sorting if the spaces appeared in the actual rowID data. If rowID is stored as text of some kind, then yeah, maybe he'd have an issue. But I have a feeling you're talking about the code itself and whether to put the quer into a variable or not (rebuting what I said). Here'

Re: [PHP-WIN] ORDER BY is not sorting

2007-07-31 Thread tg-php
I can't really see anything wrong with what you have there. It shouldn't matter that your SQL is inside the query function, although I like to build the query in a variable outside the query function, but either way it should work. And you're obviously getting data and not an error, right? Wha

Re: [PHP-WIN] ORDER BY is not sorting

2007-07-31 Thread Dan Shirah
Well, it looks like you're trying to get your results in an array and run the query all at the same time. Also, I believe you need to put the variable in your SELECT statement inside of some single quotes. Try something like this: $query = "SELECT * FROM '$table_name' ORDER BY DESC"; $result = my