MySQL Forums
Forum List  »  PHP

Problem: mysql queries does no return result....
Posted by: Orestis Apostolopoulos
Date: December 07, 2005 02:17AM

Hi... I'm Orestis from Greece...

I working on a helpdesk for my univercity using mysql 4, php 4 and IIS for locally design and testing...
The I send with ftp the file in a linux server....

Locally everything works perfect... (connect, queries)

When I try to run it from the site the execution of php file stop at sql queries...

I try to check the privilege of root in sql server but he has it all...
I can't thing anything else....

PLEASE HELP....

Here is a part of the code:

$link = mysql_connect("localhost","root","") or die("Could not connect");
mysql_select_db("helpdesk2") or die("Could not select database");
$Result = mysql_query("SELECT * FROM Administrator") or die('Could not execute query');<---- STOPS HERE!!!! prints 'Could not execute query'

If i remove the die from query then print:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in

Thanks....

Options: ReplyQuote


Subject
Written By
Posted
Problem: mysql queries does no return result....
December 07, 2005 02:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.