List Info

Thread: Hi
Hi
user name
 2006-12-19 01:50:14 

  


  

    




  



    

            
Hi,



I know how to use the " like %...% " function in MYSQL to

serarch for text...



Is there another function that we can search for blank fields ?



Or more specifically, fields  which do not contain  -   a-z,

0 (or 0-9)



Can we use normal preg commands in a MYSQL query ?



G



K-Email v1.00



Join the New Zealand Online/Email Community

Email :-  new_zealand-subscribe%40yahoogroups.com">new_zealand-subscribeyahoogroups.com or

Online:- http://groups.yahoo.com/group/new_zealand/





    
  

    
    __._,_.___
    
     
    
    
  
.


  

__,_._,___



  

  
  
   
     
    

  

    Hi
  


  

     user name

     2006-12-19 02:19:04
  


  

    

  


  

    




  



    

            
--- " gordon%40kwister.com">gordonkwister.com" < gordon%40kwister.com">gordonkwister.com> wrote:



> Hi,

> 

> I know how to use the " like %...% " function in MYSQL to

> serarch for text...

&gt; 

> 

> Is there another function that we can search for blank fields ?

> 

> Or more specifically, fields  which do not contain  -   a-z,

> 0 (or 0-9)

> 

> Can we use normal preg commands in a MYSQL query ?

> 

> G



Sure.  Take a look at RLIKE instead of LIKE.



James Keeline





    
  

    
    __._,_.___
    
     
    
    
  
.


  

__,_._,___



  

  
  
   
     
    

  

    bargraph help
  


  

     user name

     2006-12-26 16:05:10
  


  

    

  


  

    




  



    

            
Ihow can I take the following code and just display 1 bar graph les say at

just 45% 



How can I read a value from a database  and display the bargraph from

that value ??? 



<?php



# Example2.php



require_once( 'PogProgressBar.php' );



// start objects



$objBar0 = new PogProgressBar( 'pb0' );



$objBar1 = new PogProgressBar( 'pb1' );



$objBar2 = new PogProgressBar( 'pb2' );



$objBar3 = new PogProgressBar( 'pb3' );



// set themes



$objBar1-&gt;setTheme( 'blue' );



$objBar2->setTheme( 'green' );



$objBar3->setTheme( 'red' );



?>;



<html>



&lt;head>



<title>PogProgressBar - Example 2</title>



&lt;/head>



<body>



&lt;table align=&quot;center&quot; cellpadding="0&quot;

cellspacing=&quot;20"; border=&quot;0"&gt;



<tr><td>PogProgressBar - Example

2</td></tr>



<tr&gt;<td&gt;All progress&lt;/td>&lt;/tr>



<tr&gt;<td>;<? $objBar0-&gt;draw();

?></td></tr>



<tr>&lt;td>Bar 1</td&gt;</tr&gt;



<tr><td><? $objBar1-&gt;draw();

?></td></tr>



<tr>&lt;td>Bar 2</td&gt;</tr&gt;



<tr><td><? $objBar2-&gt;draw();

?></td></tr>



<tr>&lt;td>Bar 3</td&gt;</tr&gt;



<tr><td><? $objBar3-&gt;draw();

?></td></tr>



</table&gt;



</body>



<html&gt;



<?php



// time for each



$intMax1 = 300;



$intMax2 = 250;



$intMax3 = 700;



$intCount = 0;



while ( $objBar0-&gt;getProgress() != 100 )



{



$objBar1-&gt;setProgress( $intCount * 100 / $intMax1 );



if ( $objBar1-&gt;getProgress() == 100 )



{



$objBar2-&gt;setProgress( ( $intCount - $intMax1 ) *

100 / $intMax2 );



}



$objBar3-&gt;setProgress( $intCount * 100 / $intMax3 );



$objBar0->setProgress(



(



( $objBar1-&gt;getProgress() * $intMax1 ) +



( $objBar2-&gt;getProgress() * $intMax2 ) +



( $objBar3-&gt;getProgress() * $intMax3 )



) / ( $intMax1 + $intMax2 + $intMax3 )



);



++$intCount;



usleep( 100 );



}



?>



--

No virus found in this incoming message.

Checked by AVG Free Edition.

Version: 7.1.409 / Virus Database: 268.15.24/592 - Release Date: 12/18/2006



-- 

No virus found in this outgoing message.

Checked by AVG Free Edition.

Version: 7.1.409 / Virus Database: 268.15.28/604 - Release Date: 12/26/2006

 



[Non-text portions of this message have been removed]





    
  

    
    __._,_.___
    
     
    
    
  
.


  

__,_._,___



  

  
  
   
     
    






 [1-3]











   
 





about | contact  Other archives ( Real Estate discussion Medical topics )