Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Pattern Matching
Thanks MillerH. I'm amazed I got that right. Maybe I'm learning something after all. Thanks again Bob -
Pattern Matching
I need to use a regexp to match segments of a URL which contains javascript. The string is in this format, and I need to match the querystring and the name of the URL, which are in bold. <!--videocode--><a... -
Help with shockwave-flash parser
I’m no that good with regexp so I really need the help of someone who is. I’m trying to write a parser to parse the shockwave-flash embedded video code from sites like Google video, Yahoo, Youtube, Bolt and others. It needs to be parsed into a query string which is passed to a script which... -
select and or help
Thanks r973, That is the index name. If you don't give an index a name then it defaults to the column name. thanks Bob http://totallyfreeads.com.au -
select and or help
Thanks for the reply. Glob is indexed, explain select says that possible keys are country_id,category_id,glob,subcat_id but its not using any. I've been trying to force it to use a key with use index - SELECT... -
select and or help
I need help with this table join. What i'm using at the moment is this select table join statement which works fine. SELECT A.id,A.mem_id,C.category,B.subcat,D.country,A.state,A.city,A.acode,A.international,A.title,A.description,A.slocation,A.url,A.phone,DATE_FORMAT(A.date_added, '%D %b... -
select && ¦¦ table join help
Sorry I did start in the mysql forum but somehow I posted here. I will post in the correct forum. Thanks for the reply but it dosn't make any difference to the select. thanks Bob http://totallyfreeads.com.au -
select && ¦¦ table join help
I need help with this table join. I'm using mysql. What i'm using at the moment is this select table join statement which works fine. SELECT... -
case sensitive selects and indexes
Why dosn't this select statement use and index, SELECT username,email FROM members WHERE BINARY email='$mail'; Explain tells me that this is not good. table type possible_keys key key_len ref rows Extra members ALL NULL NULL NULL NULL...
