[RESOLVED] Sort issue in IE6

sabien

$lookup=mysql("$DBName","SELECT * FROM events ORDER BY EvDate ASC");

This seems as simple as it gets - and works great ... in FireFox. For some reason the sort is not working when I load the page in IE6 or Opera.

How can a browser have any effect on a PHP query? This is done server-side, correct?

I have changed the sort to DESC and it works great again in Firefox. No change in IE6, etc.

I mix up the query and it always pulls the right data, but only sorts right in FireFox.

Has anyone ever heard of this?

execute

you have a syntax error,... i dunno maybe im stupid but i dont think there is a function called mysql(); nor is there ASC... i believe its ASCE and you cant put a value in front if its suppose to be mysql_query("SELECT * FROM events ORDER BY EvDate DESC");

bastien

Nah, execute, he's calling some user defined function...the query syntax is correct. I woul suspect that its something in the output that is causing it to render incorrectly...show your code...

Nugen

bastien wrote:
Nah, execute, he's calling some user defined function...the query syntax is correct. I woul suspect that its something in the output that is causing it to render incorrectly...show your code...

MySQL = SQL Server, the internet browser can not interfer with the query since PHP makes the query on the servers side.

ASC is a valid ORDER BY code for ascending.

The problem is most likely in the code your using to display the output of that query, or the mysql or whatever your using to get your info.

justsomeone

if you're building the rows up for display in html tables, you neeed to be careful. Minor problems with the html syntax can cause different browsers to interpret your request differently.

In any case, the browser you use can not have any control over the order in which rows are returned by a database query.

Najjar

What is the data type of the "EvDate" field in the table is it Date or varchar?
If it is not date then this will cause a problem in your sort.

sabien

Here is the code for the query. I am convinced that it is an HTML interpretation (client-side, right?).

I cannot see the problem, though.

Yes, the EvDate field is type Date in the database.

echo "<table summary=\"Current Events\"";

$db = mysql_connect($DBHost, $DBUser, $DBPass) or die("Cannot connect.");
mysql_select_db($DBName, $db) or die("Cannot select database.");

$lookup=mysql("$DBName","SELECT * FROM events WHERE EvDate >= '$today' ORDER BY EvDate ASC");

while ($row = mysql_fetch_row($lookup)) {
$EvID=$row[0];
$EvTitle=$row[1];
$EvDesc=$row[2];
$EvDate=$row[3];

echo "<tr>";
echo "<td>$EvTitle<br>$EvDesc</td>";
echo "</tr>";
}

echo "</table>";

Thanks for all your help.

justsomeone

Your opening "table" tag doesn't have a closing ">".

I wonder if that's causing your browser problems.

bastien

Hve you set the variable for today as the correct date format as the field? I don't see it being set in the code