Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
passing variables to mailto:
<?echo "<a href="mailto:$em1"> $id1 </a>";?> any reason that that gives a parse error? -
Make a code go on
Im using a quite complicated script for parsing XML so ill try to explain: Im parsing from an XML file http://www.netclans.com/test.xml As you can see there there are a number of fields. But my script now only parses the first one, as i need to parse them all, The problem here is in the ID... -
PHP problem with adding to a DB
it works thanks guys :D just checked the DB and its all in there -
PHP problem with adding to a DB
YES!!!! Ive tryed that before but w/o the , removed!! now it seems to work, no errors -
PHP problem with adding to a DB
CREATE TABLE `attacks` ( `id` int(12) unsigned NOT NULL default '0', `attackerid` int(12) unsigned NOT NULL default '0', `attackerstatename` varchar(30) NOT NULL default '', `attackertag` varchar(12) NOT NULL default '', `defenderid` int(12) unsigned NOT NULL default '0'... -
PHP problem with adding to a DB
i have removed the , not the ) and it seems to work but now it gives: Invalid query: Unknown column 'Mustafa' in 'field list' thats the attackerstatename column -
PHP problem with adding to a DB
where? in the first line or the VALUES line? as i removed it in the first line, but the error stays the same -
PHP problem with adding to a DB
Im using the following code: "INSERT INTO attacks ( id, attackerid, attackerstatename, attackertag, defenderid, defenderstatename, defendertag, type, losses, ) VALUES (... -
Problem with variables
SQL-query : [Edit] [Create PHP Code] INSERT INTO stats( id, regplayers, activeplayers, deadplayers ) VALUES ( '', 1.311, 130, 710 ) yep running fine as i expected output can be found at http://www.wowstats.netclans.com/update.php -
Problem with variables
if i print it and after that use it it works fine and their are no weird chars -
Problem with variables
yes when i try numbers it works fine its the variables that dont work full code: <? $username=""; $password="F"; $database=""; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $buffer =... -
Problem with variables
you have the exact code as i tryed. it doesnt work see my post for the error i get -
Problem with variables
Invalid query: 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 '1.310, 130, 709 )' at l this is what it says when i remove the ' $query = "INSERT INTO stats ( regplayers, activeplayers, deadplayers... -
Problem with variables
this is my table: CREATE TABLE `stats` ( `id` int(11) NOT NULL auto_increment, `regplayers` decimal(7,6) NOT NULL default '0.000000', `activeplayers` int(6) NOT NULL default '0', `deadplayers` int(6) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id_2` (`id`), KEY `id`... -
Problem with variables
I have a script wich is parsing info from an XML page and then storing it into the following variables: $regplayers $activeplayers $deadplayers Now if i want to get it into the DB: $query = "INSERT INTO stats ( regplayers, activeplayers, deadplayers ) VALUES ( '$regplayers'...
