You can use limit 10
You only add the 0, 10 if u want to start it from 0, which you do but it isn't necessary.

You can use limit 10
You only add the 0, 10 if u want to start it from 0, which you do but it isn't necessary.
Well source's wouldnt work because he forgot to close a bracket.
But anyways that does the same thing, all thats been changed is the variable name
;veni vidi vici
;i came, i saw, i ownt
Ah, OK, thanks
Try using my code anyway, without echoing it out in double quotes, if not, there is definitely something else wrong, could you perhaps paste the whole file and included files?
How could this hapen to meeeeeeeeeeeeeee?lol.
If it isn't a large piece, try recoding it?
I often find that helps because you sometimes don't see some errors.
You'd think a community of people would spot it though :rolleyes:
ok this is the page:
PHP Code:<?php
$skin = mysql_query( "SELECT * FROM `skins` ORDER BY `id` ASC LIMIT 10" );
if( $form == "ok" )
{
$skin_choice=htmlspecialchars(stripslashes(mysql_real_escape($_POST[ 'skin_choice' ])));
if( $skin_choice == "" )
{
echo "Sorry you didnt pick a skin!";
}
else
{
mysql_query("UPDATE user SET skin='".$skin_choice."' WHERE id='".$usrd[id]."'");
echo "Your settings have been updated!";
}
}
else
{
echo "<form action=\"\" method=\"post\">
<input type=\"hidden\" name=\"form\" value=\"ok\" />
<div id=\"left\">";
while( $fetch = mysql_fetch_array( $skin ) ) {
echo "<div style=\"margin-bottom: 20px;\">
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\">
<tr>
<td><img src=\"".$url."images/skins/".$fetch[ 'path' ]."/skin.png\" width=\"200\" height=\"100\" alt=\"\" border=\"0\" /></td>
<td width=\"50\"></td>
<td valign=\"top\"><h2> ".$fetch[ 'name' ]." </h2> ".$fetch[ 'description' ]." <br /> <span style=\"font: 10px arial; color: orange;\"> Skin created by <em>".$fetch[ 'author' ]."</em></td>
<td valign=\"top\"> <span style=\"font: 11px arial; color: #333;\"> Use this skin? </span> <input type=\"radio\" name=\"skin_choice\" value=\"".$fetch[ 'id' ]."\" /> </td>
</tr>
</table>
</div>";
}
echo "<div class=\"save\"> <input type=\"submit\" value=\"Save this skin\" class=\"save\" /> </div>
</form>";
}
?>
Last edited by DUB; 29-09-2008 at 08:00 PM.
;veni vidi vici
;i came, i saw, i ownt
If the code all of us have done for you doesn't work check your PMA, if nothing is in there it's the script you're using to submit the information.
Back for a while.
The script im using to submit the information? what do you mean by that?
;veni vidi vici
;i came, i saw, i ownt
Want to hide these adverts? Register an account for free!