CODEWITHSUNDEEP
php
Shashank Padwal
Shashank Padwal

Reputation: 323

PHP code run on local host but gives error on godaddy server :(

$query1="SELECT e.Enrol_id,e.Enrol_date,e.cd_id,e.S_R_id,i.info_Eid,i.Feedback_status,i.e_status from Enrollment e,info_enrol_student i where e.Enrol_id in(select     i.Enrol_id from info_enrol_student where i.ES_Email='$Email') order by     e.enrol_Date DESC";
$conq=mysqli_query($conn,$query1);
if(mysqli_num_rows($conq) > 0){
//any code
}

Above code runs on my local host but it gives an error on go daddy server

warning:mysql_num_rows() expects parameter 1 to be resource boolean given

Upvotes: 0

Views: 130

Answers (1)

Divyesh Savaliya
Divyesh Savaliya

Reputation: 2740

Two possible case for this

i). Database connection is not established
But you says Login is working so this is not a problem

ii). Compare all character in your query and check for case sensitive. Case sensitive works on local server but not works on live server

Upvotes: 1

Related Questions