Re: db query not working as expected

On 3/7/07, Ed Curtis <e_curtis@homes2see.com> wrote:

I have this code: mysql_connect ($local_host, $local_user, $local_pass); mysql_select_db ($local_db); mysql_query ("DELETE FROM tmphitsmag"); $result = mysql_query ("SELECT DISTINCT company FROM view_log WHERE company != ''"); if ($row = mysql_fetch_array($result)) {

        do {

                $magazine_path = $row['company'];
                $magazine_path = explode("/", $magazine_path);

                echo str_replace("_", " ", $magazine_path[2]) . "<br>";

                mysql_query ("INSERT INTO tmphitsmag (magazine)
VALUES                          ('$magazine_path[2]')");

what about adding the usual "or die"? mysql_query ("INSERT INTO tmphitsmag (magazine)VALUES ('$magazine_path[2]')") or die(mysql_error()); Tijnema

       } while($row = mysql_fetch_array($result));

} mysql_close(); The code dumps the first table fine, selects, manipulates, and echoes the string the way I expect, but fails to input the string into the tmphitsmag table. Any ideas? Thanks, Ed -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php