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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Mark,
	I have another suggestion for you to try, you can use this while
using post variables, and class-access variables.

	$result = mysql_query("SELECT * FROM {$table_name} ORDER BY rowID
DESC");

	This is doing the exact same thing as your previous statement, but
it allows you to remove the parenthesis and you can also do nifty things
like 
{$_myclass->getuserid()} without having to escape it with parenthesis.

	Another thing to check, do you have register_globals set to on?
Your PHP may be requiring you to access $table_name as $_GET["table_name"]
or $_POST["table_name"]?

Cheers,

Tom Hearn
Software Engineer
N Software
http://www.nsoftware.com
  

-----Original Message-----
From: Mark Abrams [mailto:mark@xxxxxxxxxxxxxxxxxxxxxxxx] 
Sent: Wednesday, August 01, 2007 9:59 AM
To: php-windows@xxxxxxxxxxxxx
Subject:  Solved - Re: [PHP-WIN] ORDER BY is not sorting

Thank you all.  Problem solved.

Gustav, I followed your recomendation and changed the table name var to the 
actual table name and my problem is solved. Perpaps something is lost in the

interperter when PHP passes the code.

It has been this group that helps make working with PHP fun.

"Gustav Wiberg" <gustav@xxxxxx> wrote in message 
news:6E.E1.12911.71320B64@xxxxxxxxxxxxxxx
Hi!

I can't see anything with your code either. Mysql_fetch_array should work 
fine yes. No indexes are needed to sort fields, but are recommended for 
speeding up the process :-)

How does the table users look like? (Please send a link to a screenshot or 
something like that)

Sometimes I have noticed that PHP isn't that good of getting right results 
when using $variable inside ""-chars


You could try doing this:

   $table_name ='users';

    // Select records
    $result = mysql_query("SELECT * FROM " . $table_name . " ORDER BY rowID 
DESC");


    // Loop through the record set
    while($row = mysql_fetch_array($result))
         print 'rowID ='          .$row['rowID']. '<br />'


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:mark@xxxxxxxxxxxxxxxxxxxxxxxx]
Sent: Wednesday, August 01, 2007 12:50 AM
To: php-windows@xxxxxxxxxxxxx
Subject: Re:  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 mySQL DB.

rowID is the primary key.  Do I need to have an index attribute on a field I
want to sort?




<tg-php@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:20070731203155.CEE1819504F@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>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?
>
> What happens if you leave the "DESC" off?  Does it come back 4, 3, 2, 1?
> or still 1, 2, 3, 4?
>
> You might try displaying more data from the result set to see if there's
> some other issue.
>
> And have you tested the SQL statement just using MySQL via command line,
> phpMyAdmin, WinSQL, Navicat, or something like that?
>
> -TG
>
> = = = Original message = = =
>
> Sorry, this seams very trivial but I can not sort the result set for any
> field.  What am I doing wrong?
>
>
> php & mySQL 5
>
>
> <?php
>
> ...
>
>   $table_name ='users';
>
>    // Select records
>    $result = mysql_query("SELECT * FROM $table_name ORDER BY rowID DESC");
>
>
>    // Loop through the record set
>    while($row = mysql_fetch_array($result))
>         print 'rowID ='          .$row['rowID']. '<br />'
>
>
> ?>
>
> 1
> 2
> 3
> 4
>
>
> TIA
> Mark
>
> -- 
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> ___________________________________________________________
> Sent by ePrompter, the premier email notification software.
> Free download at http://www.ePrompter.com.

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.476 / Virus Database: 269.11.0/927 - Release Date: 2007-07-30 
17:02

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.11.0/929 - Release Date: 7/31/2007
5:26 PM
 

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.476 / Virus Database: 269.11.0/929 - Release Date: 7/31/2007
5:26 PM
 

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux