讨论：php与MYSQL连接的问题
作者 sushui 发布于
0000-00-00 分类：php基础编程
小生刚上手PHP，就遇到很多问题，PHP与MYSQL连接，错误：Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in E:phplink.php on line 22
代码：
databasc link </tilt>
</head>
<body>
<?php
$mylink=mysql_connect("localhost","123","123");
mysql_select_db("stu",$mylink);
$sql="select * from stu";
$result=mysql_query($sql);
?>
<center>
<table border>
<tr>
<th>id</th>
<th>name</th>
<th>sex</th>
<th>birthday</th>
</tr>
<?php
while($myarray=mysql_fetch_array($result))
{
?>
<tr>
<td><?php echo $myarray["id"]?></td>
<td><?php echo $myarray["name"]?></td>
<td><?php echo $myarray["sex"]?></td>
<td><?php echo $myarray["birthday"]?></td>
</tr>
<?php
}
?>
</table>
</center>
</body>
</html></P>
<P><INPUT onClick="location.hash='reply';" type=button value=我来回答><br /><br />
<STRONG>逛论坛交流</STRONG>：<A href="http://bbs.phpres.com" target=_blank>php与MYSQL连接的问题</A></P>
<DIV style="MARGIN-TOP: 15px; DISPLAY: block">
<DIV style="DISPLAY: inline; MARGIN-RIGHT: 0px" align=right>
<DL class=tags3>
<DT>加入书签
<DD><A
onclick="this.href='http://digg.com/submit?phase=2&url=' + escape(window.location)"
href="javascript:;" target=_blank
rel=nofollow>digg+</A>,
<DD><A
onclick="this.href='http://reddit.com/submit?url=' + escape(window.location) + '&title=' + escape('php与MYSQL连接的问题')"
href="javascript:;" target=_blank
rel=nofollow>reddit+</A>,
<DD><A
onclick="this.href='http://del.icio.us/post?url=' + escape(window.location) + '&title=' + escape('php与MYSQL连接的问题')"
href="javascript:;" target=_blank
rel=nofollow>del.icio.us+</A>,
<DD><A
onclick="this.href='http://www.dzone.com/links/add.html?url=' + escape(window.location) + '&title=' + escape('php与MYSQL连接的问题')"
href="javascript:;" target=_blank
rel=nofollow>dzone+</A> </DD></DL></DIV></DIV>
<DIV class=vendor-content-box>
<H3>相关讨论话题</H3>
<P class=entryarticle><A href="/php-9160.html" >PHP Version 4.3.2 的SESSION问题</A></P>
<P class=entryarticle><A href="/php-15161.html" >Php显示中文的乱码问题</A></P>
<P class=entryarticle><A href="/php-3488.html" >php编译运行的问题？</A></P>
<P class=entryarticle><A href="/php-7922.html" >php.mysql.apache在linux下的安装问题！！</A></P>
<P class=entryarticle><A href="/php-22253.html" >mysql/php有没有这个功能。请教一下(where in)</A></P>
</DIV>
<SCRIPT src="readmore_files/forum.js" type=text/javascript></SCRIPT>
<DIV class=comments-header>
<H3><a name="reply-list"></a><SPAN id=comments-number>7</SPAN> 条回复</H3>
<P><A class=comment-reply href="#reply">回复</A> </P></DIV><SPAN id=newMessage
style="DISPLAY: none"></SPAN><SPAN id=replyTree_21197></SPAN><SPAN
id=replyMessage_21197></SPAN>
<DIV class=forum-list-tree
style="LEFT: 0px; MARGIN-RIGHT: 0px; POSITION: relative"><A
class=forum-list><SPAN id=tooltip_21194
style="CURSOR: hand">>是不是数据库没有连接上？
现判断数..</SPAN> </A>发表人 cizi 发表于 10月01日
</DIV><SPAN id=replyTree_21194></SPAN><SPAN id=replyMessage_21194></SPAN>
<DIV class=forum-list-tree
style="LEFT: 0px; MARGIN-RIGHT: 0px; POSITION: relative"><A
class=forum-list><SPAN id=tooltip_21194
style="CURSOR: hand">>数据库是没问题的，在这之前我装上了d..</SPAN> </A>发表人 sushui 发表于 10月01日
</DIV><SPAN id=replyTree_21194></SPAN><SPAN id=replyMessage_21194></SPAN>
<DIV class=forum-list-tree
style="LEFT: 0px; MARGIN-RIGHT: 0px; POSITION: relative"><A
class=forum-list><SPAN id=tooltip_21194
style="CURSOR: hand">>你的表名和库名都是stu?????</SPAN> </A>发表人 点击注册 发表于 10月01日
</DIV><SPAN id=replyTree_21194></SPAN><SPAN id=replyMessage_21194></SPAN>
<DIV class=forum-list-tree
style="LEFT: 0px; MARGIN-RIGHT: 0px; POSITION: relative"><A
class=forum-list><SPAN id=tooltip_21194
style="CURSOR: hand">>$result=mysql_query($sql);//出错
..</SPAN> </A>发表人 blueaurora 发表于 10月01日
</DIV><SPAN id=replyTree_21194></SPAN><SPAN id=replyMessage_21194></SPAN>
<DIV class=forum-list-tree
style="LEFT: 0px; MARGIN-RIGHT: 0px; POSITION: relative"><A
class=forum-list><SPAN id=tooltip_21194
style="CURSOR: hand">>不行啊
Warning : mysql_fetch_arr..</SPAN> </A>发表人 sushui 发表于 10月01日
</DIV><SPAN id=replyTree_21194></SPAN><SPAN id=replyMessage_21194></SPAN>
<DIV class=forum-list-tree
style="LEFT: 0px; MARGIN-RIGHT: 0px; POSITION: relative"><A
class=forum-list><SPAN id=tooltip_21194
style="CURSOR: hand">>不行啊
Warning : mysql_fetch_arr..</SPAN> </A>发表人 sushui 发表于 10月01日
</DIV><SPAN id=replyTree_21194></SPAN><SPAN id=replyMessage_21194></SPAN>
<DIV class=forum-list-tree
style="LEFT: 0px; MARGIN-RIGHT: 0px; POSITION: relative"><A
class=forum-list><SPAN id=tooltip_21194
style="CURSOR: hand">> QUOTE:</SPAN> </A>发表人 cizi 发表于 10月01日
</DIV><SPAN id=replyTree_21194></SPAN><SPAN id=replyMessage_21194></SPAN>
<DIV class=comments-sort><SPAN id=comments-sort><A class=comment-sort-desc
href="#reply">顶一贴功德无量！</A> </SPAN></DIV>
<OL class=comments>
<LI id=comment-21219><A name=view_21219></A>
<DIV class=comment-header>
<P class=comment-top><A
href="#">返回顶部</A></P>
<DIV id=header_21219>
<H4><A href="#"
name=21219>Re: php与MYSQL连接的问题</A></H4>
<P class=comment-author>2003年10月01日 发表人 <STRONG>cizi
</STRONG></P></DIV></DIV>
<DIV id=body_21219>
<P><SPAN id=quote_21219>>是不是数据库没有连接上？<br />
现判断数据库是否连接……</SPAN></P></DIV>
<P class=comment-footer><A href="#reply" >回复</A></P><SPAN id=replyFlat_21219></SPAN></LI><SPAN
id=replyFlatMessage_21219></SPAN>
<LI id=comment-21219><A name=view_21219></A>
<DIV class=comment-header>
<P class=comment-top><A
href="#">返回顶部</A></P>
<DIV id=header_21219>
<H4><A href="#"
name=21219>Re: php与MYSQL连接的问题</A></H4>
<P class=comment-author>2003年10月01日 发表人 <STRONG>sushui
</STRONG></P></DIV></DIV>
<DIV id=body_21219>
<P><SPAN id=quote_21219>>数据库是没问题的，在这之前我装上了discuz论坛，数据库字段都在phpmyadmin设置好了！<br />
5555555 。。。怎么搞的呀</SPAN></P></DIV>
<P class=comment-footer><A href="#reply" >回复</A></P><SPAN id=replyFlat_21219></SPAN></LI><SPAN
id=replyFlatMessage_21219></SPAN>
<LI id=comment-21219><A name=view_21219></A>
<DIV class=comment-header>
<P class=comment-top><A
href="#">返回顶部</A></P>
<DIV id=header_21219>
<H4><A href="#"
name=21219>Re: php与MYSQL连接的问题</A></H4>
<P class=comment-author>2003年10月01日 发表人 <STRONG>点击注册
</STRONG></P></DIV></DIV>
<DIV id=body_21219>
<P><SPAN id=quote_21219>>你的表名和库名都是stu?????</SPAN></P></DIV>
<P class=comment-footer><A href="#reply" >回复</A></P><SPAN id=replyFlat_21219></SPAN></LI><SPAN
id=replyFlatMessage_21219></SPAN>
<LI id=comment-21219><A name=view_21219></A>
<DIV class=comment-header>
<P class=comment-top><A
href="#">返回顶部</A></P>
<DIV id=header_21219>
<H4><A href="#"
name=21219>Re: php与MYSQL连接的问题</A></H4>
<P class=comment-author>2003年10月01日 发表人 <STRONG>blueaurora
</STRONG></P></DIV></DIV>
<DIV id=body_21219>
<P><SPAN id=quote_21219>>$result=mysql_query($sql);//出错<br />
<br />
echo $result;<br />
echo mysql_error();<br />
看看</SPAN></P></DIV>
<P class=comment-footer><A href="#reply" >回复</A></P><SPAN id=replyFlat_21219></SPAN></LI><SPAN
id=replyFlatMessage_21219></SPAN>
<LI id=comment-21219><A name=view_21219></A>
<DIV class=comment-header>
<P class=comment-top><A
href="#">返回顶部</A></P>
<DIV id=header_21219>
<H4><A href="#"
name=21219>Re: php与MYSQL连接的问题</A></H4>
<P class=comment-author>2003年10月01日 发表人 <STRONG>sushui
</STRONG></P></DIV></DIV>
<DIV id=body_21219>
<P><SPAN id=quote_21219>>不行啊
<b>Warning</b>: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>E:phplink.php</b> on line <b>23</b><br /></SPAN></P></DIV>
<P class=comment-footer><A href="#reply" >回复</A></P><SPAN id=replyFlat_21219></SPAN></LI><SPAN
id=replyFlatMessage_21219></SPAN>
<LI id=comment-21219><A name=view_21219></A>
<DIV class=comment-header>
<P class=comment-top><A
href="#">返回顶部</A></P>
<DIV id=header_21219>
<H4><A href="#"
name=21219>Re: php与MYSQL连接的问题</A></H4>
<P class=comment-author>2003年10月01日 发表人 <STRONG>sushui
</STRONG></P></DIV></DIV>
<DIV id=body_21219>
<P><SPAN id=quote_21219>>不行啊
<b>Warning</b>: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>E:phplink.php</b> on line <b>23</b><br /></SPAN></P></DIV>
<P class=comment-footer><A href="#reply" >回复</A></P><SPAN id=replyFlat_21219></SPAN></LI><SPAN
id=replyFlatMessage_21219></SPAN>
<LI id=comment-21219><A name=view_21219></A>
<DIV class=comment-header>
<P class=comment-top><A
href="#">返回顶部</A></P>
<DIV id=header_21219>
<H4><A href="#"
name=21219>Re: php与MYSQL连接的问题</A></H4>
<P class=comment-author>2003年10月01日 发表人 <STRONG>cizi
</STRONG></P></DIV></DIV>
<DIV id=body_21219>
<P><SPAN id=quote_21219>><br><center><table border="0" width="90%" cellspacing="0" cellpadding="0"><tr><td><b>QUOTE:</b></SPAN></P></DIV>
<P class=comment-footer><A href="#reply" >回复</A></P><SPAN id=replyFlat_21219></SPAN></LI><SPAN
id=replyFlatMessage_21219></SPAN>
<LI id=comment-21219>
<br /><br /><br />
<A name="reply" class=comment-sort-desc>我有话要讲：(可以匿名发表, 发广告的有多远请滚多远!!!)</a>
<br />
<textarea rows="6" cols="60" name="reback">LZ, 我顶你个肺啊！俺不说两句，心里过意不去，刚心里憋得慌，回来说两句了，心里终于踏实了。</textarea>
<br />昵称：<input type="text" name="pubname" value="php爱好者" onclick="this.value='';" size="8"/> 请输入验证码：<img src="/comm/hack.php" align="absmiddle">
<input type="text" name="userHack" size="6" />
<input type="submit" name="submit" value="俺说两句" />
<br /><br /><br />
</LI>
</OL>
<DIV class=box-bottom>
</DIV></DIV></DIV>
<DIV class=bottom-corners>
<DIV></DIV></DIV></DIV></DIV></DIV></DIV><!-- content end -->
<DIV id=clearer></DIV>
<!-- right side start -->
<DIV id=rightbar>
<DIV id=right-wrapper><!-- box start -->
<DIV class=box>
<H2>抢着回答</H2>
<DIV class=top-corners>
<DIV></DIV></DIV>
<DIV class=box-content>
<DIV class=box-content-2>
<DIV class=box-content-3 id=rightbarcontentbox>
<FORM id=tabstateform action=""><INPUT id=startIndex type=hidden value=0
name=startIndex> <INPUT id=selectedTab type=hidden value=ALL_EXCEPT_NEWS
name=selectedTab> <INPUT id=rightBarLanguage type=hidden value=zh name=language>
</FORM>
<DIV class=entry>
<H1 class=ex-articles><A href="/php-6941.html" >谁知道php和音乐有关的操作?如创建midi...
</A></H1>
<P class=image></P>
<P>如创建MIDI文件?制作乐谱?</P>
<UL class="info link-col">
<LI><A id=739
href="/php/php基础编程/1" name=java>php基础编程</A>,
<LI class=author><SPAN> </SPAN>02日, By <strong class=author>ttt8com</strong>.
<LI class=comments><SPAN></SPAN>
</A></LI></UL></DIV>
<DIV class=clearer></DIV>
<DIV class=entry>
<H1 class=ex-articles><A href="/php-6489.html" >怎么用header()写认证程序的前台
</A></H1>
<P class=image></P>
<P>怎么用header()写认证程序的前台 谢谢</P>
<UL class="info link-col">
<LI><A id=739
href="/php/php基础编程/1" name=java>php基础编程</A>,
<LI class=author><SPAN> </SPAN>02日, By <strong class=author>zhezhe_w</strong>.
<LI class=comments><SPAN></SPAN>
</A></LI></UL></DIV>
<DIV class=clearer></DIV>
<DIV class=entry>
<H1 class=ex-articles><A href="/php-23213.html" >Session能自动在页面间传递吗?
</A></H1>
<P class=image></P>
<P>在一个页面中定义了session变量,那么通过点击该页中的链接打开新...</P>
<UL class="info link-col">
<LI><A id=739
href="/php/php基础编程/1" name=java>php基础编程</A>,
<LI class=author><SPAN> </SPAN>23日, By <strong class=author>laogong</strong>.
<LI class=comments><SPAN></SPAN>
</A></LI></UL></DIV>
<DIV class=clearer></DIV>
<DIV class=entry>
<H1 class=ex-articles><A href="/php-3593.html" >求助：当apache出现这样的问题怎么办？...
</A></H1>
<P class=image></P>
<P>Method Not Allowed
The requested method POST is not allowe...</P>
<UL class="info link-col">
<LI><A id=739
href="/php/php基础编程/1" name=java>php基础编程</A>,
<LI class=author><SPAN> </SPAN>01日, By <strong class=author>apo</strong>.
<LI class=comments><SPAN></SPAN>
</A></LI></UL></DIV>
<DIV class=clearer></DIV>
<DIV class=entry>
<H1 class=ex-articles><A href="/php-10660.html" >数据库问题
</A></H1>
<P class=image></P>
<P>有个数组（“1”，“2，”4“）
如何写一个函数Next()
执行一...</P>
<UL class="info link-col">
<LI><A id=739
href="/php/php基础编程/1" name=java>php基础编程</A>,
<LI class=author><SPAN> </SPAN>23日, By <strong class=author>k1997</strong>.
<LI class=comments><SPAN></SPAN>
</A></LI></UL></DIV>
<DIV class=clearer></DIV>
<DIV class=entry>
<H1 class=ex-articles><A href="/php-5725.html" >来个测试，了解你是男性化还是女性化
</A></H1>
<P class=image></P>
<P>http://notitle.51.net/zz/boygirl.htm</P>
<UL class="info link-col">
<LI><A id=739
href="/php/娱乐乐园/1" name=java>娱乐乐园</A>,
<LI class=author><SPAN> </SPAN>01日, By <strong class=author>aqswde</strong>.
<LI class=comments><SPAN></SPAN>
</A></LI></UL></DIV>
<DIV class=clearer></DIV>
<DIV class=entry>
<H1 class=ex-articles><A href="/php-12176.html" >斑竹，还是不行
</A></H1>
<P class=image></P>
<P>还是不行：（怎么办？</P>
<UL class="info link-col">
<LI><A id=739
href="/php/php基础编程/1" name=java>php基础编程</A>,
<LI class=author><SPAN> </SPAN>23日, By <strong class=author>bluesky21st</strong>.
<LI class=comments><SPAN></SPAN>
</A></LI></UL></DIV>
<DIV class=clearer></DIV>
<DIV class=entry>
<H1 class=ex-articles><A href="/php-4376.html" >体检结束！
</A></H1>
<P class=image></P>
<P>黑就一个字，反正通过了，不说也罢。大笑三声以示祝贺！！哈~哈~...</P>
<UL class="info link-col">
<LI><A id=739
href="/php/娱乐乐园/1" name=java>娱乐乐园</A>,
<LI class=author><SPAN> </SPAN>02日, By <strong class=author>csqspc</strong>.
<LI class=comments><SPAN></SPAN>
</A></LI></UL></DIV>
<DIV class=clearer></DIV>
<DIV class=entry>
<H1 class=ex-articles><A href="/php-1765.html" >mysql的问题！
</A></H1>
<P class=image></P>
<P>$list=mysql_query("select * from xfy where mingzi=$mingzi;")...</P>
<UL class="info link-col">
<LI><A id=739
href="/php/php基础编程/1" name=java>php基础编程</A>,
<LI class=author><SPAN> </SPAN>02日, By <strong class=author>xfy</strong>.
<LI class=comments><SPAN></SPAN>
</A></LI></UL></DIV>
<DIV class=clearer></DIV>
<DIV class=entry>
<H1 class=ex-articles><A href="/php-8809.html" >有问题请教各位高手！
</A></H1>
<P class=image></P>
<P>有两个问题请教大家。希望大家不吝赐教。多谢！！
问题一：...</P>
<UL class="info link-col">
<LI><A id=739
href="/php/linux技术/1" name=java>linux技术</A>,
<LI class=author><SPAN> </SPAN>23日, By <strong class=author>alight</strong>.
<LI class=comments><SPAN></SPAN>
</A></LI></UL></DIV>
<DIV class=clearer></DIV>
<UL class="newsnav link-col">
<LI><A href="/php-7926.html">更早的 ></A> </LI></UL>
<DIV class=box-bottom></DIV></DIV></DIV>
<DIV class=bottom-corners>
<DIV></DIV></DIV></DIV></DIV>
</DIV></DIV>
<DIV class=clearer></DIV>
<DIV id=footer>
<P>暂助本站后请务必把您的信息发送到moolao#gmail.com。版权所有© 2003-2008. 项目赞助：<a href="http://www.codegear.com" target="_blank">CodeGear</a> 空间赞助：<a href="http://www.winet.cn/" target="_blank">中国赢网</a>。</P></DIV></DIV>
<div style="display:none">[<script src='http://s115.cnzz.com/stat.php?id=502548&web_id=502548' language='JavaScript' charset='gb2312'></script>]</div>
</BODY></HTML> 
