drunkelf

Hello everyone i need help again.I am reading a book that requires me to import a old sql file.WHen I do this get following error #1064 - 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 'TYPE=MyISAM' at line 7 mysql version 5.5.24 OK so it is around line 7.this should be easy to fix but I dont know how.If you can have a look In Need to make this work so I can finish the book even though it is outdated -- phpMyAdmin SQL Dump -- version 2.6.3-pl1 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Aug 24, 2005 at 12:34 PM -- Server version: 4.1.13 -- PHP Version: 5.0.4 -- -- Database: `seasons` -- -- -------------------------------------------------------- -- -- Table structure for table `quotations` -- DROP TABLE IF EXISTS `quotations`; CREATE TABLE `quotations` ( `quote_id` int(10) unsigned NOT NULL auto_increment, `quotation` varchar(255) NOT NULL default '', `first_name` varchar(30) NOT NULL default '', `family_name` varchar(30) NOT NULL default '', PRIMARY KEY (`quote_id`) ) TYPE=MyISAM; -- -- Dumping data for table `quotations` -- INSERT INTO `quotations` VALUES (1, 'My disability is that I cannot use my legs. My handicap is your negative perception of that disability, and thus of me.', 'Rick', 'Hansen'); INSERT INTO `quotations` VALUES (2, 'Life is a great surprise. I do not see why death should not be an even greater one.', 'Vladimir', 'Nabokov'); INSERT INTO `quotations` VALUES (3, 'Money couldn''t buy friends, but you got a better class of enemy.', 'Spike', 'Milligan'); INSERT INTO `quotations` VALUES (4, 'In the factory we make cosmetics; in the store we sell hope.', 'Charles', 'Revson'); INSERT INTO `quotations` VALUES (5, 'Man is the only animal that blushes. Or needs to.', 'Mark', 'Twain'); INSERT INTO `quotations` VALUES (6, 'Familiarity breeds contempt — and children.', 'Mark', 'Twain'); INSERT INTO `quotations` VALUES (7, 'Good breeding consists in concealing how much we think of ourselves and how little we think of the other person.', 'M', 'Twain'); INSERT INTO `quotations` VALUES (8, 'If it turns out that there is a God, I don''t think that he''s evil. But the worst that you can say about him is that basically, he''s an underachiever.', 'Woody', 'Allen'); INSERT INTO `quotations` VALUES (9, 'I don''t want to achieve immortality through my work... I want to achieve it by not dying.', 'Woody', 'Allen'); INSERT INTO `quotations` VALUES (10, 'A thing of beauty is a joy forever.', 'John', 'Keats'); INSERT INTO `quotations` VALUES (11, 'Scenery is fine — but human nature is finer.', 'John', 'Keats'); INSERT INTO `quotations` VALUES (12, 'The nice aspect about football is that, if things go wrong, it''s the manager who gets the blame.', 'Gary', 'Lineker'); INSERT INTO `quotations` VALUES (13, 'Iron rusts from disuse; stagnant water loses its purity and in cold weather becomes frozen; even so does inaction sap the vigor of the mind.', 'Leonardo', 'da Vinci'); INSERT INTO `quotations` VALUES (14, 'A hundred times I have thought: New York is a catastrophe, and fifty times: it is a beautiful catastrophe.', '', 'Le Corbusier'); INSERT INTO `quotations` VALUES (15, 'Power is the great aphrodisiac.', 'Henry', 'Kissinger'); INSERT INTO `quotations` VALUES (16, 'Injustice anywhere is a threat to justice everywhere.', 'Martin Luther', 'King'); INSERT INTO `quotations` VALUES (17, 'Democracy is the worst form of government except all those other forms that have been tried from time to time.', 'Winston', 'Churchill'); INSERT INTO `quotations` VALUES (18, 'Love, friendship, respect do not unite people as much as common hatred for something.', 'Anton', 'Chekhov'); INSERT INTO `quotations` VALUES (19, 'Everything''s got a moral, if only you can find it.', 'Lewis', 'Carroll'); INSERT INTO `quotations` VALUES (20, 'The greatest happiness of the greatest number is the foundation of morals and legislation.', 'Jeremy', 'Bentham'); INSERT INTO `quotations` VALUES (21, 'There''s a hell of a distance between wise-cracking and wit. Wit has truth in it; wise-cracking is simply callisthenics with words.', 'Dorothy', 'Parker'); INSERT INTO `quotations` VALUES (22, 'Summers pleasures they are gone like to visions every one.', 'John', 'Clare'); INSERT INTO `quotations` VALUES (23, 'Under the cherry —\r\nblossom soup,\r\nblossom salad', 'Matsuo', 'Basho'); INSERT INTO `quotations` VALUES (24, 'No spring, nor summer beauty hath such grace,\r\nAs I have seen in one autumnal face', 'John', 'Donne'); INSERT INTO `quotations` VALUES (25, 'Sweet lovers love the spring.', 'William', 'Shakespeare'); INSERT INTO `quotations` VALUES (26, 'O, Wind,\r\nIf Winter comes, can Spring be far behind?', 'Percy Bysshe', 'Shelley'); INSERT INTO `quotations` VALUES (27, 'In the spring a young man''s fancy lightly turns to thoughts of love', 'Alfred, Lord', 'Tennyson'); INSERT INTO `quotations` VALUES (28, 'It is not spring until you can plant your foot on twelve daisies.', '', 'Proverb'); INSERT INTO `quotations` VALUES (29, 'The way to ensure summer in England is to have it framed and glazed in a comfortable room.', 'Horace', 'Walpole'); INSERT INTO `quotations` VALUES (30, '’Tis the last rose of summer\r\nLeft blooming alone\r\nAll her lovely companions\r\nAre faded and gone', 'Thomas', 'Moore'); INSERT INTO `quotations` VALUES (31, 'Shall I compare thee to a summer''s day?\r\nThou art more lovely and temperate', '', 'Shakespeare'); INSERT INTO `quotations` VALUES (32, 'Now is the winter of our discontent\r\nMade glorious summer by this sun of York', '', 'Shakespeare'); INSERT INTO `quotations` VALUES (33, 'Blow, blow, thou winter wind,\r\nThou art not so unkind\r\nAs man''s ingratitude', 'W', 'Shakespeare'); INSERT INTO `quotations` VALUES (34, 'My age is as a lusty winter, frosty, but kindly.', 'William', 'Shakespeare'); INSERT INTO `quotations` VALUES (35, 'The first fall of snow is not only an event, but it is a magical event. You go to bed in one kind of world and wake up to find yourself in another quite different...', 'JB', 'Priestley'); INSERT INTO `quotations` VALUES (36, 'Therefore all seasons shall be sweet to thee.', 'Samuel Taylor', 'Coleridge'); INSERT INTO `quotations` VALUES (37, 'The frost performs its secret ministry,\r\nUnhelped by any wind', 'Samuel Taylor', 'Coleridge'); INSERT INTO `quotations` VALUES (38, 'And then my heart with pleasure fills,\r\nAnd dances with the daffodills', 'William', 'Wordsworth'); INSERT INTO `quotations` VALUES (39, 'Oh, my Luve''s like a red, red rose\r\nThat''s newly sprung in June', 'Robert', 'Burns'); INSERT INTO `quotations` VALUES (40, 'Season of mists and mellow fruitfulness,\r\nClose bosom-friend of the maturing sun', 'John', 'Keats'); INSERT INTO `quotations` VALUES (41, 'The coming musk rose, full of dewy wine,\r\nThe murmurous haunt of flies on summer eves', 'John', 'Keats'); INSERT INTO `quotations` VALUES (42, 'Snowy, Flowy, Blowy,\r\nShowery, Flowery, Bowery,\r\nHoppy, Croppy, Droppy,\r\nBreezy, Sneezy, Freezy', 'George', 'Ellis'); INSERT INTO `quotations` VALUES (43, 'Mais où sont les neiges d''antan? (But where are the snows of yesteryear?)', 'François', 'Villon'); INSERT INTO `quotations` VALUES (44, 'Summer time an'' the livin'' is easy,\r\nFish are jumpin'' and the cotton is high', 'Heyward &', 'Gershwin'); INSERT INTO `quotations` VALUES (45, 'I never think of the future. It comes soon enough.', 'Albert', 'Einstein'); INSERT INTO `quotations` VALUES (46, 'The English never smash in a face. They merely refrain from asking it to dinner.', 'Margaret', 'Halsey'); INSERT INTO `quotations` VALUES (47, 'Once the toothpaste is out of the tube, it is awfully hard to get back in.', 'HR', 'Haldeman'); INSERT INTO `quotations` VALUES (48, 'Le sens commun est fort rare. (Common sense is not so common.)', '', 'Voltaire'); INSERT INTO `quotations` VALUES (49, 'I hate television. I hate it as much as peanuts. But I can''t stop eating peanuts.', 'Orson', 'Welles'); INSERT INTO `quotations` VALUES (50, 'I always say, keep a diary and some day it''ll keep you.', 'Mae', 'West');

it works baby!sadly my book by david powers uses difrrint versions of these programs but he did say to install the latest versions availible so I am sure that I will be able to make sense of it.This wamp server thingy is so cool so easy.You can close the thead now

really intresting thank you I will study it in detail

yes that I am sure off.I will go through all the "adjustments" I made to php.ini when I first "installed" it otherwise I will use another pc.I am thinking instead of installing php 5 because that is the one used it my book I will install the latest and instead of installing phpmyadmin 2.6.4.p1 I will install the latest I am also going to use a windows installer instead of copying files like david powers told me too. Hopefully I can follow the book using diffrint versions of these programs

PLease be pateint with me I am only starting out.I see there is a heading for sq lite and that sq lite has something to do with databases.That has nothing to do with my sql right?

This might be a dumb question but would the information about mysql in php info be plain english?I want to know what to look thank you

I restarted both mysql and apache I am looking at php info but dont know what to look for because I did not find anything about mysql

Like this you can see that mysql has been uncommented in my php.ini file ;extension=php_mssql.dll ;extension=php_msql.dll extension=php_mysql.dll extension=php_mysqli.dll ;extension=php_oci8.dll ;extension=php_openssl.dll

yes I do it was installed sucessfully

I followed all of the instructions and it still does not work.Here is the instructions here is my error cannot load mysql extension; please check PHP configuration <snip mod: removed hundreds of lines of copy/pasted phpmyadmin instructions and phpmyadmin config file>

Maybe I am just tired but I cannot seem to grasp returning values from functions using the return keyword thingy and its practical application.Maybe you can break it down for me

I quaote When you pass an argument to the function, a local copy is made in the function to store the value. Any changes made to that value affect only the local copy of the variable in the function, not the source of the parameter. You can define parameters that modify the source variable by defining reference parameters. Reference parameters define references by placing an ampersand (&) directly before the parameter in the function’s definition. some code <?php function capitalize( &$str, $each=TRUE ) { // First, convert all characters to lowercase $str = strtolower($str); if ($each === true) { $str = ucwords($str); } else { $str{0} = strtoupper($str{0}); } } $str = "hEllo WoRld!"; capitalize( $str ); echo $str; ?> Ok I do not undestand reference parameters.CAn sombody help me out.I am going to continue with other lessons but would like to have a better understanding of this reference parameters.Thanks

SO I am learing to code php by hand the same time I am learning how to use it in dreamweaver.By hand I am working with very basic stuff but a script that comes straight from the book does not work.It os very simple little block of code but what is wrong with it.If the code in the book itself is faulty then I cant learn so please help me with this I need to learn these things so I can understand it myself <?php echo "Executing line " . __LINE__ . " of PHP script " . __FILE_ _ . "."; ?>

Error is gone!I would like to understand what is happening here but right now it only needs to work. thank you

OK i think I understand what you mean so where do I type in the code you gave me.IF you can tell me where I should put the code I think I will understand better