[SOLVED] mysql fetch array error

[SEVIZ]

Here is my code

<?php
$con = mysql_connect("--------","------------","-----------");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

$result = mysql_query("SELECT * FROM sprint WHERE id=7710");

while($row = mysql_fetch_array($result))
  {
  echo $row['num'] . " " . $row['name'];
  }

?>

 

I get this error:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /techdb.php on line 10

 

What am I missing here?

[gevans]

You haven't chosen a db;

 

http://uk2.php.net/manual/en/function.mysql-select-db.php

[Ken2k7]

Or just run the SQL "use dbname" where dbname is the name of the DB.