blocks|key|3553898|text|$firstrow+=+null;
while($article=+mysql_fetch_array($articleQuery))+{
++++if+($firstrow+===+null)
++++++++$firstrow+=+$article;

++++$aid+=+$article['id'];
++++$media+=+$article['media'];
++++$link+=+$article['link'];
++++//manipulate+$aid,+$media+and+$link.
}

//manipulate+$firstrow|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|3553899|如果只需要第一行，请将查询限制为一个结果，并且最多执行一次mysql_fetch_array，而不是在循环中执行。|unstyled|offset|length|style|CODE|3553900|entityMap^0|0|T|H|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|N|8|@$G|O|H|P|I|J]]|9|@]|A|$]]|$1|K|3|-4|5|F|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<pre><code>$firstrow = null;
while($article= mysql_fetch_array($articleQuery)) {
 if ($firstrow === null)
 $firstrow = $article;

 $aid = $article['id'];
 $media = $article['media'];
 $link = $article['link'];
 //manipulate $aid, $media and $link.
}

//manipulate $firstrow
</code></pre>

If you only need the first row, limit the query to one result and execute <code>mysql_fetch_array</code> at most once, instead of in a loop.

blocks|key|5021978|text|或者你可以这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5021979|+$array+=+array();
+while($article+=+mysql_fetch_object($articleQuery+)){
++$array[]+=+$article;
+}

echo+$array[0]->id;+//+get+first+id
echo+$array[0]->media;+//+get+first+media
echo+$array[0]->link;+//+get+first+link

echo+$array[1]->id;+//+get+second+id
echo+$array[1]->media;+//+get+second+media
echo+$array[1]->link;+//+get+second+link
//+and+so+on.......|code-block|syntax|javascript|5021980|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|$]]

Or you can do like this:

<pre><code> $array = array();
 while($article = mysql_fetch_object($articleQuery )){
 $array[] = $article;
 }

echo $array[0]-&gt;id; // get first id
echo $array[0]-&gt;media; // get first media
echo $array[0]-&gt;link; // get first link

echo $array[1]-&gt;id; // get second id
echo $array[1]-&gt;media; // get second media
echo $array[1]-&gt;link; // get second link
// and so on.......
</code></pre>

blocks|key|1237090|text|如果你想让$aid成为一个数组，你应该这样做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1237091|$aid+=+array();
while($article=+mysql_fetch_array($articleQuery+)){
++++$aid[]+=+$article['id'];
}|code-block|syntax|javascript|1237092|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|$]]

if you want $aid to be an array, you should do something like that:

<pre><code>$aid = array();
while($article= mysql_fetch_array($articleQuery )){
 $aid[] = $article['id'];
}
</code></pre>

blocks|key|3553991|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3553992|问题是它没有真正选择/显示正确的信息。我想要的是能够选择第一个数组的值。|blockquote|offset|length|style|BOLD|3553993|3553994|3553995|你想要的大概是：|3553996|$articleQuery+=+mysql_query("SELECT+*+FROM+articles+WHERE+topic+=+'IT'+");
$article=+mysql_fetch_array($articleQuery);
echo+$article[0];|code-block|syntax|javascript|3553997|你有不必要的循环。您也可以在sql查询中添加limit+1。尽管我不确定我是否正确理解了你的目标。|3553998|entityMap^0|0|Q|A|0|0|0|0|0|0^^$0|@$1|2|3|-4|4|5|6|U|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|V|7|@$D|W|E|X|F|G]]|8|@]|9|$]]|$1|H|3|-4|4|5|6|Y|7|@]|8|@]|9|$]]|$1|I|3|-4|4|5|6|Z|7|@]|8|@]|9|$]]|$1|J|3|K|4|5|6|10|7|@]|8|@]|9|$]]|$1|L|3|M|4|N|6|11|7|@]|8|@]|9|$O|P]]|$1|Q|3|R|4|5|6|12|7|@]|8|@]|9|$]]|$1|S|3|-4|4|5|6|13|7|@]|8|@]|9|$]]]|T|$]]

<blockquote>
 The problem is that its not really
 selecting/displaying the correct
 information. What I want is to be able
 to select the value of the first
 array.
</blockquote>

What you want is propably this:

<pre><code>$articleQuery = mysql_query("SELECT * FROM articles WHERE topic = 'IT' ");
$article= mysql_fetch_array($articleQuery);
echo $article[0];
</code></pre>

You have unnecessary loop. You can also add "limit 1" to sql query. Although I'm not sure I understand your goal correctly.

blocks|key|1214960|text|使用mysql_fetch_assoc，将使用字段名作为数组索引器，因此$+$article‘’id‘代替。这样，如果您通过添加新列来更改表的定义，您的代码不会崩溃！|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1214961|$articleQuery+=+mysql_query("SELECT+*+FROM+articles+WHERE+topic+=+'IT'+LIMIT+1");
$article=+mysql_fetch_assoc($articleQuery);
var_dump($article);|code-block|syntax|javascript|1214962|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|$]]

Using mysql_fetch_assoc, will use the field names as the array indexer, so $article['id'] instead of $article[0]. That way if you change the definition of the table by adding new columns, your code won't break!

<pre><code>$articleQuery = mysql_query("SELECT * FROM articles WHERE topic = 'IT' LIMIT 1");
$article= mysql_fetch_assoc($articleQuery);
var_dump($article);
</code></pre>

blocks|key|1221068|text|如果你真的只想要第一个结果：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1221069|$articleQuery+=+mysql_query("SELECT+*+FROM+articles+WHERE+topic+=+'IT'+LIMIT+1");+//+note+LIMIT+clause
if(+false+!==+($article+=+mysql_fetch_array($articleQuery+)))
{
++++$aid+++=+$article['id'];
++++$media+=+$article['media'];
++++$link++=+$article['link'];
}
echo+$aid;|code-block|syntax|javascript|1221070|如果你想要所有的，但可索引的：|1221071|$articleQuery+=+mysql_query("SELECT+*+FROM+articles+WHERE+topic+=+'IT'+");
while($article=+mysql_fetch_array($articleQuery+))
{
++++$aid[]+++=+$article['id'];
++++$media[]+=+$article['media'];
++++$link[]++=+$article['link'];
}
echo+$aid[0];|1221072|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

If you really only want the first result:

<pre><code>$articleQuery = mysql_query("SELECT * FROM articles WHERE topic = 'IT' LIMIT 1"); // note LIMIT clause
if( false !== ($article = mysql_fetch_array($articleQuery )))
{
 $aid = $article['id'];
 $media = $article['media'];
 $link = $article['link'];
}
echo $aid;
</code></pre>

If you want them all, but indexable:

<pre><code>$articleQuery = mysql_query("SELECT * FROM articles WHERE topic = 'IT' ");
while($article= mysql_fetch_array($articleQuery ))
{
 $aid[] = $article['id'];
 $media[] = $article['media'];
 $link[] = $article['link'];
}
echo $aid[0];
</code></pre>

blocks|key|5022157|text|为什么不编辑SQL语句，使其只选择一项呢？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5022158|mysql_query("SELECT+*+FROM+articles+WHERE+topic+=+'IT'+LIMIT+1");|code-block|syntax|javascript|5022159|但代码中的错误是，您循环遍历所有选定的记录，在每次遍历时覆盖变量。如果您希望将所有行存储为一个数组，则应该像这样修改语法：|5022160|while($article=+mysql_fetch_array($articleQuery+)){
++$aid[]+=+$article['id'];
++$media[]+=+$article['media'];
++$link[]+=+$article['link'];
}|5022161|可以用aid[0]访问第一行的...after。|offset|length|style|CODE|5022162|但我建议使用一种不同的结构：|5022163|while($article=+mysql_fetch_array($articleQuery+)){
++$articles[]['aid']+=+$article['id'];
++$articles[]['media']+=+$article['media'];
++$articles[]['link']+=+$article['link'];
}|5022164|这样做的目的是将所有数据收集到单个数据结构中，其中每条记录都保存与文章相关的所有数据。您可以像这样访问它：|5022165|echo+$articles[0]['aid'];+
echo+$articles[0]['media'];
echo+$articles[0]['link'];|5022166|如果这看起来像是希伯来语，请看一下PHP+manual+section+for+arrays。|5022167|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/language.types.array.php^0|0|0|0|0|3|6|0|0|0|0|0|H|T|0|0^^$0|@$1|2|3|4|5|6|7|18|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|19|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|1A|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|1B|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|1C|8|@$M|1D|N|1E|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1F|8|@]|9|@]|A|$]]|$1|S|3|T|5|D|7|1G|8|@]|9|@]|A|$E|F]]|$1|U|3|V|5|6|7|1H|8|@]|9|@]|A|$]]|$1|W|3|X|5|D|7|1I|8|@]|9|@]|A|$E|F]]|$1|Y|3|Z|5|6|7|1J|8|@]|9|@$M|1K|N|1L|1|1M]]|A|$]]|$1|10|3|-4|5|6|7|1N|8|@]|9|@]|A|$]]]|11|$12|$5|13|14|15|A|$16|17]]]]

Why not edit your SQL statement to select only one item?

<pre><code>mysql_query("SELECT * FROM articles WHERE topic = 'IT' LIMIT 1");
</code></pre>

But the error in your code, is that you're looping over all your selected records, overwriting your variables on each pass. If you want to store all the rows as an array, you should modify your syntax like this: 

<pre><code>while($article= mysql_fetch_array($articleQuery )){
 $aid[] = $article['id'];
 $media[] = $article['media'];
 $link[] = $article['link'];
}
</code></pre>

...after which you could access the first row with <code>aid[0]</code>.

But instead I'd suggest a different structure:

<pre><code>while($article= mysql_fetch_array($articleQuery )){
 $articles[]['aid'] = $article['id'];
 $articles[]['media'] = $article['media'];
 $articles[]['link'] = $article['link'];
}
</code></pre>

What that does, is collect all the data into a single data structure, where each record holds all the data related to the article. You would access it like this:

<pre><code>echo $articles[0]['aid']; 
echo $articles[0]['media'];
echo $articles[0]['link'];
</code></pre>

If this looks like hebrew to you, take a look at the <a href="http://php.net/manual/en/language.types.array.php" rel="nofollow noreferrer">PHP manual section for arrays</a>.

I have the following code and want to manually select an array:

<pre><code>&lt;?php

 $articleQuery = mysql_query("SELECT * FROM articles WHERE topic = 'IT' ");


 while($article= mysql_fetch_array($articleQuery )){
 $aid = $article['id'];
 $media = $article['media'];
 $link = $article['link'];
 }


 echo $aid[0];

?&gt;
</code></pre>

The problem is that its not really selecting/displaying the correct information. What I want is to be able to select the value of the first array.

Thanks in advance.

php array selection

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有以下代码，并希望手动选择一个数组：<?php $articleQuery = mysql_query("SELECT * FROM articles WHERE topic = 'IT' "); while($article= mysql_fetch_array($articleQuery )){ $aid = $article['id']; $media = $article['medi

问php数组选择
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问php数组选择EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问php数组选择
EN