MySQL

Query Problem

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2005

Posts: 4

Reputation: pgroover is an unknown quantity at this point

Solved Threads: 0

pgroover

Offline

Newbie Poster

Query Problem

Mar 19th, 2005

Okay, not new to MySQL, or PHP, but I'm really lost on this one. I have a query (simple one really) that is supposed to return the requested values from a database. I've tested the query with MySQL direct and it works fine, but when used via the web interface, it chokes and doesn't get a valid result resource.

I don't understand how a valid query can work with MySQL directly but not with the web interface. I've added the query below:

SELECT GUID, FirstName, LastName, Address, Address1, City, State, Zip, Phone, Email, Company, Remove FROM databasename WHERE GUID = '$id'

$id would of course be a POSTed variable. I've also tried this using "SELECT * from databasename" and it also fails for the same reason. Of course, my first thought was something simple so I pasted a working query from another function and it also failed. Nothing is any different for the connection as it's the only one used. And yes, all the column names are correct.

What am I missing?

thx,
Plenty

•

Join Date: Oct 2004

Posts: 348

Reputation: paradox814 is an unknown quantity at this point

Solved Threads: 4

paradox814 paradox814 is offline

Offline

Posting Whiz

Re: Query Problem

Mar 20th, 2005

perhaps you are not logged in with the correct username/password combination

if you do have a correct user name/password then...
maybe the one you have doesn't have access to SELECT statments on that database and/or table

try doing this...

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
<?
$server = "localhost";
mysql_connect ($server, $user, $password) OR die ('I cannot connect to the database because: ' . mysql_error());
 
mysql_select_db ($database) OR die ("cannot connect to the datbase");
 
$result = mysql_query("SELECT * FROM databasename");
if ($result == 0)
{
   echo("<b>Error " . mysql_errno() . ": " . mysql_error() . "</b>");
}
ELSE
{
    echo "the query worked!";
}
<?
$server = "localhost";
mysql_connect ($server, $user, $password) or die ('I cannot connect to the database because: ' . mysql_error());

mysql_select_db ($database) or die ("cannot connect to the datbase");

$result = mysql_query("SELECT * FROM databasename");
if ($result == 0)
{
   echo("<b>Error " . mysql_errno() . ": " . mysql_error() . "</b>");
}
else
{
    echo "the query worked!";
}

hopefully the error message generated gives you enough information to solve your problems. try usign localhost for your host name instead of your domain name.

http://www.brangle.com/

•

Join Date: Mar 2005

Posts: 4

Reputation: pgroover is an unknown quantity at this point

Solved Threads: 0

pgroover

Offline

Newbie Poster

Re: Query Problem

Mar 20th, 2005

Actually, I use the same connection for all the queries so that rules out the incorrect login/password. Further, I've tried successfully used the query against the database directly, as well as taken other queries known to be good and tried them, but they all fail just in this block of code.

I had also tried as you suggested, but result is actually "1" afterwards, shouldn't it be "Resource ID#x"?? I'll still go back and try again, but I'm not to hopeful...

I know I'm missing something, but I just can't seem to get it.

Thanks.

•

Join Date: Feb 2005

Posts: 355

Reputation: DanceInstructor is an unknown quantity at this point

Solved Threads: 14

DanceInstructor DanceInstructor is offline

Offline

Posting Whiz

Re: Query Problem

Mar 24th, 2005

Post your origional php code for the query.

Clear Mind Hosting and Web Design

If I've helped you please consider adding to my reputation.

•

Join Date: Mar 2005

Posts: 2

Reputation: synergz is an unknown quantity at this point

Solved Threads: 0

synergz

Offline

Newbie Poster

Re: Query Problem

Mar 30th, 2005

Take a look at your apache error log, often you will get an insight there into how a query has failed. In most linux systems its under /var/logs/apache