Im trying to select the title column from a particular row
$eventid = $_GET['id'];
$field = $_GET['field'];
$result = mysql_query("SELECT $field FROM `events` WHERE `id` = '$eventid' ");
echo $result;
all i get is Resource id #19
How should i do this? What is best method?
Read the manual, it covers it very well: http://php.net/manual/en/function.mysql-query.php
Usually you do something like this:
while ($row = mysql_fetch_assoc($result)) {
echo $row['firstname'];
echo $row['lastname'];
echo $row['address'];
echo $row['age'];
}
And escape your values with mysql_real_escape_string since PHP6 won't do that for you anymore! :)
Try this:
echo mysql_result($result, 0);
This is enough because you are only fetching one field of one row.
Source: Stackoverflow.com