Results 1 to 2 of 2

Thread: MySQL

  1. #1
    Join Date
    Feb 2003
    Location
    Reading
    Posts
    4

    Unhappy MySQL

    I am currently trying to complete part of my A-level coursework but am stuck.

    i am creating a website for a restaurant on which customers can submit information to do with four areas:
    ---------------------
    Bookings
    Comments
    Job Applications
    Pre-order
    ----------------------

    i have used access alot in the past and had no problems creating a running model of my final database.

    i have built my website and created the four tables in the alloted MySQL area that came with my website package.

    BIG QUESTION:

    how do i create the interface for people to submit data and for it to be sent to my database?

    i am a complete beginner to MySQL using it for the first time this week so im not sure what i need to do in the slightest to solve this issue

    -------------

    any help or advice would be VERY VERY gratefull

  2. #2
    Join Date
    Feb 2003
    Location
    Tallahassee, Florida USA
    Posts
    43
    If you are using PHP then this is how u connect to the database

    mysql_connect('','username','password');
    mysql_select_db(databasename);
    $sql = "SELECT * FROM tablename";
    $result_Name = mysql_query($sql);
    $row_Name=mysql_fetch_row($result_Name);


    otherwise

    tell me more about what u r using
    and i hope that i can help

    Sites might help:
    www.HotScripts.com
    www.mysql.com



Posting Permissions

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