good drupal.org documentation is here: http://drupal.org/node/101496 getting a single value: use db_result

$result=db_result(db_query('Select uid from {users} where uid = %d',5));

getting multiple rows: use db_query

The data is here for example for content type event_calendar:
So just look for your content type using the same naming convention.

Note I've found all these directions on making it work even when installing port php52 it simply does not work. I'm still trying to get this to work. ack.

Great post on a site that is eerily exactly like this one!
http://stevepurkiss.com/blog/steve-purkiss/2009/04/15/setting-seo-frien…

After opening a lightbox with thickbox: see http://jquery.com/demo/thickbox/

You can close the lightbox and have an href link open a url in the parent window:

Register for an Infinite Connection account.

Also to have a form and click submit but close the lightbox and have the form submit to the parent page use this code.

<?php
$output .= "
?>

this took me an hour or two to figure out, so you're welcome :)

I use the following code to conditionally show pieces of the page depending on which page the user is on:

$curr_uri = check_plain(request_uri());
//print $curr_uri;
<?php if ((!preg_match("/contact/i", $curr_uri))&&(!preg_match("/authentication-options/i", $curr_uri))&&(!preg_match("/node\/305/i", $curr_uri))) : ?>
conditional html code here
<?php or php code here to be conditionally shown?>
<?php endif; ?>

/usr/sbin/apachectl configtest
and then if that's ok
 /usr/sbin/apachectl restart

This site uses code filter module to diplay code correctly in posts.

use <pre> and <code> tags to wrap your code.

this is a p tag
this is an h1 tag 

I also put this in my style.css file in this drupal installation:

I put this in my style.css file in this drupal installation:

code, tt, pre {
background-color: #EDF1F3;
font-family: "Bitstream Vera Sans Mono",Monaco,"Lucida Console",monospace;
font-size: 0.9em;
line-height: 1.2em;
}