<div>
ok so an alias is a 'name' that follows the table. i get it, and i can look it up now. <br />
<br />
thanks
</div>


ok so an alias is a 'name' that follows the table. i get it, and i can look it up now.

thanks

<div>
<div class="content wysiwyg-content">
i have a question about this query:<br />
<br />
db_query_range('SELECT c.* FROM {comments} c WHERE c.status = %d ORDER BY c.timestamp', COMMENT_NOT_PUBLISHED, 0, $num_posts);<br />
<br />
i understand the query, but the c.* and c.status.... what's happening here? is the table name &gt;&gt;&gt;&nbsp;comments being turned into a nickname or variable? one called &gt;&gt;&nbsp;c. it would normally be comments.status right? and comments.*<br />
<br />
i know the brackets are a drupalism so maybe the c is also.<br />
<br />
thanks for your help<br />
tony<br />
<br />
<br />

</div>
</div>


i have a question about this query:

db_query_range('SELECT c.* FROM {comments} c WHERE c.status = %d ORDER BY c.timestamp', COMMENT_NOT_PUBLISHED, 0, $num_posts);

i understand the query, but the c.* and c.status.... what's happening here? is the table name >>> comments being turned into a nickname or variable? one called >> c. it would normally be comments.status right? and comments.*

i know the brackets are a drupalism so maybe the c is also.

thanks for your help
tony




drupal query question

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.