Ubuntu
mysql-5.5 package

Mysql SELECT doesn't work

Asked by Serge Girard

I have a PHP website application which is running fine under Windows.
However, one specific SELECT statement refuses to give result:

value Resource id #20
Rows 0.

When changing the WHERE forcing to give all the values and then looping (while row...) and testing if my key==was found does'nt work as well.

Any idea what is happening?

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu mysql-5.5 Edit question
Assignee:
No assignee Edit question
Solved by:
Serge Girard
Solved:
Last query:
Last reply:

This question was originally filed as bug #920435.

Revision history for this message
Jean-Baptiste Lallement (jibel) said : 		#1

Thank you for taking the time to report this issue and helping to make Ubuntu better. Examining the information you have given us, this does not appear to be a bug report so we are closing it and converting it to a question in the support tracker. We appreciate the difficulties you are facing, but it would make more sense to raise problems you are having in the support tracker at https://answers.launchpad.net/ubuntu if you are uncertain if they are bugs. For help on reporting bugs, see https://help.ubuntu.com/community/ReportingBugs#When%20not%20to%20file%20a%20bug. There is also a vibrant support community available at http://askubuntu.com and you might consider asking your question there.

Revision history for this message
Serge Girard (sergegirard) said : 		#2

Just installed Opera 11.60 for Ubuntu and this works fine, so I think it is a problem in Mozilla Firefox 3.6.24

Revision history for this message
Serge Girard (sergegirard) said : 		#3

Hello Jean-Baptiste,

I just solved (a bit) of this problem.

I installed Opera and this seems to work, so the problem lies within Mozilla
Firefox 3.6.24.
Is this a bug?

Grtz,

Serge

----- Original Message -----
From: "Jean-Baptiste Lallement" <email address hidden>
To: <email address hidden>
Sent: Monday, January 23, 2012 3:06 PM
Subject: Re: [Question #185573]: Mysql SELECT doesn't work

Your question #185573 on Ubuntu changed:
https://answers.launchpad.net/ubuntu/+question/185573

Jean-Baptiste Lallement posted a new comment:
Thank you for taking the time to report this issue and helping to make
Ubuntu better. Examining the information you have given us, this does
not appear to be a bug report so we are closing it and converting it to
a question in the support tracker. We appreciate the difficulties you
are facing, but it would make more sense to raise problems you are
having in the support tracker at https://answers.launchpad.net/ubuntu if
you are uncertain if they are bugs. For help on reporting bugs, see
https://help.ubuntu.com/community/ReportingBugs#When%20not%20to%20file%20a%20bug.
There is also a vibrant support community available at
http://askubuntu.com and you might consider asking your question there.

--
You received this question notification because you asked the question.

Revision history for this message
marcus aurelius (adbiz) said : 		#4

okay. what does MySQL select statement have to do with firefox or opera?

Revision history for this message
Serge Girard (sergegirard) said : 		#5

It was Javascript/AJAX working different for FF.
Problem solved.

Revision history for this message
Serge Girard (sergegirard) said : 		#6

Problem solved.