Click here to Skip to main content
13,249,174 members (34,595 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
 
$link=mysql_connect('localhost','root','12345') or die (mysql_error());
 
mysql_select_db("library") or die (mysql_error());
 

 
?>
 
<html>
 
    <head>
 
        <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />
 
        <title>AIMST Online Library Systeme</title>
 

 
        <link href="/library/css/style.css" rel="stylesheet" type="text/css" />
 
    </head>
 

 
    <body>
 
        <div id="wrapper">
 
<?php include_once $_SERVER['DOCUMENT_ROOT'] .'/library/includes/header.php'; ?>
 
                <div id="page">
 
                <div id="content">
 
                    <div id="welcome">
 

 
 <h2 class="head2" ><a class="head">View / Edit Book Master Data</a></h2>
 

 
 <table class="aatable">
 
<tr>
 
<th >SL No</th>
 
<th>Title</th>
 
<th>Media Type</th>
 
<th >Author</th>
 
<th >Publication</th>
 
<th >Edition</th>
 
<th >Year</th>
 
<th >No of Copy Avail</th>
 
<th >Location</th>
 
<th >Category</th>
 
<th >Sub Category</th>
 
<th >Loan Status</th>
 
<th >Remark</th>
 
</tr>
 
<?php
 

 
if ($_POST[search_type]=='all'){
 
$query = "SELECT * FROM book WHERE
 
slno LIKE '%$_POST[keyword]%'||
 
title LIKE '%$_POST[keyword]%' ||
 
author LIKE '%$_POST[keyword]%'||
 
publication LIKE '%$_POST[keyword]%'||
 
year LIKE '%$_POST[keyword]%'||
 
location LIKE '%$_POST[keyword]%'||
 
category LIKE '%$_POST[keyword]%'||
 
sub_category LIKE '%$_POST[keyword]%'||
 
related_name LIKE '%$_POST[keyword]%'||
 
media_type  LIKE '%$_POST[keyword]%'||
 
book_remark LIKE '%$_POST[keyword]%'
 
    ";
 
$result = mysql_query($query,$link)
 
or die(mysql_error());
 
}
 

 
else {
 
$query = "SELECT * FROM book WHERE $_POST[search_type] LIKE '%$_POST[keyword]%'";
 
$result = mysql_query($query,$link)
 
or die(mysql_error());
 
}
 

 

 
while ($row = mysql_fetch_array($result)) {
 

 
$book_id = $row['book_id'];
 
$slno = $row['slno'];
 
$title = $row['title'];
 
$media_type = $row['media_type'];
 
$author=$row['author'];
 
$publication=$row['publication'];
 
$edition=$row['edition'];
 
$year=$row['year'];
 
$total_holding=$row['total_holding'];
 
$location=$row['location'];
 
$category=$row['category'];
 
$sub_category=$row['sub_category'];
 
$book_remark=$row['book_remark'];
 

 
echo "<tr>";
 
echo "<td>".$slno."</td>";
 
echo "<td >".$title."</td>";
 
echo "<td>".$media_type."</td>";
 
echo "<td>".$author."</td>";
 
echo "<td>".$publication."</td>";
 
echo "<td >".$edition."</td>";
 
echo "<td>".$year."</td>";
 
echo "<td >".$total_holding."</td>";
 
echo "<td>".$location."</td>";
 
echo "<td>".$category."</td>";
 
echo "<td>".$sub_category."</td>";
 

 
echo "<td>".$book_remark."</td>";
 

 
echo "</tr>";
 
}
 
?>
 
 </table>
 
                          <!--body ends-->
 
 </div>
 
                    <!-- end div#welcome -->
 

 
                </div>
 
                <!-- end div#content -->
 

 
                <!-- end div#sidebar -->
 
                <div style="clear: both; height: 1px"></div>
 
            </div>
 
<?php include_once $_SERVER['DOCUMENT_ROOT'] . '/library/includes/footer.php'; ?>
 
        </div>
 
        <!-- end div#wrapper -->
 
    </body>
 
</html>



this is my coding, query from a table name book, and now i plan to add in a table call loan and just join the coluum call loan_status with the table above
im tried and got syntax error..may i know how?
Posted 8-Apr-12 4:15am
Jayfam465
Comments
ryanb31 9-Apr-12 10:38am
   
This is a lot of code to look at to try and find the issue. Please use the improve question link and simplify it down to just the code that is having a problem.
digimanus 10-Apr-12 5:09am
   
join between which to fields of table Loan and Book?
and your query for 'All' can never work! || oustide querystring is not SQL. you must use OR in the string!!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy |
Web04 | 2.8.171114.1 | Last Updated 8 Apr 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100