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 PRO

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 actual

[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