birthday wapdesire v_2

**brand** · 16-06-10, 23:33

hi there i have seen this on lava script and tryed playing around with it for wapdesire v_2 script can any one please help change this for it to work please

Code:

$noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_users where month(`birthday`) = month(curdate()) and dayofmonth(`birthday`) = dayofmonth(curdate());"));
  if($noi[0]!=0){
  $sql = mysql_fetch_array(mysql_query("SELECT id, name, birthday  FROM ibwf_users where month(`birthday`) = month(curdate()) and dayofmonth(`birthday`) = dayofmonth(curdate()) ORDER BY RAND() LIMIT 1"));
  $uage = getage($sql[2]);
  $lnk = "Happy Birthday<br/><a href=\"index.php?action=viewuser&amp;who=$sql[0]&amp;sid=$sid\">$sql[1]</a>";
  echo "$lnk<br/>Hope U have A Wonderful Day<br/><br/>";
  }

thanks to any one that can help me with it pelase

**brand** · 23-06-10, 13:50

can any one help with this please

**Sora101** · 23-06-10, 15:27

this should work ;)

Code:

$noi = mysql_num_rows(mysql_query("SELECT COUNT(*) FROM ibwf_users where month(`birthday`) = month(curdate()) and dayofmonth(`birthday`) = dayofmonth(curdate());"));
if($noi > 0){
	$sql = mysql_query("SELECT id, name, birthday  FROM ibwf_users where month(`birthday`) = month(curdate()) and dayofmonth(`birthday`) = dayofmonth(curdate()) ORDER BY RAND() LIMIT 1");
	while ($row = mysql_fetch_array($sql,MYSQL_BOTH)) {
		$uage = getage($row[2]);
		$lnk = "Happy Birthday<br/><a href=\"index.php?action=viewuser&amp;who=$sql[0]&amp;sid=$sid\">$sql[1]</a>";
		echo "$lnk<br/>Hope U have A Wonderful Day<br/><br/>";
	}
 }

**brand** · 23-06-10, 19:55

Originally Posted by Sora101 [Only registered and activated users can see links. Click Here To Register...]

this should work ;)

Code:

$noi = mysql_num_rows(mysql_query("SELECT COUNT(*) FROM ibwf_users where month(`birthday`) = month(curdate()) and dayofmonth(`birthday`) = dayofmonth(curdate());"));
if($noi > 0){
	$sql = mysql_query("SELECT id, name, birthday  FROM ibwf_users where month(`birthday`) = month(curdate()) and dayofmonth(`birthday`) = dayofmonth(curdate()) ORDER BY RAND() LIMIT 1");
	while ($row = mysql_fetch_array($sql,MYSQL_BOTH)) {
		$uage = getage($row[2]);
		$lnk = "Happy Birthday<br/><a href=\"index.php?action=viewuser&amp;who=$sql[0]&amp;sid=$sid\">$sql[1]</a>";
		echo "$lnk<br/>Hope U have A Wonderful Day<br/><br/>";
	}
 }

thanks but that is the same as what i put up and is off a lava script i am using wapdesire v_2 script

**subzero** · 24-06-10, 11:48

it is lavalair DUH lol

**brand** · 24-06-10, 12:48

Originally Posted by subzero [Only registered and activated users can see links. Click Here To Register...]

it is lavalair DUH lol

lava uses echo for the coding and ibwf_ for database and wapdesire v_2 dont use none of them it uses $main.=" and also has the name of the part eg users, profiles, themes

**animal1982** · 24-06-10, 22:34

add a new row birthday` varchar(10) NOT NULL default in table users, then insert it in when user signs up then u can call it m8 thats what i would do lol

**jsyguy23** · 23-10-10, 16:22

$noi=mysql_num_rows(mysql_query("SELECT COUNT(*) FROM users where month(`birthday`) = month(curdate()) and dayofmonth(`birthday`) = dayofmonth(curdate());"));
if($noi>0){
$sql=mysql_query("SELECT id, name, birthday FROM users where month(`birthday`) = month(curdate()) and dayofmonth(`birthday`) = dayofmonth(curdate()) ORDER BY RAND() LIMIT 1");
while($row=mysql_fetch_array($sql,MYSQL_BOTH)){
$uage=getage($row[2]);
$lnk="Happy Birthday<br/><a href=\"profile.php?who=$sql[0]&sid=$sid\">$sql[1]</a>";
$main.="$lnk<br/>Hope U have A Wonderful Day<br/><br/>";
}
}