Re: [PHP] db query not working
Satyam wrote: > It is an old guy thing, at least in my case (trivia: I was born the day > after the ENIAC was turned off) Young kids these days :-) I was born the month before it was turned _on_! Cheers -- David Robley Why do we read left to right yet turn pages right to left? Today is Boomtime, the 67th day of Chaos in the YOLD 3173. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] db query not working
It is an old guy thing, at least in my case (trivia: I was born the day after the ENIAC was turned off) Aha! October 3, 1955 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] db query not working
- Original Message - From: "Jochem Maas" <[EMAIL PROTECTED]> Satyam wrote: I saw two people pointing two errors on the SQL insert statement which you would have found yourself had you put the 'or die()' at the end of the query, as someone else suggested. Do never leave any query without the 'or die()' after it (or any other means to check if mysql_query returns anything not false). This would have saved lots of your time, our time, everybody's bandwidth and would avoid your asking everybody again for the next error you make. We all make errors, none of us is above that, that's why, at least in my case, I never fail to add the or die() at the end. That's why the developers of function libraries have put some means of reporting errors back. It takes time for providing good error reporting. You are wasting that effort as well. Do you deserve all this speech? yes. no error checking, no attempt at self improvement and above all no patience when it comes to waiting for an answer. ... I call 'ballistic' code: code you have no control over once it launches. Guided missiles are far better. might I suggest that the word 'better' shouldn't be used to describe any kind of missile other than a decommissioned one. 'better' ways of killing people are things generally only sought after by fundamentalists, arms-industry employees and megalomaniacs (it just springs to mind that a certain leader of the [not so] free world could happily sit in any of those categories) My apologies, it was not a happy comparison. gun analogies suck almost as much as guns, as opposed to good old rant, which, as long as they're not combined with guns are fairly harmless and quite often informative. Anyway, you got it because I had time to rant about this. we make time to rant ;-) It is an old guy thing, at least in my case (trivia: I was born the day after the ENIAC was turned off) -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.7/712 - Release Date: 06/03/2007 15:42 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] db query not working
Satyam wrote: > I saw two people pointing two errors on the SQL insert statement which > you would have found yourself had you put the 'or die()' at the end of > the query, as someone else suggested. Do never leave any query without > the 'or die()' after it (or any other means to check if mysql_query > returns anything not false). This would have saved lots of your time, > our time, everybody's bandwidth and would avoid your asking everybody > again for the next error you make. We all make errors, none of us is > above that, that's why, at least in my case, I never fail to add the or > die() at the end. That's why the developers of function libraries have > put some means of reporting errors back. It takes time for providing > good error reporting. You are wasting that effort as well. > > Do you deserve all this speech? yes. no error checking, no attempt at self improvement and above all no patience when it comes to waiting for an answer. ... > I call 'ballistic' code: code you have no control over once it launches. > Guided missiles are far better. might I suggest that the word 'better' shouldn't be used to describe any kind of missile other than a decommissioned one. 'better' ways of killing people are things generally only sought after by fundamentalists, arms-industry employees and megalomaniacs (it just springs to mind that a certain leader of the [not so] free world could happily sit in any of those categories) gun analogies suck almost as much as guns, as opposed to good old rant, which, as long as they're not combined with guns are fairly harmless and quite often informative. Anyway, you got it because I had time > to rant about this. we make time to rant ;-) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] db query not working
Satyam wrote: I saw two people pointing two errors on the SQL insert statement which you would have found yourself had you put the 'or die()' at the end of the query, as someone else suggested. Do never leave any query without the 'or die()' after it (or any other means to check if mysql_query returns anything not false). This would have saved lots of your time, our time, everybody's bandwidth and would avoid your asking everybody again for the next error you make. We all make errors, none of us is above that, that's why, at least in my case, I never fail to add the or die() at the end. That's why the developers of function libraries have put some means of reporting errors back. It takes time for providing good error reporting. You are wasting that effort as well. Do you deserve all this speech? No more than the dozens who write what I call 'ballistic' code: code you have no control over once it launches. Guided missiles are far better. Anyway, you got it because I had time to rant about this. Satyam I wasted no more bandwidth than you did with your rant. My code post was edited from the original code and that's where the mistake was made, not in the code itself. And I do, by the way, end all my queries with or die(). I just left it out of the edit. Besides, the problem is fixed now. Thanks to all that helped. Ed -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] db query not working
I saw two people pointing two errors on the SQL insert statement which you would have found yourself had you put the 'or die()' at the end of the query, as someone else suggested. Do never leave any query without the 'or die()' after it (or any other means to check if mysql_query returns anything not false). This would have saved lots of your time, our time, everybody's bandwidth and would avoid your asking everybody again for the next error you make. We all make errors, none of us is above that, that's why, at least in my case, I never fail to add the or die() at the end. That's why the developers of function libraries have put some means of reporting errors back. It takes time for providing good error reporting. You are wasting that effort as well. Do you deserve all this speech? No more than the dozens who write what I call 'ballistic' code: code you have no control over once it launches. Guided missiles are far better. Anyway, you got it because I had time to rant about this. Satyam - Original Message - From: "Ed Curtis" <[EMAIL PROTECTED]> To: Sent: Wednesday, March 07, 2007 3:28 PM Subject: [PHP] db query not working 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]) . ""; mysql_query ("INSERT INTO tmphitsmag (magazine) VALUES('$magazine_path[2]'"); } while($row = mysql_fetch_array($result)); } mysql_close(); It dumps the table fine, works the explode, outputs the string in the echo command the way I expect, but doesn't place the value in tmphitsmag table. Anyone have a clue? Thanks, Ed -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.7/712 - Release Date: 06/03/2007 15:42 -- 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
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
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]) . ""; 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
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]) . ""; 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
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]) . ""; mysql_query ("INSERT INTO tmphitsmag (magazine) VALUES('$magazine_path[2]'"); Look how many ( you have, and how many ) you have that's the problem... try mysql_query ("INSERT INTO tmphitsmag (magazine) VALUES('$magazine_path[2]')"); that should solve the problem Tijnema } while($row = mysql_fetch_array($result)); } mysql_close(); It dumps the table fine, works the explode, outputs the string in the echo command the way I expect, but doesn't place the value in tmphitsmag table. Anyone have a clue? 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
> > It dumps the table fine, works the explode, outputs the string in the > echo command the way I expect, but doesn't place the value in > tmphitsmag > table. Does it insert an empty record? JM -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php