Simple PHP & MySQL Question

[Nixon]

Hi I have the following mysql query:

$querytop= mysql_query( "select outwarusername, outwarlink, points, clicks from outwarinfo order by points desc limit 5" );

This basically gets the five rows with the highest points frommy database. Now I want to beable to pull these 5 rows out seperatly. I can list them all but I cant figure out how to get row 1 or get row 4.

Also is there a way to execute a script when a link is clicked? I think it might look something like this:

<a href="otherpage.php" onClick="clickscript.php">Click Here</a>

Would this work?

Thanks, Nixon

[tsinka]

Hi,

you can use mysql_fetch_array to fetch the data as an array. This enables you to select a certain row by accessing the array by index.

<a href="otherpage.php" onClick="clickscript.php">Click Here</a>

That will not work. Why do you want to do this ? In most cases you will be able to do stuff in just one script ...

[Nixon]

Could you explain to me the mysql array?

What I have on my website is a points system and I want it so that everytime you click on a link 1 point is deducted from the persons whos link it is for example:

[TABLE]

Name | Points | Link

Jack | 10 | jack.com
John | 15 | john.com

---

Now I click on jacks link and I want it to deduct a point from him so he would then have 9 points. Do you see what I mean? Thanks a lot nixon.

[Yamakazi]

First off all: How do you know wich user has been clicked. You want to deduct points from a user who's link has been clicked. to do this you should pass a variable with the UserId.

<a href="otherpage.php" onClick="clickscript.php?UserId=12">Click Here</a>

If this link is clicked you'll know a link of the user jack wa clicked.

[TABLE]

UserId|Name | Points | Link

12|Jack | 10 | jack.com
13|John | 15 | john.com

First get the clicked user's Id:

$UserId = $_POST['UserId'];

Now the query you should preform is:

$querytop= mysql_query( "select points from outwarinfo where UserId = $UserId" ) or die("Querytop failed");

Now you know how much points the user has.

You can retrieve it by fetching the data.

$ResultTop = mysql_fetch_array($queryTop) or die("ResultTop failed");

$PointsUser = $ResultTop[points];

Know because the link was clicked you want to deduct a point so.

$PointUser = $PointUser - 1;

You can do a check if you're score is negative

if($PointUser<0){
$PointUser = 0;
}

The only thing left to do know is update the database with the new score.

mysql_query( "update outwarinfo set points = $PointsUser where UserId = $UserId" ) or die("Update Query Failed");

[Nixon]

Sorry i haven't check this yet i have another problem to sort out before i can maybe you will understand better seeing you see my situation.

see: Get seperate variable for each row.

Thanks,