#32356 [Opn->Bgs]: doesn't show the characters of the items

ID: 32356 Updated by: tony2001@php.net Reported By: lavitaesbena at hotmail dot com -Status: Open +Status: Bogus Bug Type: MSSQL related Operating System: Windows XP PHP Version: 4.3.10 New Comment: Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Even if you think it is not a bug, we often know better than you, please consult the support channels first before even considering to reopen this report. Thank you for your interest in PHP. Previous Comments: ------------------------------------------------------------------------ [2005-03-17 19:25:27] lavitaesbena at hotmail dot com Description: ------------ Doesn't perform the query Reproduce code: --------------- $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()); Expected result: ---------------- To get the colours of the items Actual result: -------------- 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 '' at line 1 ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=32356&edit=1