[RESOLVED] Question regarding outputting mysql table

mhodge87

I'm trying to output a sql table into a html table. Below is the code.

mysql_select_db("zid", $con);


$query = "SELECT cid, firstn, lastn, email, rating FROM userinfo ORDER BY Lname";

//gets information

$result = mysql_query($query, $con);

//creates table for displaying all on roster

echo("<table border = 1> <center>
<tr><th> CID </th>
<th> Last Name </th>
<th> First Name </th>
<th> Email </Th>
<th> Rank </th>");

while($row = mysql_fetch_array($result))
{
	echo("<tr>");
	echo("<td>" . $row['cid'] . "</td>");
	echo("<td>" . $row['firstn'] . "</td>");
	echo("<td>" . $row['lastn'] . "</td>");
	echo("<td>" . $row['email'] . "</td>");
	echo("<td>" . $row['rating'] . "</td>");
	}
echo("</table> </center>");

cid, first, lastn, email, rating, are the actual colum names in mysql. It gives me an error stating mysql_fetch_array is not a valid sql result resource. Any tips. I've looked it over and searched to try to find the answer. No luck.

QUESTION #2

If i created a file that contained the connection info such as:

connection.php


<?php

//connection file


$con = mysql_connect("localhost", "root", ""); ?>

and included it in my other php files using

 include 'connection.php';

then would I be able to call $con in my other php files using for the example at the top mysql_query($query, $con) or do i have to define $con as a global variable to do that? (hope this makes sense)

-Mike

bradgrafelman

mhodge87 wrote:
It gives me an error stating mysql_fetch_array is not a valid sql result resource.

This means that your MySQL query failed. Thus, the first step is to find out what MySQL said is wrong with your query. To do so, I normally execute queries like so:

$result = mysql_query($query, $con) or die('MySQL Error: ' . mysql_error() . "<hr>Query: $query");

Let us know what the output is so we can help diagnose the query (unless you yourself can spot the error with the aid of the MySQL error message!).

mhodge87

MySQL Error: Unknown column 'Lname' in 'order clause'

Query: SELECT cid, firstn, lastn, email, rating FROM userinfo ORDER BY Lname

there is a colum named lname. So i don't understand what it means.

bradgrafelman

Are you sure there's a column named Lname? Are you sure it's not "lastn" (as SELECT'ed in your query)?

mhodge87

Ok when i took out the "ORDER BY lname" the command worked. However, I need to have it sort the info.

bradgrafelman

Erm, did you read my above post?

mhodge87

sorry brad, didn't see your last post when i posted lol. Thanks again for your help brad. Your help in noticing the smallest of errors is very much appreciated, as well as respected. Another Thread resolved.