[RESOLVED] sorting

rbblue8

Hey guys,

My step is like this.

Databse 1 holds the user name, there picture, there rank, and info about them.

databse 2 hold all ranks (just the names like commander and peeon) along with a number value (commander=1 peeon=15)

What i want is to have a sorting by the rank (the highest rank being @ top).

Here is what i have so far

<?php
include 'mysql1.php';

$query='SELECT username, rank, picture_file, about_me from users';
$result=mysql_query($query, $db);
if(!$result)die('unable to process the request, please let the site administration know :' .mysql_error());

while ($row = mysql_fetch_array($result)) {
echo  '<table width="690" border="1" cellpadding="0" cellspacing="0" align="center">';
echo  '<tr>';
echo  '<td width="139" rowspan="2" valign="top"><img src="'.$row[2].'" width="139" height="153"/></td>';
echo  '<td width="276" height="35" valign="top">Name: ' .$row[0].' </td>';
print '<td width="275" valign="top">Rank: ' .$row[1].' </td>';
echo  '</tr>';
echo  '<tr>';
echo  '<td height="102" colspan="2" valign="top">' .$row[3].' </td>';
echo  '</tr>';
echo  '<tr>';
echo  '<td height="1"></td>';
echo  '<td></td>';
echo  '<td></td>';
echo  '</tr>';
echo  '</table>';
echo  '<p>&nbsp;</p>';

}

mysql_close($db);

Can ya help out?

I'm stuck on how to intergrate the number field from databse2 into the query from data base 1. Honestly I have no clue how to get it done. SHould i just add a number field to database one?

Houdini

Sort Ranks alphabetically

$query='SELECT username, rank, picture_file, about_me FROM users ORDER BY rank';

Or in reverse alphsabetical

$query='SELECT username, rank, picture_file, about_me FROM users ORDER BY DESC rank';

gammaster

Hi!
I hope this will give you a hint:

$sql = "SELECT tab1.value1, tab1.value2, tab1.value3";
$sql.= " FROM tab1, tab2";
$sql.= " WHERE tab1.value1 = tab2.value1";
$sql.= " ORDER BY tab2.orderField";

rbblue8

gammaster wrote:

Hi!
I hope this will give you a hint:

$sql = "SELECT tab1.value1, tab1.value2, tab1.value3";
$sql.= " FROM tab1, tab2";
$sql.= " WHERE tab1.value1 = tab2.value1";
$sql.= " ORDER BY tab2.orderField";

um. ya lost me 🙂)

would i just do a $result=($sql, $db) ?
then a $row=mysql_fetch_row($result);

then all of ouf my outputs would be $row[0] - $row[whatever]; ?

and i assume tab1.value1 means

tab.1=table
value1=row?

which would mean users=username rank=number

is that right?

samudasu

rbblue8, here is an excellent page that will help you to understand what gammaster is saying. Sql Joins

After you look at this page, i suggest going through the whole tutorial.