morrisjohnny

In Reguards to the Month I Solved it I'm now having trouble Getting the Date as in the 1st or 27th ectAnyway I Have bene using the The code for getting the weekday ( from w3schools )From here To Do the Day & Month But i really can't figure out how to get the date since u they use the same variables or don't they? Someone exapling PLeaseCheers in advance-Jny Mris

Hey, I do understand HTML and i do have my own website.Anyway i was Broswing the internet (titernet as i like to call it anyway) and came across a very nice looking web site I was wondering, Whts the html side of this? I know how the tables are layed out but i'm more interesed on they got the mouse roll over effects for the hyperlinks?Now i'm not saying It can be done in HTML, But could it? or does it use Javascript or somthing similer?Since every hyperlink has a differnt name on it and the Name os built into the logo, it don't see a way they have done it, i tried to look at their source code but with my knowledge being very little on anything more than html and basic php I got confussed with a fair bit of it.How Do they get that nice effect?What did they use to create the effect?Would it be easy to do?Thanks in advanceJnyP.S. Sorry it might be in the wrong forum Since i don't really know If it was done using HTML but i hope it looks from the html side, PLEASE MOVE if its in the wrong section aswell.

Once they click that link i want the frame it is in to reload and load a page in a different frame called "showframe"

hmm i understand non of that <a href =\"inbox.php\" target =\"showframe\">You Have {$messag} New Message</a> u click that link that displayes that text then i want that page to reload

does anyboddy know how once a hyperlink is click they can force that page to be refreshed?Thanks in advance-Jny

Thank you so much, Since you also helped me out with the how to refresh a frame every 60 seconds I can now do that section of my "future" game can now be completed Thanks again mate-JnySorry it too so long to sort

Okay now it shows Inbox [0] or Inbox [1] if u have one unread, This will be suitable although i don't surpose u know how i could make it say "You Have New Mail" if one mail is unread and say nothing if their is no new mail?Thanks though Thts awesome the way u have done that

the New Error message, followered by the new code

My database name i think is "jnymris_mozza" but i uploaded a file to mysql called "maffia MYSQL.sql"Anyway i now recive a new error <?php$link = mysql_connect('localhost', 'jnymris_mozza', '***');mysql_select_db(jnymris_mozza);if (!$link) { die('Could not connect: ' . mysql_error());}mysql_select_db("jnymris_mozza") or echo mysql_error();$sql = "SELECT * FROM inbox WHERE reciever='$cookieusername' AND unread='0'";$result = mysql_query($sql) or echo mysql_error();$messag = "0";while($row = mysql_num_rows($result){$messag++;} echo "<a href =\"inbox.php\" target =\"showframe\">Inbox [{$messag} new]</a>";mysql_close($link);?>

tyvm

Quick Question:Does anybody know how to make a frame refresh every 60 seconds?I dunno if u can use html, but if u can't could u explain how to use php or javascript?Sorry if its in the wrong forum

I'm getting sick of this, i'm posting now but i'll check in the morning since i really can't be bothered anymore<?php$link = mysql_connect('localhost', 'jnymris_mozza', 'qwerty######er');mysql_select_db(inbox);if (!$link) { die('Could not connect: ' . mysql_error());}mysql_select_db("Inbox");$sql = "SELECT * FROM inbox WHERE reciever='$cookieusername' AND unread='0'";$result = mysql_query($sql);$messag = "0";while($row = mysql_num_rows($result){$messag++;} echo "<a href =\"inbox.php\" target =\"showframe\">Inbox [{$messag} new]</a>";}mysql_close($link);?>

I'm starting to get sick of php already, I hope this can be sorted soon, This is the last one for the night, I've had enough.<?php$link = mysql_connect('localhost', 'jnymris_mozza', '***');mysql_select_db(inbox);if (!$link) { die('Could not connect: ' . mysql_error());}mysql_select_db("Inbox");$sql = "SELECT * FROM inbox WHERE reciever='$cookieusername' AND unread='0'";$result = mysql_query($sql);$num_messages = mysql_num_rows($result);if ($messag > 0){ echo "<a href =\"inbox.php\" target =\"showframe\">Inbox [{$messag} new]</a>";}mysql_close($link);?>

Thanks, I can't do it right now cause the server i am using has stopped working, sorry i cause so much trouble, I'm sure it will work now as if thts all wht i was missing.

<?php$link = mysql_connect('localhost', 'jnymris_mozza', '***');if (!$link) { die('Could not connect: ' . mysql_error());}$sql = "SELECT * FROM inbox WHERE reciever='$cookieusername' AND unread='0'";$result = mysql_query($sql);$num_messages = mysql_num_rows($result);if ($messag > 0){ echo "<a href =\"inbox.php\" target =\"showframe\">Inbox [{$messag} new]</a>";}mysql_close($link);?> The mail is in a table called Inbox and my phpadmin is called : jnymris_mozza i know i'm totaly new but it looks fine to me and i can't find mysql_select_db did i miss it out?

MY database is called jnymris_mozza if that helps? i'm just about to try it now. I hope i'm not causing any trouble, like i say i'm totaly new ( started last night ) and i really do thank you very muchOn top of the tweed? i live up north in the uk yeah. I got the scripts from a mate, who i think he got from someone eles

Okay thts how i wanted, Thank you for solving that problem, Now i seem to have a different one, <?php$link = mysql_connect('localhost', '***', '***');if (!$link) { die('Could not connect: ' . mysql_error());} $lijstGebruikers = "SELECT * FROM inbox WHERE reciever='$cookieusername' AND unread='0'"; $resultLijstGebruikers = mysql_query($lijstGebruikers); $messag = mysql_num_rows($resultLijstGebruikers);if ($messag > 0){ echo "<a href =\"inbox.php\" target =\"showframe\">Inbox [{$messag} new]</a>";}mysql_close($link);?> <html><head> <title>Johnnys Junk Clock Frame</title> <link rel="stylesheet" type="text/css" href="src/standard.css" /><script type="text/javascript">var d = new Date()document.write(d.getDate())document.write(".")document.write(d.getMonth() + 1)document.write(".")document.write(d.getFullYear())</script><script type="text/javascript">var d = new Date()document.write(d.getHours())document.write(".")document.write(d.getMinutes())document.write(".")document.write(d.getSeconds())</script><br /></head></html>

Thanks i think we are making progress.I will use this code untill i find out is it possible to only show this if new messages exsist

justsomeguy You nearly have my idea, I want it to say. "You Have New Mail" and make it able so u can click it and then it goes to inbox.php If you have 1 or more than 1 unread mail.

Okay i have Changed the file to start with <?phpI now recive the very simlier error New Code<?php$link = mysql_connect('localhost', '***', '***');if (!$link) { die('Could not connect: ' . mysql_error());} $lijstGebruikers = "SELECT * FROM inbox WHERE reciever='$cookieusername' AND unread='0'"; $resultLijstGebruikers = mysql_query($lijstGebruikers); $messag = mysql_num_rows($resultLijstGebruikers); "<a href ="inbox.php" target ="showframe">Inbox <? if ($messag > 0) { echo [$"messag new"]; } ?></a>"mysql_close($link);?> <html><head> <title>Mafia :: v0.10 Beta</title> <link rel="stylesheet" type="text/css" href="src/standard.css" /><script type="text/javascript">var d = new Date()document.write(d.getDate())document.write(".")document.write(d.getMonth() + 1)document.write(".")document.write(d.getFullYear())</script><script type="text/javascript">var d = new Date()document.write(d.getHours())document.write(".")document.write(d.getMinutes())document.write(".")document.write(d.getSeconds())</script><br /></head></html>

Tht works, Thanks mate

Okay i hace "conneted to mysql" as the Text says so But i now recive this error And this is my code for the whole page<html><head> <title>Mafia :: v0.10 Beta</title> <link rel="stylesheet" type="text/css" href="src/standard.css" /><?php$link = mysql_connect('localhost', '*******', '*******');if (!$link) { die('Could not connect: ' . mysql_error());} $lijstGebruikers = "SELECT * FROM inbox WHERE reciever='$cookieusername' AND unread='0'"; $resultLijstGebruikers = mysql_query($lijstGebruikers); $messag = mysql_num_rows($resultLijstGebruikers); "<a href ="inbox.php" target ="showframe">Inbox <? if ($messag > 0) { echo " [$messag new]"; } ?></a>"mysql_close($link);?> <script type="text/javascript">var d = new Date()document.write(d.getDate())document.write(".")document.write(d.getMonth() + 1)document.write(".")document.write(d.getFullYear())</script><script type="text/javascript">var d = new Date()document.write(d.getHours())document.write(".")document.write(d.getMinutes())document.write(".")document.write(d.getSeconds())</script></head></html>

Oka yi added that in but i still recive a warning saying.Warning: mysql_query(): Access denied for user 'nobody'@'localhost' (using password: NO) in /home2/jnymris/public_html/Maffia (05-05-05)/Info.php on line 26Warning: mysql_query(): A link to the server could not be established in /home2/jnymris/public_html/Maffia (05-05-05)/Info.php on line 26Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home2/jnymris/public_html/Maffia (05-05-05)/Info.php on line 27

Hello, I'm totaly new to PHP and was wondering if i could get some help ( i have read the w3schools page)I was wanting to know:When a person who was logged in has 1 unread mailed how to display textI do use Mysql tables, and i believe it has somthing to do with this: <? $lijstGebruikers = "SELECT * FROM inbox WHERE reciever='$cookieusername' AND unread='0'"; $resultLijstGebruikers = mysql_query($lijstGebruikers); $messag = mysql_num_rows($resultLijstGebruikers); ?> <tr><td class="menuItem">- <a class="menuItem" href="inbox.php">Inbox<? if ($messag > 0) { echo " [$messag new]"; } ?></a></td></tr> Thanks in advance-Jny

Thanks VM i have got it to work