Need help getting an email in query

[monkeybidz]

I need to get the email for a user using a query. Here is what I have so far:

 

<?php
$query = "SELECT email FROM PHPAUCTIONXL_users WHERE nick='$user_nick'";

$email = mysql_query("email");//<-- <-- This is my problem. 

?>

 

I also tried this:

 

<?php
$query = "SELECT email FROM PHPAUCTIONXL_users WHERE nick='$user_nick'";
$result =mysql_query($query);
$email = mysql_query($result,0,"email");
?>

 

 

[Psycho]

<?php
$query = "SELECT email FROM PHPAUCTIONXL_users WHERE nick='$user_nick'";
$result =mysql_query($query) or die (mysql_error());
$record = mysql_fetch_assoc($result);
$email = $record['email'];
?>

[monkeybidz]

I get nothing. I have $email set to echo in page to see if there is a result, but nothing.

[trq]

Where is $user_nick defined?

[monkeybidz]

It is defined all over the page in other code not shown here and echoes OK after this query.

[trq]

It is defioned all over the page? Sounds interesting. Any reason why its defined moire than once?

 

Anyway, lets try some decent debuging.

 

<?php

$query = "SELECT email FROM PHPAUCTIONXL_users WHERE nick='$user_nick'";
if ($result =mysql_query($query)) {
  if (mysql_num_rows($result)) {
    $record = mysql_fetch_assoc($result);
    $email = $record['email'];
  } else {
    echo "No record found matching $user_nick";
  }
} else {
  echo "Query failed<br />$sql<br />" . mysql_error();
}

?>

[monkeybidz]

<?php
$query = "SELECT email FROM PHPAUCTIONXL_users WHERE nick='$user_nick'";
$result =mysql_query($query) or die (mysql_error());
$record = mysql_fetch_assoc($result);
$email = $record['email'];
?>

 

This code worked, and so did one of mine. The problem was that I set this query to only work if a form was submitted.

 

I had this above the query.

<?php 
if($_POST['Submit']) {

$query = "SELECT email FROM PHPAUCTIONXL_users WHERE nick='$user_nick'";
$result =mysql_query($query) or die (mysql_error());
$record = mysql_fetch_assoc($result);
$email = $record['email'];
?>

 

It slipped my mind.

 

Thank guys.

[trq]

Still, that is poor coding practive. My example is much better. You should always check your queries succeed and return a result before trying to use them.

[monkeybidz]

I will give it a shot. Thanks!