in reply to how do get value of mysql column

The following SQL statement should do the trick:

SELECT <column_name> FROM <table_name>

[download]

If you only want the column value for certain records, filter it like so:

SELECT <column_name> FROM <table_name> WHERE <clause>

[download]

As for a tutorial, I would suggest finding a good SQL tutorial on Google, there are tons of them.

Hope this helps...

Replies are listed 'Best First'.
Re^2: how do get value of mysql column
by bageler (Hermit) on Nov 30, 2005 at 19:00 UTC
    using dbi: 
    $sth = $dbh->prepare("SELECT column FROM table");
$sth->execute;
$column_value = $sth->fetchrow;

    [download]
[reply]
[d/l]

In Section Seekers of Perl Wisdom