'SELECT' error on database?

Hi all..

Lately I've been getting a lot of e-mails about errors on my directory's database. I am displayed this:

SELECT FAILED ON: SELECT link_id, link_url, link_title FROM tbl_links
WHERE link_url = ""


Anyone knows what might be the problem?

 

Does it display the error?

Have you tried using single quotes instead of double?

What database are you using?

 

I'm using sql. It doesn't display the error but whenever someone tries to place a bid on my directory, I get an e-mail sent to me with the above message.

Is it showing this error because it can't find the table?

I don't think this error is related to quotes...

 

Do you mean mySQL? Or SQL Server?

It's difficult to know what the problem is without knowing what kind of error you are getting. You sql statement looks fine. Make sure your table exists as well as all of the columns.

 

I agree , statement looks fine.. Give us more on the error

 

If you are using MySQL and PHP, use mysql_error() to get the error message. It is nearly impossible to guess that what could be the error.