DaniWeb Forum Index > Web Development > PHP

Need help with If and While Clauses

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2007

Posts: 13

Reputation: elderp is an unknown quantity at this point

Solved Threads: 0

elderp

Offline

Newbie Poster

Need help with If and While Clauses

Jun 23rd, 2007

Here is my code:

Help with Code Tags

(Toggle Plain Text)

if ($num = $i) {
echo ("<p align='left'>It's everyone's unbirthday today!</p><br>")
}
else {
while ($i < $num) {
 
 
 
 
$name=mysql_result($result,$i,"username");
 
$day=mysql_result($result,$i,"bday");
 
$city=mysql_result($result,$i,"lpcity");
 
$email=mysql_result($result,$i,"emailques");
 
 
 
 
 
echo "<br>Username: $name<br>Birthday: $day<br>City From: $city<br>On Emailing?: $email<br><br><hr><br>";
 
$i++;
 
}
 
 
 
 
echo("<p align='center'><font face='Arial' size='3' color='#FF0000'>If your information is wrong please email lpbirthdays@johnpedroza.com and we will change it.</font></p>");
echo("<p></p>");
 
include("adder.html");
 
echo("<p></p>");
include("footer.html");
?>

What I want it to do is if there is a birthday show it, but if there is not a birthday say "It is everyone's unbirthday!" Should be easy but it isn't working. The while statement by itself is working, in other words I can get it to show me a list of today's birthdays, but if it is a no birthday month it isn't working. Thanks in advance for the help.

•

Join Date: Aug 2005

Posts: 5,266

Reputation: iamthwee is a splendid one to behold

Solved Threads: 377

iamthwee

Offline

Posting Expert

Re: Need help with If and While Clauses

Jun 24th, 2007

I've not looked at your code extensively but if statements need a double equals sign to do comparisons.

i.e. if (something == condition)

Assuming a table as such...

pedantic_table (table name)

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
+----+-------+------------+
| id | name  | birthday   |
+----+-------+------------+
|  1 | Dan   | 1995-09-01 |
|  2 | Dani  | 1982-11-11 |
|  3 | Sally | 1989-10-13 |
+----+-------+------------+
+----+-------+------------+
| id | name  | birthday   |
+----+-------+------------+
|  1 | Dan   | 1995-09-01 |
|  2 | Dani  | 1982-11-11 |
|  3 | Sally | 1989-10-13 |
+----+-------+------------+

What I would do is pipe all your data from your table into an array then compare each birthday date as you go along. If the birthday matches the curDate() show "it's your birthday" if not show "happy unbirthday"

Last edited by iamthwee; Jun 24th, 2007 at 7:40 am.

*Voted best profile in the world*