StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POmy script working on my localhost while not working on internet hosting
primarykey
Id
10547404
data
AcceptedAnswerId
10547770
AnswerCount
2
ClosedDate
CommentCount
7
CommunityOwnedDate
CreationDate
2012-05-11T07:42:35.460
FavoriteCount
0
LastActivityDate
2012-05-11T08:44:02.077
LastEditDate
2012-05-11T08:07:53.623
LastEditorUserId
1388852
OwnerUserId
1388852
ParentId
0
PostTypeId
1
Score
0
ViewCount
337
LastEditorDisplayName
text
Body
<p>I got this warning on the web hosting, on page (report-hours-male.php) as following</p> <pre><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></pre> <p>my problem is: The script is working fine on my localhost >> on my computer while not working on internet hosting !!!!!</p> <p>this is the page</p> <pre><code> <?php include 'config.php'; ?><BR> Report for year <?php echo $_SESSION['year']; ?> semester <?php echo $_SESSION['sem']; ?> <?php // list of teachers Table rows and total hours echo "<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>"; ?>  <html> <head>  <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 = 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>  <center><div id="chart_div"></div></center> <form> <input type="button" value="Print This Report" onclick="window.print();"> </form> </body> </html> <?php ob_end_flush(); ?> </code></pre> <p>this is th config.php</p> <pre><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></pre> <p>help me please :(</p>
Tags
<php><mysql><warnings>
Title
my script working on my localhost while not working on internet hosting
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USHatim
UserOwnerUserId
1. USHatim
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.