svnno****@sourc*****
svnno****@sourc*****
2011年 5月 16日 (月) 14:09:28 JST
ForkRevision: 44
http://sourceforge.jp/projects/smartupload/svn/view?view=rev&revision=44
Author: hryksbt
Date: 2011-05-16 14:09:28 +0900 (Mon, 16 May 2011)
Log Message:
-----------
アップロードフォームのカテゴリの並び順をORDER BYに変更
Modified Paths:
--------------
trunk/SmartUpload/upload_form.php
-------------- next part --------------
Modified: trunk/SmartUpload/upload_form.php
===================================================================
--- trunk/SmartUpload/upload_form.php 2011-05-16 05:04:21 UTC (rev 43)
+++ trunk/SmartUpload/upload_form.php 2011-05-16 05:09:28 UTC (rev 44)
@@ -25,13 +25,13 @@
$value = 0;
- $stmt = $db->prepare("SELECT * FROM category");
+ $stmt = $db->prepare("SELECT * FROM category ORDER BY cat_number");
$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
?>
- <option value="<?php print($row["cat_number"]); ?>">
- <?php print($row["cat_name"]); ?>
+ <option value="<?php print($row['cat_number']); ?>">
+ <?php print($row['cat_name']); ?>
</option>
<?php
}