A rather strange one..

[itandme]

hi again!

i have a index.php which displays new from a mysql database!

below the last post, i have two buttons which allows the users tp view all the news, sorted by date or name.

both links defines the variable 'newsort' to either 'bydate' or 'byname'.

And then i got this script in top of the page

if ($newsort == bydate) {
$query = "SELECT title,adress,body,link,submitted,date FROM news ORDER BY submitted Desc";
}
if ($newsort == byname)   {
$query = "SELECT title,adress,body,link,submitted,date FROM news ORDER BY title DESC";
}
if (!$newsort) {
$query = "SELECT title,adress,body,link,submitted,date FROM news ORDER BY timestamp DESC LIMIT 4";
}

$news = mysql_query($query);

But for some strange reason, going to either index.php?newsort=bydate, or newsort=byname gives me a pretty strange result.

The normal news displaying is not workinb aswell, however thats another story.

You can go http://lorenscorn.net/dicemania/ and try it.

thanks

[stolzyboy]

looks like your query isn't returning any results, use an or die(mysql_error()) to get an idea of what the error could be

$news = mysql_query($query) or die(mysql_error());

[jpmoriarty]

I'm guessing you've got coding errors in there:

You'll notice one of your links is buname, so that wont work because you've spelt it wrong (but works okay if you actually type it in).

Let us see the code for your index and we may find more errors!

(but i'm guessing that since it displays <img= on my screen it's because you havent stripped HTML chars out for example, and it's getting screwed up by quote marks ending your echo before you want to)

[itandme]

I dont know what i did, but the spooky <img thingy doesnt show annymore. In fact, the news display on the main index works fine, except i havent got the dates and order quite right yet.

However, now when going to php?newsort= i get the error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/lorens/public_html/dicemania/index.php on line 0

omg i am really tired on that error, as only god knows whats wrong when its this error. why the heck isnt it a valid resource? it works for the normal displaying for gods sake! why isnt it valid when newsort is defined.. ? the queries are almost identical!

😕

 <?
                              while ($display = mysql_fetch_array($news)) {
                              $title = $display['title'];
                              $adress = $display['adress'];
                              $body = $display['body'];
                              $link = $display['link'];
							  $datefromdb = $display['date'];
$year = substr($datefromdb,0,4);
$mon  = substr($datefromdb,0,4);
$day  = substr($datefromdb,6,2);
$orgdate = date("d M",mktime($year));
?>

						  <br>
                          <table width="99%" border="0" cellpadding="0" cellspacing="0" align="center">
                            <tr> 
                              <td>
                                <?
                               if($link == "true") {
							   print("<a href='adress' class='ctext_yellow'>$title<i> - $orgdate</i></a><span class='ctext_yellow'></span><br><span class='ctext_normal'>$body]</span>");
							   }
							   else {
							   print("<span class='ctext_yellow'>$title - <i>$orgdate</i><br><span class='ctext_normal'>$body</span>");
							   }
							   ?>
                              </td>
                            </tr>
                          </table>



                            <br>
                            <table width="97%" border="0" cellpadding="0" cellspacing="0" align="center" class="td_middlegray" height="1">
                              <tr>
                                <td></td>
                              </tr>
                            </table>

                          <?
						  }
						  ?>

[jpmoriarty]

isnt it supposed to be "newsort=bydate"?

And they both link to the same one at the moment - newsort=date. Change one to newsort=bydate and one to newsort=byname and you should be okay

[itandme]

argh yees that is correct.. I dont know how this is possible, as i didd change it long ago and it should be correct now. its possible that the changes was not applied right with the save, as i am working with same file with several pograms and perhaps i am not carefull enough of what versions i save :o

thanks annyway! it works now!

however i have another problem that i find rather strange ( i find all my code errors totally bizzare and unlogical ) 😃.

you may have noticed my email list in the right collumn. That form goes to a php file which handle the database queries, and then redirect to diffirent pages depending on what result you get. for example if the sign up is compleated, you are redirected to mailinglist_index.php?page=subscribed. however the page turns up pretty strange.

this is the mailinglist_index code

<html>
<head>
<title>Dicemania - Praising games</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="styles.css" type="text/css">
<meta HTTP-EQUIV="REFRESH" CONTENT="6; URL=index.php">
</head>

<body text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="100%" border="0" height="100%" cellpadding="9" cellspacing="0" bgcolor="BFC0B8" align="center" class="ctext_normal">
  <tr>
    <td height="100%"> 
      <table width="100%" border="0" height="100%" cellpadding="0" cellspacing="0" bgcolor="#99FF00" align="center">
        <tr> 
          <td height="14" bgcolor="#969696" valign="middle">
            <?php 
                                                    virtual ("header.php");
                                                    ?>
          </td>
        </tr>
        <tr> 
          <td height="100%" valign="top" align="center" bgcolor="#333333"> 
            <table width="100%" border="0" cellpadding="0" cellspacing="0" height="100%">
              <tr> 
                  <td height="5" valign="top" align="left"> </td>

            <td width="66%" valign="top" rowspan="2" class="ctext_small"> 
              <table width="100%" border="0" cellpadding="0" cellspacing="0" height="100%">
                <tr> 
                  <td align="left" valign="top" height="100%"> 
                    <table width="100%" border="0" cellpadding="0" cellspacing="0" height="100%">
                      <tr> 
                        <td valign="top"> 
                          <table width="100%" border="0" cellpadding="0" cellspacing="0" height="81">
                            <tr> 
                              <td height="20" valign="top" align="center"> 
                                <table width="99%" border="0" cellpadding="0" cellspacing="0" height="139">
                                  <tr> 
                                    <td height="7"></td>
                                  </tr>
                                  <tr> 
                                    <td height="6" align="center"> 
                                      <table width="100%" border="0" cellpadding="0" cellspacing="0" class="td_red">
                                        <tr> 
                                          <td height="11" bgcolor="#3A3A3A">
                                            <?php 
                                               virtual ("overtext.php");
                                                ?>
                                          </td>
                                        </tr>
                                      </table>
                                    </td>
                                  </tr>
                                  <tr> 
                                    <td height="12"> </td>
                                  </tr>
                                  <tr> 
                                    <td valign="top">
                              <?
			  print("<div align='center' class='ctext_normal'>");
			  if ($page == emailerror) {
			  print("There seems to be something wrong with your email. Try again.");
			  }
			  if ($page == subscribed) {
			  print("Thank you for subscribing!");
			  }
			  if ($page == match) {
			  print("You are already subscribed!");
			  }
			  if ($page == unsubscribed) {
			  print("You have been unsubscribed.");
			  }
			  if ($page == nomatch) {
			  print("You are not even subscribed yet! ");
			  } 
			  echo "<br><br><br>";
			  echo "You are shortly redirected back to the index page.<br><br>";
			  echo "If you dont get redirected, <a href='index.php'>then click here.</a>"; 
			  print("</div>");
			  ?>
                                    </td>
                                  </tr>
                                </table>
                              </td>
                            </tr>
                          </table>
                          <br>
                        </td>
                      </tr>
                    </table>

                  </td>
                </tr>
                <tr>
                  <td align="left" valign="bottom" height="0">
                    <div align="center" class="header_text"> 
                      <?php 
                                                virtual ("copyright.php");
                                                ?>
                    </div>
                  </td>
                </tr>
              </table>


            </td>

            <td bgcolor="#404040" width="15%'" rowspan="2" valign="top" align="center"><?php 
                                                virtual ("right.php");
                                                ?>
            </td>
            </tr>
            <tr> 

            <td width="13%" valign="top" align="center"> 
              <table width="98%" border="0" cellpadding="0" cellspacing="0" class="ctext_small">
                  <tr>
                    <td width="6" height="8"></td>

                  <td width="125" height="8" valign="top"> 
                    <?php 
                                               virtual ("menu.php");
                                                ?>
                  </td>
                  </tr>
                </table>

            </td>
            </tr>
          </table>

      </td>
    </tr>
  </table>
</td>
  </tr>
</table>
</body>
</html>

You might wanna go the site (http://lorenscorn.net/dicemania/) and just enter something in the email form. what you get is a blank page without the includes.

thanks!!! 😃 😃

[jpmoriarty]

I refer you to the manual:

virtual() is an Apache-specific function which is equivalent to <!--#include virtual...--> in mod_include. It performs an Apache sub-request. It is useful for including CGI scripts or .shtml files, or anything else that you would parse through Apache. Note that for a CGI script, the script must generate valid CGI headers. At the minimum that means it must generate a Content-type header. For PHP files, you need to use include() or require(); virtual() cannot be used to include a document which is itself a PHP file.

So it looks as if your error is not that strange at all...

I'd also suggest heading to the manual as a first port of call for things like that - it obvoiusly was something wrong with the virtual() commands, so it's a good idea to check it out. There are days when I actually have stuff to do, and so wont be able to hang around on these boards waiting to have new posts to make!

Hope that sorts you out.

[itandme]

er right, then i must express my suprise that the virtual() did work in the index file... and my web host said it was okay with php files.. so i excluded that as a cause.

annyways, thankyou! it works now! thanks!