links Database Table

Table: links

Tool: Links

Fields

id INT UNSIGNED NOT NULL AUTO_INCREMENT v5.06

title VARCHAR(50) NOT NULL v5.06

description VARCHAR(255) NOT NULL v5.06

url VARCHAR(255) NOT NULL v5.06

recipurl VARCHAR(255) NOT NULL v5.06

category SMALLINT UNSIGNED NOT NULL v5.06

dorder SMALLINT UNSIGNED NOT NULL v5.06

Example PHP Usage

The following php example is designed for the main folder: /

<?php
include("admin/load/nosession.php");  //Load Database Connection

$results = $mysqli->query("SELECT * FROM links");
while ($resRow = $results->fetch_assoc())
{
 $id = $resRow["id"];  //
 $title = $resRow["title"];  //
 $description = $resRow["description"];  //
 $url = $resRow["url"];  //
 $recipurl = $resRow["recipurl"];  //
 $category = $resRow["category"];  //
 $dorder = $resRow["dorder"];  //
}

Table: links

Fields

Example PHP Usage

Other Links Tables