Results 1 to 8 of 8

Thread: Reading values from specific tables in MySQL

  1. #1
    Join Date
    Oct 2013

    Reading values from specific tables in MySQL

    Hi All,

    Firstly I'm very very new to php and learning all the time but this particular issue is one I cannot find resources to answer in one clean go.

    So I have a MySQL database with several tables. Each table has 3 columns labeled Record_Number, Field, Value. Each table has 97 rows with varying data under each column. I need, for example, to read all the data in say, Table1, in the Field column and Value column and assign a variable to each separate bit if data and then echo them out on a web page.

    I know how to connect to the database. What I can't find is a concise way to specify the required table, and read the required data in the rows under the two specific columns, field and Value, and assign them to variables.

    I hope this makes sense and would be grateful for any help.

    Many thanks in advance

  2. #2
    Join Date
    Jul 2013
    Voorheesville NY USA
    Can you show us you attempt at a query?

  3. #3
    Join Date
    Oct 2013
    All I have so far is the code to connect to the SQL database

    $link = mysql_connect($param1,$param2,$param3) or die(mysql_error());

    where param.php is a separate file containing the name of the database ($param1), the username ($param2) and password ($param3) to connect.

    If i search google on how to specify a table within the database to read from, the results are pretty thin and assume the reader is more advanced in php than I am.

  4. #4
    Join Date
    Jul 2013
    Voorheesville NY USA
    This is more than a php question - it is an sql/MySQL question. In order to obtain data from a sql database, php users rely on the ability to write queries using the sql language/syntax. You need to do some (easy) research on sql. I did a simple search and found this starting tutorial. Perhaps it is just what you need.


  5. #5
    Join Date
    Oct 2013
    Thanks for the link but it doesn't help. I need to read data values from a specific table in a MySQL database so I can echo them out on a web page. And all in php.

  6. #6
    Join Date
    Aug 2004
    Quote Originally Posted by eyetrance View Post
    Thanks for the link but it doesn't help. I need to read data values from a specific table in a MySQL database so I can echo them out on a web page. And all in php.
    Which means you are going to have to use a query written in SQL, which is then executed within your PHP script via the mysql_query() function. If you are going to do database programming, you will need to learn some SQL. (E.g.: see the examples on the PHP manual page for mysql_query().)
    "Well done....Consciousness to sarcasm in five seconds!" ~ Terry Pratchett, Night Watch

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

    My Blog
    cwrBlog: simple, no-database PHP blogging framework

  7. #7
    Join Date
    Jul 2013
    Voorheesville NY USA
    the link is EXACTLY what you need. You don't understand the relationship between a database and php. SQL is the link and you have to learn some in order to do this thing you want to do.

  8. #8
    Join Date
    Sep 2013
    The most basic SELECT syntax looks like this:

    SELECT expressions_and_columns FROM table_name
    [WHERE some_condition_is_true]
    [ORDER BY some_column [ASC | DESC]]
    [LIMIT offset, rows]

    and try out with the below example, it has worked fine for me:

    $result = mysql_query('SELECT...');

    $data = array();
    while(($row = mysql_fetch_array($result))) {
    $data[] = $row['columnName'];

    Hope this helps.
    strad solutionswww.stradsolutions.com

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

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



X vBulletin 4.2.2 Debug Information

  • Page Generation 0.13610 seconds
  • Memory Usage 2,919KB
  • Queries Executed 15 (?)
More Information
Template Usage (33):
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (8)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (1)navbar_moderation
  • (1)navbar_noticebit
  • (1)navbar_tabs
  • (2)option
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (26):
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/functions_navigation.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_facebook.php
  • ./includes/functions_calendar.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (71):
  • init_startup
  • friendlyurl_resolve_class
  • init_startup_session_setup_start
  • database_pre_fetch_array
  • database_post_fetch_array
  • init_startup_session_setup_complete
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • load_show_variables
  • load_forum_show_variables
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • strip_bbcode
  • friendlyurl_clean_fragment
  • friendlyurl_geturl
  • forumjump
  • cache_templates
  • cache_templates_process
  • template_register_var
  • template_render_output
  • fetch_template_start
  • fetch_template_complete
  • parse_templates
  • fetch_musername
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • build_navigation_data
  • build_navigation_array
  • check_navigation_permission
  • process_navigation_links_start
  • process_navigation_links_complete
  • set_navigation_menu_element
  • build_navigation_menudata
  • build_navigation_listdata
  • build_navigation_list
  • set_navigation_tab_main
  • set_navigation_tab_fallback
  • navigation_tab_complete
  • fb_like_button
  • showthread_complete
  • page_templates