3 column to 2 column?
here is sidebar.php:
-
<div id="sidebar_left" class="sidebar">
-
-
-
<div id="logo">
-
<h3><a href="http://gcm.syr.edu/_/snippetz/wp-admin/%3C?php bloginfo(’url’) ?>/"><!–p bloginfo(‘name’)–></a><!–alternative color <a class="logoalt" href="/" mce_href="/"></a> –></h3>
-
</div>
-
<div id="aboutme">
-
<ul>
-
<li><img src="http://gcm.syr.edu/_/snippetz/wp-admin/%3C?php bloginfo(’template_url’) ?>/images/aboutme.gif" alt="About me" /><strong>About</strong>
-
<!–p bloginfo(‘description’)–></li>
-
</ul>
-
</div>
-
<div id="navcontainer">
-
<ul id="navlist"><!–p wp_list_pages(‘title_li=&depth=1′);–></ul>
-
</div>
-
<h2>Categories</h2>
-
<ul>
-
<li>
-
<ul>
-
<li><!–p_tag_cloud();–></li>
-
</ul>
-
</li>
-
<!–p wp_list_cats(‘&title_li=’); ?></ul>
-
<h2>Tag Cloud</h2>
-
<!–p }–></ul>
-
-
-
<!–p endif;–>
-
-
-
-
</div>
-
<div id="sidebar_right" class="sidebar">
-
<div class="search"><form id="searchform" action="<?php bloginfo(’url’); ?>" accept-charset="UNKNOWN" enctype="application/x-www-form-urlencoded" method="get"><input id="search_query" class="searchinput" maxlength="2147483647" name="s" size="20" type="text" value="<?php echo wp_specialchars($s, 1); ?>" /> <input class="searchbutton" maxlength="2147483647" size="20" type="submit" value="Find" /> </form></div>
-
</div>
-
<!–p if ( !function_aexists(‘dynamic_sidebar’) || !dynamic_sidebar(’sidebar_right’) ) :–>
-
<h2>Archives</h2>
-
<ul><!–p wp_get_archives(‘type=monthly’);–></ul>
-
<ul><!–p<br–>if (wp_version()==‘20′) {
-
echo ‘
-
<h2>Links</h2>
-
‘;
-
get_links(‘1′,‘
-
<li>’,‘</li>
-
‘,”,false,‘name’,false);
-
}
-
else {
-
<h2>’, ‘title_after’ => ‘</h2>
-
‘, ‘category_before’ => ”, ‘category_after’ => ”));
-
}
-
?></ul>
-
<!–p endif;–>
-
<div id="logo">
-
<h3><a href="http://gcm.syr.edu/_/snippetz/wp-admin/%3C?php bloginfo(’url’) ?>/"><!–p bloginfo(‘name’)–></a><!–alternative color <a class="logoalt" href="/" mce_href="/"></a> –></h3>
-
</div>
-
<div id="aboutme">
-
<ul>
-
<li><img src="http://gcm.syr.edu/_/snippetz/wp-admin/%3C?php bloginfo(’template_url’) ?>/images/aboutme.gif" alt="About me" /><strong>About</strong>
-
<!–p bloginfo(‘description’)–></li>
-
</ul>
-
</div>
-
<div id="navcontainer">
-
<ul id="navlist"><!–p wp_list_pages(‘title_li=&depth=1′);–></ul>
-
</div>
-
<h2>Categories</h2>
-
<ul>
-
<li>
-
<ul>
-
<li><!–p_tag_cloud();–></li>
-
</ul>
-
</li>
-
<!–p wp_list_cats(‘&title_li=’); ?></ul>
-
<h2>Tag Cloud</h2>
-
<!–p }–></ul>
-
-
-
<!–p endif;–>
-
-
-
<div id="sidebar_right" class="sidebar">
-
<div class="search"><form id="searchform" action="<?php bloginfo(’url’); ?>" accept-charset="UNKNOWN" enctype="application/x-www-form-urlencoded" method="get"><input id="search_query" class="searchinput" maxlength="2147483647" name="s" size="20" type="text" value="<?php echo wp_specialchars($s, 1); ?>" /> <input class="searchbutton" maxlength="2147483647" size="20" type="submit" value="Find" /> </form></div>
-
</div>
-
<!–p if ( !function_aexists(‘dynamic_sidebar’) || !dynamic_sidebar(’sidebar_right’) ) :–>
-
<h2>Archives</h2>
-
<ul><!–p wp_get_archives(‘type=monthly’);–></ul>
-
<ul><!–p<br–>if (wp_version()==‘20′) {
-
echo ‘
-
<h2>Links</h2>
-
‘;
-
get_links(‘1′,‘
-
<li>’,‘</li>
-
‘,”,false,‘name’,false);
-
}
-
else {
-
<h2>’, ‘title_after’ => ‘</h2>
-
‘, ‘category_before’ => ”, ‘category_after’ => ”));
-
}
-
?></ul>
-
<!–p endif;–>
PHP pagination form MySQL db
-
<?php
-
//pagination part below
-
$pageno = $_GET[‘pageno’];
-
} else {
-
$pageno = 1;
-
} // if
-
//pagination part above
-
-
if (!$link) {
-
‘database server at this time.</p>’ );
-
}
-
‘database at this time.</p>’ );
-
}
-
//pagination part below
-
$query = "SELECT count(*) FROM quotes";
-
$numrows = $query_data[0];
-
-
$rows_per_page = 7;
-
$pageno = (int)$pageno;
-
if ($pageno > $lastpage) {
-
$pageno = $lastpage;
-
} // if
-
if ($pageno < 1) {
-
$pageno = 1;
-
} // if
-
$limit = ‘LIMIT ‘ .($pageno - 1) * $rows_per_page .‘,’ .$rows_per_page;
-
$query = "SELECT * FROM quotes $limit";
-
//pagination part above
-
-
if (!$result) {
-
$message .= ‘Whole query: ‘ . $query;
-
}
-
echo "<br><u><b>Quotes:</b></u><br>";
-
//var_dump($row);
-
//echo $row['quote'] . ‘<br>’;
-
-
}
-
//pagination part below
-
if ($pageno == 1) {
-
echo " FIRST PREV ";
-
} else {
-
echo " <a href=’{$_SERVER['PHP_SELF']}?pageno=1′>FIRST</a> ";
-
$prevpage = $pageno-1;
-
echo " <a href=’{$_SERVER['PHP_SELF']}?pageno=$prevpage’>PREV</a> ";
-
} // if
-
-
echo " ( Page $pageno of $lastpage ) ";
-
if ($pageno == $lastpage) {
-
echo " NEXT LAST ";
-
} else {
-
$nextpage = $pageno+1;
-
echo " <a href=’{$_SERVER['PHP_SELF']}?pageno=$nextpage’>NEXT</a> ";
-
echo " <a href=’{$_SERVER['PHP_SELF']}?pageno=$lastpage’>LAST</a> ";
-
} // if
-
-
//pagination part above
-
?>
Testing code highlighting:
-
// Connect to server and select database.
-
-
$sql="SELECT counter FROM $tbl_name";
-
-
$counter=$rows[‘counter’];
-
-
// if have no counter value set counter = 1
-
$counter=1;
-
$sql1="INSERT INTO $tbl_name(counter) VALUES(’$counter’)";
-
}
-
-
echo $counter;
-
echo " Visitors since July 2005";
-
-
// count more value
-
$addcounter=$counter+1;
-
$sql2="update $tbl_name set counter=’$addcounter’";