Click here to Skip to main content
Rate this: bad
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 4:15am
ryanb31 at 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 at 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
0 DamithSL 340
1 Maciej Los 282
2 OriginalGriff 203
3 ridoy 160
4 George Jonsson 90
0 OriginalGriff 7,953
1 DamithSL 6,139
2 Sergey Alexandrovich Kryukov 5,454
3 Maciej Los 5,293
4 Kornfeld Eliyahu Peter 4,539

Advertise | Privacy | Mobile
Web01 | 2.8.141223.1 | Last Updated 8 Apr 2012
Copyright © CodeProject, 1999-2014
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