hello all;
<!DOCTYPE html>
<!--
To change this license header, choose License Headers in Project Properties.
To change this template file, choose Tools | Templates
and open the template in the editor.
-->
<html>
<head>
<meta charset="UTF-8">
<title>Our Local site</title>
</head>
<body>
<form action="welcome.php" method="post">
<input id="t1" name="t1"type="text" placeholder="table name"><br>
<input id="s1"type="text" name="skill[]"placeholder="skill or item or spec">
<input id="s2" type="text" name="skill[]" placeholder="skill or item or spec">
<input id="s3" type="text" name="skill[]" placeholder="skill or item or spec">
<input id="s4"type="text" name="skill[]" placeholder="skill or item or spec">
<input id="s5"type="text" name="skill[]" placeholder="skill or item or spec">
<input id="s6"type="text" name="skill[]" placeholder="skill or item or spec">
<input id="s7"type="text" name="skill[]" placeholder="skill or item or spec">
<input id="s8"type="text" name="skill[]" placeholder="skill or item or spec">
<input id="s9"type="text" name="skill[]" placeholder="skill or item or spec">
<input id="c1"type="text" name="city[]"placeholder="city">
<input id="c2"type="text" name="city[]"placeholder="city">
<input id="c3"type="text" name="city[]" placeholder="city">
<input id="c4"type="text" name="city[]" placeholder="city">
<input id="c5"type="text" name="city[]" placeholder="city">
<input id="c6"type="text" name="city[]"placeholder="city"><br>
<input id="r1"type="text" name="region[]"placeholder="Region in city">
<input id="r2"type="text" name="region[]" placeholder="Region in city">
<input id="r3"type="text" name="region[]" placeholder="Region in city">
<input id="cn1"type="text" name="country[]" placeholder="country">
<input id="cn2"type="text" name="country[]" placeholder="country">
<input id="cn3"type="text" name="country[]" placeholder="country">
<input id="l1"type="text" name="lat"placeholder="Latitude in degrees">
<input id="l2"type="text" name="long"placeholder="Longitude in degrees">
<input type="submit">
</form>
</body>
</html>
i wanna use nested views on a same column....
like there is a column of "skills" in my database and i wanna query it for three words....
c++,java,python
i wanna find a person with all these three skills ,,
so i am using regexp like
create view a1 as
SELECT "email" from e where (skills) regexp "java";
then
create view b1 as
SELECT "email" from a1 where (skills) regexp "java";
then
create view c1 as
SELECT "email" from b1 where (skills) regexp "java";
i want to get the values from form
and then want to create an array of views like
create view anyname as
SELECT "email" from e where (skills) regexp "java";
here "java" should be taken from the skills textbox..