'选择'& '顺序'确定 - 哪里不起作用 [英] 'Select' & 'Order By' OK- Where Does Not Work
问题描述
在我发布实际代码之前，因为我需要快速回复。
首先我可以问一下是否有人知道他们的头脑，如果有可能的话，那么可能是b $ ba导致以下问题的明显原因。
目前我已将表单请求缩减为简单的文本字符串
条目，而不是我想要的可选参数。因为我已经被卡住了一年多一次不可思议的小故障。
基本上，如果我输入的问题，例如;
" select * from table 按艺术家的表格顺序选择*，
它完美无缺。但是，如果我引入''where''选项，就像在
" select * from table from artist where whatever"。它回来了
无法执行查询。即使我附加order by，也会发生这种情况。
吧。
如果有人可以帮忙，我会发布所有各种代码。
这可能是一个愚蠢的问题，
但有时最愚蠢的是问题!!!
你有没有机会忘记报价？
您输入的方式与列相比!!!
ian justice <我******* @ onmail.co.uk> schreef in bericht
news：f6 ************************** @ posting.google.c om ...在我发布实际代码之前，因为我需要一个快速的回复。
我可以先询问是否有人知道他们的头脑，如果有可能是明显的原因对于以下问题。
目前我已将表单请求缩减为简单的文本字符串
条目，而不是我想要的可选参数。因为我已经被困在一个不可思议的故障超过一年了。
基本上，如果我输入查询，例如;
" select * from table" 按艺术家的表格顺序选择*，
它完美无缺。但是，如果我引入''where''选项，就像在
select * from table from arts that what like中一样。它返回
无法执行查询。即使我附加order by，也会发生这种情况。
它会发布所有各种代码，如果有人可以帮忙的话。
Too Sexy <所以***** @ nobody.com>在消息新闻中写道：< bn ********** @ news3.tilbu1.nb.home.nl> ...这可能是一个愚蠢的问题，但有时最愚蠢的事情就是问题!!!
你有没有机会忘记引用？
你输入它的方式就是与列相比!!! blockquote>
我已经尝试了单引号和双引号的每一种组合。
有趣的是它实际上排序并满足请求
详情如下（1& 2），完全没有任何引用！。
我将其输入到我的文本字段中，没有任何标点符号。
1.从表格中选择* >
2。选择*从表格顺序列到
我通过网络电视发送这个，所以我会在周日将电脑上的脚本发布。
我正在使用的版本是;
PHP4u版本3.0基于PHP-4.3.2
MySQL 3.23.52
i.*******@onmai l.co.uk （伊恩正义）在留言新闻中写道：< f6 ************************** @张贴。谷歌。 com> ...我正在通过网络电视发送这个，所以我会在电脑上发布脚本来
周日。我正在使用的版本是;
PHP4u 3.0版基于PHP-4.3.2
MySQL 3.23.52
基本和简单的表格下面给出了脚本。
####### SHORT FORM ########
< form method =" get" action =" file_name.php">
在此处写入< input type =" textarea"命名= QUOT;写" rows =" 1"
cols =" 400">< br>< br>
< input type =" submit" value =" SEARCH">
< input type =" reset" value =" RESET">
###### SHORT SCRIPT ########
<？php
Before i post actual code, as i need a speedyish reply.
Can i first ask if anyone knows off the top of their head, if there is
a likely obvious cause to the following problem.
For the moment i''ve reduced my form request to a simple text string
entry, instead of my desired optional parameters. As i have been stuck
with a single unfathomable glitch for over a year.
Basically, if i enter queries such as ;
"select * from table" "select * from table order by artist",
it works perfectly. However if i introduce the ''where'' option, as in
"select * from table where artist like whatever". It comes back with
"could not execute query". This happens even if i append "order by" to
it.
I''ll post all the various codes if anyone can please help.解决方案It might be a stupid question,
but sometimes the most stupid thing is the problem!!!
Did you by any chance forget quotes?
The way you typed it you''re comparing to columns!!!
"ian justice" <i.*******@onmail.co.uk> schreef in bericht
news:f6**************************@posting.google.c om...Before i post actual code, as i need a speedyish reply.
Can i first ask if anyone knows off the top of their head, if there is
a likely obvious cause to the following problem.
For the moment i''ve reduced my form request to a simple text string
entry, instead of my desired optional parameters. As i have been stuck
with a single unfathomable glitch for over a year.
Basically, if i enter queries such as ;
"select * from table" "select * from table order by artist",
it works perfectly. However if i introduce the ''where'' option, as in
"select * from table where artist like whatever". It comes back with
"could not execute query". This happens even if i append "order by" to
it.
I''ll post all the various codes if anyone can please help.
"Too Sexy" <so*****@nobody.com> wrote in message news:<bn**********@news3.tilbu1.nb.home.nl>...It might be a stupid question,
but sometimes the most stupid thing is the problem!!!
Did you by any chance forget quotes?
The way you typed it you''re comparing to columns!!!
I''ve tried every combination of single and double quotes.
Interestingly enough it actually sorts and fulfills requests
as detailed below ( 1 & 2 ), WITHOUT ANY QUOTES AT ALL !.
I enter it into my text field without any punctuation.
1. select * from table
2 .select * from table order by column
I''m sending this via web tv, so i''ll post the scripts on a pc come Sunday.
The versions i am using are;
PHP4u Version 3.0 Based on PHP-4.3.2
MySQL 3.23.52
i.*******@onmail.co.uk (ian justice) wrote in message news:<f6**************************@posting.google. com>...I''m sending this via web tv, so i''ll post the scripts on a pc come Sunday. The versions i am using are;
PHP4u Version 3.0 Based on PHP-4.3.2
MySQL 3.23.52
The basic and simple form and scripts are given below.
#######SHORT FORM########
<form method="get" action="file_name.php">
Write In Here <input type="textarea" name="write" rows="1"
cols="400"><br><br>
<input type="submit" value="SEARCH">
<input type="reset" value="RESET">
######SHORT SCRIPT########
<?php
这篇关于'选择'& '顺序'确定 - 哪里不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
