Jump to content

vipula

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

vipula's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. can any one please change this script to display reslts in several pages if the result is more than 10 record. [color=red]<?php $action = $_SERVER['SCRIPT_NAME']; ?> <?php //if(!$_POST['search']=='result') //{echo "<p style=' font-family: arial; color: blue; font-size: 14px;'>You are not authorized!</p>"; return false;} //$choice=$_POST['choice']; $name=$_POST['name']; $link=mysql_connect("localhost", "root", "") or die("<p class='texxt'>Can't connect to server: ".mysql_error()); mysql_select_db("test",$link); $query="SELECT * FROM saudi_journal WHERE match (FAU, TI, AU, SO, PT, DP, MESH, KW, TA, AD, ISSN, NOTE) against ('$name' in boolean mode) ORDER BY DP DESC"; $result=mysql_query($query,$link) or die("Cannot find Server: ".mysql_error()); $num_rows = mysql_num_rows($result); if ($num_rows=="0"){$search_result="<p class='error'>No Results Found</p>";} elseif ($num_rows > 0){$search_result="<p class='error'>".$num_rows. " Articles Found</p>";} ?>[/color]<body topMargin="0" onLoad="dynAnimation()" vlink="#0000FF" alink="#0000FF" bgcolor="#fffff0" language="Javascript1.2"> <div align="left"> <table border="0" cellPadding="0" cellSpacing="0" height="112" width="100%">   <tbody>   <tr>     <td height="112" width="994"><img border="0" src="img/x.gif" width="990" height="102"></td>   </tr></tbody></table></div> <div align="left"> <table border="0" cellPadding="0" cellSpacing="0" width="100%">   <tbody>   <tr>     <td valign="top">       <div align="left">         <table border="0" cellpadding="0" cellspacing="0" width="979">           <tr>             <td width="312">             </td>             <td align="center" width="355">               <a onMouseOver="document['fpAnimswapimgFP2'].imgRolln=document['fpAnimswapimgFP2'].src;document['fpAnimswapimgFP2'].src=document['fpAnimswapimgFP2'].lowsrc;" onMouseOut="document['fpAnimswapimgFP2'].src=document['fpAnimswapimgFP2'].imgRolln" href="javascript:void(0)">               <img border="0" src="img/hsl1.gif" id="fpAnimswapimgFP2" name="fpAnimswapimgFP2" dynamicanimation="fpAnimswapimgFP2" lowsrc="img/HSL2.gif" width="354" height="25"></a></td> <!-- Search Google --> <form method=GET action=http://www.google.com/custom> <td width="312" align="right">&nbsp;&nbsp; <input type=hidden name=cof VALUE="AH:center;LH:36;L:http://www.nwafh.med.sa/eng/HTML/libweb/img/HSL-NWAFH.gif;LW:432;AWFID:8099ac48bde120fe;"> </td></form>           </tr>         </table>       </div>     </td></tr></tbody></table></div> <div align="left"> <table background="img/bg2.gif" border="0" cellPadding="0" cellSpacing="0" width="989">   <tbody>   <tr>     <td width="845">       <p align="left"><a href="Index.htm"><img border="0" src="img/Home.gif" width="161" height="31"></a><img border="0" src="img/SPACE.gif" width="10" height="10"><a href="about.htm"><img border="0"       src="img/ABOUT.gif" width="116" height="31"></a><img border="0"       src="img/SPACE.gif" width="10" height="10"><a href="services.htm"><img border="0"       src="img/SERVICES.gif" width="116" height="31"></a><img border="0"       src="img/SPACE.gif" width="10" height="10"><a href="ejournals.htm" target="_self"><img border="0" src="img/JOURNAL.gif" width="116" height="31"></a><img border="0"       src="img/SPACE.gif" width="10" height="10"><a href="eb.htm"><img border="0"       src="img/BOOKS.gif" width="116" height="31"></a><img border="0"       src="img/SPACE.gif" width="10" height="10"><a href="databases.htm"><img border="0"       src="img/DATABASE.gif" width="116" height="31"></a></p></td>     <td width="140">       <p align=center>&nbsp;</p></td></tr></tbody></table></div> <div align=center> <center> <table border="0" cellPadding="2" cellSpacing="3" width="108%">   <tbody>   <tr>     <td width="145" rowspan="2" valign="top" bgcolor="#339966">       <p align="center"><b><font size="4">NWAFH<br>   </font><font size="2">Health Sciences Library </font></b></p>   <table id="table2" width="103%" border="0">    <tr>     <td align="left"><font color="#ffffff" size="2">About     SaudiMedLit</font></td>    </tr>    <tr>     <td align="left"><font color="#ffffff" size="2">Journal List</font></td>    </tr>    <tr>     <td>     <p align="left"><font color="#ffffff" size="2">Issues Indexed To     Date</font></td>    </tr>    <tr>     <td><font size="2">&nbsp;</font></td>    </tr>    <tr>     <td>     <p align="left" class="style20"><a href="tips1.htm" class="style21">Search Tips</a></td>    </tr>   </table>   <p></td>     <td width="900">          <form name="search_form" action="display3.php" method="post">                    <div align="center">                 <input type="hidden" name="search" value="result" />          <b>&nbsp;<font size="4" color="#0000ff"><br> </font><span class="style22"><font color="#0000ff">SaudiMedLit</font></span></b>                <font size="2">                   <font color="#008000">is a service of the Health Sciences       Library, </font>&nbsp;</font>      </div>               <p align="center">     <b>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; SEARCH&nbsp;&nbsp;&nbsp;&nbsp; </b>     <SELECT name="choice" size="1">        <!-- <option value="books">Books</option> -->       <option value="smj">Medical Journals</option>       <!-- <option value="staffpub">Staff Publications</option> -->                        </SELECT>      <b>FOR</b>      <input name="name" />      <input name="B1" type="button" value="Go!" onClick="search_submit()" />&nbsp;&nbsp;&nbsp;&nbsp;               </p>    </form>            </td>     <td width="1">&nbsp;</td>   </tr>   <tr>     <td colspan="2" width="870">             [color=red]<?php          echo '<table border="0" cellspacing="10">';        echo '<tr>';          echo '<td colspan="2" class="staffpub_title" align= "center"><font color="blue" size="4"> Search Results </font></td>';        echo '</tr>';      echo '<tr><td align="center" colspan="2"><font color="red" face="Georgia, Times New Roman, Times, serif">'.$search_result.'</font></td></tr>';      while ($rs = mysql_fetch_array($result)){   $TI=$rs['TI'];   $AU=$rs['AU'];   $FAU=$rs['FAU'];   $SO=$rs['SO'];   $DP=$rs['DP'];   $PT=$rs['PT'];   $MESH=$rs['MESH'];   $KW=$rs['KW'];   $TA=$rs['TA'];   $TF=$rs['TF'];   $EDTA=$rs['EDAT'];   $AD=$rs['AD'];   $ISSN=$rs['ISSN'];   $NOTE=$rs['NOTE'];   $EB=$rs['EB'];        echo '<tr>';          echo '<td width="200" align="right" valign="top"><b>Title of the Article: </b></td>';          echo '<td align="left" valign="top">'.$TI.'</td>';        echo '</tr>';        echo '<tr>';          echo '<td align="right"  valign="top"><b>Author(s)          : </b></td>';          echo '<td align="left"  valign="top">'.$AU.'</td>';        echo '</tr>';        echo '<tr>';          echo '<td align="right"  valign="top"><b>Source              :</b></td>';          echo '<td align="left"  valign="top">'.$SO.'</td>';        echo '</tr>';               echo '<tr>';          echo '<td align="right"  valign="top"><b>Address of the Author: </b></td>';          echo '<td align="left"  valign="top">'.$AD.'<hr></td>';              echo '</tr>';                        echo '<tr>';          echo '<td colspan="2" class="staffpub_left">&nbsp;</td>';        echo '</tr>';}     echo '</table>';   ?>          [/color]                                                      <p>&nbsp;</p>   <p><br />     </p>   <p></td>     </tr></tbody></table> </center></div>               <div align=left>               <table bgColor=#000000 border="0" cellPadding="2" cellSpacing="3" width="1010" height="41">   <tbody>
×
×
  • 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.