4 replies to this topic

[Crofty]

ok well i am trying to make a top selleres list but when the amountsold goes past 10 it reads it as 1

	$r4 = mysql_query("SELECT * FROM `products` order by `amountsold` DESC LIMIT 0,10");
	while($row = mysql_fetch_assoc($r4)){
	echo' 
	  <tr>
		<td width="200" align="center"><a href="index.php?view=dvd&id='.$row['dvdid'].'">'.$row['dvdname'].'</a></td>
	  </tr>';
}

have i missed out something?

[Crofty]

well in my database there is a field called amountsold and once this value increases above 10 it dosent read the second digit

[Mr. Matt]

you missed the $ from the $r so you will get an error.

Matt

[Crofty]

the limit seems to be fine it works atm

[Crofty]

EDIT: SOLVED DIDNT MAKE AMOUNT SOLD INT


no sorry i mean the limt worked fine in the first place. every time a product is bought it adds 1 to the amountsold field of that product, but when the amount sold gets bigger than 10 it starts to read the first didgit only for example it reads 10 as 1 and 25 as 2, i dont know why its doing this?

Edited by Crofty, 29 September 2006 - 04:10 AM.