[ ptomic @ 10.01.2004. 01:52 ] @
Imam problem da mi se redovno prijavi sledeca greska: Citat: Connected successfullyQuery failed : You have an error in your SQL syntax near '; CREATE TABLE phpbb_flags (flag_id int(10) NOT NULL auto_increment, flag_na' at line 1 Koristim ovakav PHP fajl za punjenje, pomagajte ljudi, gde gresim?? Code: <?php /* Connecting, selecting database */ $link = mysql_connect("localhost", "{username za DB}", "{pass za DB}") or die("Could not connect : " . mysql_error()); print "Connected successfully"; mysql_select_db("{DB}") or die("Could not select database"); /* Performing SQL query */ $query = "ALTER TABLE phpbb_users ADD user_from_flag varchar(25) NULL AFTER user_from; CREATE TABLE phpbb_flags (flag_id int(10) NOT NULL auto_increment, flag_name varchar(25), flag_image varchar(25), PRIMARY KEY (flag_id)); INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES ('','usa','usa.gif'); ... ... ... " ; $result = mysql_query($query) or die("Query failed : " . mysql_error()); /* Printing results in HTML */ print "<table>\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { print "\t<tr>\n"; foreach ($line as $col_value) { print "\t\t<td>$col_value</td>\n"; } print "\t</tr>\n"; } print "</table>\n"; /* Free resultset */ mysql_free_result($result); /* Closing connection */ mysql_close($link); ?> |