PHP: Sistemi i lajmeve

[Butrinti]

permbajtja.php

@mysql_connect("localhost", "yyyyy", "yyyyy");
@mysql_select_db("vlora") or die("nuk mund te lidhem me database");
echo "Database Output

";
$query="SELECT Permbajtja FROM lajmet where lajmi_nr='$lajmi_nr'";
$result=mysql_query($query);
$row = mysql_fetch_assoc($result);
$Permbajtja = $row['Permbajtja'];
echo "permbajtja: $Permbajtja";
mysql_close();
?>

nuk nxjerr permbajtjen por vetem
permbajtja:

[Butrinti]

scripti trego.php


@mysql_connect("localhost", "xxxx", "xxxx");
@mysql_select_db("vlora") or die("nuk mund te lidhem me database");
$query="SELECT titulli,lajmi_nr FROM lajmet ORDER BY lajmi_nr";
$result=mysql_query($query);
$num=mysql_numrows($result);
echo "Database Output

";
while ($row = mysql_fetch_assoc($result)) { //konsultohu me manualin per pjesen ketu
$lajmi_nr = $row['lajmi_nr'];
$titulli = $row['titulli'];
echo " $titulli
";
}
$i++;
mysql_close();
?>

[Gepardi]

Butrinti nuk i ke lexuar mesa duket dy postimet vijuese.


gabimin e ke ne QUERY sepse une kam shkruajtur dicka gabim pa dashje.

permbajtja.php

$nr = $_GET['nr'];
$query="SELECT Permbajtja FROM lajmet where lajmi_nr='$nr";
//ketu ishte gabimi sepse ishte variabla $lajmi_nr qe nuk kishte vlere

Provoje mbasi ta kesh ndryshuar query -n

[Butrinti]

e zgjidha tek scripti trego.php korigjova
echo " $titulli
";

ne

echo " $titulli
";

[Butrinti]

dua te seleksionoj lajmet sipas numrit te fundit pra te javes se fundit ( jo sipas dates) pra numrit me te madh dhe provova me kete selsekt por pa sukses
$query="SELECT * FROM lajmet WHERE java_nr = MAX(java_nr) ORDER BY lajmi_nr";

[Gepardi]

Nje zgjidhje e mundshme do te ishte me dy query

$r1 = mysqL_query("SELECT max(java_nr) FROM lajmet");
$r1 = mysql_fetch_array($r1);
$r1 = $r1[0];

$r2 = mysql_query("SELECT * FROM lajmet WHERE java_nr='$r1'";

           //Ketu punon me query 2 

[Butrinti]

Nuk funksionon : Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in $num=mysql_numrows($result);

@mysql_connect("localhost", "gazeta", "xxxxx");
@mysql_select_db("vlora") or die("nuk mund te lidhem me database");
$r1 = mysql_query("SELECT max(java_nr) FROM lajmet");
$r1 = mysql_fetch_array($r1);
$r1 = $r1[0];
$r2 = mysql_query ("SELECT * FROM lajmet WHERE java_nr='$r1'");
$result=mysql_query($r2);
$num=mysql_numrows($result);
echo "Database Output

";
$i=0;
while ($i < $num) {
$titulli=mysql_result($result,$i,"titulli");
$lajmi_nr=mysql_result($result,$i,"lajmi_nr");
echo " $titulli
";
$i++;
}
mysql_close();
?>

[zeus]

-------------------------------------------

Provo te besh print $r1 dhe te shikosh çfare permban ...

-------------------------------------------

[zeus]

----------------------------------------------------------

Kam pershtypjen se duhet te jete mysql_num_rows() dhe jo mysql_numrows() ...

----------------------------------------------------------

[Butrinti]

E provova edhe me mysql_num_rows() gjithashtu te besh print $r1 por pa sukses.