Can't get results from MySQL via PHP

Hi there, I've been fighting with PHP/MySQL to get proper results but without success. For example: $sql = "SELECT * FROM prod WHERE shortname='Myprog"; $result = mysql_query($sql); >>> returns Resource #7 $list = mysql_fetch_row($result); >>> returns Array and actually the data in the table is a four digit number! The query returns what is expected in MySQL but refuses to do so under php. What is it (or could be) that I am doing wrong/missing? Thanks in advance. Alp