[Resolved] Sorting Problem

[Muses]

What I am trying to do is split the results over the two tables... not sure what the best method is as I am pretty sure this isnt it. Any help/suggestions/tutorial links would be appreciated.

It is the second query in which I have the problem. I changed it to DESC but it still doesnt pull up the next 50 records.

<table align=center width=100% border="1" bordercolor="#7B99FE">
<tr><td class=title colspan=3 align=center background="ima/filler.jpg"> Chart</td></tr>
<tr>
<td align=center width=50%>
<table align=center width=100% border="1" bordercolor="#7B99FE">
<tr>
<td class=title align=center width=10%>Section 1</td>
<td class=title align=center width=10%>Section 2</td>
<td class=title align=center width=10%>Section 3</td>
<td class=title align=center width=10%>Section 4</td>
<td class=title align=center width=10%>Section 5</td>
</tr>

	require_once ('../mysql_connect.php'); // Connect to the database.
$result = mysql_query("SELECT DISTINCT exp.* FROM exp  WHERE 1 ORDER BY exp_id ASC LIMIT 50");
echo mysql_error();  

if (mysql_num_rows($result)) 
while($row = mysql_fetch_array($result)) { 

   echo "<tr>";
    echo "<td align=center valign=top>" . $row['section1'] . "</td>";
    echo "<td align=center valign=top>" . $row['section2'] . "</td>";
    echo "<td align=center valign=top>" . $row['section3'] . "</td>";
    echo "<td align=center valign=top>" . $row['section4'] . "</td>";
    echo "<td align=center valign=top>" . $row['section5'] . "</td>";
    echo "</tr>";
	}

</table>
</td>
<td>&nbsp;</td>
<td align=center width=50%>
<table align=center width=100% border="1" bordercolor="#7B99FE">
<tr>
<td class=title align=center width=10%>Section 1</td>
<td class=title align=center width=10%>Section 2</td>
<td class=title align=center width=10%>Section 3</td>
<td class=title align=center width=10%>Section 4</td>
<td class=title align=center width=10%>Section 5</td>
</tr>

	require_once ('../mysql_connect.php'); // Connect to the database.
$result2 = mysql_query("SELECT DISTINCT exp.* FROM exp  WHERE 1 ORDER BY exp_id ASC LIMIT 50");
echo mysql_error();  

if (mysql_num_rows($result2)) 
while($row = mysql_fetch_array($result2)) { 

 echo "<tr>";
echo "<td align=center valign=top>" . $row['section1'] . "</td>";
echo "<td align=center valign=top>" . $row['section2'] . "</td>";
echo "<td align=center valign=top>" . $row['section3'] . "</td>";
echo "<td align=center valign=top>" . $row['section4'] . "</td>";
echo "<td align=center valign=top>" . $row['section5'] . "</td>";
echo "</tr>";
}
}

</table>

</td>
</tr>
</table>

[smurl]

I think you need to add row starts and ends to the end of your queries.

// First Query - starts at row 0 and gets first 50 rows returned.
$result = mysql_query("SELECT DISTINCT exp.* FROM exp  WHERE 1 ORDER BY exp_id ASC LIMIT 0,50");

// Second Query - starts at row 51 and gets the next 50 rows returned
$result2 = mysql_query("SELECT DISTINCT exp.* FROM exp  WHERE 1 ORDER BY exp_id ASC LIMIT 51,50");

I think... try it 🙂

[Muses]

It worked.. much appreciated and I learned something new.

On a side note, on the second query I had to change this:

// Second Query - starts at row 51 and gets the next 50 rows returned
$result2 = mysql_query("SELECT DISTINCT exp.* FROM exp  WHERE 1 ORDER BY exp_id ASC LIMIT 51,50");

to this

// Second Query - starts at row 51 and gets the next 50 rows returned
$result2 = mysql_query("SELECT DISTINCT exp.* FROM exp  WHERE 1 ORDER BY exp_id ASC LIMIT 50,50");

.

As it was it was pulling record 52 and missing record 51.