ASPN ActiveState Programmer Network
ActiveState
/ Home / Perl / PHP / Python / Tcl / XSLT /
/ Safari / My ASPN /
Cookbooks | Documentation | Mailing Lists | Modules | News Feeds | Products | User Groups


Recent Messages
List Archives
About the List
List Leaders
Subscription Options

View Subscriptions
Help

View by Topic
ActiveState
.NET Framework
Open Source
Perl
PHP
Python
Tcl
Web Services
XML & XSLT

View by Category
Database
General
SOAP
System Administration
Tools
User Interfaces
Web Programming
XML Programming
MyASPN >> Mail Archive >> php-spanish
php-spanish
[PHP-ES] Consulta sql para Search
by Oscar Le Bihan other posts by this author
Nov 13 2006 10:58AM messages near this date
RE: [PHP-ES] Resultado query SQL | [PHP-ES] segun valores de usuario y contraseņa cambiar la etiqueta </a> <img src="http://www.activestate.com/img_aspn/arrow_right.gif" align="absmiddle"> <pre>Hola a todos. Les agradeceria si me pudieran ayudar con una consulta a mysql que estoy haciendo desde mi código php. La intención es buscar una cadena en una serie de campos . Lo he resuelto utilizando match(campo1, campo2, campo3) against ('$cadena') pero mi problema esta en que en el campo1 tengo el código de un producto que esta almacenado de la siguiente forma XXX-23423 y la intención es que encuentre coincidencias ingresando en el campo search 1. xxx 2. xxx 23423 3. xxx-23423 4. XXX 5. XXX-23423 6. XXX 23423 logro que funcione solo con las 3 y 5 ya que por lo que interpreto solo lo reconoce por la palabra completa en el campo1 agredeceria cualquier pista. sigo renegando saludos _________________________________________________________________ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/ -- PHP Spanish Localization Talk Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php </pre> <script type="text/javascript"><!-- google_ad_client = "pub-5076170995242212"; google_ad_width = 728; google_ad_height = 15; google_ad_format = "728x15_0ads_al"; google_ad_channel = ""; google_color_border = "FFFFFF"; google_color_bg = "FFFFFF"; google_color_link = "664E1E"; google_color_text = "000000"; google_color_url = "008000"; //--> </script> <div style="margin-top: 1em; margin-bottom: 2em;"> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> </div> </td> </tr> </table> <!--/content--> </td> </tr> </table> </td> <!-- central content well ends --> <!-- right column begins --> <!-- border to left of right column --> <td class="leftNavLine" width="1"><img src="http://www.activestate.com/img_aspn/x.gif" width="1" height="1" alt="" /></td> <td class="leftNav" valign="top" width="10"> <!-- begin right column content --> <table border="0" cellpadding="5" cellspacing="0"> <tr> <td class="leftNav" valign="top"> <br /> <!-- begin right column--> <!-- end right column --> </td> </tr> </table> </td> <!-- right column ends --> </tr> </table> </td> </tr> <!-- main content row ends --> <!-- line under content --> <tr> <td colspan="2" class="primaryNavLine"><img src="http://www.activestate.com/img_aspn/x.gif" width="1" height="1" alt="" /></td> </tr> <!-- end line under content --> <!-- spacing row --> <tr> <td colspan="2"><img src="http://www.activestate.com/img_aspn/x.gif" width="1" height="5" alt="" /></td> </tr> <!-- end spacing row --> <!-- begin footer --> <tr> <td colspan="2" align="center"> <!-- begin footer links --> <a href="/ASPN/Legal/Privacy">Privacy Policy</a> | <a href="http://www.activestate.com/cgibin/ns.plex">Email Opt-out</a> | <a href="/ASPN/Contact/">Feedback</a> | <a href="/ASPN/Syndication">Syndication</a> <br /> © ActiveState Software Inc. <a href="/ASPN/Legal/Copyright">All rights reserved</a> <!-- end footer links --> </td> </tr> <!-- end footer --> <!-- spacing row --> <tr> <td colspan="2"><img src="http://www.activestate.com/img_aspn/x.gif" width="1" height="5" alt="" /></td> </tr> <!-- end spacing row --> </table> <script type="text/javascript" src="http://templates.activestate.com/js/pop.js"></script> </body> </html>