sql查询不返回任何东西 [英] sql query doesn't return anything

问题描述

我正在尝试运行以下查询，但似乎未返回任何内容 我要做的就是从我的工作表中返回所选工作类型的工作描述.

Hi I'm trying to run the following query but nothing seems to be returned All I want to is to return the job_discription for the choosen job_type from my jobs table.

请帮忙，因为我已经花了很多时间尝试解决它.​​

Please any help would be great as I have spent hours trying to solve it.

谢谢

alan

<input type="hidden" name="JOB_TYPE" value="<?php print $_POST['JOB_TYPE'];?>"/>

<?php
$Query = " (SELECT JOB_TYPE, JOB_DISCRIPTION FROM jobs  " .
"WHERE jobs.JOB_TYPE ='$_POST[JOB_TYPE]' " .
"AND jobs.JOB_DISCRIPTION = 'JOB_DISCRIPTION')";

$Result = mysqli_query($DB, $Query);  
?>

<?php  
$Result = mysqli_query($DB,$Query)or die(mysqli_error($DB));

while ($Row = mysqli_fetch_assoc($Result))  // Now we go through the data displaying 
{

print  $Row ['JOB_DISCRIPTION']  ;  

}
?>

推荐答案

首先，代码非常容易进行sql注入:您不应直接使用$ _POST数据.第二，如果您想要特定类型的描述，请删除最后一个条件.

First, the code is very prone to sql injection: you shouldn't use the $_POST data directly. Second remove the last condition if you want a description for a particular type.

这篇关于sql查询不返回任何东西的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！