Downloads display thing...

[Catie]

Hello again! I store my graphics in a MySQL database and this is the code I'm using to display them on my page:

PHP: Select all

 <?php 

//MySQL connection variables 
$user="blahblah";  
$host="localhost";  
$password="blahblah";  
$database="blahblahblah";  
$connection = mysql_connect($host,$user,$password)  
or die ("couldn't connect to server"); $db = mysql_select_db($database,$connection)  
or die ("Couldn't select database");  

//Which mySQL table to select from and in what order 
$query = "select * from `layouts` order by id desc";  

$result = mysql_query($query, $connection) or die ("Could not execute query : $query ." . mysql_error());  
$rows = mysql_num_rows($result); 
if ($rows=="0") { echo "No layouts found."; } 


//Gets and assigns variables to array 
while ($row=mysql_fetch_array($result)) {  
$id=$row["id"];  
$title=$row["title"];  
$artist=$row["artist"];  
$artisturl=$row["artisturl"];   
$type=$row["type"];  
$size=$row["size"];  
$date=$row["date"];  
$previewimage=$row["previewimage"]; 
$download=$row["download"];  
$preview=$row["preview"]; 
$dcounter=$dcounter["dcounter"]; 
$pcounter=$pcounter["pcounter"];  

//Prints out results 
echo "<table id=\"box_top\"><tr> 
<tr><td> 
<b>$title</b> 
</td> 
</tr> 
</table> 
     
<table id=\"box\"> 
<tr> 
<td valign=\"top\"> 
<img src=\"$previewimage\" width=\"160\" height=\"110\" border=\"0\" alt=\"\"> 
</td>  
<td valign=\"top\" width=\"170\"> 
<b>Added</b>: $date 
<br><b>Type</b>: $type 
<br><b>Size</b>: $size 
<br><b>Designer</b>: <a href=\"$artisturl\" target=\"_blank\">$artist</a> 
<br><b>Previews</b>: $pcounter 
<br><b>Downloads</b>: $dcounter 
<br><br> 
<a href=\"$preview\"><b>Preview</b></a> &nbsp; <a href=\"$download\"><b>Download</b></a> 
</td> 
</tr> 
</table><br>"; 
} 

?>

$dcounter=$dcounter["dcounter"]; and $pcounter=$pcounter["pcounter"]; should count the downloads/previews and $pcounter and $dcounter should display them? So, the problem is it won't display the number of the downloads/previews. I know I'm doing something wrong, but I don't know what.

Anyone knows?

By the way, maybe I'm doing something wrong in phpMyAdmin? Both dcounter and pcounter are set to VARCHAR(5) not null Default: 0

[ukgeoff]

Me thinks the problem is here:

Code: Select all

$dcounter=$dcounter["dcounter"]; 
$pcounter=$pcounter["pcounter"]; 

Should not the variable immediately to the right of = be $row?

[Catie]

Wow! Thanks so much! But I have another problem now, it won't count the downloads/previews. Do you know what it can be?

[ukgeoff]

Even with your code corrected, it wont count anything. It is just retrieving values from the database.

You need to be looking at the code that should be incrementing those values whenever a download takes place.

[Catie]

Do you know what code I need? Or at least what should I look for?
Thanks again!

[ukgeoff]

I'm guessing that the code you have shown us thus far is not yours, original that is. Is that a fair guess?

Is this all the code you have?

[Catie]

Of course it isn't mine. (Is it a problem?) It's from this:
http://seabreezed.org/index.php?show...&page=layoutdb

tutorial and it's all the code I have.

[Ryan Fait]

No, it's not a problem.

What do you mean by "count"? That variable is just a number that's stored in the database, it doesn't do any calculations.

[Catie]

Well for example if there are 10 downloads and you click on the download link it says 11. It shows how many times a file has been downloaded. Do you know how to make it count how many times a link has been clicked, because it only shows the number I put in the database?

[ukgeoff]

You need to have some code somewhere, hat every time the download link is clicked, this code is activated and it incremente the value in the database.

You will need to use and sql update script.