All pastes #165896 Raw Edit

Untitled

public text v1 · immutable
·published 2006-09-10 09:34 UTC
rendered paste body
<?php
$sql = mysql_connect(Like I am going to tell you this ;))
   or die('Could not connect: ' . mysql_error() . "<br />");
echo 'Connected successfully <br />';
mysql_select_db('lsproc_icms') or die('Could not select database <br />');
$query = 'SELECT id FROM news';
$result = mysql_query($query) or die('Query failed: ' . mysql_error() . "<br />");
echo 'Post ID is:' . print_r(mysql_fetch_array($result, MYSQL_BOTH)) . '<br />';
mysql_free_result($result);
$query = 'SELECT title FROM news';
$result = mysql_query($query) or die('Query failed: ' . mysql_error() . "<br />");
echo 'Post Title is:' . print_r(mysql_fetch_array($result, MYSQL_BOTH)) . '<br />';
mysql_free_result($result);
$query = 'SELECT text FROM news';
$result = mysql_query($query) or die('Query failed: ' . mysql_error() . "<br />");
echo 'Post Text is:' . print_r(mysql_fetch_array($result, MYSQL_BOTH)) . '<br />';
mysql_free_result($result);
$query = 'SELECT moretext FROM news';
$result = mysql_query($query) or die('Query failed: ' . mysql_error() . "<br />");
echo 'Post Extended Text is:' . print_r(mysql_fetch_array($result, MYSQL_BOTH)) . '<br />';
mysql_free_result($result);
$query = 'SELECT poster FROM news';
$result = mysql_query($query) or die('Query failed: ' . mysql_error() . "<br />");
echo 'Post Poster is:' . print_r(mysql_fetch_array($result, MYSQL_BOTH)) . '<br />';
mysql_free_result($result);
$query = 'SELECT date FROM news';
$result = mysql_query($query) or die('Query failed: ' . mysql_error() . "<br />");
echo 'Post Date is:' . print_r(mysql_fetch_array($result, MYSQL_BOTH)) . '<br />';
mysql_free_result($result);
$query = 'SELECT catagory FROM news';
$result = mysql_query($query) or die('Query failed: ' . mysql_error() . "<br />");
echo 'Post Catagory is:' . print_r(mysql_fetch_array($result, MYSQL_BOTH)) . '<br />';
mysql_free_result($result);
echo 'All done. <br />';
mysql_close($sql);
echo 'Connection closed.';
?>