[PHP] 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] db query not working as expected
On 3/7/07, Ed Curtis [EMAIL PROTECTED] 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
Re: [PHP] db query not working as expected
On 3/7/07, Ed Curtis [EMAIL PROTECTED] 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
Re: [PHP] db query not working as expected
try: mysql_query (INSERT INTO tmphitsmag (magazine) VALUES ('{$magazine_path[2]}')); cajb. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] db query not working as expected
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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php