Code: Select all
<body>
<?
mysql_connect('localhost','dvddb','xxx');
@mysql_select_db('dvddb') or die("Can't find database");
$sel = mysql_query("SELECT * FROM dvd");
$num_rows = mysql_num_rows($sel);
echo mysql_error();
$result = mysql_query("SELECT * FROM dvd ORDER BY id DESC");
if (isset( $_GET['order'])) {
$page = $_GET['order'];
}
else {
$page = "?";
}
switch ($page) {
default:
$result = mysql_query("SELECT * FROM dvd ORDER BY id DESC");
break;
case "oldest":
$result = mysql_query("SELECT * FROM dvd ORDER BY LCASE(oldest) DESC, id ASC");
break;
case "rate":
$result = mysql_query("SELECT * FROM dvd ORDER BY LCASE(rate) ASC, rate DESC");
break;
case "director":
$result = mysql_query("SELECT * FROM dvd ORDER BY LCASE(director) ASC, rate DESC");
break;
case "genre":
$result = mysql_query("SELECT * FROM dvd ORDER BY LCASE(genre) ASC, genre DESC");
break;
case "page":
$result = mysql_query("SELECT * FROM dvd ORDER BY id DESC LIMIT " . $_GET['start'] .",25");
$last = ($_GET['start']-25);
if ($last < 0) $last = 0;
break;
}
while ($myrow = mysql_fetch_array($result)) {
if (isset($_GET['order'])) {
if ($_GET['order'] == "oldest") {
if (strcasecmp($myrow['id']) != 0) {
echo $myrow['id'];
}
}
if ($_GET['order'] == "rate") {
if (strcasecmp($myrow['rate']) != 0) {
echo $myrow['rate'];
}
}
if ($_GET['order'] == "director") {
if (strcasecmp($myrow['director']) != 0) {
echo $myrow['director'];
}
}
if ($_GET['order'] == "genre") {
if (strcasecmp($myrow['genre']) != 0) {
echo $myrow['genre'];
}
}
}
}
?>
<div class="dvd">
<img class="dvdpic" src="<? echo $myrow['bilde'] ?>.jpg" border="0" alt="<? echo $myrow['title'] ?>" />
<h2><? $myrow['title'] ?></h2>
<p><span class="what">Added:</span> <? echo $myrow['added'] ?></p>
<p><span class="what">Director:</span> <? echo $myrow['director'] ?></p>
<p><span class="what">Genre:</span> <? echo $myrow['genre'] ?></p>
<p><span class="what">Rate:</span> <img src="<? echo $myrow['rate'] ?>.jpg" border="0" alt="<? echo $myrow['rate'] ?>" /></p>
<p><span class="what">IMDb:</span> <a href="http://www.imdb.com/title/<? echo $myrow['imdb'] ?>" target="_blank">IMDb profile</a></p>
<?
$review = echo $myrow['review'];
if($myrow['reviewyesno'] == '1'){
echo '<p><span class=\"what\">Review:</span> <a href=\"$review\">Read review</a></p>';
}
else{
echo '<!-- No review --->';
}
?>
</div>
</body>- How can I let the script make new div's for each row in the db? This only adds one of the time.
- Does this script show 25 rows only when sorting by id? If so - how to make it shows 25 anytime?
- I was thinking about making a edit script. So how can I make a input- (and submit-button) where I could write the DVD's ID, and when pressing submit - it should show the row values in input columns.
- Would that "review script" work?
- This script I've got, doesn't get data from the datbase. It only works if I put "$result = mysql_query("SELECT * FROM dvd ORDER BY id DESC");" instead of line9 to line37. What should I do?