Problem with displaying records

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • kavithadevan
    New Member
    • Jul 2007
    • 23
    #1

    Problem with displaying records

    Hi,

    Here i pasted Three scripts first one is displaying the details which
    i have stored in database this is working but in second script is in
    link with first one if i click main.php it displays all the details in
    the database if i click one particular detail i want to see the
    details about that( so i gave link in main.php scriptl).Here i
    mentioned some sql line i got some problem from there

    $edit="select subject from addevent where event ='$_POST[event]'";
    if i use var_dump() it gives output as NULL.

    If i give like this i got output as a blank page.

    $edit="select subject from addevent where event ='deepavali'";

    If i mentioned particular event then it displays the details adout
    that partcular event I cant found the error from that code.Tell me in
    this how to retrive the values .I got the same thing in to some other
    scripts also.

    ----------------------------Main.php---------------
    [code=php]
    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://
    www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <title>Untitl ed Document</title>
    <meta http-equiv="Content-Type" content="text/html;
    charset=iso-8859-1">
    </head>

    <body>
    <?php
    include('connec t.php');
    $sql="SELECT * FROM addevent";
    // OREDER BY id DESC is order result by descending
    $result=mysql_q uery($sql);

    ?>
    <table width="90%" border="0" align="center" cellpadding="3"
    cellspacing="1" bgcolor="#CCCCC C">
    <tr><div align="center"> <h1>List Of Events</h1></div></tr>
    <tr>
    <td width="6%" align="center" bgcolor="#E6E6E 6"><strong>Even t</
    strong></td>
    <td width="6%" align="center" bgcolor="#E6E6E 6"><strong>Coun try</
    strong></td>
    <td width="53%" align="center" bgcolor="#E6E6E 6"><strong>Date </
    strong></td>
    <td width="15%" align="center" bgcolor="#E6E6E 6"><strong>Mont h</
    strong></td>
    <td width="13%" align="center" bgcolor="#E6E6E 6"><strong>Year </
    strong></td>
    </tr>
    <?php
    while($rows=mys ql_fetch_array( $result))
    {
    // Start looping table row
    ?>
    <td bgcolor="#FFFFF F">
    <a href="event_vie w.php"<?php echo $rows['event']; ?>>
    <?php echo $rows['event']; ?></a>
    <BR>
    </td>
    <td align="left" bgcolor="#FFFFF F"><?php echo $rows['countryname']; ?
    ></td>

    <td align="center" bgcolor="#FFFFF F"><?php echo $rows['date']; ?></td>
    <td align="center" bgcolor="#FFFFF F"><?php echo $rows['month']; ?></
    td>
    <td align="center" bgcolor="#FFFFF F"><?php echo $rows['year']; ?></td>
    </tr>
    <?php
    // Exit looping and close connection
    }

    mysql_close();
    ?>

    </table>
    </body>
    </html>
    [/code]
    -------------------------------------------
    view.php

    [code=php]
    <html>
    <style type="text/css">
    <!--
    .style3 {color: #FFFFFF; font-weight: bold; }
    -->
    </style>
    <form name="form1" method="post" action="">
    <?Php
    include('connec t.php');
    $edit="select subject from addevent where event ='$_POST[event]'";
    $sql=mysql_quer y($edit);
    //$editf1=mysql_f etch_assoc($sql );
    $edits=mysql_qu ery($edit);
    echo $number = mysql_num_rows( $edits);
    while($editf1=m ysql_fetch_asso c($edits))
    {
    ?>

    </p>
    <p align="center"> &nbsp;</p>
    <p align="center"> &nbsp; </p>
    <table width="900" border="1" align="center">
    <tr bgcolor="#66666 6">
    <td width="246"><sp an class="style3"> Subject</span></td>
    </tr>
    <tr bgcolor="#CCCCC C">
    <td bgcolor="#FFFFF F"><?PHP echo $editf1['subject'];?></td>
    </tr>
    </table>
    <p align="center"> &nbsp;</p>
    <?PHP
    }

    ?>
    </form>
    </html>
    [/code]
    thanks
    Last edited by ak1dnar; Jul 16 '07, 12:09 PM. Reason: [CODE] tags Added
    Tags: None
    • ak1dnar
      Recognized Expert Top Contributor
      • Jan 2007
      • 1584
      #2
      Replace this

      [code=php]
      $edit="select subject from addevent where event ='$_POST[event]'";
      [/code]

      with this

      [code=php]
      $edit="select subject from addevent where event ='$_POST['event']'";
      [/code]
      Note: You have missed single quotes on $_POST array element.

        Comment

        • ak1dnar
          Recognized Expert Top Contributor
          • Jan 2007
          • 1584
          #3
          Please use [code] tags, Next time.

          Then you are welcome to TSDN ! :)
          -Ajaxrand

            Comment

            • kavithadevan
              New Member
              • Jul 2007
              • 23
              #4
              Iused that code but it creates error only
              thanks

                Comment

                • ak1dnar
                  Recognized Expert Top Contributor
                  • Jan 2007
                  • 1584
                  #5
                  Originally posted by kavithadevan
                  Iused that code but it creates error only
                  thanks
                  Sorry I didn't get you properly..

                    Comment

                    • pbmods
                      Recognized Expert Expert
                      • Apr 2007
                      • 5821
                      #6
                      Heya, kavithadevan.

                      Originally posted by kavithadevan
                      Iused that code but it creates error only
                      What error do you get?

                      Try this instead (note the curly braces):
                      [code=php]
                      $edit="select subject from addevent where event ='{$_POST['event']}'";
                      [/code]

                      For an explanation of why this works, check out this article.

                        Comment

                        • kavithadevan
                          New Member
                          • Jul 2007
                          • 23
                          #7
                          Hi ,

                          Actually i am not getting any errror but i am trying to display some records using select statement if i am using like this in that above code wat i send


                          $edit="select subject from addevent where event ='$_POST[event]'";

                          it shows blank page only this query not taking the value of $_POST[event].


                          If i give event name directly it displys some records which i have stored in data base
                          $edit="select subject from addevent where event ='deepavali'";

                          Tell me now y my first query is not working wat is the main problem tell me some solution regarding that.




                          thanks

                          Originally posted by pbmods
                          Heya, kavithadevan.



                          What error do you get?

                          Try this instead (note the curly braces):
                          [code=php]
                          $edit="select subject from addevent where event ='{$_POST['event']}'";
                          [/code]

                          For an explanation of why this works, check out this article.

                            Comment

                            • ak1dnar
                              Recognized Expert Top Contributor
                              • Jan 2007
                              • 1584
                              #8
                              Originally posted by kavithadevan
                              Hi ,

                              Actually i am not getting any errror but i am trying to display some records using select statement if i am using like this in that above code wat i send


                              $edit="select subject from addevent where event ='$_POST[event]'";

                              it shows blank page only this query not taking the value of $_POST[event].


                              If i give event name directly it displys some records which i have stored in data base
                              $edit="select subject from addevent where event ='deepavali'";

                              Tell me now y my first query is not working wat is the main problem tell me some solution regarding that.




                              thanks
                              Still you are showing us the same erroneous statement
                              [PHP] $edit="select subject from addevent where event ='$_POST[event]'";[/PHP]
                              This is incorrect.

                              Refer to the previous posts again to find out how to rectify the error.

                                Comment

                                • pbmods
                                  Recognized Expert Expert
                                  • Apr 2007
                                  • 5821
                                  #9
                                  Heya, kavithadevan.

                                  If you're getting a blank page, your script is probably generating an error. Check out this article to find out what is going on.

                                    Comment

                                    • kavithadevan
                                      New Member
                                      • Jul 2007
                                      • 23
                                      #10
                                      If i use these two lines in my script it displayls like this notice

                                      error_reporting (E_ALL);
                                      ini_set('displa y_errors', True);
                                      in my script then it displays one notice like this notice
                                      Notice:Undefine d index: event in C:\wamp\www\adm in\event\event_ view.php on line 17
                                      in that undefined index means wat how to clear that noice tell me suggestions
                                      thanks

                                      Originally posted by pbmods
                                      Heya, kavithadevan.

                                      If you're getting a blank page, your script is probably generating an error. Check out this article to find out what is going on.

                                        Comment

                                        • pbmods
                                          Recognized Expert Expert
                                          • Apr 2007
                                          • 5821
                                          #11
                                          Heya, kavithadevan.

                                          That error means that $_POST['event'] has no value.

                                            Comment

                                            • kavithadevan
                                              New Member
                                              • Jul 2007
                                              • 23
                                              #12
                                              Hi ,
                                              your telling no value that means no datas in database or i didnt assigned any value for that.Tell me hoe to clear this


                                              thanks


                                              Originally posted by pbmods
                                              Heya, kavithadevan.

                                              That error means that $_POST['event'] has no value.

                                                Comment

                                                Previous template Next
                                                Working...