[SOLVED] Undefined Varibale

[monkeypaw201]

so, i am trying to run the following code:

 

$pilot_id = mysql_connect("localhost","cerulean","bluesky1701");

if (!$pilot_id)

  {

  die('Could not connect: ' . mysql_error());

  }

  mysql_select_db("cerulean_site", $pilot_id);

  $result = mysql_query("SELECT * FROM pilots ORDER BY pilot_id DESC");

 

$pilot_id=$row['pilot_id'];

 

and its throwing a weird error about an undefined variable

 

Notice: Undefined variable: row

[kenrbnsn]

You haven't defined the array $row anywhere.

 

Ken

[monkeypaw201]

but this is giving me the same error:

 

$pilot_id = mysql_connect("localhost","cerulean","bluesky1701");

if (!$pilot_id)

  {

  die('Could not connect: ' . mysql_error());

  }

  mysql_select_db("cerulean_site", $pilot_id);

  $result = mysql_query("SELECT * FROM pilots ORDER BY pilot_id DESC");

 

$pilot_id=$row_pilot_id['pilot_id'];

[Caesar]

What the above poster said.  Maybe you forgot to grab the results from your query...

 

<?php

  while($row = mysql_fetch_array($result)) {
    //Do what you've got to do.
  }

?>

 

If you only want one record/row...

<?php

  $row = mysql_fetch_array($result);

?>

 

 

You are saying that "$pilot_id" equals something yuou have not defined.

[monkeypaw201]

worked perfectly, thx