advanced code snippet search

Posted By

gcman105 on 08/27/09


Tagged

mysql textmate


Versions (?)


Advertising

Website Promotion DIRECTORY is a crucial factor for all websites that need to gain better organic search engine rankings and increase website traffic.
Submitting your website as part of your Web Promotion strategy to our SEO friendly and high traffic Business Directory for review is an excellent way to gain a valuable backlink and increase your websites visibility online.

Submit Site


Who likes this?

1 person has marked this snippet as a favorite

umang_nine


WA1

Published in: PHP 

Expand | Embed | Plain Text 
  1. // fetch records
  2. $sql = "SELECT
  3. stock.goods_in_ref, 
  4. stock.delivery_ref, 
  5. stock.delivery_code, 
  6. stock.supplier_ref, 
  7. stock.product_ref, 
  8. stock.note, 
  9. stock.supp_code, 
  10. stock.supp_units, 
  11. stock.supp_weight, 
  12. stock.actual_weight, 
  13. stock.visual_check, 
  14. stock.temperature, 
  15. stock.pack_check, 
  16. stock.pass_check, 
  17. stock.ts_gone, 
  18. stock.ts_edit, 
  19. stock.ts_add, 
  20. stock.user_add_ref, 
  21. stock.user_edit_ref, 
  22. ingr.ingr_stock_ref, 
  23. ingr.stock_ref,
  24. stock.product_ref AS product,
  25. ingr.ingr_stock_ref,
  26. stock_ingr.product_ref AS stock_ingr
  27. FROM
  28. stock
  29. Inner Join ingr ON ingr.stock_ref = stock.stock_id
  30. Inner Join stock AS stock_ingr ON ingr.ingr_stock_ref = stock_ingr.stock_id
  31. WHERE stock.stock_id>' NONE' 
  32. ORDER BY stock.stock_id ASC LIMIT $offset, $rowsPerPage";

Report this snippet 

Comments

RSS Icon Subscribe to comments
Posted By: gcman105 on August 27, 2009

Private for WAFapp

You need to login to post a comment.

Download royalty free graphics