This is my statement that returns 0 results, but theres definitly one there
SELECT * FROM tbl_dev_dilligence, tbl_dev_dilligence_business, tbl_dev_dilligence_director WHERE tbl_dev_dilligence.dev_id = '115' AND tbl_dev_dilligence.dev_id = '115' AND tbl_dev_dilligence_director.dev_id = '115'
by peter_budo: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)
Select * tries to concatenate all the columns from all the tables, but every column has a dev_id, he cannot return that 4 times. Change it to
SELECT tbl_dev_dilligence.*, tbl_dev_dilligence_business.*, tbl_dev_dilligence_director.* (I think)
A lesser problem: tbl_dev_dilligence.dev_id = '115' appears twice. I'm guessing one should be tbl_dev_dilligence_business
Thanks for the response. your right, i got it working with the following
FROM tbl_dev_dilligence, tbl_dev_dilligence_business, tbl_dev_dilligence_director
WHERE tbl_dev_dilligence.dev_id = 115
AND tbl_dev_dilligence_business.dev_id = 115
AND tbl_dev_dilligence_director.dev_id = 115
Hi, I am a newbie in developing a website. i have tried to connect using mysqli conncetion
Here is my simple code.
// db.php code
//$con = mysqli_connect("localhost","root","","bakery"); ...
If you're in one of those predicaments where cls.__private attributes just aren't enough since they can easily be accessed through inst._cls__private, and you need something a little more secure, here's ...