Ordering Problem

webmasternovis

Hi again,

Sorry to ask another question 🙂

$userquery = mysql_query("SELECT * FROM table GROUP BY author LIMIT $page, 10");

while ($userrow = mysql_fetch_assoc($userquery))
	{
// Select second database
mysql_select_db($dbname2, $connect);
$usernamequery = mysql_query("SELECT * FROM user WHERE userid='$userrow[author]'");

What I'd like to do is order my results, alphabetically or maybe even the date a user joined. But for this thread, just presume I want the results ordering alphabetically 🙂

Anyway, my problem. There are two databases. I query one of them to get users who have contributed something, and the other one to get their details such as their username (the first query only gets their userid). This means that I can't order them, as the query to the second database will only return one result.

Hopefully you'll understand me, I've tried to explain it best I can anyway 🙂

Please could somebody help?

Thanks,
Mike

Shrike

You will need to push the results from the second database to an array and then use PHP to [MAN]sort[/MAN] the array.

planetsim

Do the tables need to be in different databases id suggest they be in the same database and just use a JOIN then order

ORDER BY username ASC

sidney

you will have to enter all the info return into an array
then order the array and display

put both tables in the same db and write a query to retrive the id and userinfo all in one and order it in mysql

webmasternovis

Originally posted by Shrike
You will need to push the results from the second database to an array and then use PHP to [MAN]sort[/MAN] the array.

This seems the best option really, as I don't really want to swap table and databases around.

How do you think I go about pushing the results into an array? I don't see how you could put them all in if you just used the normal method for setting an array.

Thanks,
Mike

sidney

 
while($row=mysql_fetch_array($queryuserinfodb))
      $holdarray[idformfirstdbqery]=$row

would create an array

but it would be better to have both tables in same db

webmasternovis

$userquery = mysql_query("SELECT * FROM table GROUP BY author LIMIT $page, 10");

while ($userrow = mysql_fetch_assoc($userquery))
	{
// Select second database
mysql_select_db($dbname2, $connect);
$usernamequery = mysql_query("SELECT * FROM user WHERE userid='$userrow[author]'");
while($row=mysql_fetch_array($userquery)) 
      $holdarray[$userrow[userid]]=$row

The above is what I have now, but nothing is happening? I don't quite get how the array has been made?

I'd like to use the same database but the person I'm doing it for has told me not to touch the second database, apart from to retrieve stuff from it.

Please could someone help?

Thanks,
Mike

sidney

print_r($holdarray);

and see the array output

planetsim

Originally posted by webmasternovis
$userquery = mysql_query("SELECT * FROM table GROUP BY author LIMIT $page, 10");

while ($userrow = mysql_fetch_assoc($userquery))
	{
// Select second database
mysql_select_db($dbname2, $connect);
$usernamequery = mysql_query("SELECT * FROM user WHERE userid='$userrow[author]'");
while($row=mysql_fetch_array($userquery)) 
      $holdarray[$userrow[userid]]=$row
The above is what I have now, but nothing is happening? I don't quite get how the array has been made?

I'd like to use the same database but the person I'm doing it for has told me not to touch the second database, apart from to retrieve stuff from it.

Please could someone help?

Thanks,
Mike [/B]

I believe you can still use the table join on tables outside the current database

its usually databasename.table.fieldname

webmasternovis

Hi again.

Thanks for all the replies. I've had a little play and come up with the following:

mysql_select_db($dbname2, $connect);
$usernamequery = mysql_query("SELECT * FROM table WHERE userid='$userrow[author]'");
$row = mysql_fetch_assoc($usernamequery);
array_push($stack, $row['username']);
	}

sort($stack);
print_r($stack);

It seems to order most of it correctly, but two of the results are totally out of place. They begin with an "a" and a "b", and both appear at the end. Does anyone know what the problem could be here?

Thanks,
Mike