Topic awaiting preservation: mysql_fetch_array() problem? (Page 1 of 1)

Please can you help, i connect to my database, but then I cannot get the data from my table. (I am trying to send it to the browser)

mysql_select_db("projectg");

	$query = "SELECT modCode, modTitle ";

	$query = "FROM lecfiles ";

	$query = "ORDER BY modTitle ASC";



	$result = mysql_query($query);



	if (!$result) {

	echo "...............Couldn't get file list";

		}



while($row = mysql_fetch_array($result))

	            {

		php echo "{$row['modCode']}"; 

		php echo "{$row['modTitle']}";

	          }

I am well and truly baffled.

I get the following error in my browser...

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\...\...\...

Any Ideas?

Gee

Sorry, I fixed it.

I had been debugging this script for 2 hours...
And you know what it was, 2 little dots . .

$query = "SELECT modCode, modTitle ";

$query .= "FROM lecfiles ";

$query .= "ORDER BY modTitle ASC";

I tried to delete the post but it wouldnt let me.

Sorry once again.

Gee

Unless you're dynamically building a query based on other conditions, there's no real reason not to just "SELECT field1, field2 FROM table WHERE stuff=things". And even if the query is dependent on conditions, you can "SELECT $value, $value FROM $table WHERE $value = $value" -- as long as your query is contained in double quotes, variables will be expanded.