[es] - Sta ovde nije u redu???

scepanmali
Beograd

Član broj: 167647
Poruke: 51
91.150.122.*

Sajt: www.watch-avengers.com

Profil

^{29.03.2008. u 03:06 - pre 195 meseci}

Imam ove dve stranice i nikako ne mogu da prosledim ove podatke u novu stranicu. Ne znam zasto.
Pogledajte kod, pa ako vidite razlog, javite mi, molim vas!

PRVA STRANICA:

Code:
<?php

$username = "root";
$password = "root";
$hostname = "localhost";

$dbhandle = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");
echo " ";

$selected = mysql_select_db("spotovi1", $dbhandle) or die("Could not select DB");
// If current page number, use it
// if not, set one!

if (!isset($_GET['page'])) {
 $page = 1;
} else {
 $page = $_GET['page'];
}

$max_results = 20;

$from = (($page * $max_results) - $max_results);

$table = "oblast_metal";
$id= $row['id'];
$row['id']=$id;
$row['id']=$id;
$row['Artist']=$Artist;
$row['Song']=$Song;

$sql = mysql_query("SELECT * FROM ".$table." ORDER BY id DESC LIMIT $from, $max_results");

while ($row = mysql_fetch_array($sql)) { ?>


<table border="0" bordercolor=#A49F8B align = "center"
cellspacing="0" cellpadding= 3 width= 500 >
<tr onMouseOver="this.bgColor='#355466';" onMouseOut="this.bgColor='#2c4453';">
<td width= "170" ><? echo
$row['Artist']; ?></td>
<td width= "200"><? echo
$row['Song']; ?></td>
<td width= "50"><a href="<?php echo "download.php?id=".$row['id'].">".$row['Artist']."- ". $row['Song'] . "";?>" target="_blank" style="text-decoration:none">Download</a></a></td>
</tr>

<?php

 echo "</table>";
}
echo "";

echo "</center>";
echo "<center>Select a Page ";
// Figure out the total number of results in DB:
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM '".$table."'"),0);

//za konacan broj strana
$total_pages = ceil($total_results / $max_results);

// za PREVIOUS Link
if ($page > 1) {
 $prev = ($page - 1);
 echo "<a href=\"" . $_SERVER['PHP_SELF'] . "?page=$prev\"> << Previous</a> ";
}

for ($i = 1; $i <= $total_pages; $i++) {
 if (($page) == $i) {
 echo "$i ";
 } else {
 echo "<a href=\"" . $_SERVER['PHP_SELF'] . "?page=$i\"><style=text-decoration:none>[ $i ]</a> ";
 }
}

// za NEXT link
if ($page < $total_pages) {
 $next = ($page + 1);
 echo "<a href=\"" . $_SERVER['PHP_SELF'] . "?page=$next\"> Next >></a>";
}
?>

DRUGA STRANICA:

Code:
<?php

$username = "root";
$password = "root";
$hostname = "localhost";

$dbhandle = mysql_connect($hostname, $username, $password) or die("Unable to connect to MySQL");
echo " ";

$table = "oblast_metal";
$table = $_GET["table"];
$row['Artist']=$Artist;
$row['Song']=$Song;
$id= $row['id'];
$id = $_GET['id'];
$Artist = $_GET['Artist'];
$Song = $_GET['Song'];

$selected = mysql_select_db("spotovi1", $dbhandle) or die("Could not select DB");

$sql = mysql_query("SELECT * FROM '".$table."' WHERE ID = '$id'");
while ($row = mysql_fetch_array($sql)); { ?>
<?php
$zajedno=$row['Artist']."- ".$row['Song'];
echo "Download </a> ";
echo "<a href=\"{$row['Link']}\">$zajedno</a>";
echo " Music Video </a> ";
}

php?>

Hvala vam unapred!

Odgovor na temu

scepanmali
Beograd

Član broj: 167647
Poruke: 51
91.150.122.*

Sajt: www.watch-avengers.com

Profil

Re: Sta ovde nije u redu???

^{29.03.2008. u 13:38 - pre 195 meseci}

Pa, radilo je ovako bez problema dok nisam zamenio pravu tabelu promenljvom $table!
Posto imam 5 tabela, napravio sam promenljivu za svih 5 i od tada mi nesto ne radi kako treba.
Prijavi gresku:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\test2\download.php on line 65

Ovo je odvojeno i ne racunam u gresku kao iznad.
Download - Music Video::: gde "-" kada predjem misem preko nje, pokazuje sve kako treba, ali kada kliknem samo
uradi refresh stranice! Meni ne pokazuje nijednu gresku dok pisem u PHP programu!

Odgovor na temu