SELECT Not turining up results when going through php

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.

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>'; }

SELECT Not turining up results when going through php

boggartlaura

eelixduppy

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week