Help with a function

[davidlee_hemphi]

Hi guys. This may seem kind of noobish, but here goes.

I'm trying to write a function that, when passed a single variable that corresponds to a row in a database, I want it to output the contents from a different field in the same row.

Say I have a table set up like this:

========================

ID | theName | Content |

1 | Example | examples content |

I want the function to look like this:

function getData($name) {

//code here

}

If the variable sent to the function was Example, I want it to find the row whos name is Example and return the Content from that same row. Does that make sense?

[drew010]

function getData($name) {
  //you should be connected to the database or do it here.

  $name = addslashes($name);
  $q = "select * from `table` where `theName` = '$name'";
  $r = mysql_query($q);

  if (mysql_num_rows($r) > 0) {
    $data = mysql_fetch_array($r);
    echo "ID: {$data['id']}   -    Content: {$data['content']}<br />\n";
  } else {
    echo "No record found with that name.<br />\n";
  }
}

[leatherback]

You could even afncy it up a bit more:

function getData($name, $colum) {
  //you should be connected to the database or do it here.

  $name = addslashes($name);
  $q = "select * from `table` where `$colum` = '$name'";
  $r = mysql_query($q);

  if (mysql_num_rows($r) > 0) {
    $data = mysql_fetch_array($r);
    echo "ID: {$data['id']}   -    Content: {$data['$colum']}<br />\n";
  } else {
    echo "No record found with that name.<br />\n";
  }
}  

[davidlee_hemphi]

Oh man, it couldn't have been more simple. I should've known that. But hey, thanks for the code drew010 & leatherback