RE: [PHP-DB] SELECT statement does not return rows

2002-02-01 Thread Shrock, Court
oops.forgot a semicolon on the first line of the multi-line code segment > -Original Message- > $row = mysql_fetch_array($result) > echo 'columnvalue'; > while(list($key, $val) = each($row)) { > // $row has two key/value pairs per column -- one integer, > one string > if (is_

RE: [PHP-DB] SELECT statement does not return rows

2002-02-01 Thread Shrock, Court
I am assuming that this code is NOT the file "do_mod_job.php". What happens if you do this next line right after you execute your query?: echo 'num rows fetched: '.mysql_num_rows($result).''; also, the while loop shouldn't really be necessary as the query should only return one record if I unde

Re: [PHP-DB] SELECT statement does not return rows

2002-02-01 Thread biorn
Is your id an integer or a char/varchar? If it is an integer, take the quotes off $id in your select statement. Todd Williamsen <[EMAIL PROTECTED]> said: > Weird.. > > I want to be able to edit records, which I have done in the past, and I > cannot see why it isn't working... I have tried

RE: [PHP-DB] SELECT statement does not return rows

2002-02-01 Thread Rick Emery
Did you print out the value of $sql before executing it? Was it as you expected? If so, did you print out mysql_num_rows() to verify it's greater than 0? -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Friday, February 01, 2002 2:52 PM To: [EMAIL PROTECTED] Subj