include "dbCon.php";
$sn = $_GET['sn'];
$query = mysql_query("SELECT *,signup.email as email1 from signup left join jobs on signup.email=jobs.email where signup.sn = '$sn'");
$row = mysql_fetch_array($query);
$email=$row_list['email'];
?>
$list = mysql_query("SELECT * from signup left join interest on signup.email = interest.email where signup.sn = '$sn'");
while($row_list=mysql_fetch_assoc($list))
{
if ($intScope=="")
$intScope = $row_list['interest'];
else
$intScope .= " , " . $row_list['interest'];
}
echo $intScope;
?>
Marital status:
echo $row["marital"]; ?>
Nationality:
echo $row["nationality"]; ?>
Height:
echo $row["height"]; ?>
Weight:
echo $row["weight"]; ?>
Dress size:
echo $row["dresssize"]; ?>
Shoe size:
echo $row["shoesize"]; ?>
Hair type:
echo $row["hair"]; ?>
Hair color:
echo $row["haircolor"]; ?>
Eyes color:
echo $row["eyescolor"]; ?>
Vital statistics:
Bust ( echo $row["bust"]; ?>), cup ( echo $row["cup"]; ?>), waist ( echo $row["waist"]; ?>), hip ( echo $row["hip"]; ?>)
Occupation:
echo $row["occupation"]; ?>
Spoken Language:
echo ("$row[lang]"); ?>
Other spoken languages:
echo ("$row[lang1]"); ?>
:: Self-description
echo ("$row[self]"); ?>
:: Working experience
Modeling:
Fashion Show:
echo ("$row[m1]");?>
TV Commercial:
echo ("$row[m6]")?>
Bridal Show:
echo ("$row[m2]");?>
MTV Shooting:
echo ("$row[m7]");?>
Hair Show:
echo ("$row[m3]")?>
Magazine Shooting:
echo ("$row[m8]");?>
Make-up Show:
echo ("$row[m4]");?>
Advertisement Shooting:
echo ("$row[m9]")?>
TV Shooting:
echo ("$row[m5]");?>
Others:
echo ("$row[m10]")?>
Show:
Motor Show :
echo ("$row[s1]");?>
Ushering :
echo ("$row[s5]");?>
Road Show :
echo ("$row[s2]");?>
Fair :
echo ("$row[s6]")?>
Product Launching :
echo ("$row[s3]")?>
Others :
echo ("$row[s7]");?>
Exhibition :
echo ("$row[s4]");?>
Promoter:
Electronic show:
echo ("$row[p1]");?>
Health Care Product:
echo ("$row[p9]")?>
Food and beverage:
echo ("$row[p2]");?>
Body Care Product:
echo ("$row[p10]")?>
Telecommunication:
echo ("$row[p3]")?>
Business Plan:
echo ("$row[p11]")?>
Alcohol:
echo ("$row[p4]");?>
Membership:
echo ("$row[p12]")?>
Cigarette:
echo ("$row[p5]");?>
Body Accesories:
echo ("$row[p13]")?>
Sport and Equipment:
echo ("$row[p6]")?>
Car Accesories:
echo ("$row[p14]")?>
Beauty Care Product:
echo ("$row[p7]");?>
Clothing and Shoes:
echo ("$row[p15]")?>
Make-up Product:
echo ("$row[p8]");?>
Others:
echo ("$row[p16]")?>
Others:
Make-up Artist:
echo ("$row[o1]");?>
Supervisor:
echo ("$row[o5]");?>
Hair Stylist:
echo ("$row[o2]");?>
Waiter/ Waitress:
echo ("$row[o6]")?>
Beautician:
echo ("$row[o3]")?>
Clerk:
echo ("$row[o7]");?>
Image Consultant:
echo ("$row[o4]");?>
Others:
echo ("$row[o8]");?>
Award:
Beauty Contest:
echo ("$row[a1]");?>
Others:
echo ("$row[a2]");?>
:: Preferable working time
Monday:
Tuesday:
Wednesday:
Thursday:
Friday:
Saturday:
Sunday:
:: Preferable working place
Choice
1)
Choice
2)
Choice
3)
Choice
4)
Choice
5)
Choice
6)
:: Types of jobs chosen
Modeling:
// include "dbCon.php";
// $sn = $_GET['sn'];
// $email = $_GET['email'];
// $fullname = $_GET['fullname'];
// // $query1 = mysql_query("SELECT email from signup where fullname='$fullname'");
// while($row_list=mysql_fetch_assoc($query1))
// {
// $email=$row_list['email'];
// }
// $list = mysql_query("SELECT * from signup, jobs where signup.email = '$email' and jobs.email='$email' and signup.email = jobs.email");
$list = mysql_query("SELECT * from signup left join jobs on signup.email = jobs.email where signup.email = '$email'");
while($row_list=mysql_fetch_assoc($list))
{
echo "{$row_list['model']} ";
} // End while loop.
?>
Shows:
// include "dbCon.php";
// // $sn = $_GET['sn'];
// $email = $_GET['email'];
// $fullname = $_GET['fullname'];
// $list = mysql_query("SELECT * from signup, jobs where signup.email = '$email' and jobs.email='$email' and signup.email = jobs.email");
$list = mysql_query("SELECT * from signup left join jobs on signup.email = jobs.email where signup.email = '$email'");
while($row_list=mysql_fetch_assoc($list))
{
echo "{$row_list['shows']} ";
} // End while loop.
?>
Promoter:
include "dbCon.php";
// $sn = $_GET['sn'];
// $email = $_GET['email'];
// $fullname = $_GET['fullname'];
//
// $query1 = mysql_query("SELECT email from signup where fullname='$fullname'");
// while($row_list=mysql_fetch_assoc($query1))
// {
// $email=$row_list['email'];
// }
// $list = mysql_query("SELECT * from signup, jobs where signup.email = '$email' and jobs.email='$email' and signup.email = jobs.email");
$list = mysql_query("SELECT * from signup left join jobs on signup.email = jobs.email where signup.email = '$email'");
while($row_list=mysql_fetch_assoc($list))
{
echo "{$row_list['promoter']} ";
} // End while loop.
?>
:: Others criteria
Able to work outstation
:
Able to work at night
:
Posses own transport
:
Willing to wear sexily
:
Willing to work for cigarette and alcoholic company
:
Please ">contact us to request for echo ("$sn"); ?>