#1
  1. No Profile Picture
    newmediaarts
    Guest
    Devshed Newbie (0 - 499 posts)
    The following source code manages to reliably return the wrong information. Instead of returning the proper number it returns the number 3 for the value of $PID. Just so you know the value of objective_a is unique in each mysql row. PID is generated by MySQL as soon as the row is created.

    <?
    /* declare some relevant variables */
    $hostname = "localhost";
    $username = "root";
    $password = "";
    $dbname = "Schools";
    /* make connection to database */
    MYSQL_CONNECT($hostname,$username,$password) OR DIE("Unable to connect to database");

    @mysql_select_db("$dbname") or die("Unable to select database");
    $date=(date("Y-m-d"));
    $datadump = "INSERT INTO proposal VALUES('$student_name','$student_email','$student_grade','$state','$school','$district','$partner_te acher','$partner_teacher_email','$geny_t eacher','$geny_teacher_email','$project_name','$project_subject_area','$url','$objectives_a','$objec tives_b','$objectives_c','$require_hardw are','$require_software','$require_other','$ealr1a','$ealr1b','$ealr1c','$ealr2a','$ealr2b','$ealr2c ','$ealr3a','$ealr3b','$ealr3c','$proced ures','$assessment','$consultmsg','$draft','$feedback','$edit','$date','')";
    MYSQL_QUERY($datadump);
    MYSQL_CLOSE();


    MYSQL_CONNECT($hostname,$username,$password) OR DIE("Unable to connect to database");
    @mysql_select_db("$dbname") or die("Unable to select database");


    $select = "SELECT PID FROM proposal WHERE (objectives_a='$objectives_a');";
    $result = MYSQL_QUERY($select);
    $PID = $result;

    include("thanks.html");
    PRINT"$result -- result";
    PRINT"<BR>Proposal ID number is $PID.<BR>";
    PRINT"<BR>Proposal ID SELECT is $select.<BR>";
    include("thanks2.html");
    MYSQL_CLOSE();
    ?>

    If anyone has suggestions as to a better way to return the PID of the file created in the first mysql query I would be open to any ideas.

    Thanks.

    ------------------
    Luke Bowerman
    new media arts
    www.judebowerman.com/nma


    [This message has been edited by newmediaarts (edited 08-07-99).]
  2. #2
  3. No Profile Picture
    ros87
    Guest
    Devshed Newbie (0 - 499 posts)
    I'm no php3 wizard but as far as I now $result is only a identifier and must be used with mysql_result to actually retrieve data from the query.

    In onther words .. use

    $PID = mysql_result($result,0,"PID");

    -Roger

    [This message has been edited by ros87 (edited 08-08-99).]
  4. #3
  5. No Profile Picture
    newmediaarts
    Guest
    Devshed Newbie (0 - 499 posts)
    Thank you very much. That worked great.

    ------------------
    Luke Bowerman
    new media arts
    http://www.judebowerman.com/nma

Similar Threads

  1. MySQL Select query
    By MrTee1 in forum MySQL Help
    Replies: 0
    Last Post: January 30th, 2004, 12:16 PM
  2. MySQL query using DB driven drop down menu
    By msg270 in forum PHP Development
    Replies: 3
    Last Post: January 22nd, 2004, 05:41 PM
  3. mysql query to tab delimited file?
    By direwolf in forum PHP Development
    Replies: 1
    Last Post: January 17th, 2004, 02:46 AM
  4. Overwriting mysql query with the query results
    By onerandomday in forum PHP Development
    Replies: 1
    Last Post: January 14th, 2004, 05:45 AM
  5. mysql query problem???
    By mijan10 in forum PHP Development
    Replies: 2
    Last Post: January 4th, 2004, 04:39 PM

IMN logo majestic logo threadwatch logo seochat tools logo