I did a "DELETE FROM picture" where "picture" is a table in my database.

Afterward, this piece of code does not generate an error
----------------------------------------------
try
      {
      $query = "SELECT * FROM picture p " .
                          "WHERE p.pictureFile='" . $pictureFile . "'";
      $thisRow =
              mysql_query($query, $pictures_connection);
      }
      catch(Exception $e)
             {
             echo 'caught exception: ',  $e->getMessage()."\n";
             $result = False;
             }
----------------------------------------------
and testing $thisRow
----------------------------------------------
if(!$thisRow)
      {
      echo "picture '" . $pictureFile . "' does not exist in the
database.\n";
       }
else
      {
      echo "picture '" . $pictureFile . "' exists in the database.\n";
      $picture_table = array();
      $picture_row = mysql_fetch_array($thisRow);
      do        /* capture row's picture data */
           {
           $picture_table[$picture_row["pictureHandle"]] = array(
               "pictureName" => $picture_row["pictureName"],
               "pictureFile" => $picture_row["pictureFile"],
               "pictureMapFile" => $picture_row["pictureMapFile"],
               "pictureDescription" => $picture_row["pictureDescription"],
               "pictureDescriptionFile" =>
$picture_row["pictureDescriptionFile"],
               "pictureDateTime" => $picture_row["pictureDateTime"],
               "pictureOrientation" => $picture_row["pictureOrientation"],
               "pictureStamp" => $picture_row["pictureStamp"]
                                                                            
                  )     /* add this row to the table */;
       } while(($picture_row = mysql_fetch_array($thisRow)));
      print_r($picture_table) . "\n";
----------------------------------------------------------------
results in an empty array being printed ... implying that the query
was successful?

Help, please.



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to