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
Forsvar & beredskab
Cybersikkerhed, realtidsdata og robuste it-systemer er blevet fundamentet for moderne forsvar.
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