|
|
|
การ join ตารางแบบ inner ครับ ช่วยดูให้ทีครับบบ...... |
|
|
|
|
|
|
|
Code (PHP)
<?
$objConnect = mysql_connect("root","root","1234") or die("Error Connect to Database");
$objDB = mysql_select_db("mydb");
$strSQL = "SELECT * FROM files WHERE FilesID = '".$_GET["FilesID"]."' ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$objResult = mysql_fetch_array($objQuery);
?>
<h1> <?=$objResult["FilesName"];?></h1>
Size <?=number_format($objResult["Size"]/1024/1024,2);?> Mb.
<div id="container"><a href="http://www.macromedia.com/go/getflashplayer">Get the Flash Player</a> to see this player.</div>
<script type="text/javascript" src="swfobject.js"></script>
<script type="text/javascript">
var s1 = new SWFObject("player.swf","mediaplayer","500","500","8");
s1.addParam('allowscriptaccess','always');
s1.addParam("allowfullscreen","true");
s1.addVariable("file","vdo/<?=$objResult["FilesName"];?>");
s1.addVariable('displayheight','240');
s1.addVariable('autoscroll','true');
s1.write("container");
</script>
<br>
<?
$objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
$objDB = mysql_select_db("projectblack");
$strSQL = "SELECT * FROM signup WHERE UserID = '".$_GET["UserID"]."' ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$objResult = mysql_fetch_array($objQuery);
?>
<?=$objResult["UserID"];?>
<?
mysql_close($objConnect);
?>
ชื่อที่ดึงมาไมขี้นครับ
Tag : PHP
|
|
|
|
|
|
Date :
2012-02-16 23:37:53 |
By :
OhYes!! |
View :
994 |
Reply :
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
แล้วมันติดหรือว่า Error ยังไงล่ะครับ
|
|
|
|
|
Date :
2012-02-17 01:46:38 |
By :
Manussawin |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 05
|