MySQL N00b!

darkfunkel

I am working on making a site in PHP with a MySQL backend I need to print the following code onto a page 10 times first it selects the rows in catergry foo then it lists the ten newest additions the template I require is below if you could help I would be grateful TIA

$filmname 



 Review:
$review



--------------------------------------------------------------------------------



$shoutout

Length: $length 
Framerate: $frames 
Resolution: $res
Videocodec: $codec 
Videobitrate: $bitrate 
Audio: $sound

Note: $note

Language: $lang
Total files: $tfiles
Total size: $size Mbyte

Links


Description     

IMDb: $fname $lang

darkfunkel

anyone?

acidbox

You should show us what your database design looks like, and also show us what your select statement looks like.

darkfunkel

I have no idea what to do, all I know is that where I put variables the're the cell names in the database and I want to put ten of those on a page each time with different data at the variable

acidbox

I really can't help you unless you post some sort of code or something. Because you are being really vague.

darkfunkel

the below will print out what I want once


<?php
mysql_connect("localhost","user","pass");
mysql_select_db (dbname);

$result = mysql_query("SELECT * FROM releases");
while ($row = mysql_fetch_array($result)) { 
            $codec = $row["codec"];
            $Filmgame_name = $row["Filmgame_name"];
            $Review = $row["Review"];
            $Shout_Out = $row["Shout_Out"];
            $length = $row["Length"];
            $frames = $row["Frames"];
            $bitrate = $row["bitrate"];
            $sound = $row["sound"];
            $note = $row["note"];
            $lang = $row["lang"];
            $size_in_mb = $row["size_in_mb"];
            $cover_link = $row["cover_link"];
            $edonkey_links = $row["edonkey_links"];



}
?>
<html>

<head>
<meta http-equiv="Content-Language" content="en-gb">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
</head>

<body>

<p>&nbsp;</p>
<table cellpadding="4" cellspacing="1" border="0" width="100%">
   <tr>
   	<td bgcolor="#CCCCCC" align="left" valign="middle">
    <font face="Tahoma, Verdana, Arial, sans-serif" size="-1"><? print $Filmgame_name ?> </font></td>
   </tr>
   <tr> 
      <td bgcolor="#FFFFFF" align="left" valign="top">
         <table width="100%" border="0" cellspacing="0" cellpadding="4" class="text">
            <tr>
               <td align="left" valign="top"><a target="_blank" href="<?print $cover_link ?>">
               <img src="<?print $cover_link ?>" alt="Click here for a large version" border="0" width="94" height="100"></a><br><center>
               <p>&nbsp;</p>
               </center></td>
               <td align="left" valign="top" class="text" width="100%"><a href="user.php?userid=2083">
               <img align="right" alt="[ SkyDFX ]" src="http://www.30424.net/sr/avatars/skydfx.jpg" border="0" width="100" height="100"></a><b>Review:</b><p>
               <b><?print $Review ?></b><br />
&nbsp;</p>
               <hr>
               <p><br />
<br />
<?print $shout_out ?><br />
<br />
Length: <?print $length ?> <br />
Framerate:<?print $frames ?> <br />
Videocodec: <?print $codec ?><br />
Videobitrate: <? print $bitrate ?><br />
Audio: <?print $sound ?><br />
<br />
<b>Note:</b> <? print $note ?><br>
			   <br>
               <b>Language:</b><? print $lang ?><br>
                            <b>Total size:</b><?print $size_in_mb ?> Mbyte<br>
               <br>
               <b>Links</b><br>
</p>
<table width="100%" border="0" cellspacing="1" cellpadding="1" class="text">
<tr>
<td nowrap><b>Description</b></td>
<td nowrap>&nbsp;</td>
<td nowrap align="right">&nbsp;</td>
</tr>
<tr>
<td nowrap>&nbsp;</td>
<td nowrap>&nbsp;</td>
<td nowrap align="right">&nbsp;</td>
</tr><tr>
<td nowrap>
<a  target="_blank" href="<?print $imdb_link ?>">IMDb: 
<? print $Filmgame_name ?></a></td>
<td nowrap>Film is in <?print $lang ?></td>
<td nowrap align="right">&nbsp;</td>
</tr>
</table>
<p>
<br>
                  </p>
                  <table bgcolor="#000000" width="100%" height="1" border="0" cellspacing="0" cellpadding="0">
                     <tr>
                        <td height="1"><IMG SRC="http://www.30424.net/sr/spacer.gif" witdh="10" height="1"></td>
                     </tr>
                  </table>
                  <p>
                  <br>
                  <small><br></small>
<center>Download <print $Filmgame_name ?><br>
<? print $edonkey_links ?>

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

</body>

           </html>
<?

mysql_free_result($result);

?>

What I need to do is have the latest X amount of rows by uid from the table releases and I have no idea how to put more than one on a page

acidbox

ok, so basically, to print that 10 times you gotta use a for loop.

<?php

for($x=0; $x < 10; $x++)
    {
       put the code you want repeated 10 times in here
    }

?>

darkfunkel

thanks

darkfunkel

I just did that, it printed the same data 10 times on the page exactly the same 🙁

feldon23

I don't know MySQL, but you ARE doing a range from i to i+1 in this statement so that you are "walking through the database", right?

$result = mysql_query("SELECT * FROM releases");

darkfunkel

I know how to fetch the rows etc from the database, I am trying to make a thing similar to a news system that prints the last X amount of posts with a skinable interface through variables if you get me, I think that explains it better

diego25

Put the HTML inside your original loop (in your original code, the one using while loop) so that it will be outputted 10 times.

Diego

darkfunkel

so what would I put at the query as I did this loop thing before and it outputted the same row of results so what MySQL query would I use? thanks

diego25

$result = mysql_query("SELECT * FROM releases LIMIT 10");

Diego

darkfunkel

About to test it

darkfunkel

I can't seem to get it to display anything at all now, I will check my code again

darkfunkel

has anyone got any ideas or sample code I could have a look at for me to try and figure this out in?