Temporarily offline...

ZX Member Registry

Add yourself to this registry- Click here \n"; } } # if # $qf_m="SELECT m.uid as uid,firstname,lastname,email,website,city,state,gpslat,gpslong,make,model,submodel,year,comments,bikecode,pic_url FROM zxmembers AS m,zxbikes AS b WHERE "; $qf_m="SELECT uid,firstname,lastname,email,website,city,state,gpslat,gpslong FROM zxmembers WHERE "; $qf_mb="SELECT m.uid,firstname,lastname,email,website,city,state,gpslat,gpslong,country FROM zxmembers as m,zxbikes as b WHERE "; # $qo_m="ORDER BY m.uid,lastname,firstname,year,make,model,submodel;"; $qo_m="ORDER BY lastname,firstname "; unset($qs); # if ($frm[firstname]){echo "firstname no empty";} # echo "firstname='$frm[firstname]', lastname='$frm[lastname]'
\n"; if (!empty($frm[firstname]) || !empty($frm[lastname])){ if (!empty($frm[firstname])){ # don't let someone get the whole list by putting in a name of # 'a' or something, but let people do partial searches if they're # geniunely trying to find something if (strlen($frm[firstname])>3){ $qs="firstname LIKE '%$frm[firstname]%' "; } else{ $qs="firstname='$frm[firstname]' "; } } # if if (!empty($frm[lastname])){ if (!empty($qs)){ $qs.="AND "; } if (strlen($frm[lastname])>3){ $qs.="lastname LIKE '%$frm[lastname]%' "; } else{ $qs.="lastname='$frm[lastname]' "; } # if .. else } # if # $qs=$qf_m . $qs ."AND m.uid=b.uid " . $qo; $qs=$qf_m . $qs . $qo_m; } elseif (!empty($frm[state])){ $qs=$qf_m . "state='$frm[state]' " . $qo_m; } elseif ( !( empty($frm[bikecode])&&empty($frm[year])&&(empty($frm[model])||$frm[model]=="ALL")&&empty($frm[make])&&empty($frm[submodel]) ) ){ if (!empty($frm[year])){$qs="year LIKE '%$frm[year]' ";} if (!empty($frm[email])){if ($qs){$qs.="AND ";}$qs.="email= '$frm[email]' ";} if (!empty($frm[make])){if ($qs){$qs.="AND ";}$qs.="make='$frm[make]' ";} if (!empty($frm[bikecode])&&$frm[bikecode]!="ALL"){if ($qs){$qs.="AND ";}$qs.="bikecode LIKE '%$frm[bikecode]%' ";} if (!empty($frm[model])){if ($qs){$qs.="AND ";}$qs.="model LIKE '%$frm[model]%' ";} if (!empty($frm[submodel])){if ($qs){$qs.="AND ";}$qs.="submodel='$frm[submodel]' ";} $qs_bike_specific=$qs; if ($debug){echo "qs_bike_sepcific=$qs_bike_specific

";} $qs.="AND m.uid=b.uid " . "GROUP BY b.uid " . $qo_m; $qs=$qf_mb . $qs; } if (empty($qs_bike_specific)){$qs_bike_specific="1=0";} if (!$qs){ echo "

No matches found for your search...

\n"; return(FALSE); } # if ($debug){ echo "qs=$qs

"; } if ($debug){ echo "qs=$qs

"; } $connect_id=mysql_connect("localhost","web","hello"); mysql_select_db("web"); $qr_m=mysql_query($qs); # big if enclosing all our prntout stuff if ($qr_m && mysql_num_rows($qr_m)){ if ($debug){ echo "query ok"; } $uid=-1; $bg1="ffd010"; $bg_bike="fff0c0"; $bg_match="#c0c0ff"; echo "

"; # echo "\n"; echo "\n", "\n"; while ($m=mysql_fetch_array($qr_m)){ # fix website if necessary if ($m[website] && !strstr(strtolower($m[website]),"http://")){ $m[website]="http://".$m[website]; } if ($m[pic_url] && !strstr(strtolower($m[pic_url]),"http://")){ $m[pic_url]="http://".$m[pic_url]; } echo "\n"; $qs_b="SELECT IF($qs_bike_specific,1,0) as exact,make,model,submodel,year,comments,bikecode,pic_url FROM zxbikes as b,zxmembers as m WHERE b.uid=$m[uid] AND b.uid=m.uid ORDER BY year,make,model"; $qr=mysql_query($qs_b); while ($a=mysql_fetch_array($qr)){ if ($a[exact]){$bg2=$bg_match;}else{$bg2=$bg_bike;} echo "\n"; } # while mysql_free_result($qr); } # while mysql_free_result($qr_m); mysql_close($connect_id); echo "

email	website	Members name	email	website	make	model	submodel
email	website	Members name	State	GPS lat	GPS long	Ctry
			make	model	submodel	year	comments
",$m[email]?"":" ", "	",$m[website]?"":" ", "	$m[firstname] $m[lastname]	",!empty($m[state])?strtoupper($m[state]):" ","	",$m[gpslat]==0.0?" ":$m[gpslat],"	",$m[gpslong]==0.0?" ":$m[gpslong],"	",$m[country]?$m[country]:" ","
	", $a[pic_url]?"":" ", "		$a[make]	$a[model]	",!empty($a[submodel])?$a[submodel]:" ","	$a[year]	",!empty($a[comments])?$a[comments]:" ","

\n"; } else{ # if echo "

No matches found for your search...

\n"; } # else } # do_search ?>

Search by...
Bike Code	Make	Model	Submodel	Bike Year	member email address	Member First Name	Member Last name	State


Back to zx homepage