Can some one please write a dql query so I can do the folwoing.

Retreive the names ans emails of all people in my database

SELECT name_field_name, email_field_name FROM table_name

MySQL ERROR:

Error Number: 1146

Description: Table ‘database875389.table_name’ doesn’t exist

Query: SELECT SQL_CALC_FOUND_ROWS name_field_name, email_field_name FROM table_name LIMIT 0, 100

It produced no output. Is there anything I have to modify?

Try,

I think what EugeneS was showing above was more a generic fill it in yourself type of query

Hope that helps a bit.

You could also go further with this and just return the member_id and then embed or place the Custom Profile Field Tag within the query to get at all their information but that’s for another day perhaps?

Best wishes,

Mark