strange PHP MySQL behaviour

[MrRosary]

I must be doing something wrong here but for the life of me I cant see what.

I have a table with 3 rows in it.

When I use the following code to access the contents of the table strange things happen

	$list_sql = "select urlid from price_details where urlid != 'multi'";
$list_query = mysql_query($list_sql); 
$list_array = mysql_fetch_array($list_query);

I dont get the two rows I want in the array. I get an array as follows.

Array
(
[0] => 7secrets
[urlid] => 7secrets
)

This is the 'last' row of the database. twice.... sort of.

I use this code everyday as I am sure everyone else does. Why doesnt it want to play all of a sudden? When I run the SQL though MySQL without php I get exactly the result I want.

MrRosary

[nnichols]

What you are seeing in the array is the first row returned by the query. The reason the data appears twice is because you are using "mysql_fecth_array()" which creates an array from the result - indexed both numerically and associatively. To get both of the rows you want to return you need to loop through the result set -

$list_sql = "select urlid from price_details where urlid != 'multi'";
$list_query = mysql_query($list_sql); 
while ($row = mysql_fetch_array($list_query)) {
//do whatever you want with the data
};

[MrRosary]

D'OH

[nnichols]

😉