RE: WHERE doesn'r works

2006-04-23 Thread Jay Blanchard
[snip] The php and db structure and data are attacheds. Two infos: 1) Im not a expert 2) The code is in the beggining of the development, so are too many uglyness yet =) [/snip] Find a place online to post your code or paste it into the message (only the relevant parts). Usually no one will

RE: WHERE doesn'r works

2006-04-23 Thread Jay Blanchard
[snip] Find a place online to post your code or paste it into the message (only the relevant parts). Usually no one will open an attachment on a mailing list. [/snip] Post the line of PHP where this query exists. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: WHERE doesn'r works

2006-04-23 Thread Tom Lobato
From: Jay Blanchard [EMAIL PROTECTED] Find a place online to post your code or paste it into the message (only the relevant parts). Usually no one will open an attachment on a mailing list. Oh Yes, sorry. In really, I indeed uploaded the files to the server www.spalha.com.br/spalha. Tom

Re: WHERE doesn'r works

2006-04-23 Thread Tom Lobato
From: Jay Blanchard [EMAIL PROTECTED] Post the line of PHP where this query exists. Well, I think that show $result = mysql_query($command); won't help us, because the $command indeed begins to be constructed 120 lines before this. Only looking the code =( Tom -- MySQL

RE: WHERE doesn'r works

2006-04-23 Thread Quentin Bennett
5:00 a.m. To: mysql@lists.mysql.com Subject: Re: WHERE doesn'r works From: Jay Blanchard [EMAIL PROTECTED] Post the line of PHP where this query exists. Well, I think that show $result = mysql_query($command); won't help us, because the $command indeed begins to be constructed 120

Re: WHERE doesn'r works

2006-04-23 Thread Tom Lobato
Solved =) From: Quentin Bennett [EMAIL PROTECTED] Have you tried turning on the logging on the MySQL server, and seeing exactly what command the server is receiving - it may be different from the one (you think) you are sending. Turning on the logging on the MySQL server, I saw PHP

Re: WHERE doesn'r works

2006-04-22 Thread Tom Lobato
From: [EMAIL PROTECTED] you really need to show your php code and the output from an echo of the update line so that people can try to spot what you're doing wrong. from what i've seen, people are basically just guessing at the issue with you saying tried that, didn't work. updating mysql

Re: WHERE doesn'r works

2006-04-22 Thread Rhino
- Original Message - From: Tom Lobato [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, April 22, 2006 4:03 AM Subject: Re: WHERE doesn'r works From: [EMAIL PROTECTED] you really need to show your php code and the output from an echo of the update line so that people can

Re: WHERE doesn'r works

2006-04-22 Thread Tom Lobato
From: Rhino [EMAIL PROTECTED] Most of the time, when I see a column named 'id', it is defined as an integer. If _your_ 'id' column is defined as an integer, then the reason your WHERE clause is failing is very simple: Your WHERE clause is looking for all the rows where the 'id' value is a

Re: WHERE doesn'r works

2006-04-22 Thread Rhino
- Original Message - From: Tom Lobato [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, April 22, 2006 4:18 PM Subject: Re: WHERE doesn'r works From: Rhino [EMAIL PROTECTED] Most of the time, when I see a column named 'id', it is defined as an integer. If _your_ 'id