keelfenlign
New Member
I got this warning on the web hosting, on page (report-hours-male.php) as following\[code\]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/hatimmak/public_html/ssp12/report-hours-male.php on line 28\[/code\]my problem is:The script is working fine on my localhost >> on my computerwhile not working on internet hosting !!!!!this is the page\[code\] <?phpinclude 'config.php';?><BR>Report for year <?php echo $_SESSION['year']; ?> semester <?php echo $_SESSION['sem']; ?> <?php // list of teachers Table rows and total hoursecho "<table border='0' id='hor-minimalist-b' ><tr><th scope='col'>Instructor name</th><th scope='col'>Total hours for this semester</th></tr>"; //$gender = $_SESSION['gender']; $year = $_SESSION['year']; $sem = $_SESSION['sem']; $tab = "Report$year$sem"; $query = "SELECT teacher, SUM(hours) FROM $tab GROUP BY teacher"; $result = mysql_query($query) ;while($row = mysql_fetch_array($result)){ $time = gmdate(DATE_RFC822); //$gender = $_SESSION['gender']; $year = $_SESSION['year']; $sem = $_SESSION['sem']; //$teacher = $_row['teacher']; //$sumhours = $_row['SUM(hours)'];echo "<tr>";echo "<td> ". $row['teacher']." </td>";echo "<td> ". $row['SUM(hours)']." </td>";echo "</tr>";}echo "</table>";?><!--chart--><html> <head> <!--Load the AJAX API--> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript"> // Load the Visualization API and the piechart package. google.load('visualization', '1.0', {'packages':['corechart']}); // Set a callback to run when the Google Visualization API is loaded. google.setOnLoadCallback(drawChart); // Callback that creates and populates a data table, // instantiates the pie chart, passes in the data and // draws it. function drawChart() { // Create the data table. var data = http://stackoverflow.com/questions/10547404/new google.visualization.DataTable(); data.addColumn('string', 'Topping'); data.addColumn('number', 'hours'); data.addRows([<?php $queryr = "SELECT teacher, SUM(hours) FROM $tab GROUP BY teacher"; $resultr = mysql_query($queryr) ;while($rowr = mysql_fetch_array($resultr)){ $teacherr = $_rowr['teacher']; $sumhoursr = $_rowr['SUM(hours)'];echo "['".$rowr['teacher']."' , ".$rowr['SUM(hours)']."]," ;}?> ['', 0] ]); // Set chart options var options = {'title':'Contact hours/instructor', 'legend':'left', 'is3D':true, 'width':800, 'height':300}; // Instantiate and draw our chart, passing in some options. var chart = new google.visualization.BarChart(document.getElementById('chart_div')); chart.draw(data, options); } </script> </head> <body> <!--Div that will hold the pie chart--> <center><div id="chart_div"></div></center> <form><input type="button" value="http://stackoverflow.com/questions/10547404/Print This Report" onclick="window.print();"> </form> </body></html><?phpob_end_flush();?>\[/code\]this is th config.php\[code\]<?php$con = mysql_connect("localhost","hatimmak_ssp","userpass");if (!$con) { die('Could not connect: ' . mysql_error()); }$sel = mysql_select_db("hatimmak_ssp", $con) or die();?>\[/code\]help me please 