blocks|key|1211429|text|即使只有一行包含一个字段，您也将始终从SQL查询中检索返回的行。可以使用mysql_result直接检索特定行的特定字段|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1211430|$query+=+"SELECT+MAX(stringid)+FROM+XMLString";
$result+=+mysql_query($query,+$link);
echo+mysql_result($result,+0,+0);|code-block|syntax|javascript|1211431|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/function.mysql-result.php^0|10|C|10|C|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@$9|V|A|W|1|X]]|E|$]]|$1|F|3|G|5|H|7|Y|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]]|L|$M|$5|N|O|P|E|$Q|R]]]]

You will always retrieve rows back from an SQL query, even if there's only one row with one field. You can directly retrieve a specific field of a specific row using <a href="http://php.net/manual/en/function.mysql-result.php" rel="nofollow"><code>mysql_result</code></a>:

<pre><code>$query = "SELECT MAX(stringid) FROM XMLString";
$result = mysql_query($query, $link);
echo mysql_result($result, 0, 0);
</code></pre>

blocks|key|1217819|text|mysql_query未打印结果。也许你可以试试这个：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1217820|echo+mysql_result($result);|offset|length|style|CODE|1217821|entityMap^0|0|0|R|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@$D|L|E|M|F|G]]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

mysql_query is not printing results. Maybe try this: 

<code>echo mysql_result($result);</code>

blocks|key|5002878|text|$query+=+"SELECT+MAX(stringid)+as+val+FROM+XMLString";
$result+=+mysql_query($query,+$link);
$rows+++=+mysql_num_rows($result);+
if($rows+>+0)+{
++$rstAry+=+mysql_fetch_array($result);
++echo+$rstAry['val'];
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|5002879|尝尝这个|unstyled|5002880|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code>$query = "SELECT MAX(stringid) as val FROM XMLString";
$result = mysql_query($query, $link);
$rows = mysql_num_rows($result); 
if($rows &gt; 0) {
 $rstAry = mysql_fetch_array($result);
 echo $rstAry['val'];
}
</code></pre>

Try This

blocks|key|3534679|text|您没有得到任何结果，因为mysql_query返回了一个数据库对象。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3534680|您将需要使用mysql_fetch_array处理这个“数据库对象”。此命令从MySQL“数据库对象”中“获取”一个array。您正在获取的array是您的查询生成的行。在您的例子中，它只有一行。|3534681|代码如下：|3534682|3534683|此步骤设置您的查询：|ordered-list-item|3534684|3534685|$query+=+"SELECT+MAX(stringid)+as+val+FROM+XMLString";|3534686|This步骤将运行您的查询，并返回数据库对象：|unordered-list-item|3534687|3534688|$result_database_object_whatever+=+mysql_query($query,+$link);|3534689|This步骤将处理数据库对象，并为您提供一个查询行的数组：|3534690|3534691|$result_array+=+mysql_fetch_array($query,+$link);|3534692|This步骤将回显查询返回的第一行：|3534693|3534694|echo+$result_array[1];|3534695|entityMap^0|C|B|0|6|H|1M|5|1Y|5|0|0|0|0|0|0|1I|0|0|0|0|1Q|0|0|0|0|1D|0|0|0|0|M|0^^$0|@$1|2|3|4|5|6|7|18|8|@$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1B|8|@$9|1C|A|1D|B|C]|$9|1E|A|1F|B|C]|$9|1G|A|1H|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|1I|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|1J|8|@]|D|@]|E|$]]|$1|K|3|L|5|M|7|1K|8|@]|D|@]|E|$]]|$1|N|3|-4|5|6|7|1L|8|@]|D|@]|E|$]]|$1|O|3|P|5|6|7|1M|8|@$9|1N|A|1O|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|S|7|1P|8|@]|D|@]|E|$]]|$1|T|3|-4|5|6|7|1Q|8|@]|D|@]|E|$]]|$1|U|3|V|5|6|7|1R|8|@$9|1S|A|1T|B|C]]|D|@]|E|$]]|$1|W|3|X|5|S|7|1U|8|@]|D|@]|E|$]]|$1|Y|3|-4|5|6|7|1V|8|@]|D|@]|E|$]]|$1|Z|3|10|5|6|7|1W|8|@$9|1X|A|1Y|B|C]]|D|@]|E|$]]|$1|11|3|12|5|S|7|1Z|8|@]|D|@]|E|$]]|$1|13|3|-4|5|6|7|20|8|@]|D|@]|E|$]]|$1|14|3|15|5|6|7|21|8|@$9|22|A|23|B|C]]|D|@]|E|$]]|$1|16|3|-4|5|6|7|24|8|@]|D|@]|E|$]]]|17|$]]

You are not getting any result because <code>mysql_query</code> returns a database object. 

You will need to process this "database object" using <code>mysql_fetch_array</code>. This command 'fetches' an <code>array</code> out of a MySQL "database object". The <code>array</code> you are fetching is the rows your query produced. In your case, it is just one row. 

Here is the code:

<ol>
<li>This step sets your query:

<code>$query = "SELECT MAX(stringid) as val FROM XMLString";</code></li>
<li>This step will run your query, and return the database object:

<code>$result_database_object_whatever = mysql_query($query, $link);</code></li>
<li>This step will process the database object, and give you an array of the queried rows:

<code>$result_array = mysql_fetch_array($query, $link);</code></li>
<li>This step will echo the first row returned by your query:

<code>echo $result_array[1];</code></li>
</ol>

blocks|key|3534701|text|你可以这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3534702|$query+=+"SELECT+MAX(stringid)+FROM+XMLString";
$result+=+mysql_query($query,+$link);
$fetch+=+mysql_fetch_assoc($result);
echo+$fetch['stringid'];|code-block|syntax|javascript|3534703|mysql_fetch_assoc()函数检索关联数组中的数据。|offset|length|style|CODE|3534704|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/function.mysql-fetch-assoc.php^0|0|0|0|J|0|J|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@$I|X|J|Y|K|L]]|9|@$I|Z|J|10|1|11]]|A|$]]|$1|M|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

You can do something like this:

<pre><code>$query = "SELECT MAX(stringid) FROM XMLString";
$result = mysql_query($query, $link);
$fetch = mysql_fetch_assoc($result);
echo $fetch['stringid'];
</code></pre>

The <a href="http://php.net/manual/en/function.mysql-fetch-assoc.php" rel="nofollow"><code>mysql_fetch_assoc()</code></a> function retrieves the data in an associative array.

blocks|key|5002846|text|给max一个你可以参考的名字会有帮助吗？另外，如果你认为有语法错误，你可以添加错误来帮助澄清。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5002847|$query+=+"SELECT+MAX(stringid)+as+maxNum+FROM+XMLString";
$result+=+mysql_query($query,+$link)+or+die(mysql_error());
echo+$result;|code-block|syntax|javascript|5002848|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Would it help to give the max a name you could reference? Also ifyou think there's syntax errors you could just add the error to help clarify.

<pre><code>$query = "SELECT MAX(stringid) as maxNum FROM XMLString";
$result = mysql_query($query, $link) or die(mysql_error());
echo $result;
</code></pre>

For example, for some queries like SELECT MAX(field), the query result is usually only a field value, rather than returning rows to you.

Now the field of the value I wanna get is integer type. 
As I'm a beginner of php, how can I get that value from the query result? 
As I do the following

<pre><code>$query = "SELECT MAX(stringid) FROM XMLString";
$result = mysql_query($query, $link);
echo $result;
</code></pre>

Then nothing is echoed out.
I have check the db connection made by mysqlconnect, and it's got no problem. 
And I tried this query in MySQL at phpMyAdmin, then the query is what I want, too?

So why would it be like that, and any solution?

Thanks!

Using php to access mysql, how can I get the query result which is only a number?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

例如，对于像SELECT MAX( field )这样的查询，查询结果通常只是一个字段值，而不是向您返回行。现在我想要获取的值的字段是整型的。由于我是php的初学者，如何从查询结果中获取该值？当我执行以下操作时$query = "SELECT MAX(stringid) FROM XMLString";$result = mysql_query($query, $link);echo $resul

问用php访问mysql，怎样才能得到只有一个数字的查询结果？
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用php访问mysql，怎样才能得到只有一个数字的查询结果？EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用php访问mysql，怎样才能得到只有一个数字的查询结果？
EN