Need help listing data from one column

[Gary_King]

What I want to do, is to echo the data in one column, when I send the data that is in another column, but in the same row.

For example, here is my table:

Table name: customers

firstName | lastName | emailAddress
------------------------------------------------------
John | Doe | [email=[e-mail]][e-mail][/email]
Jane | Doe | [email=[e-mail]][e-mail][/email]
Michael | Smith | [email=[e-mail]][e-mail][/email]

Now, when I ask for Jane in column firstName, I want to echo Doe, which is in the column lastName. How can I do this?

P.S.
So far I've got SELECT lastName FROM customers WHERE firstName=lastName, but I can specify which row I want to pull data from.

Thanks in advance!

[leatherback]

Hi try something like:

$query = "select * from customers where firstName = 'jane' ";
$result = mysql_query($query);

while $row=mysql_fetch_array($result)
  {
  echo $row[lastName];
  }

Cheers,

J.

[Gary_King]

Thank you very much, works great 😃

[leatherback]

Programming is easy. All you have to do is find the right keys to hit

😉

[Gary_King]

Yes, I know how to program; I just didn't know about this particular SQL function.