Category : sql

i have problem when joining my tables the error says Undefined variable: spps $siswas = DB::table(‘siswa’) ->join(‘kelas’, ‘siswa.id_kelas’, ‘=’, ‘kelas.id_kelas’) ->join(‘spp’, ‘spp.id_spp’, ‘=’, ‘siswa.id_spp’ ) ->get(); $kelass = DB::table(‘kelas’)->get(); return view(‘admin.data_siswa’,compact(‘siswas’,’kelass’)); $spps = DB::table(‘spp’, ‘kelas’)->get(); return view(‘admin.data_siswa’,compact(‘siswas’,’spps’)); } i dont know how to defining the spp table, any one please suggest me idea Source: Ask ..

Read more

I have one doubt in mysql select statement, I tried so many ways i did not get result, Can any one please help on this query. My select statement is here (SELECT document_attachment_id FROM Customer_document_relationship WHERE siteid=cs.SITE_ID LIMIT 1) AS document_attachment_id, (SELECT GROUP_CONCAT(document_name) FROM document_type_relationship WHERE document_id IN(REPLACE(document_attachment_id,"’",”)) LIMIT 1) AS billbasedOn Here document_attachment_id result ..

Read more

I keep getting the following error : Notice: Undefined variable: date in controller. I can’t find the problem… So I have this html page with a form where I’m collecting info (and I must input the DD/MM/YYYY if the duedate of my object card is NULL) <form action="card/edit_card_choice" method="post"> <p>Title</p> <textarea name="card_title" cols = ’50’ ..

Read more