[SOLVED] Query always returning first row of db.

[hellonoko]

My code below always seems to return just the first row of the DB when it should return different rows.

 

The code always returns: 8

8 is the value of the first id row in the DB.

 

Above this code I am also echoing the  $id_rank value so it should be getting proper input.

 

Any ideas?

 

Thanks for your time,

ian

 

$query = "SELECT id FROM ideas WHERE rank < '$id_rank' LIMIT 1";
	$result = mysql_query($query) or die (mysql_error());
	$row = mysql_fetch_assoc($result) or die (mysql_error());

	$moving_idea_id = $row['id'];

	// moves item rank DOWN one.
	echo $moving_idea_id;
	exit();

[bobahad]

Not too experience with these things but doesn't Limit 1 mean return just 1

[hellonoko]

Yes it does. That is what I want to do. But it doesn't mean return the first one just 1. Could be middle one. Last one.

 

In this case it is one below the current one.

[roopurt18]

Is `rank` an INTEGER column?  If so, try removing the single quotes around $id_rank in your query.

[hellonoko]

Tried that and yes it is. Actually just realized that the value I need 'id' is passed over earlier in the query string. Stupid me.

 

[revraz]

So is it solved?

[hellonoko]

Well.

 

I thought I had solved it by taking the value from query string but I actually need to get the row previous to that row.

 

But then I did solve it. (Seems to be working) Code below.

 

// get ID of idea below one to be moved.
	$query = "SELECT id FROM ideas WHERE rank < $id_rank ORDER BY ID DESC LIMIT 1";
	$result = mysql_query($query) or die (mysql_error());
	$row = mysql_fetch_assoc($result) or die (mysql_error());

	$moving_idea_id = $row['id'];

	// moves item rank DOWN one.
	echo $moving_idea_id;
	exit();