Jump to content

Frisbetarian

New Members
  • Posts

    1
  • Joined

  • Last visited

Frisbetarian's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. Hey all so Im trying to put data through an AJAX call into this div <div class="scroll-pane2 blue small" style=""> <p id="bulletinBodyArea" style="margin-right:20px;"></p> </div> The AJAX is being triggered when one clicks on one of the links being fed from the database <div class="bulletinSectionAccordion rounded"> <p class="blue" style="font-size:19px;margin-left:23px;margin-top:15px;margin-bottom:10px;">Archives</p> <?php $query = "SELECT * FROM `bulletin` LEFT JOIN `bulletininschool` ON `bulletin`.`id`=`bulletininschool`.`bulletin` WHERE `school` = 2 "; $result=$connection->query($query); while($row = $result->fetch_array()) { echo '<p class="medium titi" style="margin-left:23px;">'.$row['title'].'</p>'; } ?> </div> It gets called and then passes the data $(".titi").click( getBody ); function getBody(){ $("#bulletinBodyArea").load('update/getBody.php'); }; And this is the AJAX function <?php $section='bulletin'; $table="bulletin"; $schoolSelectorTable="bulletininschool"; $schoolSelector="bulletin"; $db_host = "localhost"; $db_user = "root"; $db_pass = ""; $db_name = "isl"; mysql_connect($db_host, $db_user, $db_pass, $db_name); mysql_select_db("isl") or die(mysql_error()); $states = mysql_query("SELECT * FROM `bulletin` LEFT JOIN `bulletininschool` ON `bulletin`.`id`=`bulletininschool`.`bulletin` WHERE `school` = 2" ); while($state = mysql_fetch_array($states)){ echo "<p>".$state['body']."</p>"; } ?> Now the links that one clicks that are fed from the database are actually article titles, and when one clicks on a specific title the AJAX call should go and fetch the body text associated with that article. But I'm having trouble understanding how I should go through that. I'm doing the correct queries and getting the titles and the bodies but I just cant figure out how to associate them. Do I pass a variable to the AJAX call? Thank you
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.