Showing data from the database

[HMBeaty]

I think so. I've attached the file to show the contents of what I currently have. Now my question is, if I use:

PHP Code:

$myquote = $db->query_first("SELECT quote, author FROM " . TABLE_PREFIX . "usml_quotesdb WHERE quoteid = '" . $somevar . "'"); 


is that going to show the quotes one at a time, randomly?

(I'm not too experienced with queries at all . Just trying re-create a different mod to do what I want )

EDIT: oops, forgot to attach the file lol. Anyway, this is going to be located at /admincp/quotesdb.php

PHP Code:

<?php
/*======================================================================*\
|| #################################################################### ||
|| # U.S. Military Life                                                  # ||
|| # Random Quotes 1.0.0                                              # ||
|| # ---------------------------------------------------------------- # ||
|| # Copyright ? U.S. Military Life 2011                              # ||
|| # This file may not be redistributed in whole or significant part. # ||
|| # ---------------------------------------------------------------- # ||
|| # http://www.USMilitaryLife.com                                      # ||
|| #################################################################### ||
\*======================================================================*/

// ######################## SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### PRE-CACHE TEMPLATES AND DATA ######################
$phrasegroups = array();

$specialtemplates = array();

$globaltemplates = array();

$actiontemplates = array();

// ########################## REQUIRE BACK-END ############################
require_once('./global.php');
require_once(DIR . '/includes/adminfunctions_template.php');

if (empty($_REQUEST['do']))
{
    $_REQUEST['do'] = 'main';
}

if ($_REQUEST['do'] == 'main')
{
    print_cp_header("[USML] Random Quotes");

    print_form_header('quotesdb', 'manage');
    print_table_start();
    print_table_header("Quotes", 4);
    print_cells_row(array("ID", "Author", "Quote", "Action"),1,0,1);

    $quotes = $vbulletin->db->query("SELECT * FROM ".TABLE_PREFIX."usml_quotesdb ORDER BY quoteid ASC");
    while ($row = $vbulletin->db->fetch_array($quotes))
    {
        $row[quoteid] = htmlspecialchars_uni($row['quoteid']);
        $row[author] = htmlspecialchars_uni($row['author']);
        $row[quote] = htmlspecialchars_uni($row['quote']);
        
        print_cells_row(array("$row[quoteid]","$row[author]","$row[quote]","<a href='?do=editquote&quoteid={$row['quoteid']}'>Edit</a>&nbsp;&nbsp;<a href='?do=quotedel&quoteid={$row['quoteid']}'>Delete</a>"),0,0,1);
    }

    print_table_footer();
    
    print_table_footer();
    print_form_header('quotesdb', 'newquote');
    print_table_header("Add a new quote", 2);
        print_input_row("Author", 'newqdbauthor');
        print_textarea_row("Quote", 'newqdbquote');
    print_submit_row("$vbphrase[save]");
    print_table_footer();
    
    print_cp_footer();
}

if($_POST['do']=="newquote")
{
    $newauthor = $vbulletin->input->clean_GPC('p', 'newqdbauthor', TYPE_STR);
    $newauthor =& $db->escape_string($vbulletin->GPC['newqdbauthor']);
    
    $newquote = $vbulletin->input->clean_GPC('p', 'newqdbquote', TYPE_STR);
    $newquote =& $db->escape_string($vbulletin->GPC['newqdbquote']);
    
    $db->query_write("INSERT INTO `" . TABLE_PREFIX . "usml_quotesdb` VALUES('','".$newauthor."','".$newquote."')");
    define('CP_REDIRECT', 'quotesdb.php?do=main');
    print_stop_message('egr_succces');
}

if ($_REQUEST['do'] == 'quotedel')
{
    $quoteid = $vbulletin->input->clean_GPC('g', 'quoteid', TYPE_UINT);

    $db->query_write("DELETE FROM `" . TABLE_PREFIX . "usml_quotesdb` WHERE quoteid=$quoteid");
    define('CP_REDIRECT', 'quotesdb.php?do=main');
    print_stop_message('egr_succes');
}

if ($_REQUEST['do'] == 'editquote')
{
    $rowid = $vbulletin->input->clean_GPC('g', 'quoteid', TYPE_UINT);
    $rowid =& $db->escape_string($vbulletin->GPC['quoteid']);    

    $quotedata = $vbulletin->db->query("SELECT * FROM `" . TABLE_PREFIX . "usml_quotesdb` WHERE quoteid='".$rowid."'");
    $nu = $db->fetch_array($quotedata);

    $quoteid[data] = htmlspecialchars_uni($nu['quoteid']);
    $author[data] = htmlspecialchars_uni($nu['author']);
    $quote[data] = htmlspecialchars_uni($nu['quote']);

    print_cp_header("Edit Quote");
    print_table_start();
    print_form_header('quotesdb', 'editsave');
    print_table_header("Edit Quote (id:$quoteid[data])", 2);

    echo "<input type='hidden' name='quoteid' value='".$quoteid['data']."'>";

    print_input_row("Author", 'newauthor', "$author[data]");
    print_textarea_row("Quote", 'newquote', "$quote[data]");

    print_submit_row("$vbphrase[save]");

    print_table_footer();
    print_cp_footer();

    define('CP_REDIRECT', 'quotesdb.php?do=main');
    print_stop_message('egr_succes');
}

if ($_REQUEST['do'] == 'editsave')
{
    $newqdbid = $vbulletin->input->clean_GPC('p', 'quoteid', TYPE_UINT);
    $newqdbauthor = $vbulletin->input->clean_GPC('p', 'newauthor', TYPE_STR);
    $newqdbquote = $vbulletin->input->clean_GPC('p', 'newquote', TYPE_STR);

    $newqdbid =& $db->escape_string($vbulletin->GPC['quoteid']);
    $newqdbauthor =& $db->escape_string($vbulletin->GPC['newauthor']);
    $newqdbquote =& $db->escape_string($vbulletin->GPC['newquote']);

    $db->query_write("UPDATE `" . TABLE_PREFIX . "usml_quotesdb` SET author='".$newqdbauthor."', quote='".$newqdbquote."' WHERE quoteid='".$newqdbid."'");

    define('CP_REDIRECT', 'quotesdb.php?do=main');
    print_stop_message('egr_succes');
}
?>