Php newb needs help sorting a mysql array

Kuhan

Heya,

The thing I want to do is take a mysql table, read it in a php file, sort it alphabeticly/numericly, and have it outputted onto the page in the form of a table.

I found 2 tutorials that I thought would help me. One allowed me to read a mysql table and output it on the screen... and another allowed me to sort a php array and output it, but unfortunatly I couldn't seem to get both to work together.

Any ideas on how this can be done?

Kudose

http://dev.mysql.com/doc/refman/5.0/en/select.html shows some ORDER BY syntax.

You use MySQL to do most of the sorting you need from the database.

i.e. SELECT whatever FROM table WHERE id='thisid' ORDER BY id DESC

Kuhan

Ah, okay, so if I did this:

<?
$username="username";
$password="password";
$database="your_database";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM contacts ORDER BY first DESC";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

echo "<b><center>Database Output</center></b><br><br>";

$i=0;
while ($i < $num) {

$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$mobile=mysql_result($result,$i,"mobile");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");

echo "<b>$first $last</b><br>Phone: $phone<br>Mobile: $mobile<br>Fax: $fax<br>E-mail: $email<br>Web: $web<br><hr><br>";

$i++;
}

?>

It would print the table, ordered by name?

Kudose

Yes. It would order by 'first' ascending.

i.e.

Aaron
Aron
Betty
Timmy

Kuhan

Just tried it, and unfortunatly, it did not work right.

"Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /mnt/web_f/d21/s06/b0262dcb/www/members.php on line 71" is what appears on the page.

Edit: nevermind, found out it was just a typo. thanks for the help 🙂

mattsoftnet

Kuhan wrote:
Just tried it, and unfortunatly, it did not work right.

"Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /mnt/web_f/d21/s06/b0262dcb/www/members.php on line 71" is what appears on the page.

Edit: nevermind, found out it was just a typo. thanks for the help 🙂

that's called debugging. I do that now and then. get stuck for a few hours on a problem, post a request for help on a forum, then find the problem a moment later. it's best to try and figure things out on your own first. you learn a lot that way. here, try this for listing your queries:

$result=mysql_query("SELECT id,title,text,UNIX_TIMESTAMP(date) FROM news WHERE enabled='1' ORDER BY date DESC, id DESC",$db_mysql);
while($row=@mysql_fetch_array($result)){
echo $row['id']." ";
echo $row['title']." ";
echo $row['text']." ";
echo date("r",$row['date'])." ";
}

foreach also comes in handy for listing normal arrays