You have an error in your SQL syntax; check the manual... Yardım

12-11-2008, 20:22:10

Üyeliği durduruldu

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by item_color' at line 2"

Bu hatayı alıyorum bir türlü çözemedim ya nedir sorun anlamadım kodlar bunlar ;

<?php
//connect to database
include ("config.php");

$display_block = "<h1>My Store - Item Detail</h1>";
 
//validate item
$get_item = "select c.cat_title, si.item_title, si.item_price,
si.item_desc, si.item_image from store_items as si left join
store_categories as c on c.id = si.cat_id where si.id = $_GET[item_id]";
 
 $get_item_res = mysql_query($get_item) or die (mysql_error());
 
 if (mysql_num_rows($get_item_res) < 1) {
    //invalid item
    $display_block .= "<P><em>Invalid item selection.</em></p>";
 } else {
    //valid item, get info
    $cat_title = strtoupper(stripslashes(
         mysql_result($get_item_res,0,'cat_title')));
    $item_title = stripslashes(mysql_result($get_item_res,0,'item_title'));
    $item_price = mysql_result($get_item_res,0,'item_price');
    $item_desc = stripslashes(mysql_result($get_item_res,0,'item_desc'));
    $item_image = mysql_result($get_item_res,0,'item_image');
 
    //make breadcrumb trail
    $display_block .= "<P><strong><em>You are viewing:</em><br>
    <a href=\"seestore.php?cat_id=$cat_id\">$cat_title</a>
     &gt; $item_title</strong></p>

    <table cellpadding=3 cellspacing=3>
    <tr>
    <td valign=middle align=center><img src=\"$item_image\"></td>
    <td valign=middle><P><strong>Açıklama:</strong><br>$item_desc</p>
    <P><strong>Price:</strong> \$$item_price</p>";
 
    //get colors
    $get_colors = "select item_color from store_item_color where
     item_id = $item_id order by item_color";
    $get_colors_res = mysql_query($get_colors) or die(mysql_error());
 
    if (mysql_num_rows($get_colors_res) > 0) {
 
        $display_block .= "<P><strong>Available Colors:</strong><br>";
 
        while ($colors = mysql_fetch_array($get_colors_res)) {
            $item_color = $colors['item_color'];

            $display_block .= "$item_color<br>";
        }
    }
 
    //get sizes
    $get_sizes = "select item_size from store_item_size where
         item_id = $item_id order by item_size";
    $get_sizes_res = mysql_query($get_sizes) or die(mysql_error());
 
    if (mysql_num_rows($get_sizes_res) > 0) {

        $display_block .= "<P><strong>Available Sizes:</strong><br>";
 
        while ($sizes = mysql_fetch_array($get_sizes_res)) {
            $item_size = $sizes['item_size'];
 
            $display_block .= "$item_size<br>";
        }
    }
 
    $display_block .= "
    </td>
    </tr>
    </table>";
 
 }
 ?>
 <HTML>
 <HEAD>
 <TITLE>My Store</TITLE>
 </HEAD>
 <BODY>
 <? print $display_block; ?>
 </BODY>
 </HTML>

13-11-2008, 00:33:55

#2

Gehinnom

$get_item = "SELECT c.cat_title, si.item_title, si.item_price,
si.item_desc, si.item_image FROM store_items AS si LEFT JOIN
store_categories ON c.id = si.cat_id WHERE si.id = $_GET[item_id]";

şeklinde deneyin bakalım.

13-11-2008, 16:21:24

#3

~~elitgenclik~~

Üyeliği durduruldu

bu seferde böyle bir hata var Unknown column 'c.cat_title' in 'field list'

13-11-2008, 16:42:48

#4

Gehinnom

Tablonda c.cat_title adında bi alan olmadığını söylüyor. c.cat_title yerine direk cat_title yaz yani başında c. olanları sil.