Pull data from a Column insted of a row

Forum|Forum|16 years ago
March 24, 2010
1 reply
372 views

I know how to pull data from a row of an mysql db. But how do I pull the data on the same COLUMN in a MYSQL db? What do I need to send to the server side script?

E.g. The mysql holds 2 field names "COMPANY" and "CONTACT PERSON". How do I pull all the COMPANY names only?

Is this possible?

ActionScript

This topic has been closed for replies.

Correct answer kglad

use something like:

$result = mysql_query("SELECT * FROM " .$tableName. " WHERE 1");

kglad

Correct answer

Community Expert

use something like:

$result = mysql_query("SELECT * FROM " .$tableName. " WHERE 1");

R

Ron ColmenAuthor

Inspiring

Thanks - I got it!

kglad

Community Expert

you're welcome.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded