[kinggeorge1987]

$newid=$_POST['product_id'];
$c="SELECT quota FROM packages WHERE vendorid= '3'";
$b=mysql_query($c) or die(mysql_error());
$count=mysql_num_rows($B)/>;
$val=mysql_fetch_array($B)/>;
	foreach($val as $q){
		echo $q;
	}

Hey everyone, this code is working to retrieve the quota, but it is returning it twice. There is only ever going to be one entry with that id, but i cant just exit after the first entry becuase I have to carry the value onto the next pages, any idea why it is returning the same value twice ?

[amitchhajer]

try using mysql_fetch_assoc also check the database again

[kinggeorge1987]

Worked great, thank you.

What is the difference between the two ?

[no2pencil]

fetch_array just pulls the values back as you requested them. Say you pulled back id,password then id would be in array element zero & password would be in array element 1. By pulling them back with assoc, it pulls them back by string value.

[Dormilich]

mysql_fetch_array() by default fetches the result set numerically and associatively indexed. you can change that with the appropriate flag or use (as mentioned) mysql_fetch_assoc()

This post has been edited by Dormilich: 06 November 2010 - 01:08 AM

[kinggeorge1987]

Thanks guys, very informative. Rep+++

[amitchhajer]

i think you got the difference now

[kinggeorge1987]

Sure do, thanks again.

[Dormilich]

I usually avoid such problems by using PDO, which allows me to use foreach()*.



* - foreach() works on the values, not on the keys.