[PHP-DB] how does this regular expression works

2011-07-13 Thread who.cat
Reading some code from the web spider,got the such a expression : preg_match("@]*>(.*?)<\/head>@si",$file, $regs); It's about get the head content of a website,i wanna know the match detail .Could someone give some tips , thanks in advance . All you best What we are strugg

Re: [PHP-DB] CURDATE()

2011-08-19 Thread who.cat
I tried on my db "select count(*) from my_table where col_timestamp wrote: > On Thursday, August 18, 2011, Ron Piggott wrote; > > > What I tried below doesn t work: ( CURDATE() . % ) > > Even though date values are presented like strings, they are > dates/times. So you need to either cast CURDATE

[PHP-DB] #@__ appeared in the sql statements

2011-09-12 Thread who.cat
Studying a cms recently ,got a sql statement like this : Select * From `#@__homepageset` i knew the '#@__' means the table prefix but how it like this ? Did defined in the mysql or in the php code .i could't find its definition at present.Any phper's comments thanks in advance . All you best --