28. maj 2004 - 15:02
Der er
24 kommentarer og 1 løsning
min tagwall melder fejl
ja se selv
http://www.dm-vaerksted.ots.dk/~frioz/tagwall.php ved ikke hvad der er galt da det ikke er min stærke side, men jeg skulle mene at det har virket. men nu siger den:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/sites/site2/users/frioz/web/tagwall.php on line 136
_________________________________________________________________
koden: <?
$result = mysql_query("select * from wall order by id desc LIMIT 0, 100");
while($row = mysql_fetch_array($result))
Annonceindlæg tema
Cloud & AI
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
prøv: $result = mysql_query("select * from wall order by id desc LIMIT 0, 100") or die(mysql_error()); og skriv hvad fejlen er..
$result = mysql_query("select * from wall order by id desc LIMIT 0, 100"); -> $result = mysql_query("select * from wall order by id desc LIMIT 0, 100") or die("error: ". mysql_error()); hvad siger den så nu ?
Parse error: parse error, unexpected T_OBJECT_OPERATOR in /home/sites/site2/users/frioz/web/tagwall.php on line 137
Hvad står der i linjerne omkring (og hvordan ser din mysql_query(..)) linje ud nu?
</div></td> <td width="369" align="center" valign="top"><div style="overflow:auto;height:427px;"> <? mysql_close(); ?> <table> <? $result = mysql_query("select * from wall order by id desc LIMIT 0, 100"); -> $result = mysql_query("select * from wall order by id desc LIMIT 0, 100") or die("error: ". mysql_error()); {
<td width="369" align="center" valign="top"><div style="overflow:auto;height:427px;"> <? mysql_close(); ?> <table> <? $result = mysql_query("select * from wall order by id desc LIMIT 0, 100") or die("error: ". mysql_error()); {
error: No Database Selected
du mangler at lave en mysql_select_db() ?
Sludder.. du lukker databasen med mysql_close() og så bruger du mysql_query() bagefter. Prøv at fjerne linjen med mysql_close():
http://dk2.php.net/mysql_select_db $link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Not connected : ' . mysql_error());
}
// make foo the current db
$db_selected = mysql_select_db('foo');
if (!$db_selected) {
die ('Can\'t use foo : ' . mysql_error());
}
eller
$result = mysql_query("select * from DITDATABASENAVN.wall order by id desc LIMIT 0, 100") or die("error: ". mysql_error());
når mysql_close(): er væk skriver den bare : []
Du har en mysql_connect (eller mysql_pconnect) og en mysql_select_db et andet sted i sourcen, right?
mysql_connect("localhost", "xx", "xxx"); mysql_select_db(frioz); xx-udfyldt med database navn og kode
jeg går ud fra at der står mysql_select_db('frioz'); og ikek bare mysql_select_db(frioz); :-) Kan du poste hele koden? (evt som et phps link)
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <script language="JavaScript" type="text/JavaScript"> <!-- function MM_preloadImages() { //v3.0 var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array(); var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++) if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}} } function MM_swapImgRestore() { //v3.0 var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc; } function MM_findObj(n, d) { //v4.01 var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) { d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);} if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n]; for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document); if(!x && d.getElementById) x=d.getElementById(n); return x; } function MM_swapImage() { //v3.0 var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3) if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];} } //--> </script> </head> <body bgcolor="#CCCCCC" onLoad="MM_preloadImages('Foside_on.jpg','ommig_on.jpg','projekter_on.jpg','tagwall_on.jpg','kontakt_on.jpg')"> <table width="800" height="600" border="0" align="center" background="bg.jpg"> <tr> <td height="156" colspan="2"><table width="798" height="157" border="0"> <tr> <th height="153" valign="bottom" scope="col"><table width="100%" border="0" cellspacing="0" cellpadding="0" align="left"> <tr> <td height="19" width="2%"> </td> <td height="19" width="10%"><img src="lights_orange.gif" width="5" height="17"> <a href="index.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image11','','Foside_on.jpg',1)"><img src="Foside.jpg" name="Image11" width="61" height="15" border="0"></a> </td> <td height="19" width="9%"><img src="lights_orange.gif" width="5" height="17"> <a href="ommig.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image10','','ommig_on.jpg',1)"><img src="ommig.jpg" name="Image10" width="53" height="15" border="0"></a> </td> <td height="19" width="12%"><img src="lights_orange.gif" width="5" height="17"> <a href="projekter.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image12','','projekter_on.jpg',1)"><img src="projekter.jpg" name="Image12" width="77" height="15" border="0"></a> </td> <td height="19" width="11%"><img src="lights_orange.gif" width="5" height="17"> <a href="tagwall.php" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image13','','tagwall_on.jpg',1)"><img src="tagwall.jpg" name="Image13" width="68" height="16" border="0"></a> </td> <td height="19" width="10%"><img src="lights_orange.gif" width="5" height="17"> <a href="kontakt.html" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image14','','kontakt_on.jpg',1)"><img src="kontakt.jpg" name="Image14" width="64" height="16" border="0"></a> </td> <td height="19" width="46%"> </td> </tr> </table></th> </tr> </table></td> </tr> <tr> <td width="389" height="429" align="center" valign="top"><div align="center"> <table width="200" border="0"> <tr> <th height="273" scope="col"><? mysql_connect("localhost", "andresen", "210387"); mysql_select_db(frioz); if( $navn && $tag ) { $tid = date("d/m Y - H:i"); $navn = addslashes($navn); $tag = addslashes($tag); $email = addslashes($email); $query = " INSERT INTO wall ( navn, tag, farve, email, ip, dato ) VALUES ( '$navn', '$tag', '$farve', '$email', '$REMOTE_ADDR', '$tid' ) "; mysql_query($query); } ?> <form method=post> </form> <form method=post> <div align="center"> <table border=0 cellspacing=0 cellpadding=0> <tr> <td width=50><font size=1 face=Verdana><b>Navn :</b></font></td> <td><input type=text size=16 name=navn></td> </tr> <tr> <td width=50><font size=1 face=Verdana><b>Email :</b></font></td> <td><input type=text size=16 name=email></td> </tr> <tr> <td width=50><font size=1 face=Verdana><b>Farve :</b></font></td> <td><select name=farve> <option value="000000" selected>----Vælg Farve----</option> <option value="000000">Sort</option> <option value="0000FF">Blå</option> <option value="FF0000">Rød</option> <option value="00FF00">Grøn</option> <option value="FF00FF">Lilla</option> </select></td> </tr> <tr> <td width=50><font size=1 face=Verdana><b>Tekst :</b></font></td> <td><input type=text size=36 name=tag></td> </tr> </table> <input name="submit" type=submit value="post indlæg"> </div> </form> <div align="center"><br> <br> </div></th> </tr> </table> </div></td> <td width="369" align="center" valign="top"><div style="overflow:auto;height:427px;"> <table> <? $result = mysql_query("select * from wall order by id desc LIMIT 0, 100") or die("error: ". mysql_error()); { $farve = $row[farve]; $email = $row[email]; $navn = $row[navn]; $tag = $row[tag]; $dato = $row[dato]; $tag = stripslashes($tag); $navn = stripslashes($navn); $tag = htmlentities($tag); $navn = htmlentities($navn); $email = htmlentities($email); echo "<tr>"; echo "<td valign=middle height=20>"; echo "<font face=verdana size=1 color=\"$farve\">"; echo "<a href=\"mailto:$email\">$navn</a> : $tag <font color=000000>[$dato]"; echo "</font>"; echo "</td>"; echo "</tr>\n"; } ?> </table> </div> </td> </tr> </table> </body> </html>
og en or die ville være rart mysql_connect("localhost", "andresen", "210387") or die("error: ". mysql_error()); du mangler '' mysql_select_db('frioz');
Ok, jeg tog vist fejl. Du skal nok også lige skifte password. :)
tilføj følgende line efter: $result = mysql_query("select * from ..."); $row = mysql_fetch_array($result);
du mangler også en: ... while($row = mysql_fetch_array($result)) { ..
Hvorfor nuppede du lige pointene?
Computerworld tilbyder specialiserede kurser i database-management