mySQL query works on phpMyadmin but not in server

[sbayter]

Hi,
I have mySQL db and a simple page with a query which displays the db.
The page was working perfect but when I added dos more columns to the db it stoped working and now it doesn't display anything.
When I run the query in phpMyadmin it show all the info. but when i upload it to the server, it does not work.
Ann suggestions?
Thanks,

sbayter

 

[sleipnir214]

What does this question have to do with PHP?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[DRJ478]

What are the differences?

1. Compare the connection parameters - user, host, pass.
2. What is the error returned?
3. What is the SQL statement?

This will help to clarify.

 

[sbayter]

This is a php page.

The query looks like this:

mysql_select_db($database_survey, $survey);
$query_Recordset = "SELECT * FROM customers";
$Recordset = mysql_query($query_Recordset, $survey) or die(mysql_error());
$row_Recordset = mysql_fetch_assoc($Recordset);
$totalRows_Recordset = mysql_num_rows($Recordset);

What I don't understand is that I only added two columns. It was working perfectly before then.



sbayter

 

[sbayter]

... and it doesn't display any error.
It just displays an empty table.

sbayter

 

[DRJ478]

You have no errorcheck in the line where you select the database. Please add that, also in the connection line.

Did you check the access parameters?

 

[sbayter]

I already have the errorcheck in my conection.
I'm relatively new to php.
What do you mean by access parameters? you mean the permissions? i so, i guess they are ok 'cause it was working before.

sbayter

 

[DRJ478]

Does your PHP script use the correct username, host, password?
Is the username allowed to connect to the mysql server from that IP?
Is the username allowed to access the database in question?

Something changed. We just need to track down what.

 

[sbayter]

for the 3 questions the answer is yes.
Do you think the db could be losing its data when it is uploaded? can that happen?

sbayter

 

[DRJ478]

I do not believe that's possible.
You say that the query works fine issued from PHPMyAdmin. There is no difference to sending it from another PHP application. The reason must lie somewhere else.

I assume you are using the same server for PHPMyAdmin and the 'uploaded' version. Right?

 

[sbayter]

I'm sure it is the same.
I'm really confused about this. I only added two columns, how big is that!!! :S

sbayter

 

[DRJ478]

Can you access MySQL fom the command line, log in, and issue the query?

 

[sbayter]

Yes,
I tried that but it is also empty this is why i think the data is getting corrupted on the upload.
Any other suggestions?
Thanks,

sbayter