Click here to Skip to main content
12,560,652 members (50,596 online)
Rate this:
Please Sign up or sign in to vote.
See more: PHP MySQL
$link=mysql_connect('localhost','root','12345') or die (mysql_error());
mysql_select_db("library") or die (mysql_error());


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 3:15am
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 | Mobile
Web02 | 2.8.161026.1 | Last Updated 8 Apr 2012
Copyright © CodeProject, 1999-2016
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