On 3/7/07, Ed Curtis <e_curtis@xxxxxxxxxxxxx> 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]')");
Not sure about it but try this:
mysql_query ("INSERT INTO tmphitsmag (magazine) VALUES
('".$magazine_path[2]."')");
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
