[PHP] Can't get results from MySQL via PHP

2004-11-15 Thread Alp
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

Re: [PHP] Can't get results from MySQL via PHP

2004-11-15 Thread raditha dissanayake
Alp wrote: 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

Re: [PHP] Can't get results from MySQL via PHP

2004-11-15 Thread Alp
Thanks for your response, I did finally sove it by changing mysql_fetch_row($result); to mysql_fetch_array($result); and assigning my variable as $somevar = $list['fieldname']; Now I get my real value. Thanks again. Alp Raditha Dissanayake [EMAIL PROTECTED] wrote in message news:[EMAIL