Problem with Code from 2nd edition Welling/Thomson PHP?MySQL Web App Book

Sorry for the long post, but I'm using with difficulty the 2nd edition of Welling/Thomson's PHP and MySQL Web Development as a textbook for self-teaching. After being pleased to work my way thru to Chapter 14, not memorizing the earlier material, but having some success basically understanding

Populating a Table with Data by Inserting a Textfile

What I'd like to do is create a textfile and then import the whole thing into a table. So, naturally, I've a few questions. Do I need to include the column heads as a line in my textfile, or can I simply go straight to the data? Assuming, no column heads are necessary--because they're already t

Trying to Learn MySQL/PHP with Dreamweaver

I'm trying to learn to create database-driven websites on the Macintosh using Dreamweave MX, PHP, and MySQL. I'm working thru exercises ina great book published by the recently-defunct Glasshaus, Dreamweaver MX: PHP Web Development. I'm in the next-to-the-last chapter, trying to complete an exe

Maybe OT: Anyone Familiar w/ Dreamweaver MX: PHP Web Development?

Well, MySQL is involved to the extent that the "Web Development" of the title does involve MySQL database-driven applications. So, is anyone familiar with this book. I'm in one of the last chapters and I am hopelessly lost trying to find the proper places to input my username, password, and db

Re: MySQL 4.0.12

Re: this latest version of MySQL. Has anyone installed a production version of MySQL 4 on the Macintosh platform yet? Anything significant to report? Advice not to do it yet? Thank you. Steve Tiano - Before posting, please che

Transactions

From what I understand, "transactions" are a kind of protection that prevents certain commands from executing if certain other conditions haven't been met. And this is particularly important for ecommerce, among other things. Do I more or less have that right? My main question, tho', is: Does t

phpMyAdmin

Anyone familiar with the GUI interface for MySQL/PHP called 'phpMyAdmin'? I'm at a point in my intensive self-study via books, tutorials, and exercises where one of the books I'm working with--trying to tie together with my graphical HTML editor--Dreamweaver: PHP Development--suggests phpMyAdmi

Re: Scripting MySQL Commands

Guys, Guys-- I got it! I stopped being a dimwit long enough to realize that the change to "USE Temp;" below was for INSIDE the script. When I made that change and again went to a new shell and typed (actually, I dragged the file from the window in which it sat in the Finder into the Terminal a

Scripting MySQL Commands

Paul, Oliver-- I really, really appreciate you guys taking time from your respective Sundays to try and enlighten me. But I'm still getting nowhere fast. I've gotten it to this: I open a new shell and type: /usr/local/bin/mysql --local-infile -u root -p [the full pathname up to]/Temp.sql a

Re: Scripting MySQL Commands

Paul, Thanks very much for responding. I tried what you suggested, but got: ERROR 1102: Incorrect database name '/Users/stephent/Sites/Temp.sql' I don't get this. What wrong database name? The script is supposed to create the database and a table in it. What an I too dense to see? Thanks a

Re: Scripting MySQL Commands

Oliver, Thanks for responding. Foolish of me to be in such a rush that I wasn't watching what I was copying and pasting. I actually did use the command you suggest below. And that's what drew the error message. So I'm back to the drawing board. Take care, and thanks again-- Steve Hy Steve,

Re: Creating Tab Delimited Textfile to Load Data Into MySQL Table

Stefan and Gerald-- Thanks for the input. Here's how I solved it ... I used a textfile that had worked for me the very first time I did such an exercise weeks ago. This particular textfile came on a CD with the book I was using. And by copying and pasting, so that all the spacing and line break

Re: Creating Tab Delimited Textfile to Load Data Into MySQL Table

Thanks to Gerald and Stefan for taking the time. Here's where I am ... Perhaps because I'm still wet behind the ears, I brainlessly included the column heads in the textfile. Of course, that's unnecessary. I substituted \N for NULL and stuck \n at the end of each line--the latter because I'm no

Creating Tab Delimited Textfile to Load Data Into MySQL Table

I'm just starting out, doing tutorials and exercises up the wazoo, trying to learn MySQL and PHP. I've created a table in a test database. When I do a DESCRIBE [table_name], the columns come up just as they should. Populating them with data's another story. I've created a textfile in a text ed

Re: Rank Amateur Back for More

mysql Thanks for responding, Paul. What's interesting is that pet.txt was still "not found" when I used the path as you suggested. What would be the reason for it being "invisible"? Steve Tiano So I issue the command LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet; and, for the first

Rank Amateur Back for More

Okay, I found User Comments at the end of the section of the user manual online that contained the info I needed to get the option of loading a textfile into a table. The startup line I use for that is: /usr/local/bin/mysql -u root --local-infile -p menagerie where 'menagerie' is the databa

Another Rank Amateur Question

The manual I was able to download, I now notice, is for version 4.0.3-beta of MySQL. So that's the official tutorial I'm working. That and Kevin Yank's Building a Database-Driven Web Site Using PHP and MySQL--a '10-week course' that I also was able to download. Problem has surfaced due to my ha

New to MySQL/PHP with Rank-Amateur Questions

I'm brand-new to MySQL/PHP and to this list, spending an interesting holiday weekend devoted to trying to start learning the MySQL/PHP/Apached axis. There're three things that had me thinking of just giving it all up. But after a night's sleep I can't deny still wanting to learn how to design