up2trouble
Jul 28 2007, 06:20 PM
When there are no birthdays for a particular month, I would like for it to say "There are no birthdays this month". When I tried, I got the phrase returned for every record in the db. Any suggestions? CODE function displayBirthdays($connect, $db_table4)
{
$sql = "SELECT dob, lastName, firstName FROM $db_table4 ORDER BY dob";
$result = mysql_query ($sql, $connect) or die ('Query failed: ' .mysql_error());
while ($row = mysql_fetch_array($result))
{
$lastname = $row["lastName"];
$firstname = $row["firstName"];
$dob = $row['dob'];
$month = substr($dob,0,2);
$day = substr($dob,3,2);
$currentmonth = date("m");
if ($month == $currentmonth && $month != 00 )
{
echo"<FONT SIZE='+1'>$firstname $lastname - [$day]</FONT><BR>";
}
}
}
Reply
jlhaslip
Jul 28 2007, 06:33 PM
One thing to check for in the If statement is the data type of the Month and Currentmonth. If one is numeric and the other is text, your comparison might fail for that reason. Not sure, but worth checking out.
Reply
up2trouble
Jul 28 2007, 08:29 PM
dob field is varchar current month is whatever type php gives to m
Reply
jlhaslip
Jul 28 2007, 09:47 PM
From the php Manual: QUOTE Returns a formatted date string. so, if the date is stored as a numeric value, I think you are comparing apples to oranges and the comparison is failing for that reason. search:php type casting to see if you can compare apples to apples. *edit* Nope. that isn't it. the following code forces a type casting onto the data and the comparison still works, so it must be something else in the code. CODE <?php
$lastname = Haslip;
$firstname = Jim;
$month = (integer) "12"; // except grab it from the database
$currentmonth = (string) 12;
if ($month == $currentmonth )
{
echo "$firstname $lastname has a birthday today<br />";
} else {
echo "no match comparing $firstname $lastname 's birthday month <br />";
}
?> to continue debugging this problem, insert some echo statements in the output to display both the month from the dob field and the current month as per the date () to compare the results manually. Also, check this line and tell me if the negative assignment for the $month being compared to '00' is correct?CODE if ($month == $currentmonth && $month != 00 )
Reply
Similar Topics
Keywords : birthday, system
- Creating A Php Login System Using Mysql
I need help in creating a login system, what I want is a login system (9)
How To Remember Complex Passwords
Use the BEST password system ever! (8) The Trap17 forums have a whole subforum devoted to those amongst use who have failed to remember
their passwords, and have locked themselves out of their free web hosting account. If you forget
your password, you can go to Free Web Hosting, No Ads > FREE WEB HOSTING > FREE WEB HOSTING
REQUESTS > Free Web Hosting : Password Reset and ask the friendly admins there to reset your
password for you. Remember the days when your password on the Internet could be something like
andrew18 ? And you could use that same password on all three websites that you visited....
Suggestions For Version 3 Of The Credit System
(23) Although its been a long time since it was first announced that a version 3 of the credit system was
announced to various people. This topic gave me a great idea and a reason for this topic . That
is what would you like to see in the version 3 of the credit system, let it be updates to current
features or new ideas post them here and give details as to why you want this change or to make an
update to the credit system. Not to take from saitunes topic about this, but sending an email or a
pm that persom is about to hit 0 credits is a great idea and I would say that wh....
Virtual Pc 7 For Mac
does anyone know how to install a operating system on it. im stuck :( (11) Hey Does anyone use Mac G5 here? I have a Mac G5 with leopard installed. Ive recently installed
Virtual Pc 7 i followed the instructions. And it told me to insert a disc and then choose the disc
type and click capture disc if it isnt already captured automatically. However it wont work for me
because the option to press capture disc is greyed out. If it doesnt let me click on it then how am
i suppose to load it. And it says any windows is compatible. but if i had service pack 2 would it
matter? I don't know. it doesnt seem to be working. Do you know which operating ....
Its's Official Microsoft Is Done With The Windows Operating System
(12) Wow and I thought this one website was joking around that Microsoft plans to do one more Windows
Operating. I don't know if Windows 7 will be the last one or not but the project goes by the
code name Midori and it is based on the Cloud computing concept, which by the way Dell is trying to
copyright this name for. All I know about cloud computer is that it will be internet based
operating system meaning that buying CD's based software could end. Heck we are already seeing
it in which yo ucan download full license software without hte use of a CD (legally). Rig....
Browse System Files In The Browser...
(2) Hi all Trap 17 people... I am not sure if you are already aware of this fine piece of information,
But definitely a must know feature... Browsing your system files in your browser. For more visit the
below link http://varalu.blogspot.com/2008/07/browsin...in-firefox.html You can use this feature
to do so many stuffs... pretty much useful for addon developers. /smile.gif"
style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />....
Full Cms System [php]
Really Good Guide to Follow. (4) This tutorial will teach you how to make a full news cms, this tutorial is quite long and don't
complain about spelling mistakes! QUOTE Features: Admin Panel - Add News - Edit News -
Delete News Comments - Add Comments - Delete Comments - Edit Comments BBCode - Bold Tags- Italics
Tags - Underlined Tags - Strike Through Tags - Link Tags - Image Tags - Code Tags - E-Mail Tags
To start off we need to create our mysql for our news cms. CODE CREATE TABLE `news`
( `id` int(10) NOT NULL auto_increment, `title` varchar&#....
Postage Costs Problem For My Website
Ideas for postage system needed (7) Hi all, I have a problem with my wife and the postman..........no, I didn't mean to
say that, I mean I have a problem with how to work out the best way of charging my customers a fair
postage. Here is the problem; on my website I sell books and our wonderful happy chappies at the
Royal Mail have decided that not only have we got to weigh the book we now have to measure the
damned thing as well! This has led to a complete restructuring and complication of the postage
prices. To make this short I will have to illustrate this the best way I know how....
Stupid Credit System
(10) Why does this site has a stupid credit system that you only get 0.7 credit a word or is it even
less. WTF is this.....
Microsoft Vs. Macintosh
Which operation system is the best (33) Now that we all know Microsoft is comming out with a new windows soon. It's called Windows 7.
Now after reading an article about that comming out, i got a little upset. For one in the last
sentece that i read, microsoft says We are trying to create an operating system that can make you
stop dreaming about OS (Operating System) X or Linux. Well for all of that don't know what OS X
is, it's Macintosh's Operating system. Last time i knew was that MAC has created an
operating system that runs off of the same hardware as Microsoft Windows does. The hardware th....
Is The Database System Gone Again? [resolved]
Errors on PHPMyAdmin again (12) I wonder if there is a problem with the PHPMyAdmin system again? When trying to get into it, I once
again get the following: QUOTE Warning: session_write_close() : SQLite: session write query
failed: database is full in /usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42
Warning: session_write_close() : Failed to write session data (sqlite). Please verify that the
current setting of session.save_path is correct
(/var/cpanel/userhomes/cpanelphpmyadmin/sessions/phpsess.sdb) in
/usr/local/cpanel/base/3rdparty/phpMyAdmin/index.php on line 42 Warning: Ca....
News System (cms)
.::DeadMan::. Paraphrased by alex1985 (4) A really nice tutorial how to create a full news system, a good guide to follow. The features are:
1. Admin Panel a) Add News /cool.gif" style="vertical-align:middle" emoid="B)" border="0"
alt="cool.gif" /> Edit News c) Delete News 2. Comments a) Add Comments /cool.gif"
style="vertical-align:middle" emoid="B)" border="0" alt="cool.gif" /> Delete Comments c) Edit
Comments 3. BBCode a) Bold Tags/Italics Tags /cool.gif" style="vertical-align:middle" emoid="B)"
border="0" alt="cool.gif" /> Underlined Tags c) Strike Through Tags d) Link Tags e) Image Tags....
Happy Birthday Canada!
July 1 is Canada's national holiday (4) Today, we Canadians celebrate Canada Day. On July 1867, three British colonies, New Brunswick, Nova
Scotia and the Province of Canada, joined together to become a federation of four provinces known as
Canada. The Province of Canada, formerly Upper Canada and Lower Canada, was divided to become
Ontario and Quebec. Originally known as Dominion Day, the name was officially changed to Canada Day
in 1982, the year the Constitution Act patriated our constitution and the British no longer had any
polotical control over our country. There is always a huge festival in Ottawa, ....
Regarding The New Rating System
(3) Alright, I love the new rating system as you can tell how much I've been using it, but there are
a few little things about it do annoy me. I've waited up until now to share it just because I
thought it was in beta or something and was going to be changed, but I think I'll post my
opinions now. First of all I'll talk about having your icon next to your name: People with
names as long as mine, it goes onto the next line, and when you mouse over, it goes back up to the
previous line. It is extremely annoying. And then when I try to click on it to se....
Blood Grouping System
Important blood grouping system of human and non-human (2) RBC (red blood cells) is an important element of blood. There are many antigenic substances present
in the surface of RBC. Depending upon the presence or absence of inherited antigenic substances on
the surface of RBC, blood may be classified in different groups; these groups are called Blood Group
or Blood Type. Other then human, animals and bacteria have cell surface antigens and they have also
blood grouping, but their blood groups are quite different. Human have 29 recognized blood group
system (recognized by International Society of Blood Transfusion, ISBT). The po....
I Have 30 System In My Network
I want my network to become slow what I need to do (9) Hi I have 30 system in my network I want my network to become slow what I need to do can any one
tell me even if there try to browes like yahoo, hotmail, gmail, etc.the pages shoud not open any
pages My network is 100mbps And my internet speed is 1mbps I don’t have any router only
unmanaged switch ....
Credit System V2.0 Online
Free Web Hosting Credit System v2 now online! (22) Dear Members, I am pleased to announce that I have finished coding Credit System V2.0 and its now
online for members to use. Instead of the old URL used for managing your free web hosting account
(http://www.trap17.com/process), You shall now be using :- http://www.trap17.com/manage (Credit
System v2.0 Url) The new version is :- More secure. More reliable. Easily Upgradable and employs
Module system. Has a Much better look. Central Login. Ajax Powered. Has a Log System. Good
number of Bugs fixes Please use it and kindly report any further suggestions, comme....
Ubuntu Linux As Free Operating System Alternative
linux operating system (47) About three years ago I decided to learn how to use Linux and after a lot of posts on a forum I
tried Ubuntu Linux as it was recommended as a good first Linux distro. Ubuntu is not the easiest
Linux distro to use but with its unmatched forum community support it is one of the easiest to learn
to use. One of the problems with learning Linux is that a lot of users have an attitude that Linux
should be a free Windows knock off which it is not. Ubuntu is build on a Linix core or kernel and is
a different Open Source and free as in to use operating system. This brings us to t....
Adventure11 - Internet Surfing Game And Advertising System
(4) About Adventure11 Innovative & Experienced Leadership Adventure11 v1.0, Internet Surfing
Game and Advertising System was officially launched on April, 23rd 2007. Adventure11 is owned and
operated by 2020 Internet Incorporated, a registered legal corporate entity of the Republic of
Panama in Central America. 2020 Internet Incorporated is a Software Development Company with a
commitment to providing unique and valuable services for the Internet Advertising Industry,
specifically for the Incentive Based Internet Advertising Industry. IT Professionals and Progra....
What's Your First System?
(93) If I had to say my very first game system was it had to be the Nintendo 64. It was christmas and
when I was little kid and opened it I was so excited to play mario 64 I played it everyday it was
so, fun! Then mario party came out..I started to play it wasn't bad I just love the felling
of playing it and now a days I still go with nintendo I have a wii and DS I would never go to
another company because mario was the game I was always good at.. /wink.gif"
style="vertical-align:middle" emoid=";)" border="0" alt="wink.gif" />....
Innovative Login System
A new way to login to a website (18) Hi, I came across this website www.planmylifestyle.com which offers an innovative login system. In
the traditional login system, a user is asked to enter a username and password besides many other
personal information. In this website, to register the site creates an ID file that the user can
download to the local hard drive. After registration, to login to the website, the user has to
simply upload the registered ID file (browser and select ID file from local hard drive) and click on
the Login Button. The user is then taken to the website which seems to be a searc....
System Does Not Detect Dvd/cdrom Drive
(21) so i came home from school and my brother told me that my mom's laptop doesn't detect the
dvd/cd rom drive (the drive icon doesn't show up in My Computer). he told me that the drive
doesn't even open up (meaning he can't put any cd there). i thought he was just joking so i
just shrugged it off. that was until i checked the laptop myself. he was right. the drive is not
detected and the icon doesn't show up in the My Computer window. when i checked the drive, the
drive light was on (just on, not blinking or anything). i tried pushing the open drive ....
Get 30 Gb Email For Free
let us talk about , email system for huge data ! (31) Friends here we are talking about largest email, free System http://www.30gigs.com this one is
good and can handel many file at a time. plz let me know any one having this type of information
! Also for small user www.walla.com is good one....
School's Blocking System.
Its not the smartest of things (28) The blocking system at school for blocking websites is stupid. It blocks pretty much any website you
go to. If you go to school what is the blocking system like there? By the way I am posting this of a
school computer /laugh.gif" style="vertical-align:middle" emoid=":lol:" border="0" alt="laugh.gif"
/>....
Game Maker
Game Creation System (15) Always wanted to make games? Check out Game Maker . It's free and you can do so much with it.
"Have you ever wanted to be able to design computer games, but didn't want to spend countless
hours learning how to become a programmer? Then you've come to the right place. Game Maker is a
program that allows you to make exciting computer games, without the need to write a single line of
code. Making games with Game Maker is a lot of fun. Using easy to learn drag-and-drop actions, you
can create professional looking games within very little time. You can make gam....
5.1 Sound System Problems
Need help... (8) I have a 5.1 Sound System. It works great in 2 channels but when I switch to 5.1 the subwoofer
ain't working. My motherboard has a nvidia 4 ultra chipset so it supports 5.1 configuration.
Also in nvidia mixer when I use sound test everything is great and I can hear the subwooofer working
as is should. But when I want to watch a movie or listen to music the subwoofer is as good as dead.
Can somebody help me? ....
New System Shuts Down After Running About 1 Minute
new ecs extreme (13) I have a new ecs extreme motherboard with an apthlon 939 3000+ processor, with 512mb ram a new power
supply and new hardrrive. I have a 128m AGP video card from a good machine. All of the itemes I am
using have either come from a running system or have been tested in a working computer. My computer
will turn on and I can get to cmos setup or to boot from cd, however, after about 1-2 minutes the
system just shuts down.....
Install Two Anti-virus Software In 1 System
Is it ok? (36) I found out that AVG Free version isn't eliminating even trojan viruses. I only have this free
version from protecting my system. Is it okay to install one more anti-virus software on top of this
AVG Free version which is already installed and updated to the latest version? I have the option of
installing Norton Anti-virus 2005. Will it cause any problem since the two softwares may use the
same source from the computer, if I install this one? Do you recommend that I should uninstall
first the existing software and install the new one? Will Norton Anti-virus 2005 ....
Complete Login System
With PHP + MYSQL (57) Its an complete login sistem made and tested by me and I think itwill be very usefull for people who
are tryn to learn PHP. First, let's make register.php: CODE <?
include("conn.php"); // create a file with all the database connections
if($do_register){ // if the submit button were clicked if((!$name)
|| (!$email) || (!$age) || (!$login) ||
(!$password) || (!$password2)){ print "You can't let
any fields in blank....
What's Your Favorite Game System - Console
select one from each poll (180) i'm a computer game fan. it's expensive but more useful. it can be use for many purpose for
your study and entertainment. much easier to use and most common to more people.....
Looking for birthday, system
|
|
Searching Video's for birthday, system
|
advertisement
|
|
