|
![](/images/resource/spacer.gif) |
|
join mysql 3 table แล้วแสดงข้อมูลจาก table1 แต่ไม่มีอะไรขึ้นมาเลย |
|
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
ลองง่ายๆก่อน
Code (SQL)
SELECT
m4_announce2015.id_anounce_exam,
name_anounce_exam.id_anounce_exam,
m4value.id_anounce_exam
FROM m4_announce2015
inner join name_anounce_exam
on m4_announce2015.id_anounce_exam = name_anounce_exam.id_anounce_exam
inner join m4value
on name_anounce_exam.id_anounce_exam = m4value.id_anounce_exam
เมื่อแสดงรายการได้ ค่อยใส่ข้างล่างเข้าไปทีละบันทัด
Code (SQL)
where m4_announce2015.iden_exam = '$numberexam'
AND m4_announce2015.iden_ppl = '$identy'
AND m4_announce2015.id_anounce_exam = 2
|
ประวัติการแก้ไข 2015-03-02 08:42:01
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2015-03-02 08:41:19 |
By :
Chaidhanan |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
คือมันเป็นเว็บประกาศผลสอบครับ ใส่เลขประชาชนกับเลขที่สอบ แล้วคิวรี่ข้อมูลออกมาอ่ะครับ
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2015-03-02 09:01:27 |
By :
thanathorn |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
print_r(); แบบนี้ใช่ไหมครับ?
Code (PHP)
<?php
include("connect.php");
$sql="SELECT
m4_announce2015.id_anounce_exam,
name_anounce_exam.id_anounce_exam,
m4value.id_anounce_exam
FROM m4_announce2015
inner join name_anounce_exam
on m4_announce2015.id_anounce_exam = name_anounce_exam.id_anounce_exam
inner join m4value
on name_anounce_exam.id_anounce_exam = m4value.id_anounce_exam
";
$result_st=mysql_query($sql);
$num=mysql_num_rows($result_st);
$row=mysql_fetch_array($result_st);
print_r();
?>
ฐานข้อมูลเป็นแบบนี้ครับ
![โครงสร้างฐานข้อมูล โครงสร้างฐานข้อมูล](https://www.thaicreate.com/upload/stock/20150302091232.png?v=1001)
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2015-03-02 09:12:57 |
By :
thanathorn |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
![](/images/resource/viewboard_01.gif?v=1001) |
|
|
![](/images/resource/viewboard_03.gif?v=1001) |
![](/images/resource/viewboard_04.gif?v=1001) |
|
ตอนนี้แก้ได้แล้วนะครับ ขอบคุณทุกคนมากครับ
|
![](/images/resource/blockviewtopic_01.gif?v=1001) |
![](/images/resource/blockviewtopic_02.gif?v=1001) |
![](/images/resource/blockviewtopic_03.gif?v=1001) |
![](/images/resource/blockviewtopic_04.gif?v=1001) |
Date :
2015-03-02 09:14:11 |
By :
thanathorn |
|
![](/images/resource/blockviewtopic_06.gif?v=1001) |
![](/images/resource/blockviewtopic_07.gif?v=1001) |
![](/images/resource/blockviewtopic_08.gif?v=1001) |
![](/images/resource/blockviewtopic_09.gif?v=1001) |
|
|
![](/images/resource/viewboard_06.gif?v=1001) |
![](/images/resource/viewboard_07.gif?v=1001) |
|
![](/images/resource/viewboard_08.jpg?v=1001) |
![](/images/resource/viewboard_09.gif?v=1001) |
|
|
|
![](/images/digitalocean-banner.jpg)
|
Load balance : Server 05
|