"); echo 'Connected successfully
'; mysql_select_db('lsproc_icms') or die('Could not select database
'); $query = 'SELECT id FROM news'; $result = mysql_query($query) or die('Query failed: ' . mysql_error() . "
"); echo 'Post ID is:' . print_r(mysql_fetch_array($result, MYSQL_BOTH)) . '
'; mysql_free_result($result); $query = 'SELECT title FROM news'; $result = mysql_query($query) or die('Query failed: ' . mysql_error() . "
"); echo 'Post Title is:' . print_r(mysql_fetch_array($result, MYSQL_BOTH)) . '
'; mysql_free_result($result); $query = 'SELECT text FROM news'; $result = mysql_query($query) or die('Query failed: ' . mysql_error() . "
"); echo 'Post Text is:' . print_r(mysql_fetch_array($result, MYSQL_BOTH)) . '
'; mysql_free_result($result); $query = 'SELECT moretext FROM news'; $result = mysql_query($query) or die('Query failed: ' . mysql_error() . "
"); echo 'Post Extended Text is:' . print_r(mysql_fetch_array($result, MYSQL_BOTH)) . '
'; mysql_free_result($result); $query = 'SELECT poster FROM news'; $result = mysql_query($query) or die('Query failed: ' . mysql_error() . "
"); echo 'Post Poster is:' . print_r(mysql_fetch_array($result, MYSQL_BOTH)) . '
'; mysql_free_result($result); $query = 'SELECT date FROM news'; $result = mysql_query($query) or die('Query failed: ' . mysql_error() . "
"); echo 'Post Date is:' . print_r(mysql_fetch_array($result, MYSQL_BOTH)) . '
'; mysql_free_result($result); $query = 'SELECT catagory FROM news'; $result = mysql_query($query) or die('Query failed: ' . mysql_error() . "
"); echo 'Post Catagory is:' . print_r(mysql_fetch_array($result, MYSQL_BOTH)) . '
'; mysql_free_result($result); echo 'All done.
'; mysql_close($sql); echo 'Connection closed.'; ?>