this is very simple.. I know

[rbblue8]

Perhaps this is b/c I have been coding for 12 hours str8 now and I'm just fried but can you guys help me out....

my query is
SELECT state FROM zipcodes

which should return 4 different answers.

It does return 4 of them when i use phpMyAdmin using the same query.

but in my php code it only return ones.

here is the php code

$string1=("SELECT state FROM zipcodes");
						$query1=mysql_query($string1, $db);
						if(!$query1)
							{
							require('pages/error.php');
							$code='1';
							}						
						$result1=mysql_fetch_assoc($query1);
						$personals=$result1['state'];
						print_r($result1);

[mborish_2000]

Your quotes are all messed up. Try this:

$string1= "SELECT state FROM zipcodes";
//Other Stuff

[tomhath]

mysql_fetch_assoc only fetches one row.