Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Dec 2007
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how to view data?

    hi,
    just want to know on how can I view the data that I have save into the database into another page which is in a table format..

    ========this is the save code =============
    mysql_select_db('dbmonitoringsystem',$connect);

    $sql="INSERT INTO tblmasterinvent (department, userName, dateissued, form, brand, model, serial, datepurchased, processor, system, usb, memory, harddisk, phone, cost, remarks) VALUES ('$_POST[department]','$_POST[userName]','$_POST[dateissued]','$_POST[form]','$_POST[brand]','$_POST[model]','$_POST[serial]','$_POST[datepurchased]','$_POST[processor]','$_POST[system]','$_POST[usb]','$_POST[memory]','$_POST[harddisk]','$_POST[phone]','$_POST[cost]','$_POST[remarks]')";

    if (!mysql_query($sql))
    {
    die ('Error: ' . mysql_error());
    }
    echo "1 record added";

    mysql_close($connect)

    ===want to view the data that save into the database in this table====
    <table border=1>
    <th class="td1">Department</th>
    <th class="td1">User Name</td></th>
    <th class="td1">Form</td></th>
    <th class="td1">Type/Model</td></th>
    <th class="td1">Brand</td></th>
    ==========
    I want all the data that I've added and save into database to appear also here..in this table..

    thanks

  • #2
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    14,852
    Thanks
    160
    Thanked 2,223 Times in 2,210 Posts
    Blog Entries
    1
    The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •