zenin
-
Posts
15 -
Joined
-
Last visited
Never
Posts posted by zenin
-
-
Is there any way one can change the size of the thumbnails in the BBcode or do the imagehosting sites have default sizes for their BBcode thumbnail pictures?
-
Thank you very much smc! I figures out by my self where to put that code. It works perfectly :D thank you very very much! :D
-
Sorry redbullmarky but I wish to have a button that a visitor can press so the testarea expands and show the hidden text. I see that this has nothing to do with php but i thought that maybe i have to edit my bbcode file to make an spoiler function. And the bbcode is in php.
Thx smc...in wich file did you place this code? -
Could you specify what you mean for my first question? Iam an absolute newbie to php so you have to take it from the start :P i know that i have to have some knowledge in javascript also. To be perfectly clear on what i want: I want a bbcode [spoiler]hiddent text[/spoiler] like code. where you have to press on a Show test button so the hidden text gets visible.
-
Hi. I would like to include a spoiler function in my blog and id like to know if there is any way to do it simple. I use MyBloggie from mywebland.com. And yes i tried to get help there but i never get any answer in the forums over there.
And i also would like to know if there is any way to make the bbcode thumbnails smaller. Thx in advance -
Hi! I need a simple referer script on my site and i have no idea how to make one. So does anyone here got a simple referer script? The idea is a list of top referes and in/out next to the link.
Thx :D -
Sorry I have to correct myself. The current code:
[code]
$query = "SELECT * FROM spunk_links
WHERE DATE_SUB(CURDATE(),INTERVAL 4 DAY) <= 'datum'
ORDER BY 'datum' DESC";
$result = mysql_query($query) or die (mysql_error());
[/code]
Will row all links I have in my database. But if I remove the ' sign around datum it will display a totally blank page.
Rest of my code looks like this:
[code]
$prev = '';
$color1 = "white";
$color2 = "#ecf5f8";
$row_count = 0;
while($r = mysql_fetch_array($result))
{
$id=$r["id"];
$title=$r["title"];
$link=$r["link"];
$info=$r["info"];
$date=$r["datum"];
$public=$r["public"];
$category=$r["category"];
$click=$r["click"];
$type=$r["type"];
$uploader=$r["uploader"];
$row_color = ($row_count % 2) ? $color1 : $color2;
if ($public == 1) {
if ($orderby == '') {
if ($last_date != $date)
{
?><br><br><center><b><? if ($date == date("Y-m-d")) { echo "Dagens länkar"; } else { echo "$date"; } ?></b></center><br><?
}
}
?>
<div id='link'>
<table width='700px' cellspacing='0px' cellpadding='2px' style='font-size: 10px;'>
<tr>
<td width='250px' bgcolor='<? echo "$row_color"; ?>' nowrap>
<? if ($category != Erbjudande) {
echo "
<a href='postlink/count.php?id=$id' target='_blank'
onmouseover=\"return overlib('$info');\" onmouseout=\"return nd();\">
$title</a>
";
} else {
echo "
<a href='$link' target='_blank'
onmouseover=\"return overlib('$info');\" onmouseout=\"return nd();\">
$title</a>
";
}
echo "
</td>
<td width='100px' align='left' bgcolor='$row_color' nowrap>
<a href='http://spunkie.se/index.php?orderby=$category'>$category</a>
</td>
<td width='100px' align='left' bgcolor='$row_color' nowrap>
<a href='http://spunkie.se/index.php?orderby=$type'>$type</a>
</td>
<td width='100px' align='left' bgcolor='$row_color' nowrap>
";
if ($category != Erbjudande) {
echo "
<a href='http://spunkie.se/index.php?orderby=clicks'>$click klick</a>
"; } else {
echo "
<a href='http://spunkie.se/index.php?orderby=Erbjudande'>Erbjudande</a>
";
}
echo "
</td>
<td width='75px' align='left' bgcolor='$row_color' nowrap>
";
$sql = mysql_query("SELECT * FROM spunk_comments WHERE reciever='$title'")or die(mysql_error());
$sql_num_rows = mysql_num_rows($sql);
echo "
<a href=''
onClick=\"return
!window.open('http://spunkie.se/comments/viewcomment.php?title=$title','comment',
'width=250,height=600,screenX=25,screenY=25,resizable=yes,scrollbars=yes')\"
>
$sql_num_rows inlägg
</a>
</td>
<td width='100px' align='right' bgcolor='$row_color' nowrap>
Av $uploader
</td>
</tr>
</table>
</div>
";
$row_count++;
$last_date = $date;
}
}
mysql_close($db);
?>
[/code] -
Sorry but it still displays a blank page... current code is still
[code]
$query = "SELECT * FROM spunk_links
WHERE DATE_SUB(CURDATE(),INTERVAL 4 DAY) <= 'datum'
ORDER BY 'datum' DESC";
$result = mysql_query($query) or die (mysql_error());
[/code]
And no errors whatsoever. I thought that perhaps my database fields have something to do with it... I changed the date field name to "datum" so it doesnt conflict with an existing function and I set the datum column type to date. Any thoughts about that? And btw that for all your help so far :D -
bumpidy bump ;)
-
If using you code everything lists up as usuall...no errors. That still didnt solve my problem... please if you dont understand my problem say so and ill explain it more thoroughly...
-
Can anyone help please. Havent figured it out yet... :(
-
Sorry wont work... my query looks like this:
$query = "SELECT * FROM spunk_links ORDER BY date DESC AND DATE_SUB(CURDATE(),INTERVAL 4 DAY) <= date";
That query will display nothing but a blank page. Not even an error.
Is there something im forgetting?
-
Im not quite sure what i have to replace enddate with. Please give me a little more concrete examples :)
-
On my website i have over 300 hundred links sorted under the date they have been posted on the site. The problem is that the list has gotten quite long. It takes like 4 seconds to load or something. So now I want to limit the list of links to the last 3 or 4 days. And I dont have a clue on how to do that.
I figuered that I cant just use the MYSQP LIMIT function becouse that only effects the links itself. I want a nice cut so it still displays all links on the last day on the index page. Please tell me if you dont understand the problem and Ill try to explain a little better.
Thx in advance!
BBcode and thumbnails
in PHP Coding Help
Posted