Avatar billede dk_gryf Nybegynder
28. februar 2006 - 08:56 Der er 7 kommentarer og
1 løsning

Problemer med, at skrive til MySQL - felter er "låst"

Hej
Jeg har ikke forstand på MySQL så derfor beder jeg om hjælp...
Jeg har oprettet en database og importeret strukturen fra en tilsvarende og som sådant virker det som det skal på nær når jeg f.eks. vil skrive FAQ spørgsmål/svar via administrationsmodulet.
Jeg får følgende når jeg vil gemme min tekst:
"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 ' The Million Dollar Homepage\". The main motivation for doing th "- og her stopper så linien....

Går manuelt direkte ind i databasen og ser på tabeloversigten, så viser det sig, at flere af tabellerne ikke kan rettes da der tonet ned og ikke kan rettes og deribland netop FAQ

Hvorfor er de nedtonet så jeg ikke kan skrive til disse tabeller? hvad gør jeg for at få dem åbnet?

Jeg har lagt et screendump på følgende adresse: http://1milliondollarhomepage.dk/faq.gif
På forhånd tak
Mogens
Avatar billede innercitydk Nybegynder
28. februar 2006 - 10:22 #1
Så vidt jeg kan se er de skraverede fordi der ikke er fyldt data i dem. Jeg tror din sql syntaks er forkert. kan du ikke lige skrive din sql sætning herinde.

Vh
Avatar billede dk_gryf Nybegynder
28. februar 2006 - 12:49 #2
Nu ved jeg ikke  helt hvad du mener med "sql sætningen", men her er databasen:
Jeg ville pokkers gerne have selve FAQ kopieret ind  så jeg var fri for at skulle skrive det hele en gang til:

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: 10.0.11.83
-- Generation Time: Jan 29, 2006 at 09:41 PM
-- Server version: 4.0.24
-- PHP Version: 4.3.2
--
-- Database: `netshp_milliondollar`
--

-- --------------------------------------------------------

--
-- Table structure for table `million_admin`
--

CREATE TABLE `million_admin` (
  `id` int(11) NOT NULL default '0',
  `username` varchar(100) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `million_admin`
--

INSERT INTO `million_admin` VALUES (1, 'admin1', 'zappa3993', 'admin@admin.com');

-- --------------------------------------------------------

--
-- Table structure for table `million_admin_home_page`
--

CREATE TABLE `million_admin_home_page` (
  `id` int(11) NOT NULL default '0',
  `page_code` text NOT NULL
) TYPE=MyISAM;

--
-- Dumping data for table `million_admin_home_page`
--


-- --------------------------------------------------------

--
-- Table structure for table `million_blog`
--

CREATE TABLE `million_blog` (
  `blog_id` int(11) NOT NULL default '0',
  `blog_desc` text NOT NULL,
  `blog_date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`blog_id`)
) TYPE=MyISAM;

--
-- Dumping data for table `million_blog`
--


-- --------------------------------------------------------

--
-- Table structure for table `million_buypix_page`
--

CREATE TABLE `million_buypix_page` (
  `id` int(11) NOT NULL default '0',
  `page_code` text NOT NULL
) TYPE=MyISAM;

--
-- Dumping data for table `million_buypix_page`
--

INSERT INTO `million_buypix_page` VALUES (1, '<h2>Purchase Pixels</h2>\r\n<h1 align="center"><a href="buypnow.php">BUY \r\n\r\nPIXELS</a></h1>\r\n<p>&nbsp;</p>\r\n<hr class="c"/>\r\n<p>&nbsp;</p>\r\n<p>The idea is simple one: to try and make $1m (US) by \r\n\r\nselling 1,000,000 pixels for $1 each. Hence, ''The Million Dollar Homepage&quot;. </p>\r\n<p>Everyone is welcome to buy my pixels, \r\n\r\nwhich are available in 100-pixel ''blocks'' (each measuring 10x10 pixels). The homepage is divided into 10,000 of these 100-pixel \r\n\r\nblocks (hence there are 1,000,000 pixels in total). The reason for selling them in 100-pixel blocks is because anything smaller \r\n\r\nwould be too small to display anything effectively.</p>\r\n<p>You can buy as many pixels as you like, as long as there are some \r\n\r\navailable (see the live stats in the top right corner of the page). When you buy some pixels, you can then display an image/ad/logo \r\n\r\nof your choice in the space you have purchased. You can also have the image click through to your own website. However, no obscene \r\n\r\nor offensive images are allowed.</p>\r\n<p>The pixels you buy will be displayed on the homepage permanently. The homepage will not \r\n\r\nchange. Using some of the money I make from the site, I guarantee to keep it online for at least 5 years, but hopefully much \r\n\r\nlonger. I want it to become a kind of internet time capsule. So, in the long run, I believe the pixels will offer good value. You \r\n\r\nwill helped create a piece of internet history and a bit of art to boot!</p>\r\n<p>&nbsp;</p>\r\n<h4>Conditions of \r\n\r\nPurchase</h4>\r\n<ul>\r\n    <li>Minimum Purchase: $100 USD (1 Pixel block - 10x10). Feel free to buy as many as you like. \r\n\r\n</li>\r\n    <li>You are purchasing a pixel advertisement on the main page lasting at least 5 years (hopefully more if we get \r\n\r\nenough funding). </li>\r\n    <li>You are only allowed to change the Image if your site has undergone a major change. Otherwise it \r\n\r\nis final. </li>\r\n    <li><font color="#ff0000">No refunds once your pixel block is accepted and put on the main page.\r\n    \r\n\r\n<li>No obscene/offensive/adult images/links will be accepted. </li>\r\n    <li>If your link is accepted and you later change the \r\n\r\ncontent of the linked site to show offensive/obscene/adult material then your link will be removed until you provide a new one, and \r\n\r\nyou will not get a refund of any kind for the link downtime. </li>\r\n    </font></li>\r\n    <li>You can get your image removed at \r\n\r\nany time but it will become publicly available again and you will not receive a refund. </li>\r\n    <li>Images must be the exact \r\n\r\nsize you have paid for (eg. 100 pixels = 10x10 pixels) </li>\r\n    <li>Images must be in GIF, PNG, BMP, or JPEG format AND not \r\n\r\nanimated. </li>\r\n    <li>Links must be to web pages only and begin with http:// </li>\r\n    <li>You must have the right to use \r\n\r\nthe image you provide. </li>\r\n    <li>There might be occasional downtime for site maintenance but that will be kept to a minimum \r\n\r\nand will only be done when switching servers or upgrading </li>\r\n    <li>Your pixels will be added within 24 hours from time of \r\n\r\npurchase. </li>\r\n</ul>\r\n<p>Ok great, so now you''re all set to buy some pixels. </p>\r\n<p>&nbsp;</p>\r\n<h4><font \r\n\r\ncolor="#0000ff">PayPal</font></h4>\r\n<p>PayPal is the ideal payment method for purchasing 100 to 1,000 pixels. Because the pixels \r\n\r\nare sold in $100 blocks, please ensure you order the correct quantity of blocks when ordering. </p>\r\n<p>Ordering is now done \r\n\r\nautomatically through the grid selection page. <a href="buypnow.php">Visit the grid page</a> and simply click on the cell that you \r\n\r\nwould like to purchase. After your selection you will have the opportunity to expand your selection in height and width. </p>');

-- --------------------------------------------------------

--
-- Table structure for table `million_casestudy_page`
--

CREATE TABLE `million_casestudy_page` (
  `id` int(11) NOT NULL default '0',
  `page_code` text NOT NULL
) TYPE=MyISAM;

--
-- Dumping data for table `million_casestudy_page`
--

INSERT INTO `million_casestudy_page` VALUES (1, '<br><h2>Case Study</h2>\r\n      <hr class="c"> <p>Insert facts and figures here \r\n\r\nabout a recent case study.</p>\r\n      <p>&nbsp;</p>\r\n      <p>&nbsp;</p>\r\n      <p>&nbsp;</p>\r\n      <p>&nbsp;</p>\r\n      \r\n\r\n<p>&nbsp;</p>\r\n      <p>&nbsp;</p>\r\n      <p>&nbsp;</p>\r\n      <p>&nbsp;</p>\r\n      <p>&nbsp;</p>\r\n      \r\n\r\n<p>&nbsp;</p>\r\n      <p>&nbsp;</p>\r\n      <p>&nbsp;</p>\r\n      <p>&nbsp;</p>\r\n      <p>&nbsp;</p>\r\n      \r\n\r\n<p>&nbsp;</p>\r\n      <p>&nbsp;</p>\r\n      <p>&nbsp;</p>');

-- --------------------------------------------------------

--
-- Table structure for table `million_configuration`
--

CREATE TABLE `million_configuration` (
  `id` int(11) NOT NULL default '0',
  `paypal` varchar(100) NOT NULL default '',
  `2co` varchar(100) NOT NULL default '',
  `currency` varchar(5) NOT NULL default '',
  `block_price` int(11) NOT NULL default '0',
  `title` varchar(100) NOT NULL default '',
  `language` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `million_configuration`
--

INSERT INTO `million_configuration` VALUES (1, 'pixel@1milliondollarhomepage.dk', '0', 'USD', 100, 'Million Dollar Script', '0', 'http://www.1milliondollarhomepage.dk');

-- --------------------------------------------------------

--
-- Table structure for table `million_contactus_page`
--

CREATE TABLE `million_contactus_page` (
  `id` int(11) NOT NULL default '0',
  `page_code` text NOT NULL
) TYPE=MyISAM;

--
-- Dumping data for table `million_contactus_page`
--

INSERT INTO `million_contactus_page` VALUES (1, '<h2>Contact</h2>\r\n<hr class="c"/>Default Contact Page\r\n<p>Contact Us: <a \r\n\r\nhref="mailto:Contact@1milliondollarhomepage.dk">Contact@1milliondollarhomepage.dk</a> </p>\r\n<p>We look forward to hearing from you! </p>\r\n<p>&nbsp; \r\n\r\n</p>\r\n<p>&nbsp; </p>\r\n<p>&nbsp; </p>\r\n<p>&nbsp; </p>\r\n<p>&nbsp; </p>\r\n<p>&nbsp; </p>\r\n<p>&nbsp; </p>\r\n<p>&nbsp; \r\n\r\n</p>\r\n<p>&nbsp; </p>\r\n<p>&nbsp; </p>\r\n<p>&nbsp; </p>\r\n<p>&nbsp; </p>\r\n<p>&nbsp; </p>');

-- --------------------------------------------------------

--
-- Table structure for table `million_faq`
--


CREATE TABLE `million_faq` (
  `faq_id` int(5) NOT NULL auto_increment,
  `question` varchar(200) NOT NULL default '',
  `answer` text NOT NULL,
  `date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`faq_id`)
) TYPE=MyISAM;




--
-- Dumping data for table `million_faq`
--


-- --------------------------------------------------------

--
-- Table structure for table `million_language`
--

CREATE TABLE `million_language` (
  `language` varchar(100) NOT NULL default '',
  `newsletter` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `home` varchar(100) NOT NULL default '',
  `buypixels` varchar(100) NOT NULL default '',
  `faq` varchar(100) NOT NULL default '',
  `blog` varchar(100) NOT NULL default '',
  `pixellist` varchar(100) NOT NULL default '',
  `press` varchar(100) NOT NULL default '',
  `casestudy` varchar(100) NOT NULL default '',
  `tellafriend` varchar(100) NOT NULL default '',
  `contactme` varchar(100) NOT NULL default '',
  `sold` varchar(100) NOT NULL default '',
  `avaliable` varchar(100) NOT NULL default '',
  `footer` text NOT NULL,
  `perpixel` varchar(100) NOT NULL default '',
  `own` varchar(100) NOT NULL default '',
  `notsure` varchar(100) NOT NULL default '',
  `id` int(11) NOT NULL default '0',
  `captions` varchar(100) NOT NULL default '',
  `captionsreserve` varchar(100) NOT NULL default '',
  `yellow_title1` text NOT NULL,
  `captionsselected` varchar(100) NOT NULL default '',
  `yellow_title2` text NOT NULL,
  `yellow_title3` text NOT NULL,
  `yellow_title4` text NOT NULL,
  `javamessage` varchar(100) NOT NULL default '',
  `buypixels1` varchar(100) NOT NULL default '',
  `buypixels2` varchar(100) NOT NULL default '',
  `buypixels3` text NOT NULL,
  `buypixels4` varchar(100) NOT NULL default '',
  `buypixels5` varchar(100) NOT NULL default '',
  `buypixels6` varchar(100) NOT NULL default '',
  `buypixels7` varchar(100) NOT NULL default '',
  `order1` varchar(100) NOT NULL default '',
  `order2` varchar(100) NOT NULL default '',
  `order3` varchar(100) NOT NULL default '',
  `order4` varchar(100) NOT NULL default '',
  `order5` varchar(100) NOT NULL default '',
  `order6` varchar(255) NOT NULL default '',
  `order7` varchar(255) NOT NULL default '',
  `order8` varchar(255) NOT NULL default '',
  `order9` varchar(255) NOT NULL default '',
  `news1` varchar(30) NOT NULL default '',
  `news2` varchar(30) NOT NULL default '',
  `news3` varchar(30) NOT NULL default '',
  `news4` varchar(30) NOT NULL default '',
  `news5` varchar(30) NOT NULL default '',
  `news6` varchar(30) NOT NULL default '',
  `news7` varchar(30) NOT NULL default '',
  `tell1` varchar(30) NOT NULL default '',
  `tell2` varchar(30) NOT NULL default '',
  `tell3` varchar(30) NOT NULL default '',
  `tell4` varchar(30) NOT NULL default '',
  `tell5` varchar(30) NOT NULL default '',
  `pixellist1` varchar(30) NOT NULL default '',
  `pixellist2` varchar(30) NOT NULL default '',
  `pixellist3` varchar(30) NOT NULL default '',
  `pixellist4` varchar(30) NOT NULL default '',
  `faq1` varchar(100) NOT NULL default '',
  `faq2` varchar(100) NOT NULL default '',
  `faq3` varchar(100) NOT NULL default '',
  `faq4` varchar(100) NOT NULL default '',
  `faq5` varchar(100) NOT NULL default '',
  `faq6` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`language`,`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `million_language`
--

INSERT INTO `million_language` VALUES ('English', 'Get my newsletter', 'your@email.address', 'Home', 'BUY PIXELS', 'FAQ', 'Blog', 'Pixel List', 'Press', 'Case Study', 'Tell a Friend', 'Contact me', 'Sold', 'Available', 'I am not responsible for the content of \r\n\r\nexternal sites. Images featured on homepage are © of their respective owners. ', 'per pixel', 'Own a piece of Internet history!', 'Not sure if my pixels are worth buing? Click here', 0, 'These pixels are available!', 'Waiting for approval.', 'Choose and upload \r\n\r\na logo or any other picture for this place and link your website to it! Click to select the pixels. \r\n', 'You have already \r\n\r\nselected these pixels.', 'Number of selected fields', ' Delete the selection and start it again', 'Click Here to link the pixels to \r\n\r\nyour website >>', 'This operation is not permited.', 'Select the picture that you want to link to your website', 'Upload picture \r\n\r\n...', 'Notice: The picture must have a GIF, JPG or PNG format, may have up to 500 kB.\r\nPlease be aware that you need to have the \r\n\r\ncopyrights of the image you are providing.', 'Chosen form:', 'Choose your picture >>', 'Total Price', 'Upload >>', 'Link your \r\n\r\npage', 'Please provide your link details.', 'Your Pixel Image', 'Please confirm the following information:', 'Contact Name', 'Email \r\n\r\naddress', 'Link to website', 'Title Message', 'Submit to secure payment', 'First Name', 'Last Name', 'Email', 'Subscriber Action', 'Subscriber', 'Un subecriber', 'Submit', 'Enter your Friends Emails', '(Separated by comma)', 'Your Name', 'Your Email', 'Your \r\n\r\nMessage', 'Pixel List', 'Date of purchase', 'Website', 'Pixels', 'Frequently Asked Question', 'All Questions:', 'Question and \r\n\r\nAnswer:', 'Question:', 'Answer:', 'Date:');
INSERT INTO `million_language` VALUES ('French', 'Obtenez mon bulletin', 'your@email.address', 'Home', 'Achetez', 'Question', 'Blog', 'Liste De Pixel', 'Pression', 'Étude', 'Dites un ami', 'Contactez-moi', 'Vendu', 'Disponible\r\n', 'Je ne suis pas \r\n\r\nresponsable de la teneur des emplacements externes.  Les images décrites sur le homepage sont © de leurs propriétaires \r\n\r\nrespectifs.', 'par Pixel', 'Posséder un morceau d''histoire d''Internet', 'Non sûr si mes Pixel valent la peine de buing?  Click', 4, 'Non sûr si mes Pixel valent la peine de buing?  Cliquetez ici', 'Approbation d''attente.', 'Choisissez et téléchargez un logo \r\n\r\nou n''importe quelle autre image pour cet endroit et liez votre website à lui!  Cliquetez pour choisir les Pixel.', 'Vous avez déjà \r\n\r\nchoisi ces Pixel.', 'Nombre de champs choisis', 'Supprimez le choix et commencez-l''encore', 'Cliquetez ici pour lier les Pixel à \r\n\r\nvotre website > >', 'Cette opération n''est pas autorisée.', 'Choisissez l''image que vous voulez lier à votre website', 'Image de \r\n\r\ntéléchargement...', 'Notification:  Limage doit avoir un GIF, JPG ou le format de png, peut avoir jusquà 500 KBS.  Veuillez se \r\n\r\nrendre compte que vous devez avoir copyright de image que vous fournissez.', 'Forme choisie:', 'Choisissez votre image > >', 'Prix \r\n\r\nTotal', 'Téléchargement > >', 'Liez votre page', 'Veuillez fournir vos détails de lien.', 'Votre Image De Pixel', 'Veuillez \r\n\r\nconfirmer l''information suivante:', 'Nom De Contact', 'Email', 'Lien', 'Message De Titre', 'Soumettez au paiement bloqué\r\n', 'Prénom', 'Dernier Nom', 'Email', 'Action D''Abonné', 'Abonné', 'Subecriber d''un', 'Soumettez', 'Entrez dans vos email d''amis', '(séparé par virgule)', 'Votre Nom', 'Votre Email', 'Votre Message', 'Liste De Pixel', 'Date d''achat', 'Website', 'Pixel', 'Question Fréquemment Posée\r\n', 'Toutes les Questions:\r\n', 'Question et réponse:\r\n', 'Question:', 'Réponse:', 'Date:');
INSERT INTO `million_language` VALUES ('German', 'Rundschreiben', 'Ihr@email. Adresse', 'Haupt', 'Kaufen', 'Frage', 'Blog', 'PixelcListe', 'Presse', 'Fallstudie', 'Sie einem Freund', 'Treten Sie mit mir', 'Verkauft', 'Vorhanden', 'Ich bin nicht für den \r\n\r\nInhalt der externen Aufstellungsorte verantwortlich.  Die Bilder, die auf homepage gekennzeichnet werden, sind © ihrer jeweiligen \r\n\r\nInhaber.', 'pro Pixel', 'Ein Stück Internet-Geschichte besitzen!', 'Nicht sicher, wenn meine Pixel wertSIND buing?  Klicken Sie \r\n\r\nhier', 5, 'Diese Pixel sind vorhanden!', 'Wartezustimmung.', 'Wählen Sie und hochladen Sie ein Firmenzeichen oder jede mögliche \r\n\r\nandere Abbildung für diesen Platz und verbinden Sie Ihr website mit ihm!  Klicken Sie, um die Pixel vorzuwählen.', 'Sie haben \r\n\r\nbereits diese Pixel vorgewählt.', 'Zahl der vorgewählten Felder', 'Löschen Sie die Vorwähler und beginnen Sie sie wieder', 'Klicken \r\n\r\nSie hier, um die Pixel mit Ihrem website zu verbinden > >\r\n', 'Dieser Betrieb wird nicht die Erlaubnis gehabt.', 'Wählen Sie die \r\n\r\nAbbildung vor, die Sie mit Ihrem website verbinden möchten', 'Antriebskraftabbildung...', 'Nachricht:  Die Abbildung muß ein GIF, \r\n\r\nJPG haben, oder png-Format, kann bis 500 KBS haben.  Beachten Sie bitte, daß Sie das copyright des Bildes haben müssen, das Sie zur \r\n\r\nVerfügung stellen.', 'Gewählte Form:', 'Wählen Sie Ihre Abbildung > >', 'GesamtcPreis', 'Antriebskraft > >', 'Verbinden Sie Ihre \r\n\r\nSeite', 'Stellen Sie bitte Ihre Verbindungsdetails zur Verfügung.', 'Ihr PixelcBild', 'Bestätigen Sie bitte die folgenden \r\n\r\nInformationen:', 'KontaktcName', 'Email', 'Verbindung zum website', 'TitelcAnzeige', 'Reichen Sie bei der sicheren Zahlung \r\n\r\nein\r\n', 'Vorname', 'Letzter Name', 'Email', 'TeilnehmercTätigkeit', 'Teilnehmer', 'Un-subecriber', 'Reichen Sie', 'Betreten Sie \r\n\r\nIhre Freund-e', '(getrennt durch Komma)', 'Ihr Name', 'Ihr Email', 'Ihre Anzeige', 'PixelcListe', 'Datum des Erwerbes', 'Website', 'Pixel', 'Häufig Gestellte Frage', 'DE Fragen:\r\n', 'Frage und Antwort:', 'Frage:', 'Antwort:', 'Datum:\r\n');
INSERT INTO `million_language` VALUES ('Italian', 'Mio bollettino', 'vostro@email.com', 'Home', 'Compri', 'Domande', 'Blog', 'Lista \r\n\r\ndei pixel', 'Pressa', 'Inchiesta', 'Dica ad un amico', 'Contatto', 'Venduto', 'Disponibile', 'Non sono responsabile del contenuto \r\n\r\ndei luoghi esterni.  Le immagini descritte sul homepage sono © dei loro proprietari rispettivi.', 'il pixel', 'Possedere una parte \r\n\r\ndi storia del Internet', 'Non sicuro se i miei pixel valgono la pena di buing?  Click', 3, 'Questi pixel sono disponibile!', 'Approvazione Attendente.', 'Scelga ed upload un marchio o qualunque altra immagine per questo posto e colleghi il vostro website \r\n\r\nad esso!  Scattisi per selezionare i pixel.', 'Già avete selezionato questi pixel.', 'Numero di campi selezionati', 'Cancelli la \r\n\r\nselezione ed inizila ancora', 'Click per collegare i pixel al vostro website > >', 'Questo funzionamento non è consentito.', 'Selezioni l''immagine che desiderate collegare al vostro website', 'Immagine di upload...', 'Avviso:  L''immagine deve avere un \r\n\r\nGIF, JPG o la disposizione del png, può avere fino a 500 Kb.  Sia prego informato che dovete avere il copyright dell''immagine che \r\n\r\nstate fornendo.', 'Forma scelta:', 'Scelga la vostra immagine > >', 'Prezzo Totale', 'Upload > >', 'Colleghi la vostra pagina', 'Fornisca prego i vostri particolari di collegamento.', 'La Vostra Immagine Del Pixel', 'Confermi prego le seguenti informazioni:', 'Nome Del Contatto', 'Email', 'Link', 'Messaggio Di Titolo', 'Presenti al pagamento sicuro', 'Nome', 'Ultimo Nome', 'Email', 'Azione Dell''Abbonato', 'Abbonato', 'Unsubecriber', 'Presenti', 'Entri nei vostri email degli a', '(separato dalla virgola)', 'Il \r\n\r\nVostro Nome', 'Il Vostro Email', 'Il Vostro Messaggio', 'Lista Del Pixel', 'Data dell''acquisto', 'Website', 'Pixel', 'Domanda \r\n\r\nFatta Frequentemente', 'Tutte le Domande:\r\n', 'Domanda e risposta:\r\n', 'Domanda:\r\n', 'Risposta:', 'Data:');
INSERT INTO `million_language` VALUES ('Portuguese', 'Assina gratis', 'seu@email.aqui', 'Home', 'Comprar', 'Perguntas', 'Blog', 'Lista de pixels', 'Sala de Imprensa', 'Estudos', 'Envia este site', 'Fale Conosco', 'Vendidos', 'Sobram', 'Eu não sou responsável \r\n\r\npelo conteudo dos links externos.  As imagens localizadas na homepage são propriedades de seus respectivos donos.', 'por pixel', 'Faça parte na historia da Internet!', 'Não tem certeza que pixels valem a pena? Clique Aqui.', 1, 'Estes espaço está livre!', 'Esperando por aprovação.', 'Aqui você pode escolher o espaço que deseja comprar. Selecione o espaço, depois clique com o mouse.', 'Você já selecionou estes pixels.', 'Blocos selecionados', 'Começar novamente', 'Clique aqui para continuar>>', 'Esta operação não \r\n\r\né permitida.', 'Selecione a imagen a ser "Linkada" a seu website.', 'Envia uma image...', 'Nota: A imagem deve ser no formato GIF, \r\n\r\nJPG ou PNG, pode ter no máximo 500KB.\r\nPor favor use uma imagem com direitos autorais pessoais.', 'Forma escolhida:', 'Escolha \r\n\r\numa imagen >>', 'Preço total', 'Enviar >>', 'Link para sua pagina', 'Por favor envie seu link', 'Sua imagem pixelizada', 'Por favor \r\n\r\nconfirm as informações do formulário', 'Nome', 'Email', 'Link', 'Mensagem', 'Pagar (Site seguro)', 'Primeiro Nome', 'Sobrenome', 'Email', 'Ação', 'Subscrever', 'Eliminar subscripção', 'Enviar', 'Email de seus amigos', '(Separados por vírgula)', 'Seu Nome', 'Seu Email', 'Sua menssagem', 'Lista de pixels', 'Data de compra', 'Website', 'Pixels', 'Perguntas frequentes', 'Todas as \r\n\r\nperguntas', 'Questões e Respostas', 'Questão:', 'Resposta:', 'Data:');
INSERT INTO `million_language` VALUES ('Spanish', 'Recibe mi Noticias', 'entra.su@email', 'Inicio', 'Comprar', 'Pregutas', 'Blog', 'Lista de pixeles', 'Prensa', 'Estudio', 'Envíe a un amigo', 'Contacto', 'Vendido', 'Restam', 'No soy responsable por el contenido \r\n\r\nde los sitios en esta pagina.  Las imágenes ofrecidas en el homepage son © de sus dueños respectivos.', 'por pixel', '¡Tenga un \r\n\r\npedazo de la historia!', '¿No estas seguro si mis pixeles valen?  Haz Click', 2, '¡Estos pixeles estan disponibles!', 'Espacio \r\n\r\nReservado', '¡Elija y upload una imagen o cualquier otra foto para este sitio. Link su website a él!  Haz click para seleccionar \r\n\r\nlos pixeles.', 'Usted ha seleccionado estos pixeles.', 'Número de campos seleccionados', 'Apagar la selección y comiéncela otra \r\n\r\nvez.', 'Haz click aquí para ligar los pixeles a su website > >', 'Esta operacción no está permitida.', 'Selecciona la foto que \r\n\r\ndesea usar.', 'Envia la imagen...', 'Atencción: La foto o imagen deve ser de su responsabilidad', 'Formato:', 'Selecciona una \r\n\r\nimagem >>>', 'Precio Total', 'Envia >>', 'Link su pagina', 'Por favor entra su link', 'Su imagen', 'Por favor confirmar', 'Nombre', 'Email', 'Link', 'Mensaje', 'Envia un page', 'Primer Nombre', 'Apelido', 'Email', 'Acción', 'Subscrever', 'Apagar de la lista', 'Envia', 'Entra el nombre de tu amigo', '(Separados por coma)', 'Su Nombre', 'Su Email', 'Su mensaje', 'Lista de Pixeles', 'Fecha \r\n\r\nde compra', 'Sitio', 'Pixeles', 'Pregunta Hecha Con frecuencia\r\n', 'Todas las preguntas', 'Questiones e Respuestas', 'Question:', 'Respuesta:', 'Fecha:');

-- --------------------------------------------------------

--
-- Table structure for table `million_newsletter`
--

CREATE TABLE `million_newsletter` (
  `id` int(11) NOT NULL default '0',
  `fname` varchar(100) NOT NULL default '',
  `lname` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `sub_date` date NOT NULL default '0000-00-00',
  `unsub_date` date NOT NULL default '0000-00-00',
  `sub_status` char(1) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

--
-- Dumping data for table `million_newsletter`
--

INSERT INTO `million_newsletter` VALUES (1, 'Mogens', 'Ivanoff', 'pixel@1milliondollarhomepage.dk', '2006-01-27', '0000-00-00', '1');
INSERT INTO `million_newsletter` VALUES (2, 'Mogens', 'Ivanoff', 'pixel@1milliondollarhomepage.dk', '2006-01-27', '0000-00-00', '1');

-- --------------------------------------------------------

--
-- Table structure for table `million_order`
--

CREATE TABLE `million_order` (
  `id` int(11) NOT NULL auto_increment,
  `x1` int(11) NOT NULL default '0',
  `y1` int(11) NOT NULL default '0',
  `x2` int(11) NOT NULL default '0',
  `y2` int(11) NOT NULL default '0',
  `name` varchar(100) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `url` varchar(100) NOT NULL default '',
  `title` varchar(100) NOT NULL default '',
  `img_name` varchar(100) NOT NULL default '',
  `amount` int(11) NOT NULL default '0',
  `cnf_status` char(1) NOT NULL default '',
  `payment_status` char(1) NOT NULL default '',
  `ord_date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`id`),
  KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

--
-- Dumping data for table `million_order`
--

INSERT INTO `million_order` VALUES (4, 0, 98, 2, 100, 'Mogens', 'pixel@1milliondollarhomepage.dk', 'http://www.1milliondollarhomepage.dk', 'Have you own milliond Dollar Home Page!', 'img_4.gif', 400, '1', '0', '2006-01-29');
INSERT INTO `million_order` VALUES (3, 98, 0, 100, 2, 'Mogens', 'pixel@1milliondollarhomepage.dk', 'http://www.1milliondollarhomepage.dk', 'I Hate the Million Dollar Home Page!', 'img_3.gif', 400, '1', '0', '2006-01-29');

-- --------------------------------------------------------

--
-- Table structure for table `million_press_page`
--

CREATE TABLE `million_press_page` (
  `id` int(11) NOT NULL default '0',
  `page_code` text NOT NULL
) TYPE=MyISAM;

--
-- Dumping data for table `million_press_page`
--

INSERT INTO `million_press_page` VALUES (1, '<h2>Press Coverage</h2>\r\n<hr class="c"/>\r\n<p>Current Listing of Press \r\n\r\nCoverage</p>\r\n<p>&nbsp;</p>\r\n<h3>Web Sites/Blogs</h3>\r\n<ul>\r\n    <li>Coming Soon \r\n\r\n</li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<h3>Newspapers, TV, Media</h3>\r\n<ul>\r\n    <h4>Local</h4>\r\n    <li>Coming Soon \r\n\r\n</li>\r\n</ul>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</\r\n\r\np>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>\r\n<p>&nbsp;</p>');

-- --------------------------------------------------------

--
-- Table structure for table `million_tellafriend`
--

CREATE TABLE `million_tellafriend` (
  `id` int(11) NOT NULL default '0',
  `mail_body` text NOT NULL,
  `from_mail` varchar(200) NOT NULL default ''
) TYPE=MyISAM;

--
-- Dumping data for table `million_tellafriend`
--

INSERT INTO `million_tellafriend` VALUES (1, '<p>This is an invitation. This is pixel page.</p>\r\n<p>visit <a \r\n\r\nhref="www.1milliondollarhomepage.dk</a></p>\r\n<p>&nbsp;</p>'" target="_blank">http://www.1milliondollarhomepage.dk">www.1milliondollarhomepage.dk</a></p>\r\n<p>&nbsp;</p>', 'pixel@1milliondollarhomepage.dk');

-- --------------------------------------------------------

--
-- Table structure for table `pagecount`
--

CREATE TABLE `pagecount` (
  `count` varchar(13) NOT NULL default '1',
  `page` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`count`),
  KEY `page` (`page`)
) TYPE=MyISAM;
Avatar billede innercitydk Nybegynder
28. februar 2006 - 13:23 #3
Jeg tænkte nu mere på den sætning der bliver sendt mod databasen når du klikker på knappen indsæt, eller hvad den nu måtte hede, i din admin sektion.
Avatar billede dk_gryf Nybegynder
28. februar 2006 - 19:35 #4
Jeg har lidt problemer med selve scriptet og er i øjeblikket igang med at geninstallere databasen, og forsøger at importere den database som medfulgte scriptet og som jeg ikke tidligere har haft problemer med, men nu kommer den konstant med "Fejl" når jeg forsøger at importere - jeg vender tilbage til mit spørgsmål såsnart jeg databasen på plads- en anden  ting er, kan det ikke lade sig gøre at indsætte FAQ teksten direkte i ovennævnte:
Teksten ser således ud (det vil jo gøre tingene nemmere hvis jeg kunne det og så importere det hele på en gang):

You guessed it. On this page you will find answers to some of the most frequently asked questions. Got a question not answered here? Please get in touch.

Who are you?

Are you genuine/is this a joke?

How did you come up with the idea?

Why do you need $1m for University?

What will you do with the money?

Why should I buy your pixels?

Why can't I buy one single pixel?

How long will the site be online?

If you're from the UK, why are you selling pixels in dollars?

If you want money for uni, why don't you get a job?

Are you worried about copy-cats/rip-offs?

Can I put a count of your pixel sales on my site/blog? 


--------------------------------------------------------------------------------

1. What is the idea?

The idea is simple: to try and make $1m (US) by selling 1,000,000 pixels for $1 each. Hence, 'The Million Dollar Homepage". The main motivation for doing this is to pay for my degree studies, because I don't like the idea of graduating with a huge student debt. I know people who are paying off student loans 15-20 years after they graduated. Not a nice thought!
So, everyone is welcome to buy my pixels, which are available in 100-pixel 'blocks' (each measuring 10x10 pixels). You will see the homepage is divided into 10,000 of these 100-pixel blocks (hence there are 1,000,000 pixels in total). The reason for selling them in 100-pixel blocks is because anything smaller would be too small to display anything meaningful.

You can buy as many pixels as you like, as long as there are some available (see the live stats in the top right corner of the page). When you buy some pixels, you can then display an image/ad/logo of your choice in the space you have purchased. You can also have the image click through to your own website. However, no obscene or offensive images are allowed.

The pixels you buy will be displayed on the homepage permanently. The homepage will not change. Using some of the money I make from the site, I guarantee to keep it online for at least 5 years, but hopefully much longer. I want it to become a kind of internet time capsule. So, in the long run, I believe the pixels will offer good value. You will have a piece of internet history!

Top


--------------------------------------------------------------------------------

2. Who are you?

My name is Alex Tew, I'm 21 years old and I live in a small town in Wiltshire, England. I'll be starting at University in England at the end of September, where I will be reading Business Management. I'm going to Uni a little later than normal (I will technically be a mature student), but I'm really looking forward to it. Infact, I can't wait. But Uni is not cheap, and faced with the prospect of graduating after 3 years with a huge debt, I thought I'd try and make some money ($1m should do the trick!)
Top


--------------------------------------------------------------------------------

3. Are you genuine/is this a joke?

I am completely genuine and although this site might be funny in various ways, it is not a joke! I really am selling pixels for $1 each, because I don't want a monstrous debt when I graduate. I am pixel hustler and proud!
Some people have even asked if I am actually 21 and going to University. Fair question I guess. The answer is of course yes, as this photo of me and my uni acceptance form should prove to any doubters:

For non-UK folks, 'UCAS' is the 'Universities and Colleges Admissions Service' who, as the name suggests, handle all University admissions in the UK. Forgive me for deliberately blurring out my address :)

Top


--------------------------------------------------------------------------------

4. How did you come up with the idea?

It was a muggy summer's night late in August (2005), the time around midnight, and there I was, lying on my bed with a notepad, brainstorming ideas to make money for uni. I think I'm quite a creative person, so I wanted to come up with an idea that was unique and would hopefully capture people's imagination, but with the whole purpose of making money. No point being shy about it! I think we brits can sometimes be too shy about money. Well bugger that, I DO NOT want to be a broke student!
So anyway, after an hour of two of jotting random things on paper, the idea seemingly popped out of nowhere. Almost like my subconscious mind had been ticking over in the background, working it all out. So it just kind of happened. That's about it. I scribbled it down and within about 10 minutes a picture of what needed to be done had emerged.

Top


--------------------------------------------------------------------------------

5. Why do you need $1m for University?

I don't. Textbooks might be expensive, but they're not that steep! But with this project I knew I had to aim high - my thinking being that even if I only got 1 or 2 percent of a million dollars, that would sort me out.
Infact, making any money whatsoever by selling pixels had to be worth a try. Afterall, I had plenty of pixels to start with! Furthermore, I knew the site had to be 'The Million Dollar Homepage' in order to catch people's attention - anything else just wouldn't cut it, eg. '$100,000 Homepage'. Er... no.


Top


--------------------------------------------------------------------------------

6. What will you do with the money?

First and foremost, if I make enough money, I will pay my way through University. That includes 3 years worth of tuition fees, accomodation fees, textbooks etc, and [god forbid] - having a social life!
After that, I would like to pay for my parents to have some time off because they work so hard and they deserve a break. I would like to return some of the support they have given me over all these years.

Thirdly... socks! I definitely need some new socks. Whenever I buy new ones they seem to disappear, or they disintegrate. So I want to buy some really expensive, long-lasting socks.

Finally... if I reach the $1m target and still have money left over after buying my swanky new socks, then I have a couple of interesting business ideas I would love to invest some money in. So watch this space!

Top


--------------------------------------------------------------------------------

7. Why should I buy your pixels?

Because you will have an image and a link to your site on the homepage of a site that could potentially be seen by millions of people over the coming years. The site will be online for at least 5 years, that's guaranteed, but the idea is to keep it online forever. So you really could own a piece of 'internet history'!
--------------------------------------------------------------------------------

8. Why can't I buy one single pixel?

I decided that although it would probably be cool if individuals could buy a single pixel each, in practise, it wouldn't so effective. The reason I believe this is because you can't display anything meaningful in one pixel - nor click it easily - so visually, it would be pointless. With thousands of random tiny coloured dots all over the place, the homepage would look gastly.
I also thought that the site would appeal more to people with businesses/websites to advertise than it would to individuals, or to put it more accurately, businesses would pay more to have a meaningful graphic on the homepage. Hence the minimum purchase is $100 - a 10x10 block.

However! If you really want to own a single pixel, there is always the option of clubbing together with your friends/family/colleauges and buying a 10x10 block.

Top


--------------------------------------------------------------------------------

9. How long will the site be online?

The site will be online for 5 years guaranteed (at least until 26th August 2010), however the aim is to keep the site online forever (or as long as humanly possible).
The idea is to create something of an internet time capsule: a homepage that is unique and permanent. Everything on the internet keeps changing so fast, it will be nice to have something that stays solid and permanent for many years. You can be a part of that!

Top


--------------------------------------------------------------------------------

10. If you're from the UK, why are you selling the pixels in dollars?

I think US dollars are the closest thing we have to a universal currency on the internet, so it made more sense to do it in dollars. 'The Million Pound Homepage' just doesn't have the same ring to it!
Also, given that the US has the largest online population in the world, more people will be able to relate to the concept than had I done it in British pounds. Plus, £1 GBP per pixel would probably be too expensive (would equate to around $1.80 US per pixel).

Top


--------------------------------------------------------------------------------

11. If you want money for Uni, why don't you get a job?

Although I've done many different jobs in the past, it's not really how my brain likes to work. My natural disposition is to think of ideas, and I like to create interesting things and ways of doing things. Plus this is much more fun to do, with a potential higher reward. That's not a cop-out, honest guv!
Top


--------------------------------------------------------------------------------

12. Are you worried about copy-cats/rip-offs?

Not at all. It is bound to happen (this is the internet afterall), and infact, I think it will work in my favour. They say imitation is the sincerest form of flattery. So I think any copy-cat sites will only have pure comedy value, whereas mine possibly has a bit of comedy PLUS some actual pull in terms of advertising dollars (I will be able to afford swanky socks, they will only get to buy crappy ones probably! They could have my old ones, if they like).
So I say good luck to the imitators! While in my opinion it's not very cool - I would prefer to come up with something original - in many ways the act of copying (perhaps more on a subconcious level than anything) is the basis of all creativity. But yeah, really bad rip-offs are seriously lame - I mean, if you're gonna copy the concept, at least come up with your own design and text!

UK folks > am I bothered? :)

Top


--------------------------------------------------------------------------------

Can I put a count of your pixel sales on my site/blog?

Certainly! The code is:
<a href="http://www.milliondollarhomepage.com/" title="Million Dollar
Homepage"><img src="http://www.milliondollarhomepage.com/img-pix/pixelcount.gif"
alt="Million Dollar Pixel Page progress report" border="0" width="495"
height="45"></a>

This will display as: 

The graphic will be updated automatically every time pixels are added to the site!

Top


--------------------------------------------------------------------------------
Avatar billede dk_gryf Nybegynder
28. februar 2006 - 23:06 #5
Jeg kan ikke indsætte noget direkte fra MySQL - kun via admin, men det bliver ikke gemt - det eneste som jeg får tilbage er:
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 'The Million Dollar Homepage\". The main motivation for doing th
Avatar billede dk_gryf Nybegynder
28. februar 2006 - 23:40 #6
Kan dette bruges:  Der ser ud til at være en fejl i din SQL-forespørgsel. MySQL-serverens fejlmelding der følger herunder, hvis der er nogen, kan også hjælpe dig med at finde problemet.

ERROR: Ukendt tegnsætnings-streng @ 10356
STR: ://
Avatar billede innercitydk Nybegynder
01. marts 2006 - 09:37 #7
Jeg tror problemet ligger i selve koden, og ikke i databasen. Jeg kender ikke den side du bruger, men har du tjekket om der er et forum der hvor du downloadede det? Det kunne være andre har haft samme problem.

Vh
Avatar billede dk_gryf Nybegynder
21. august 2006 - 22:40 #8
case closed
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Computerworld tilbyder specialiserede kurser i database-management

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester



Seneste spørgsmål Seneste aktivitet
I dag 06:10 Excel åbner fil i kæmpe format Af Aske i Excel
I går 22:00 Datafordeler Af Lsk i PHP
I går 12:37 Summere beløb pr. dato Af TTA i Excel
31/1022:44 Tilslutte chassic fans Af viking69 i PC
31/1020:28 LED lysstofrør Af ErikHg i Fri debat