Search results for query: *

Thanks MillerH. I'm amazed I got that right. Maybe I'm learning something after all. Thanks again Bob

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...

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...

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

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...

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...

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

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...

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...