Results 1 to 10 of 10
Thread: Ïîìîù çà MySQL update?
Hybrid View
-
15th October 2008 16:32 #1
Ïîìîù çà MySQL update?
Çäðàâåéòå!Èñêàì äà ïîïèòàì çà êîä,êîéòî update-âà Áàçàòà äàííè.Íà êðàòêî, ìè òðÿáâà äà ðåñòàðòèðàì òî÷êèòå,íî ñàìî òî÷êèòå îò ñèñòåìà,êàòî Òóçàðèòå
.Äà çàïàçÿ id è user ,íî âñè÷êè points äà ñòàíàò íà íóëà.
Áëàãîäàðèÿ!
-
15th October 2008 16:43 #2
-
15th October 2008 16:48 #3
"UPDATE table_name SET column1=value, column2=value2,... WHERE some_column=some_value"
sourceEP 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
-
15th October 2008 19:12 #4
........................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"!
-
15th October 2008 19:14 #5
-
15th October 2008 20:02 #6
È òîãàâà êàêúâ å ïðîáëåìúò ïî ïðèìåðà íà Òåêèë÷î äà ñè íàïðàâèø ïðàâèëíî ïîñëåäîâàòåëíîñòòà îò êîìàíäè è ïàðàìåòðè, íàïðèìåð:
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.
ASUS P5KPL-AM EPU | Intel® Xeon E5430@3.2 GHz | 2x2GB DDRII-800 SuperT | ATi HD5870 1G GDDR5 | 2x250 GB + 500 GB +120 GB SSD
Ñëàäóðèòå | "Êîéòî èñêà - íàìèðà íà÷èí, îñòàíàëèòå ñè íàìèðàò îïðàâäàíèå."
Êàê äà ñïîðèø. Ïðî÷åòè è ñïîäåëè. Èíòåëåêòóàëíî.
-
15th October 2008 19:38 #7
åìè íà÷èíàåù ñúì ñ php-òo
è...
...ïîìîãíåòå ìàëêî

-
15th October 2008 19:42 #8PHP Code:
$setPoints = @mysql_query("UPDATE `nova` SET `points` = 0");
if(@mysql_affected_rows() == $setPoints ) {
echo "Òî÷êèòå ñà íóëèðàíè!";
} else {
echo "Òî÷êèòå íå áÿõà íóëèðàíè!";
}
-
15th October 2008 19:52 #9
-
15th October 2008 20:48 #10
àç èìàì åêñïîðò,çà òîâà ñå ñåòèõ ,íî çàïèñèòå ñà 1500




Reply With Quote


Lenovo ThinkPad 15 èëè IdeaPad 15
5th May 2023, 22:16 in Ìîáèëíè êîìïþòðè