birthday wapdesire v_2

[brand]

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

$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]

can any one help with this please

[Sora101]

this should work ;)

$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]

this should work ;)

$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]

it is lavalair DUH lol

[brand]

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]

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]

$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]&amp;sid=$sid\">$sql[1]</a>";
$main.="$lnk<br/>Hope U have A Wonderful Day<br/><br/>";
}
}

[adriane14]

clear code answer ?

[summerskye]

where do u add this?

where do u add this please

[amylee]

where do u add this please

top of the index page i presume

[summerskye]

ty

thank u amylee

[woody]

where do u add this please

it's main.php on v2