Ordering values from the same row?

Serpent7

So, I have a database where each user has a row, and aswell as username, password etc. the fields count how many times each user clicks on a certain link. For example, a sample row might look like this:

[FONT=Lucida Console]

Somedude | Pass1234 | 4 | 2 | 16 | 9 | 0 |

[/FONT]

Now, say I wanted to let a user see what their three most clicked on links were?
I.e.

"You've clicked on:
Link C 16 times;
Link D 9 times;
and Link A 4 times!"

How could I do that? Thanks in advance. 🙂

EDIT- Don't think I made myself too clear, I don't want to just echo out the values of the fields, I want to take only the TOP THREE most clicked on links.

Vbabiy

Just use Mysql_fetch_array() to pull a ray from that table and then just do this

Link A : <?php echo $row['linka'] ?>

Or somthing like that

Serpent7

But as far I can see, that would only echo out all of the fields. I want only the top three MOST clicked on for a certain user.

DoctorWho

He wants only the Top 3 Most clicked links, in this case C, D, A

I am not sure how you do that, but I wonder if you can pull the data into PHP and do the comparisons in PHP, then print the top 3 results.

Don't know yet, still looking at this.

Serpent7

Thanks for your help.

madwormer2

Read into an array, and sort using the array sorting functions.

Vbabiy

Yea

do something like this:

<?php
$newrow = sort($row);

for($i=0; $i < 3; $i++)
{
echo '<input type="text" name="text" value="';
echo $newrow[$i];
echo '">';
}

Serpent7

Could you show me how to take the contents of the LINK fields from one row and put it into an array? Thanks.

bodzan

At least for future notice to avoid mishaps like this one you might want to consider different MySQL table layout:

Table users:
id | username | password

Table links:
id | user | link | visits

Where you would insert data like you do now except when you enter a number of clicks on a certain link by certain user you would simply update that field in table links. This way you would not have to modify the database say if you want to add new link to follow or delete one...

Also, with this way you would be able to do simple sorting of results you need by simple query in MySQL and not to use PHP's funtions for sorting an array...

Vbabiy

bodzan wrote:
At least for future notice to avoid mishaps like this one you might want to consider different MySQL table layout:

Table users:
id | username | password

Table links:
id | user | link | visits

Where you would insert data like you do now except when you enter a number of clicks on a certain link by certain user you would simply update that field in table links. This way you would not have to modify the database say if you want to add new link to follow or delete one...

Also, with this way you would be able to do simple sorting of results you need by simple query in MySQL and not to use PHP's funtions for sorting an array...

This is very true when you have am much better planed database it I will make your life a lot easier and in the long run