[SOLVED] Order BY & Updating verification

[ballouta]

Hello

 

Question1:

========

I have this qurey, I want to order the result by ID ASC. How?

 

$query = "SELECT members.ID, members.name, members.user, credits.user, credits.num

              FROM members INNER JOIN credits ON members.user = credits.user";

 

Question2:

========

How do i know if an update for a table has been applied successfully?

I used this before for Select: if (mysql_num_rows($result) > 0)

 

thanks

[r-it]

question 1:

SELECT members.ID, members.name, members.user, credits.user, credits.num

              FROM members INNER JOIN credits ON members.user = credits.user ORDER BY members.ID ASC"

 

question 2:

 

use mysql_affected_rows instead