As an aid memoir; Firstly, to create stored procedures in MySQL you need to temporarily change the line delimiter so you can add code with normal delimiters without delimiting what you're currently doing.  Secondly, in order to use variables passed into a procedure you need to concatenate into a...

dbPHP is a lightweight framework allowing object relational mapping between (at present) mySQL and PHP.   dbphp project home dbphp twitter Google Code Home SourceForge Code Home dbphp manual   Object relational mapping is the process of creating a structural relationship...

As of My Sql 3.something you can now add text indexes to your columns and do full text searches with relevance ranking! text indexes are fantastic and allow more efficient searching and categorisation of text. The relevance ranking feature is rather good too and gives you a much better idea of how y...

sql    SERVEROUTPUT ON    declare     result_limit number := 10;     current_query_no number := 1;     --table_n varchar2(30) := 'brian.cran1400_der_results';     --cursor all_results is select * from brian.cran1400_der_results;     cursor result_list(counter number) is select * from brian....

If need to browse the world wide web and you are either running in an ssh window or you really hate the whole web 2 thing.. help is at hand Centos yum install lynx Debian apt-get intall lynx run lynx then you can view this page like this... icurtain - lights on the roundab...