1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Form submission and MySQL retrieval

Discussion in 'PHP' started by Paxfia, Jan 7, 2010.

  1. Paxfia

    Paxfia New Member

    Hi all,

    I'm running on a limited knowledge of PHP, but I've been able to use intuition to get by up till now... I've got a problem, and I can't figure out the solution.

    I managed to create a dynamic dropdown menu that populates itself with names from a MySQL table, with the option values being the IDs on the table. Using $_POST, the form sends the option value to another PHP page to execute the action.

    I've confirmed that the action page IS receiving the proper ID number.

    What I want to do is use PHP and the ID to retrieve the rest of the information relevant to that ID from the table and display it. (i.e., if I selected name#2, who's option value is 2, I want the action page to retrieve and display the rest of that entry (like phone number, email, etc.)

    I have a feeling it's probably a fairly simple solution, I've just run out of ideas.:eek:

    Help? Please and thank you :)
     
  2. gotroot

    gotroot New Member

    whats the code?
    if u can post the mysql and php, i can probably help you
     
  3. ManzZup

    ManzZup New Member

    yah displaying the code would help and meanwhile i think you tried using 'select from' and having some errors?
     
  4. johnny.dacu

    johnny.dacu New Member

    in your action page perform a select query base on the provided id.
     
  5. raanrater

    raanrater New Member

    hi..

    can send me a code of forums in PHP...??? meet again.

    :baby:
     
  6. ManzZup

    ManzZup New Member

    :S code of forums?
     
  7. pein87

    pein87 New Member

    You need to do

    PHP:
    $id$_POST['id'];
    if(
    is_numeric($id)) // check that its a real number
    {
    $q "SELECT * FROM table_name WHERE id=$id"//since its a number no need to add '".."'
    if(mysql_num_rows($q) < 1// check if theres any results returned
    {
    //trigger no results error
    echo " sorry but that id does not exist";
    }
    else
    {
    while(
    $get_all_info mysql_fetch_assoc($q))
    {
    $ID $get_all_info[id];
    $INFO $get_all_info[info];

    }
    }
    the $get_all_info is returned as an associative array with the columns of the table as the array index.
     
    shabbir likes this.

Share This Page