Results 1 to 10 of 10

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User a4kata_pz's Avatar
    Join Date: Jul:2008
    Location: Ïàçàðäæèê
    Posts: 1,093

    Ïîìîù çà MySQL update?

    Çäðàâåéòå!Èñêàì äà ïîïèòàì çà êîä,êîéòî update-âà Áàçàòà äàííè.Íà êðàòêî, ìè òðÿáâà äà ðåñòàðòèðàì òî÷êèòå,íî ñàìî òî÷êèòå îò ñèñòåìà,êàòî Òóçàðèòå .Äà çàïàçÿ id è user ,íî âñè÷êè points äà ñòàíàò íà íóëà.
    Áëàãîäàðèÿ!

  2. #2
    Registered User fly's Avatar
    Join Date: Jun:2005
    Location: Ñîôèÿ
    Posts: 803
    Óáèéñòâåíî îáÿñíåíèå

  3. #3
    Ãëàìà TEKIL4O's Avatar
    Join Date: Feb:2007
    Location: Rousse/Sofia
    Posts: 341
    "UPDATE table_name SET column1=value, column2=value2,... WHERE some_column=some_value"

    source
    EP 9NPA+ U (HR-05/IFX)| 4200+X2@2.8GHz (IFX-14) | 2x1GB KINGSTON (DDR430 3-4-3-6-1T@2.7V) | GB 8800GT (512MB) | WD6401AALS | CFT-750-14CS

  4. #4
    Registered User a4kata_pz's Avatar
    Join Date: Jul:2008
    Location: Ïàçàðäæèê
    Posts: 1,093
    ........................update.php...... ..................

    <?php
    mysql_connect("localhost","xxx","xxx");
    @mysql_select_db("xxx") or die( "MySQL die");
    UPDATE nova
    SET points='0'
    ?>

    .......................ðåçóëòàòúò....... ..................

    Parse error: syntax error, unexpected T_STRING in /home/a4eka/public_html/game/update.php on line 4

    ........................................ .......................
    Óáåäåí ñúì ,÷å òàáëèöàòà ñå êàçâà "nova"!

  5. #5
    White awesomeness z0ne's Avatar
    Join Date: Feb:2002
    Location: Õàñêîâo
    Posts: 13,331
    Quote Originally Posted by acid_burn View Post
    ........................update.php...... ..................

    <?php
    mysql_connect("localhost","xxx","xxx");
    @mysql_select_db("xxx") or die( "MySQL die");
    UPDATE nova
    SET points='0'
    ?>

    .......................ðåçóëòàòúò....... ..................

    Parse error: syntax error, unexpected T_STRING in /home/a4eka/public_html/game/update.php on line 4

    ........................................ .......................
    Óáåäåí ñúì ,÷å òàáëèöàòà ñå êàçâà "nova"!
    Çàâàëèÿ .... ïúðâî ïðî÷åòè ìàëêî óðîöè êàê ñå ïèøå êîä è òîãàâà ñå îïèòâàé äà ïðàâèø ïîäîáíè "ñëîæíè" íåùà.

  6. #6
    Creative destructor OgiDogi's Avatar
    Join Date: Nov:2002
    Location: Ñëèâåí
    Posts: 7,601
    Quote Originally Posted by acid_burn View Post
    ...
    UPDATE nova
    SET points='0'
    ?>
    ...

    Óáåäåí ñúì ,÷å òàáëèöàòà ñå êàçâà "nova"!
    È òîãàâà êàêúâ å ïðîáëåìúò ïî ïðèìåðà íà Òåêèë÷î äà ñè íàïðàâèø ïðàâèëíî ïîñëåäîâàòåëíîñòòà îò êîìàíäè è ïàðàìåòðè, íàïðèìåð:

    UPDATE `nova` (`id`, `username`, `points`) SET points='0'

    èëè àêî èìàø åêñïîðò íà áàçàòà ñ íîìåðàòà è èìåíàòà îò òîçè âèä, ñàìî ïðîìåíÿø ïîñëåäíàòà êîëîíà (ñòèãà äà íå ñà íÿêîëêî õèëÿäè çàïèñà):

    UPDATE `nova` (`id`, `username`, `points`) VALUES
    (1, 'user1', '0'),
    (2, 'user2', '0'),
    ...
    (n, 'usern', '0');

    ñëåä êîåòî ãî èìïîðòèðàø îáðàòíî.


    Ï.Ï. z0ne ìåæäóâðåìåííî òè å äàë ãîòîâîòî ðåøåíèå. Íå òàêà áå, z0ne, îñòàâè ãî ìàëêî äà ñå ÷åøå ïî âðàòà
    Last edited by OgiDogi; 15th October 2008 at 20:12.

  7. #7
    Registered User a4kata_pz's Avatar
    Join Date: Jul:2008
    Location: Ïàçàðäæèê
    Posts: 1,093
    åìè íà÷èíàåù ñúì ñ php-òo è...
    ...ïîìîãíåòå ìàëêî

  8. #8
    White awesomeness z0ne's Avatar
    Join Date: Feb:2002
    Location: Õàñêîâo
    Posts: 13,331
    PHP Code:
    $setPoints = @mysql_query("UPDATE `nova` SET `points` = 0");
    if(@
    mysql_affected_rows() == $setPoints ) {
       echo 
    "Òî÷êèòå ñà íóëèðàíè!";
    } else {
          echo 
    "Òî÷êèòå íå áÿõà íóëèðàíè!";
      } 

  9. #9
    Registered User a4kata_pz's Avatar
    Join Date: Jul:2008
    Location: Ïàçàðäæèê
    Posts: 1,093
    Áëàãîäàðèÿ òè z0ne!

  10. #10
    Registered User a4kata_pz's Avatar
    Join Date: Jul:2008
    Location: Ïàçàðäæèê
    Posts: 1,093
    àç èìàì åêñïîðò,çà òîâà ñå ñåòèõ ,íî çàïèñèòå ñà 1500

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 | Ìàãàçèí çà åëåêòðîííè öèãàðè