[SOLVED] Selecting a single field from a row and assign it to a variable?

[clay1]

I am having some difficulty wrapping my head around this.

 

I want to select a single value from a table for example:

 

pg_query($conn, "select email from markets where market = richmond");

 

I want to assign that to variable $email

 

pg_query gives me resource id #9

 

What do I need to do to get assign the email to the variable?

 

 

[Zane]

what have you tried so far?

[clay1]

I haven't made it past the pg_query

 

I tried $email = pg_query(....)

 

but when I echo it I just get resource id #9

[Zane]

This is straight from the manual for pg_query

 

Example #1 pg_query() example

.

.

.

.

.

$result = pg_query($conn, "SELECT author, email FROM authors");
if (!$result) {
  echo "An error occured.\n";
  exit;
}

while ($row = pg_fetch_row($result)) {
  echo "Author: $row[0]  E-mail: $row[1]";
  echo "
\n";
}

?>

[clay1]

I need a loop for a single field from a single row?

[Zane]

not if you don't want a loop

just do it once if that's all you need to do it..you're the coder