I also tried with (

I try to delete the first 12 characters of a field, so I tried: mysql_query ("UPDATE` heat score `SET tsqq` tsqq` = SUBSTR ('tsqq', 12)"); But instead of me remove the first 12 letters of each entry, it removes me all entries instead. Why would anyone? Thank you!
jeanluc WRInaute addicted Posts: heat score 3152 Joined: May 3, 2004 Website
antinomx wrote: As you can see in the doc, define the character of departure and the end so it would rather substr ('tsqq', 0, 12). Be confused substr (PHP) and SUBSTR (MySQL). Jean-Luc
I also tried with ("UPDATE` `SET tsqq` tsqq` = SUBSTRING ('tsqq', 12, -9)") ("UPDATE` `SET tsqq` tsqq` = MID ('tsqq' 12, - 9) ") I even tried putting 1, -1 just to see, but in any case it clears me. It's super annoying, because in addition to move forward and do other stuff I especially need to solve this specific heat score problem ... ^^ So a very big thank you to those who solve me!
Ah progress. When I did this: mysql_query ("UPDATE` `SET tsqq` tsqq` = SUBSTR ('tsqq', heat score 3) WHERE id = '24099'"); It gives me << >> qq. So in fact it does not take the value of the field but literally tsqq << >>. But I do not see how anything other than the single quotes around the field 'tsqq' for sql understand that this is a field and not text.
Yeah that's right had to SUBSTR (`tsqq`, 3) actually. Well it was already marked nowhere and more ... yeah not nothing but it made me drunk to come across heat score what Bon ben thank you, it's solved!
Uh no it's not actually resolved Does not work if I put two numbers (2 and -9 in the example) mysql_query ("UPDATE SET tsqq tsqq = SUBSTR (` tsqq`, 2, -9) WHERE id = 24099 "); It only works if I put a number, or by putting in one, you can not delete letters at the end. In the limit I can maybe do something style = tsqq tsqq - SUBSTR (`tsqq`, -9) There's a way to do something like this in there?
No it does not change anything. heat score (I had already tested but gained heat score consciousness I tried again, heat score same result) Actually what I find strange is that it works perfectly with a number, but not with two.
noel2008 wrote: mysql_query ("UPDATE` `SET tsqq` tsqq` = SUBSTR ('tsqq', 12)"); esais ca? Code: Select all mysql_query ("UPDATE SET tsqq tsqq = 'SUBSTR (' tsqq ', 12)' WHERE id = 24099"); UPDATE tsqq this is the name of your table? SET tsqq this is the name of your fields? WHERE id = 24099 "as needed to parameterize ...
webmasterdemonsite wrote: mysql_query ("UPDATE` `SET tsqq` tsqq` = SUBSTR ('tsqq', 12)"); and if you put Code: Select mysql_query (.. "UPDATE SET` `tsqq` tsqq` =" substr ('tsqq', 12) ";"); I do not know if it will change much, but it seems more clean if you want to use the php function ... it seems to me that the mysql function called SUBSTRING! the bizarre operation comes to my mind the confusion of languages ...
Wordpress SEO Training Special: Learn how to optimize the SEO of a website made with Wordpress ... Training Ranking Metrics driven by a SEO / Wordpress expert.
Substr problem heat score [PHP] function substr () PHP function substr [solved (I'm a ball dsl)] PHP => Pb with substr Bizarre you said these weird links on my name The additional results, you said weird weird Tales of the Unexpected: two areas known to one website Google Yahoo travel weird weird .... did I forget stuff? Google Tips Pros
Christmas gift 2007 Google heat score AdSense - 06-12-2007 Released a new book on Google - 13-09-2004 heat score elgooG: mirror Google - Google News 02-02-2003: tips and tricks - 13-01 -2005 Forum Analytics Gastronomie - 07-09-2009 New in Google Analytics heat score API (September 2009) - 19-09-2009 tricks for optimizing local SEO - 02-03-2009 Financial Results Google in Q1 2010 (Q1 2010) - 16-04-2010