SELECT Not turining up results when going through php

[boggartlaura]

If I enter

SELECT * FROM Teams WHERE num=1

directly everything works fine.

But when I do

$sql = "SELECT * FROM Teams WHERE num=1";
$lad = mysql_query($sql) or die(mysql_error());

I don't seem to get any results. I've tried printing out different columns, as

echo $lad['column']

but I get nothing. I've tried reformatting both statements and still get nothing. When I try using mysql_fetch_array() instead of mysql_query, I get:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

I'm very very frusterated. Could someone please help me?

Thanks.

[eelixduppy]

mysql_connect("localhost","username","password");
mysql_select_db("db_name");
$sql = "SELECT * FROM Teams WHERE num=1";
$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($result)) {
echo '<pre>';
print_r($row);
echo '</pre>';
}

Try this :)