Add link to article titles on new page???

  • I’m trying create page that has the titles of articles from a blog, and which also links back to the page where the entire article is listed.

    So far I have the first part done. I created a DIV and then inserted from the DATA tab of DreamWeaver – a dynamic table which shows the titles from my WordPress/MySql database.

    The problem I have now, is how do I get those titles to become live links to the pages which host the articles.

    Is there an easyway to do this with the functions built into DW so I don’t have to get into code? In either case I’d appreciate your guidance on how to do this.

Viewing 1 replies (of 1 total)
  • Thread Starter howhite

    (@howhite)

    Here the code I for the page I’m experiment with:

    <?php require_once(‘Connections/WordPress.php’); ?>
    <?php
    if (!function_exists(“GetSQLValueString”)) {
    function GetSQLValueString($theValue, $theType, $theDefinedValue = “”, $theNotDefinedValue = “”)
    {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

    $theValue = function_exists(“mysql_real_escape_string”) ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

    switch ($theType) {
    case “text”:
    $theValue = ($theValue != “”) ? “‘” . $theValue . “‘” : “NULL”;
    break;
    case “long”:
    case “int”:
    $theValue = ($theValue != “”) ? intval($theValue) : “NULL”;
    break;
    case “double”:
    $theValue = ($theValue != “”) ? “‘” . doubleval($theValue) . “‘” : “NULL”;
    break;
    case “date”:
    $theValue = ($theValue != “”) ? “‘” . $theValue . “‘” : “NULL”;
    break;
    case “defined”:
    $theValue = ($theValue != “”) ? $theDefinedValue : $theNotDefinedValue;
    break;
    }
    return $theValue;
    }
    }

    $maxRows_test2 = 5;
    $pageNum_test2 = 0;
    if (isset($_GET[‘pageNum_test2’])) {
    $pageNum_test2 = $_GET[‘pageNum_test2’];
    }
    $startRow_test2 = $pageNum_test2 * $maxRows_test2;

    mysql_select_db($database_WordPress, $WordPress);
    $query_test2 = “SELECT post_title FROM wp_posts ORDER BY post_date DESC”;
    $query_limit_test2 = sprintf(“%s LIMIT %d, %d”, $query_test2, $startRow_test2, $maxRows_test2);
    $test2 = mysql_query($query_limit_test2, $WordPress) or die(mysql_error());
    $row_test2 = mysql_fetch_assoc($test2);

    if (isset($_GET[‘totalRows_test2’])) {
    $totalRows_test2 = $_GET[‘totalRows_test2’];
    } else {
    $all_test2 = mysql_query($query_test2);
    $totalRows_test2 = mysql_num_rows($all_test2);
    }
    $totalPages_test2 = ceil($totalRows_test2/$maxRows_test2)-1;
    ?><!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”&gt;
    <html xmlns=”https://www.w3.org/1999/xhtml”&gt;
    <head>
    <meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />
    <title>Untitled Document</title>
    </head>

    <body>
    <table border=”0″ cellpadding=”1″ cellspacing=”2″>
    <tr>
    <td>post_title</td>
    </tr>
    <?php do { ?>
    <tr>
    <td><?php echo $row_test2[‘post_title’]; ?></td>
    </tr>
    <?php } while ($row_test2 = mysql_fetch_assoc($test2)); ?>
    </table>
    </body>
    </html>
    <?php
    mysql_free_result($test2);
    ?>

Viewing 1 replies (of 1 total)
  • The topic ‘Add link to article titles on new page???’ is closed to new replies.