Guest User

Untitled

a guest
Jan 23rd, 2019
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. String sqlMaj = "SELECT * FROM product as prod"
  2. + "INNER JOIN utilisateurs as ut ON prod.no_utilisateur = ut.no_utilisateur "
  3. + "INNER JOIN retraits as ret ON ret.no_article = prod.no_article "
  4. + "INNER JOIN categories as cat ON cat.no_categorie = prod.no_categorie "
  5. + "WHERE prod.name LIKE ? AND cat.name= ? ";
  6.  
  7. <select name="category" id="inputState" class="form-control">
  8. <option value="1=1" selected>Toutes</option>
  9. <c:forEach items="${listCategories}" var="category">
  10. <option value="${category}">${categorie}</option>
  11. </c:forEach>
  12. </select>
Add Comment
Please, Sign In to add comment