Gintaxas
Narys
Margas
Pranešimai: 83
Įstojęs: 2008 Lie. 16 01:07:42
|
Sveiki, čia yra kodas, kuris rodo visų žmonių komentarus, kaip reikėtų jį pakeisti, kad rodytų tik mano parašytus?
$i = 0;
$result = dbquery(
"SELECT * FROM ".DB_COMMENTS." LEFT JOIN ".DB_USERS."
ON fusion_comments.comment_name=fusion_users.user_id
ORDER BY comment_datestamp DESC LIMIT 150"
);
if (dbrows($result)) {
echo "<table width='100%' align='center' cellpadding='0' cellspacing='1' class='tbl-border'>\n";
while ($data = dbarray($result)) {
echo "<tr>\n<td class='".($i% 2==0?"tbl1":"tbl2")."'><span class='comment-name'>";
if ($data['user_name']) {
echo "<a href='".BASEDIR."profile.php?lookup=".$data['comment_name']."' class='slink'>".$data['user_name']."</a>";
} else {
echo $data['comment_name'];
}
$comment_message = nl2br(parseubb($data['comment_message']));
$comment_item_id = $data['comment_item_id'];
$comment_type = $data['comment_type'];
echo "</span>
<span class='small'> ".showdate("longdate", $data['comment_datestamp'])."</span><br>
".$comment_message."<br>";
if ($data['comment_type'] == "N") {
echo "<a href='".BASEDIR."news.php?readmore=".$data['comment_item_id']."'>Skaityti komentarą</a><br>";
}
else if ($data['comment_type'] == "A") {
echo "<a href='".BASEDIR."readarticle.php?article_id=".$data['comment_item_id']."'>View Article Comment</a><br>";
}
else if ($data['comment_type'] == "P") {
echo "<a href='".BASEDIR."photogallery.php?photo=".$data['comment_item_id']."'>View Photo Comment</a><br>";
}
else if ($data['comment_type'] == "C") {
echo "<a href='".BASEDIR."viewpage.php?page_id=".$data['comment_item_id']."'>View Custom Page Comment</a><br>";
}
else {
echo "No link.";
}
echo "</td>\n</tr>\n";
$i++;
}
echo "</table>\n";
} else {
echo "<center><br>There are no comments.<br><br></center>\n";
}
http://gameris.lt |
avice
Narys
Terminatorius
Pranešimai: 1441
Įstojęs: 2010 Bir. 25 20:06:33
|
gal sitaip
"SELECT * FROM ................. WHERE USERNAME .................
Redagavo avice 2011 Sau. 12 21:01:35 |
Gintaxas
Narys
Margas
Pranešimai: 83
Įstojęs: 2008 Lie. 16 01:07:42
|
Bet toje vietoje kaip suprantu ima duomenis iš duomenų bazės, tai tavo variantu, imtų iš mano profilio.
"SELECT * FROM ".DB_COMMENTS." LEFT JOIN ".DB_USERS." WHERE user_id='".$_GET['lookup']."
ON fusion_comments.comment_name=fusion_users.user_id
ORDER BY comment_datestamp DESC LIMIT 150"
);
Jei taip norėjai pasakyti tai išmetą tokią klaidą:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE user_id='1 ON fusion_comments.comment_name=fusion_users.user_id ORDER BY' at line 1
There are no comments.
http://gameris.lt
Redagavo Gintaxas 2011 Sau. 12 22:01:54 |
Gintaxas
Narys
Margas
Pranešimai: 83
Įstojęs: 2008 Lie. 16 01:07:42
|
Argi čia taip sunku, kad niekas nesugeba padėti? Aišku, be užmokesčio niekas nieko nedarys, todėl padėjusiam sumokėsiu 5 lt.
http://gameris.lt |
Wyciokazz
Narys
Buldozeris
Pranešimai: 216
Įstojęs: 2008 Kov. 1 14:03:15
|
<?php
$i = 0;
$result = dbquery(
"SELECT * FROM ".DB_COMMENTS."
WHERE comment_name = ".$userdata['user_id']."
ORDER BY comment_datestamp DESC LIMIT 150"
);
if (dbrows($result)) {
echo "<table width='100%' align='center' cellpadding='0' cellspacing='1' class='tbl-border'>\n";
while ($data = dbarray($result)) {
echo "<tr>\n<td class='".($i% 2==0?"tbl1":"tbl2")."'><span class='comment-name'>";
echo "<a href='".BASEDIR."profile.php?lookup=".$userdata['user_id']."' class='slink'>".$data['user_name']."</a>";
$comment_message = nl2br(parseubb($data['comment_message']));
$comment_item_id = $data['comment_item_id'];
$comment_type = $data['comment_type'];
echo "</span>
<span class='small'> ".showdate("longdate", $data['comment_datestamp'])."</span><br>
".$comment_message."<br>";
if ($data['comment_type'] == "N") {
echo "<a href='".BASEDIR."news.php?readmore=".$data['comment_item_id']."'>Skaityti komentarą</a><br>";
}
else if ($data['comment_type'] == "A") {
echo "<a href='".BASEDIR."readarticle.php?article_id=".$data['comment_item_id']."'>View Article Comment</a><br>";
}
else if ($data['comment_type'] == "P") {
echo "<a href='".BASEDIR."photogallery.php?photo=".$data['comment_item_id']."'>View Photo Comment</a><br>";
}
else if ($data['comment_type'] == "C") {
echo "<a href='".BASEDIR."viewpage.php?page_id=".$data['comment_item_id']."'>View Custom Page Comment</a><br>";
}
else {
echo "No link.";
}
echo "</td>\n</tr>\n";
$i++;
}
echo "</table>\n";
} else {
echo "<center><br>There are no comments.<br><br></center>\n";
}
|
Gintaxas
Narys
Margas
Pranešimai: 83
Įstojęs: 2008 Lie. 16 01:07:42
|
Nu va šitas kodas sutvarkytas. Čia tiems kas nori kiekvieno profilyje matyti to žmogaus parašytus komentarus. Į profile.php failą po paskutinio closetable(); įklijuojat šį kodą.
$i = 0;
$result = dbquery(
"SELECT * FROM ".DB_COMMENTS."
WHERE comment_name = ".$user_data['user_id']."
ORDER BY comment_datestamp DESC LIMIT 50"
);
if (dbrows($result)) {
echo "<table width='100%' align='center' cellpadding='0' cellspacing='1' class='tbl-border'>\n";
while ($data = dbarray($result)) {
echo "<tr>\n<td class='".($i% 2==0?"tbl1":"tbl2")."'><span class='comment-name'>";
echo "<a href='".BASEDIR."profile.php?lookup=".$user_data['user_id']."' class='slink'>".$user_data['user_name']."</a>";
$comment_message = nl2br(parseubb($data['comment_message']));
$comment_item_id = $data['comment_item_id'];
$comment_type = $data['comment_type'];
echo "</span>
<span class='small'> ".showdate("longdate", $data['comment_datestamp'])."</span><br>
".$comment_message."<br>";
if ($data['comment_type'] == "N") {
echo "<a href='".BASEDIR."news.php?readmore=".$data['comment_item_id']."'>Skaityti komentarą</a><br>";
}
else if ($data['comment_type'] == "A") {
echo "<a href='".BASEDIR."readarticle.php?article_id=".$data['comment_item_id']."'>View Article Comment</a><br>";
}
else if ($data['comment_type'] == "P") {
echo "<a href='".BASEDIR."photogallery.php?photo=".$data['comment_item_id']."'>View Photo Comment</a><br>";
}
else if ($data['comment_type'] == "C") {
echo "<a href='".BASEDIR."viewpage.php?page_id=".$data['comment_item_id']."'>View Custom Page Comment</a><br>";
}
else {
echo "No link.";
}
echo "</td>\n</tr>\n";
$i++;
}
echo "</table>\n";
} else {
echo "<center><br>There are no comments.<br><br></center>\n";
}
http://gameris.lt |
