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);
?>
<?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);
?>