Forum: web design and graphics community

Celestial Star Forum > Web Development > Coding > New Question on preview/Download counter!!

Pages: [1]

« previous next »

Author

Topic: New Question on preview/Download counter!! (Read 792 times)

lulusoccer

Angeling

Posts: 19

New Question on preview/Download counter!!

« on: July 24, 2005, 08:31:00 PM »

Okay, I keep on getting the same problem, if I try to click on the links it gives me this error
"Could not execute query : SELECT * from where id='3'.Query was empty"

Here is the page that has the counter on it:
http://www.eternal-dreamz.net/guildlayouts.php?category=full

If anybody could figure out why it's doing that, I would greatly appreciate it!.. Here are my codes if you want to see them:

View.php

Code:

<?php
include ('connection.php');

$query="SELECT * from guildlayouts order by name";
$result= mysql_query($q) or die
("Could not execute query : $query." . mysql_error());

echo "<p align=center><b>Files Download</b></p>";
echo "<ol>";

while ($row=mysql_fetch_array($result))
{
$id=$row["id"];
$preview=$row["preview"];
$counter =$row["counter"];

echo "<li><a href=download.php?id=$id>$name</a></li>";
}
?>

download.php:

Code:

<?php

include ('connection.php');

$q="SELECT * from guildlayouts where id='$id'";
$result= mysql_query($query) or die
("Could not execute query : $q." . mysql_error());

while ($row=mysql_fetch_array($result))
{
$id=$row["id"];
$preview=$row["preview"];
$counter =$row["counter"];

header('Location: '.$preview);

$q="update counter set counter=counter+1 where id='$id'";
$result= mysql_query($q) or die
("Could not execute query : $q." . mysql_error());

}

?>

guildlayouts.php:

Code:

<?php

include('header.php');?>
<p class="head">|.:Neopet Guild Layouts:.|</p>
<div align="center">
<?php
include ('database/connection.php');

$category = $_GET['category'];
$query = "select * from `guildlayouts` where category='$category' order by id desc ";
$result= mysql_query($query, $connection) or die
("Could not execute query : $query." . mysql_error());

// Start  paging variables
$screen = $_GET['screen'];
$PHP_SELF = $_SERVER['PHP_SELF'];
$rows_per_page=10;         // number of records per page
$total_records=mysql_num_rows($result);
$pages = ceil($total_records / $rows_per_page);        // calculate number of pages required

if (!isset($screen))
$screen=0;
$start = $screen * $rows_per_page;        // determine start record
$query .= " LIMIT $start, $rows_per_page";
$result= mysql_query($query) or die
("Could not execute query : $query." . mysql_error());

while ($row=mysql_fetch_array($result))
{
$id=$row['id'];
$name=$row['name'];
$artist=$row['artist'];
$category=$row['category'];
$date=$row['date'];
$preview=$row['preview'];
$previewimage=$row['previewimage'];
$code=$row['code'];
$counter=$row['counter'];
?>

<table id="tablelayouts">
<tr><td colspan="2" id="tablelayoutname"><?php echo "$name"; ?></td></tr>
<tr>
<td colspan="1" id="tablelayoutimage">
<img src="<?php echo "$previewimage"; ?>"></img></td>
<td colspan="1" width="170" valign="top"></img><b>Artist:</b> <?php echo "$artist"; ?><br><b>Category:</b> <?php echo "$category"; ?><br><b>Date:</b> <?php echo "$date"; ?><br><b>Preview:</b> <a href="<?php echo "database/download.php?id=$id"; ?>">Download</a> (<?php echo "$counter"; ?>) <br><b>Code:</b><br><div align="center"><textarea><?php echo "$code"; ?></textarea></div>
</tr></td></table><br>

<?php

}

// create the dynamic links
if ($screen > 0) {
$j = $screen - 1;
$url = "guildlayouts.php?category=full&screen=$j";
echo "<a href=\"$url\">Prev</a>";        // generate the prev text link so long as page is not first page
}

// page numbering links now

for ($i = 0; $i < $pages; $i++) {            // here we go thru a loop to get the page numbers
$url = "guildlayouts.php?category=full&screen=" . $i;
$j = $i + 1;
echo " | <a href=\"$url\">$j</a> | ";
}

if ($screen < $pages-1) {                // here we generate the next text link so long as page is not last page.
$j = $screen + 1;
$url = "guildlayouts.php?category=full&screen=$j";
echo "<a href=\"$url\">Next</a>";
} ?>

<?php include('footer.php'); ?>
</div>

Thanks!