db query not working as expected

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]')");

} 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

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]')");


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
>
>

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
>
>

try:

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

cajb.

Ed Curtis wrote:
> mysql_query ("INSERT INTO tmphitsmag (magazine)
> VALUES ('$magazine_path[2]')");

Replace that with this...


mysql_query ("INSERT INTO tmphitsmag (magazine) VALUES

('".mysql_real_escape_string($magazine_path[2])."')");

-Stut