Chirurgia cranio-cerebrală minim invazivă
Tehnicile minim invazive impun utilizarea unei tehnologii ultramoderne. Endoscoapele operatorii de diverse tipuri, microscopul operator dedicat, neuronavigația, neuroelectrofiziologia, tehnicile avansate de anestezie, chirurgia cu pacientul treaz reprezintă armamentarium fără de care neurochirurgia prin "gaura cheii" nu ar fi posibilă. Folosind tehnicile de mai sus, tratăm un spectru larg de patologii cranio-cerebrale. www.neurohope.ro |
Mysql problema
#1
Posted 18 April 2008 - 14:55
Baza De date initial arata asa:
-- phpMyAdmin SQL Dump -- version 2.11.4 -- [url="http://www.phpmyadmin.net"]http://www.phpmyadmin.net[/url] -- -- Host: localhost -- Generation Time: Feb 05, 2008 at 07:08 PM -- Server version: 5.0.51 -- PHP Version: 5.2.5 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `cs_servers` -- -- -------------------------------------------------------- -- -- Table structure for table `info` -- CREATE TABLE IF NOT EXISTS `info` ( `srvname` varchar(30) NOT NULL, `srvip` char(50) NOT NULL, `srvport` float NOT NULL, `srvsite` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `sia` char(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `info` -- INSERT INTO `info` (`srvname`, `srvip`, `srvport`, `srvsite`, `email`, `sia`) VALUES ('SERVER NAME', 'cs.unserver.ro', 27015, 'www.unsiteoarecare.ro', '[email protected]', ''); Dupa Cateva Modificari arata asa: -- phpMyAdmin SQL Dump -- version 2.11.4 -- [url="http://www.phpmyadmin.net"]http://www.phpmyadmin.net[/url] -- -- Host: localhost -- Generation Time: Feb 05, 2008 at 07:08 PM -- Server version: 5.0.51 -- PHP Version: 5.2.5 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `cs_servers` -- -- -------------------------------------------------------- -- -- Table structure for table `info` -- CREATE TABLE IF NOT EXISTS `info` ( `srvip` char(50) NOT NULL, `srvport` float NOT NULL, `srvplayers` float NOT NULL, `srvanticheat` float NOT NULL, `srvisp` float NOT NULL, `srvsite` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `sia` char(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `info` -- INSERT INTO `info` (`srvip`, `srvport`, `srvplayers`,`srvanticheat`,`srvisp`,`srvsite`, `email`, `sia`) VALUES ('cs.unserver.ro', 27015, '24[color="#FF0000"]'[/color],'HLguard','GMB','www.unsiteoarecare.ro', '[email protected]', ''); Ce este gresit in ce am modificat eu de nu vrea sa imi importe in baza de date? Aceasta este eroarea primita.... SQL query: -- -- Dumping data for table `info` -- INSERT INTO `info` ( `srvip` , `srvport` , `srvplayers` , `srvanticheat` , `srvisp` , `srvsite` , `email` , `sia` ) VALUES ( 'cs.unserver.ro', 27015, '24', 'HLguard', 'GMB', 'www.unsiteoarecare.ro', '[email protected]', '' ); MySQL said: Documentation #1054 - Unknown column 'srvplayers' in 'field list' PS. Nu fac cum fac altii, postez intreg scriptul si incep vreau aia, vreau aia, vreau aia... Ma chinui de 2 zile si de ieri mam blocat la chestia asta... incepator si yo, ce sa fac.... LE... o greseala am gasito... lipsea un " ' " Edited by Alexutzu_1991, 18 April 2008 - 15:00. |
#2
Posted 18 April 2008 - 15:00
Ai citit eroarea ? ERROR: Unclosed quote @ 239 , vezi ca la insert la 'cs.unserver.ro', 27015, '24,'HLguard', ai acolo '24 , trebuie '24'
Edited by WizzB, 18 April 2008 - 15:01. |
#3
Posted 18 April 2008 - 15:03
2 zile zici? wow. citirea mesajului de eroare mi-a luat 2 minute:
Quote Error There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem ERROR: Unclosed quote @ 239 STR: ' SQL: -- -- Dumping data for table `info` -- INSERT INTO `info` (`srvip`, `srvport`, `srvplayers`,`srvanticheat`,`srvisp`,`srvsite`, `email`, `sia`) VALUES ('cs.unserver.ro', 27015, '24,'HLguard','GMB','www.unsiteoarecare.ro', '[email protected]', ''); SQL query: -- -- Dumping data for table `info` -- INSERT INTO `info` (`srvip`, `srvport`, `srvplayers`,`srvanticheat`,`srvisp`,`srvsite`, `email`, `sia`) VALUES ('cs.unserver.ro', 27015, '24,'HLguard','GMB','www.unsiteoarecare.ro', '[email protected]', ''); MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HLguard','GMB','www.unsiteoarecare.ro', '[email protected]', '')' at line 2 |
#4
Posted 18 April 2008 - 15:03
Da asta gasisem... Am dat edit dar nu am vazut ca postasei deja... scz si ms...
Acum asta cum o rezolv... #1054 - Unknown column 'srvplayers' in 'field list' |
#5
Posted 18 April 2008 - 15:06
Eroarea asta ti-a dat tot la sql de mai sus ? Mie in afara de acel ' nu mi-a mai dat nicio eroare si a mers perfect.
|
#6
Posted 18 April 2008 - 15:11
mai indeaproape, zooming in:
Quote You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HLguard','GMB','www.unsiteoarecare.ro', '[email protected]', '')' at line 2 nu e destul de aproape? ce zici de asta: Quote You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HLguard','GMB','www.unsiteoarecare.ro', '[email protected]', '')' at line 2 Hmmm... ia sa belim ochii in cererea SQL indeaproape: Quote '24,'HLguard',' poate te ajuta sa citesti cateva sfaturi utile si din semnatura mea de mai jos bafta Alexutzu_1991, on Apr 18 2008, 15:03, said: Da asta gasisem... Am dat edit dar nu am vazut ca postasei deja... scz si ms... Acum asta cum o rezolv... #1054 - Unknown column 'srvplayers' in 'field list' 1. citesti eroarea 2. o intelegi. daca nu o intelegi, du-te la pasul 1. 3. o repari Dupa cum observi, tot ceea ce te incetineste este tu necitind mesajele de eroare nesuferite care "nu iti dau niciun indiciu" |
#7
Posted 18 April 2008 - 15:14
Da ma da nu inteleg ce este gresit... :| ... oricum multumesc pentru raspunsuri...
@originalcopy am facut pasul 1. de n'spe ori si tot nu ajung la 2... |
#8
Posted 18 April 2008 - 15:16
sper ca ai liber urmatoarele ... 2 zile pentru inca o bucla infinita
|
#9
Posted 18 April 2008 - 15:19
si inca ceva : `srvanticheat` float NOT NULL,`srvisp` float NOT NULL, le declari float dar tu in insert pui string ....
|
#10
Posted 18 April 2008 - 15:21
Alexutzu_1991, on Apr 18 2008, 15:14, said: Da ma da nu inteleg ce este gresit... :| ... oricum multumesc pentru raspunsuri... @originalcopy am facut pasul 1. de n'spe ori si tot nu ajung la 2... defapt la 2 ajungi, dar nu treci la 3 pentru ca sari iar la 1 posteaza detalii, sa ne uitam iar pe cereri WizzB, on Apr 18 2008, 15:19, said: si inca ceva : `srvanticheat` float NOT NULL,`srvisp` float NOT NULL, le declari float dar tu in insert pui string .... @Alexutzu_1991 citeste manualul Edited by OriginalCopy, 18 April 2008 - 15:22. |
|
#11
Posted 18 April 2008 - 15:32
-- phpMyAdmin SQL Dump -- version 2.11.4 -- [url="http://www.phpmyadmin.net"]http://www.phpmyadmin.net[/url] -- -- Host: localhost -- Generation Time: Feb 05, 2008 at 07:08 PM -- Server version: 5.0.51 -- PHP Version: 5.2.5 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Database: `cs_servers` -- -- -------------------------------------------------------- -- -- Table structure for table `info` -- CREATE TABLE IF NOT EXISTS `info` ( `srvip` char(50) NOT NULL, `srvport` float NOT NULL, `srvplayers` float NOT NULL, `srvanticheat` varchar(50) NOT NULL, `srvisp` varchar(50) NOT NULL, `srvsite` varchar(50) NOT NULL, `email` varchar(50) NOT NULL, `sia` char(50) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `info` -- INSERT INTO `info` (`srvip`, `srvport`, `srvplayers`,`srvanticheat`,`srvisp`,`srvsite`, `email`, `sia`) VALUES ('cs.unserver.ro', 27015, 24,'HLguard','GMB','www.unsiteoarecare.ro', '[email protected]', ''); Adica asa trebuie sa arate? Edited by Alexutzu_1991, 18 April 2008 - 15:33. |
#12
Posted 18 April 2008 - 15:35
cam asa ceva , dar renunta de tot la float , ai primit un link , l-ai citit? float e de genul 0.0 , nu cred ca un port sau un ip are virgula
da are 3 virgule dar totusi nu e niciun float un ip Edited by WizzB, 18 April 2008 - 15:41. |
#13
Posted 18 April 2008 - 15:38
camp: srvip
valoare: cs.unserver.ro intrebare: cs.unserver.ro este un ip? hmmm nu e "neaparat" gresit, dar e un mic indiciu ca nu stii cu adevarat cum functioneaza platforma pe care o programezi, web-ul, internetul, s.a.m.d. invata lucrurile de baza mai intai WizzB, on Apr 18 2008, 15:35, said: cam asa ceva , dar renunta de tot la float , ai primit un link , l-ai citit? float e de genul 0.0 , nu cred ca un port sau un ip are virgula PS: IPv4 desigur |
#14
Posted 18 April 2008 - 15:43
era vorba de ip sau dns... oricum cred ca raman la scriptul "original" fara sa mai modific nimic ce tine de mysql sa sunt boot...
|
#15
Posted 21 April 2008 - 15:40
inca 3 probleme am si eu... :|
1. Cum fac sa imi selecteze din baza de date ultimele 10 servere adaugate :| 2. Mie tabelul cu servere mi'l afiseaza asa: ========== server|ip|etc| ========== server|ip|etc| ========== server|ip|etc| ========== Cum fac sa imi numeroteze serverele :| ? ========== 1.|server|ip|etc| ========== 2.|server|ip|etc| ========== 3.|server|ip|etc| ========== 3. Cum fac sa adune toate serverele si sa afiseze mesaj: Avem xxx servere in baza noastra de date... Edited by Alexutzu_1991, 21 April 2008 - 15:40. |
|
#16
Posted 21 April 2008 - 15:42
1. adauga la tabel o coloana id unsigned int auto_increment
3. SELECT COUNT(*) FROM `servers` |
#17
Posted 21 April 2008 - 20:32
Alexutzu_1991, on Apr 21 2008, 15:40, said: 1. Cum fac sa imi selecteze din baza de date ultimele 10 servere adaugate :| SELECT * FROM `servers` ORDER BY id DESC LIMIT 10 Alexutzu_1991, on Apr 21 2008, 15:40, said: 2. Cum fac sa imi numeroteze serverele :| ? $i=0; while ($r=mysql_fetch_array($r)) { $i++; //afisare $i,datele serverului } Alexutzu_1991, on Apr 21 2008, 15:40, said: 3. Cum fac sa adune toate serverele si sa afiseze mesaj: Avem xxx servere in baza noastra de date... |
#18
Posted 08 May 2008 - 19:07
Am evoluat destul la site insa tot nu am reusit sa imi numeroteze randurile la tabel :|
am asa: mysql_select_db($db_name, $connection); $result = mysql_query("SELECT * FROM cs16 ORDER BY srvname DESC LIMIT 5"); echo "<br />"; echo "<center>"; echo "<table class=tabele_tabele width=570"; echo "<tr width=470>"; echo "<th width=100 class=scris align=center>Nr.</th>"; echo "<th width=100 class=scris align=center>Nume</th>"; echo "<th width=270 class=scris align=center>Adresa:Port</th>"; echo "<th width=50 class=scris align=center>Sloturi</th>"; echo "<th width=50 class=scris align=center>Detalii</th>"; while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td class=tabele_tabele>" . "<strong>" . "aici trbuie sa apara numarul" . "</td>"; echo "<td class=tabele_tabele>" . "<strong>" . $row['srvname'] . "</td>"; echo "<td class=tabele_tabele>" . "<strong>" . $row['srvip'] . ":" . $row['srvport'] . "</td>"; echo "<td class=tabele_tabele>" . "<strong>" . $row['srvplayers'] . "</td>"; echo "<td class=tabele_tabele>" . "<strong>" . "<a href=http://cs.dap.ro/stats/stats.php?ip=$row[srvip]&port=$row[srvport]>" . "Verifica"; echo "</center></tr>"; } Cum fac? Nu reusesc de nici un chip... Va rog mult daca cineva ma poate ajuta... Edited by Alexutzu_1991, 08 May 2008 - 19:15. |
Anunturi
▶ 0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users