RE: [PHP-DB] Select Query--Need help urgently

2004-03-27 Thread Katie Evans-Young
Irin said: > $sql = mysql_query("SELECT * FROM class where timetable_day='Monday'"); Oops, I see that he DID do a mysql_query and save the result resource in $sql. Sorry, guys! I haven't had my coffee yet this morning! Katie Dewees Web Developer E-mail: [EMAIL PROTECTED] -- PHP Database Mailing

RE: [PHP-DB] Select Query--Need help urgently

2004-03-27 Thread Katie Evans-Young
Irin said: > $sql = mysql_query("SELECT * FROM class where timetable_day='Monday'"); > > $row = mysql_fetch_array($sql); > $result = $db->query($sql); > $numofrows = mysql_num_rows($sql); >From the PHP manual: array mysql_fetch_array ( resource result [, int result_type]) You can't send the func

Re: [PHP-DB] Select Query--Need help urgently

2004-03-27 Thread Mikhail U. Petrov
Hi! Hello irinchiang, Saturday, March 27, 2004, 8:52:51 AM, you wrote: ijc> Hi all, ijc> But I was unable to retrieve the values from database. Was it because I have ijc> written the SELECT query wrongly?? ijc> Realli need some help urgently..Hope to hear from all soon. Thanks in advance.