vraagje php totaal signup
ik had een vraag hoe kan ik een bestaande nieuwe lid die aangemeld sta op me index pagina krijgen via mysql.
of weet iemand hoe ik deze kan invoegen.
Danny schreef op 02.12.2008 00:35:
Iets specefieker aub?
heb een stuk tekst dat vanuit de database moet wordt geroepen hoeveel nieuwe klanten zich hebben aangemeld zodat ik deze kan bijhouden.
qua landen heb ik al in gevolg van
<script language="php"> include("header.php");</script>
<table width="100%" border="0" cellspacing="5" cellpadding="5">
<tr>
<td align="left">
<table class=design width=100% border=0 cellspacing=0 cellpadding=0><tr>
Click <a href="country_lookup.php">HERE</A> to go back!<br>
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
<?
if ($_POST[get]=='search'){
if (!$_POST[nouplinesearch]){
$getads=@mysql_query("select ".$mysql_prefix."users.* from ".$mysql_prefix."users left join
".$mysql_prefix."interests on ".$mysql_prefix."users.username=".$mysql_prefix."interests.username
where ($_POST[keyword] ".$mysql_prefix."users.username like '%$_POST[user]%' and pay_account like
'%$_POST[payacc]%' and referrer like '%$_POST[referrer]%' and upline like '%$_POST[upline]%' and
password like '%$_POST[pass]%' and email like '%$_POST[email]%' and first_name like
'%$_POST[first]%' and last_name like '%$_POST[last]%' and country like '%$_POST[country]%' and
signup_ip_host like '%$_POST[host]%') $_POST[free_refs] order by username $_POST[limit]");
}
$count=mysql_num_rows($getads);
echo "<center><table border=0 bgcolor=#FFFFCA bordercolor=#FFE339><tr><td><b>".$count." member(s)
found</b></form></td></tr></table></td></tr></table></center>";}
?>
if ($_POST[get]=='search'){
if (!$_POST[nouplinesearch]){
$getads=@mysql_query("select ".$mysql_prefix."users.* from ".$mysql_prefix."users left join
".$mysql_prefix."interests on ".$mysql_prefix."users.username=".$mysql_prefix."interests.username
where ($_POST[keyword] ".$mysql_prefix."users.username like '%$_POST[user]%' and pay_account like
'%$_POST[payacc]%' and referrer like '%$_POST[referrer]%' and upline like '%$_POST[upline]%' and
password like '%$_POST[pass]%' and email like '%$_POST[email]%' and first_name like
'%$_POST[first]%' and last_name like '%$_POST[last]%' and country like '%$_POST[country]%' and
signup_ip_host like '%$_POST[host]%') $_POST[free_refs] order by username $_POST[limit]");
}
$count=mysql_num_rows($getads);
echo "<center><table border=0 bgcolor=#FFFFCA bordercolor=#FFE339><tr><td><b>".$count." member(s)
found</b></form></td></tr></table></td></tr></table></center>";}
?>
</td></table>
</tr>
</table><br>
<script language="php"> include("footer.php");</script>
nu zocht ik iets dat deze ook nieuwe klanten er uit kan halen inplaats van de land van afkomst.