Latest ads
-
Colombo Kaduwela - Two Storey House for Sale- dilrasan
- Updated:
-
Wechat qr verification
- Pawan2005
- Updated:
-
🚀 GOOGLE AI PRO 18 MONTHS ACTIVATION 🚀- sayuru bandara
- Updated:
-
Pure VPN - Up to 27 Months- vgp
- Updated:
ElaKiri Programmer's Club
- Thread starter ilanganthilaka
- Start date
-----------------------------------------------------------------------
function getBits($pid){
global $conn;
$query="SELECT student_id,project_id,date(bid_date) AS bdate,amount
FROM (SELECT * FROM project_bid WHERE project_id='$pid')
AS pb LEFT JOIN project AS p ON pb.project_id=p.id;";
$result=mysql_query($query,$conn) or die("cannot run the bit query");
return $result;
------------------------------------------------------------------------------
මේ තියන උඩ Code එක Table දෙකකින් data ගන්න විදිහට හදා ගන්නේ කොහොමද මචන්ලා
මෙන්න මේ විදිහට table 2 කේ columns add කර ගන්න ඕනේ
project_bid table = student_id,project_id,date(bid_date)
student table = accepted, name
මම එච්චර coding දන්නේ නැ බන් .. Final Year project එක බන් ..
please help me ...
function getBits($pid){
global $conn;
$query="SELECT student_id,project_id,date(bid_date) AS bdate,amount
FROM (SELECT * FROM project_bid WHERE project_id='$pid')
AS pb LEFT JOIN project AS p ON pb.project_id=p.id;";
$result=mysql_query($query,$conn) or die("cannot run the bit query");
return $result;
------------------------------------------------------------------------------
මේ තියන උඩ Code එක Table දෙකකින් data ගන්න විදිහට හදා ගන්නේ කොහොමද මචන්ලා
මෙන්න මේ විදිහට table 2 කේ columns add කර ගන්න ඕනේ
project_bid table = student_id,project_id,date(bid_date)
student table = accepted, name
මම එච්චර coding දන්නේ නැ බන් .. Final Year project එක බන් ..
please help me ...
A distributed system is a network that consists of autonomous computers that are connected using a distribution middleware. They help in sharing different resources and capabilities to provide users with a single and integrated coherent network.
https://www.techopedia.com/definition/18909/distributed-system
සරළවම කිව්වොත් ඕක තමා..
https://www.techopedia.com/definition/18909/distributed-system
සරළවම කිව්වොත් ඕක තමා..
---------------------------------------------------------------
function getBits($pid){
global $conn;
$query="SELECT student_id,project_id,name,date(bid_date) AS bdate,amount,accepted
(SELECT * FROM student WHERE project_id='$pid')
FROM (SELECT * FROM project_bid WHERE project_id='$pid') AS pb LEFT JOIN project AS p ON pb.project_id=p.id;";
$result=mysql_query($query,$conn) or die("cannot run the bit query");
return $result;
}
-----------------------------------------------------------------
machan oya bold karala tiyana fields tiyanne ( project_bid )kiyana table eka name, ewa tiyanne (student) kiyala table ekaka
mata one wenama tabale ekak my sql wala hadanne natuwa oya kiyana table 2nma data ekata ganna ( project_bid ) and (student)
function getBits($pid){
global $conn;
$query="SELECT student_id,project_id,name,date(bid_date) AS bdate,amount,accepted
(SELECT * FROM student WHERE project_id='$pid')
FROM (SELECT * FROM project_bid WHERE project_id='$pid') AS pb LEFT JOIN project AS p ON pb.project_id=p.id;";
$result=mysql_query($query,$conn) or die("cannot run the bit query");
return $result;
}
-----------------------------------------------------------------
machan oya bold karala tiyana fields tiyanne ( project_bid )kiyana table eka name, ewa tiyanne (student) kiyala table ekaka
mata one wenama tabale ekak my sql wala hadanne natuwa oya kiyana table 2nma data ekata ganna ( project_bid ) and (student)
math programming walata asi.. danata mama c,c++,java,php, karanawa javascript(hodatama ba eth wadak kraganna puluen yanthamata).
nula dala awrudu 3 k gyata mata set une ada. ela ela.. dan mata ena error ehema ela kiriyenma kha ganna puluan
rep ++
nula dala awrudu 3 k gyata mata set une ada. ela ela.. dan mata ena error ehema ela kiriyenma kha ganna puluan
rep ++
member ,librarian dekatama one nam eka table ekak use karanna puluwan Type column ekak dala type eka wenas karala,
anith eka burrow and return dekama eka table eke thiyala isReturn column ekak and,ReturnDate column ekak add karanna.
foreign keys waladi Text use karanna epa int wage ekak use kranna.podi adu padu thiyanawa but ok.
anith eka burrow and return dekama eka table eke thiyala isReturn column ekak and,ReturnDate column ekak add karanna.
foreign keys waladi Text use karanna epa int wage ekak use kranna.podi adu padu thiyanawa but ok.
මචන්ලා ජාවා වල JTabbedPane එකේ selected tab color එක චේන්ජ් කරන්ඩ දන්න කෙනෙක් කියන්වද,
මම Stack Overflow එකේ බැලුවා,ගොඩක් ඒවා පොයිල් වගේ ... 
මේක (UIManager.put("TabbedPane.selected", Color.RED)
Constructor ඇතුලේ ලිව්වට වෙනස් වෙන්නේ නැත්තෙ ඇයි ??? 
PHP:
public tabpane() {
initComponents();
UIManager.put("TabbedPane.selected", Color.RED);
}
මචන්ලා මන් internship යන්න ඉන්නේ IT field එකේ. software development. java වගේ. internship එකට යන්න exam තියෙනවනේ ඒ company වල. මට පොඩ්ඩක් කියන්නකෝ එවේ මොන වගේ ප්රශ්නද අහන්නේ කියල.
wenas wenna one. ehema wenas wenne natte wenath UI ekak dala thibboth thama. Nimbus UI eka ayin karanna..
මචන්ලා ජාවා වල JTabbedPane එකේ selected tab color එක චේන්ජ් කරන්ඩ දන්න කෙනෙක් කියන්වද,
මේක (UIManager.put("TabbedPane.selected", Color.RED)
PHP:public tabpane() { initComponents(); UIManager.put("TabbedPane.selected", Color.RED); }
nath nam dala thiyena UI eke Property change karanna,
me error ekA ENNA HETHUWA MOKAKDA BUN??
Database query failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1
SQL:
Database query failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1
SQL:
PHP:
function get_subject_by_id($subject_id){
global $connection;
$query = "SELECT * ";
$query .= "FROM subjects ";
$query .= "WHERE id=" . $subject_id . " ";
$query .= "LIMIT 1";
$result_set= mysqli_query($connection,$query);
confirm_query($result_set);
//Remember.....
//if no rows are returned,fetch_array will return false
if($subject=mysqli_fetch_array($result_set)){
return $subject;
}else{
return NULL;
}
}
Last edited:
Similar threads
