Results 1 to 12 of 12

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    ìåðàêëèÿ
    Join Date: May:2005
    Location: Varna
    Posts: 290

    Íÿêîëêî âúïðîñà îòíîñíî òúðñà÷êà

    Çäðàâåéòå.
    Èñêàì äà íàïðàâÿ òúðñà÷êà, êîÿòî äà ìè ïðåòúðñâà áàçàòà äàííè è äà èçêàðâà ðåçóëòàòà. Îáà÷å èäâà è ïðîáëåìà:
    1) Íàïðàâèõ ñè àç åëåìåíòàðåí ñåëåêò, êîéòî äà èçêàðâà öÿëàòà òàáëèöà, íî íå èñêàì äà ÿ ïîêàçâà öÿëàòà, à äà íàìèðà ÑÀÌÎ òúðñÿíèÿ òåêñò. Òîâà íå çíàì êàê ùå ñòàíå
    2) Ðåäîâåòå ñà ìíîãî - òîâà ïðîáëåì ëè å? Áàçàòà ùå å ðàçïîëîæåíà íà áúðç ñúðâúð, òàêàì ÷å ìèñëÿ òîé ùå êîìïåíñèðà ãîëåìèÿ áðîé êúíåêöèè è ìíîãîòî ðåäîâå.

    Áèõòå ìè ìè ïîìîãíàëè? Ñúâñåì íà÷èíàåù ñúì è àêî ìîæå äà ìè äàäåòå íàïðàâî íÿêàêúâ ëèíê êúì íåùî ïîäîáíî?

    Áëàãîäàðÿ ïîðåäâàðèòåëíî


    åäèò: Ïðîãðàìíèÿ åçèê å ÐÍÐ, à áàçàòà äàííè - mySQL

  2. #2
    Registered User Pa3KaTaH's Avatar
    Join Date: Sep:2003
    Location: Âàðíà
    Posts: 3,851
    Last edited by Pa3KaTaH; 18th July 2006 at 12:13.

  3. #3
    ìåðàêëèÿ
    Join Date: May:2005
    Location: Varna
    Posts: 290

    áëàãîäàðÿ ðàçêàòàíè

    À òîâà êàê ñå ñëàâà â ÐÍÐ ?

  4. #4
    Registered User Pa3KaTaH's Avatar
    Join Date: Sep:2003
    Location: Âàðíà
    Posts: 3,851
    Â "åëåìåíòàðíèÿ" òè SELECT

  5. #5
    ìåðàêëèÿ
    Join Date: May:2005
    Location: Varna
    Posts: 290

    Talking

    Quote Originally Posted by Pa3KaTaH
    Â "åëåìåíòàðíèÿ" òè SELECT

    Eòî êàêâî ñúì íàïèñàë àç:

    Code:
    <html><head><title>only for test purposes!</title></head><body>
    <meta http-equiv=Content-Type content="text/html; charset=windows-1251">
    
    <?php
    $conn=@mysql_connect( "Localhost","root","")
    		or die("<b><center>Ãðåøêà ïðè âðúçêàòà ñ áàçàòà äàííè!</b></center>");
    $rez=@mysql_select_db("article", $conn)
    		or die ("<b><center>Ãðåøêà ïðè ñåëåêòèðàíåòî íà áàçàòà äàííè!</b></center>");
    
    $zaiavka = "select id, code, name, saleprice from article"; /* long query */
    $rez = mysql_query($zaiavka, $conn );
    
    while ( $red = mysql_fetch_array( $rez ) )
    { echo( "<b><center><tr>ID 	 = </tr></b>" . $red["id"]   . "<br>" );
      echo( "<b>Êîä  = </b>" . $red["code"] . "<br>" );
      echo( "<b>Èìå  = </b>" . $red["name"] . "<br>" );
      echo( "<b>Öåíà = </b>" . $red["saleprice"] . "<br></center>");
      echo( "<center> _________________________________________ </centeR><br>" );
    }
    
    ?>
    </body></html>
    èçâèíÿâàé çà íåâåæåñòòà, íî áè ëè ìè ïîìîãíàë. Áèðàòà å îò ìåí
    Last edited by Nedko; 7th August 2006 at 12:40.

  6. #6
    Registered User
    Join Date: May:2006
    Location: Bulgaria
    Posts: 9
    Code:
    $wordSearched = "blabla";
    ....
    $zaiavka = "select id, code, name, saleprice from article WHERE code LIKE '%$wordSearched%' OR  name LIKE '%$wordSearched%'
    Èëè íåùî ïîäîáíî, íå ñúì ðàáîòèë ìíîãî ñ ïõï è ìúñêë
    Óñïåõ

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè