frobak
-
Posts
96 -
Joined
-
Last visited
Everything posted by frobak
-
Hi Im trying to write a very simple script that creates a php file that logs a download in a database. Basically, the user will upload some audio and I want to use fopen to automatically create a download counter. I get the file created ok, but my $sql, $result & $connection are stripped and not written, so the queries wont run. Is there anyway to escape this, so it writes the variables. Heres the code: <?php $file = "downloads/pbz99.php"; $open = fopen($file, "w+"); fwrite($open,"<?php include ('functions/db_fws_connect.inc.php'); $sql = 'INSERT INTO `frobakco_fwsapps`.`downloadcount` (`downloadcountid`, `downloadid`) VALUES (NULL, '99')'; $result = @mysql_query($sql,$connection) or die(mysql_error());?> <html><head><title>DJ Neil S audio download page</title></head><body><a href='../mixes/.$filename.mp3'></a></body></html>"); ?> any ideas
-
yeah sorry i solved it, my db include file was wrong, so it was looking at my old server and database!
-
can you mark this as solved, im stupid!
-
yes ive just copied the above table structure direct from phpmyadmin?
-
but heres the table, copied directly from mysql? the columns there? customer_id int(15) No company_name varchar(20) Yes NULL address_line1 varchar(20) Yes NULL address_line2 varchar(20) Yes NULL City varchar(20) Yes NULL postcode varchar( Yes NULL contact_name varchar(25) Yes NULL emailaddress varchar(25) Yes NULL webaddress varchar(25) Yes NULL phone varchar(20) Yes NULL fax varchar(20) Yes NULL mobile varchar(20) Yes NULL
-
thank but this still doesnt work, i am still getting the same error Unknown column 'company_name' in 'field list' surely this is something really simple?
-
CREATE TABLE customers( customer_id INT(15), company_name VARCHAR(20), address_line1 VARCHAR(20), address_line2 VARCHAR(20), City VARCHAR(20), postcode VARCHAR(, contact_name VARCHAR(25), emailaddress VARCHAR(25), webaddress VARCHAR(25), phone VARCHAR(20), fax VARCHAR(20), mobile VARCHAR(20));
-
Hi i have this simple php insert statement, but whatever i try it says: Unknown column 'company_name' in 'field list' all the column names are the same in my html documnt, this statement here and in my database table. Thsi is really simple and driving me mad <? if($_POST['add']) { include("includes/db_connect.inc.php"); $sql = ("INSERT INTO customers (company_name, address_line1, address_line2, city, postcode, contact_name, emailaddress, webaddress, phone, fax, mobile) VALUES ('$_POST[company_name]', '$_POST[address_line1]', '$_POST[address_line2]', '$_POST[city]', '$_POST[postcode]', '$_POST[contact_name]', '$_POST[emailaddress]', '$_POST[webaddress]', '$_POST[phone]', '$_POST[fax]', '$_POST[mobile]')"); $result = @mysql_query($sql,$connection) or die(mysql_error()); } ?> any help much appreciated. cheers
