Problem with an Array

liquid2k

Hey People,

I'm a little confused with an array i have here, Here's how it goes.

$check = mysql_query("select id,fname,lname,department...... $result = mysql_fetch_array($check);

Now when i echo the results e.g $result['id'] etc they all work but one. $result['department'] doesn't echo unless i do a 'department as dep' or $result[3].....

Is there a max length for key's??? or am i going wrong somewhere?

Thanks for your time,
Justin.

DeltaRho2K

You should be fine with this... What happens if you change your select query to "SELECT * FROM table_name....." rather than calling out each field?

liquid2k

SELECT * from..... works if i use $result['department']. Thanks for your help.

Any ideas why it wouldn't work as;

SELECT id, department.... using $result['department']

This has happened to me a few times in the past but i didn't want to select everything as this database is getting rather massive...

Thanks again.

Justin.

DeltaRho2K

Like I said before, it should be fine... I would have to see the whole query you originally had written, but from what I can tell, it should have worked.