[resolved] Downloads display thing..

Catie · 12-19-2006, 06:37 AM

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

PHP Code:

  <?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

baxter · 12-19-2006, 06:55 AM

should this

PHP Code:

  $preview=$row["preview"]; 

$dcounter=$dcounter["dcounter"]; 

$pcounter=$pcounter["pcounter"];

be

PHP Code:

  $preview=$row["preview"]; 

$dcounter=$row["dcounter"]; 

$pcounter=$row["pcounter"];

Noobie · 12-19-2006, 08:16 AM

Quote:

Originally Posted by baxter

should this

PHP Code:

  $preview=$row["preview"]; 

$dcounter=$dcounter["dcounter"]; 

$pcounter=$pcounter["pcounter"];

be

PHP Code:

  $preview=$row["preview"]; 

$dcounter=$row["dcounter"]; 

$pcounter=$row["pcounter"];

Good eyes

give him some rep

Alex. · 12-27-2006, 06:29 PM

doesnt his script only print out 1 result?

sorry, i am novice and im very confused

Dan · 12-27-2006, 06:43 PM

No:

while ($row=mysql_fetch_array($result)) {
That somehow works for looping, although PHP has another function made for looping through results: mysql_fetch_assoc.

12-19-2006, 06:37 AM	#1 (permalink)
Catie New Member Join Date: Dec 2006 Posts: 10 0.00 NP$ (Donate)	Downloads display thing.. Hello everyone! I store my graphics in a MySQL database and this is the code I'm using to display them on my page: PHP Code: <?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>   <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

12-19-2006, 06:55 AM	#2 (permalink)
baxter NamePros Regular Join Date: Apr 2006 Posts: 289 1,990.00 NP$ (Donate)	should this PHP Code: `$preview=$row["preview"]; $dcounter=$dcounter["dcounter"]; $pcounter=$pcounter["pcounter"];` be PHP Code: `$preview=$row["preview"]; $dcounter=$row["dcounter"]; $pcounter=$row["pcounter"];` __________________ Chimps.ca - Swans.ca - Snails.ca

12-27-2006, 06:29 PM	#4 (permalink)
Alex. NamePros Regular Join Date: Nov 2006 Location: Uk Posts: 601 133.80 NP$ (Donate)	doesnt his script only print out 1 result? sorry, i am novice and im very confused __________________ _\\|/_ _\\|/_ _\\|/_ _\\|/_ _\\|/_ :confused:

12-27-2006, 06:43 PM	#5 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,801 56.00 NP$ (Donate)	No: while ($row=mysql_fetch_array($result)) { That somehow works for looping, although PHP has another function made for looping through results: mysql_fetch_assoc.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)