fwilson

Hi! I've made a website for our wedding and let me tell you, it's been a looong time since I did any programing in PHP and mysql. I actually managed to make a decent HTML5 page with some php elements a mysql DB that registers all the guests who sign up and even sends a confirmation per e-mail and sms. Now I'm working on the back-end where we can view all the guests who has signed up, which also works just fine. I have now however, arrived at the point where my mySQL skills come to an abrupt stop. The database is called bryllup and the only table I'm using is called deltager. I have two rows which I want to count, these rows are called, gjest1 and gjest2 I need to make a php script that checks if gjest1 and gjest2 IS NOT NULL (i guess) and then count and add then into one variable and then print them.. something like: print "So far there are $row guests registered for the big day"; Anyone able to help us out with this? Cheers, will make the musses very happy - best moonunit