I installed a preconfigured package called MAMP on my MacBook Pro and have just
about everything working except my database connections. I can use phpMyAdmin
to manipulate databases and tables, but I can't connect to those databases from
Dreamweaver.
I read somewhere that you have to use a spec
You wrote, "You need to create a root password and other users."
insert into mysql.user set
Host='localhost',
User='',
* * * * * * * * * *
Thanks, but that gave me an error message.
I clicked on a particular database, then clicked Privileges and changed the
pa
='Y',
Create_tmp_table_priv='Y',
Lock_tables_priv='Y',
Execute_priv='Y',
Repl_slave_priv='Y',
Repl_client_priv='Y',
Create_view_priv='Y',
Show_view_priv='Y',
Create_routine_priv='Y',
A
How would you write a database connection for a database on which you haven't
yet established a username or password? None of the following work:
$link = mysql_connect ("localhost" , "root" , "") or die(mysql_error());
mysql_select_db ("test", $link) or die(mysql_error());
$link = mysql_conne
'root'@'localhost' (using password: YES)
* * * * * * * * * *
I opened config.inc.php but couldn't find any reference to the database table,
password or username I created. Any tips?
Thanks.
- Original Message ----
From: Schalk Neethling <[EMAIL PROTECTED]>
Ah, that does look like a better way. Thanks!
Schalk Neethling <[EMAIL PROTECTED]> wrote: Hi David,
Actually the way to do this would be as follows:
When you have created a new database, click on the SQL tab and the use
the following to create the user and password:
GRANT ALL PRIVILEGES ON data
Sorry for the beginner's question, but I'm confused. I can easily create
passwords and usernames for my online databases by going into my C-Panel and
clicking a MySQL icon. It fetches a page that allows me to easily create and
delete databases, add and change passwords, etc. But I can't remember
I'm in the process of moving a MySQL database with about 170 tables from my PC
to a new MacBook Pro. On my PC, I exported each database table as a SQL file,
then copied a folder containing all these files to my Mac.
I'd like to know if there's a way to import all these SQL files into a database
OK, now I get it. I'll give that a try. Thanks for the tip about the OmniWeb
browser, too.
- Original Message
From: Chris Sansom <[EMAIL PROTECTED]>
To: David Blomstrom <[EMAIL PROTECTED]>; mysql@lists.mysql.com
Sent: Sunday, October 8, 2006 1:51:33 AM
Subject: Re: Mov
Hopeffully this will be the last question in this series. :)
I want to copy a database from my PC to my Apple laptop. I installed MySQL's
GUI Tools on both computers, created a file named Backup.mpb on my PC, then put
a copy of it on my Mac. Now I'm trying to figure out how to get Backup.mbp int
OK, I'm halfway there. But I don't understand what you mean by "saved
settings." Is there some sort of default value I can try?
Also, if I can't recover my password, is there a file I can open and retrieve
it from?
I tried it with localhost, Port 3306, Username: root and the password of one of
I just downloaded MySQL Administrator and am now trying to set it up. Can
anyone tell me what "stored connection" and "Server Host" mean? I'm using
Apache on Windows XP, but I'm not sure what they mean by Server Host. 3306 is
listed under "Port" by default.
Also, what are the default username a
Ah, that's better. I learned how to use Terminal just the other day. I'll check
out the other programs you recommended, too. Thanks.
- Original Message
From: Douglas Sims <[EMAIL PROTECTED]>
To: David Blomstrom <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sen
Thanks. Is this something I can do through phpMyAdmin? I'm not used to working
with MySQL directly and don't understand exactly what this command means:
shell> mysqldump [options] --all-databasesDoes "shell" mean I have to be
working in some sort of command line program?
Also, if I can't figure
I recently purchased a MacBook Pro laptop and hired someone to help me set up
Apache, PHP and MySQL on it. Now I want to import my database tables from my
PC. So my main question is this:
Is there a quick, simple of importing an entire database?
If not, I figured I'd simply export each database
David,
Who was the ISP? Maybe they'd like some free advertising. :)Ha! I'd
better wait until April 1, when I hope to have a new home.
I've actually been promoting this webhost since I've been with them. They
just flaked out very badly all of a sudden. Coincidentally, they had a ma
[EMAIL PROTECTED] wrote:
Is this a free hosting package David B?
That's a bit naughty I think - just removing your database
without warning you about it first. At least you would have
had time to make a backup copy.
* * * * *
I'm paying $50 a month, and I was blown away when they s
I recently discovered that all my websites were wrecked. I spent several hours
trying to troubleshoot it, until I finally discovered that my database was
missing. I asked my webhost about it, and they told me they deactivated it
because it was "overwhelming the server."
Someone told me a
--- [EMAIL PROTECTED] wrote:
> <<<>>>
>
> David, is it at all intuitive to organize your
> geography into a tree-type
> structure? Here is an example:
>
> Western Hemisphere (hemisphere)
> C. America (continent)
> Guatemala (country)
> N. America (continent)
>
--- Jigal van Hemert <[EMAIL PROTECTED]> wrote:
> > ANIMALS TABLE
> > Canis_lupus | wolf
> > Panthera_tigris | tiger
> >
> > JOIN TABLE
> > SPECIES | ECOREGION
> > Canis_lupus | NA1008
> > Canis_lupus | NA1010
> >
> > ECOREGIONS TABLE
> > ID | NAME | Geog | Geog2
> > NA1008 | Alaska tundra | na
I have a PHP script that displays data like this:
Eurasia
Eurasiaisland
Africa
Where Eurasia and Africa are mainland parents of
ecological regions and Eurasiaisland is a
parent of an ecological system that is associated with
a continent. For example, Borneo would be
Eurasiaisland.
The finished s
OK. I thought about that earlier, but I wasn't sure if
I'd be able to adapt it to this particular problem.
Do you think the "automated tree traversal" method
described at the link you posted...
http://www.sitepoint.com/article/hierarchical-data-database/2
...is the only one that would work? I've
I hope this isn't too long-winded. It's kind of hard
to explain.
I'm trying to figure out a scheme that will display
animal distribution information. First, I want to
divide animal species by continents. Next, I want to
further identify species that live on islands that are
associated with contine
--- [EMAIL PROTECTED] wrote:
> Please, please! read up on normalization. The way I
> would probably handle
> this design issue is by creating a separate table of
> taxonomic names (I
> know this is very different than my previous advice
> but I have had longer
> to think about it).
OK, I'll ha
(Sorry if this is a repeat; I think my first post
didn't go through.)
I'm still stuck on the problem I asked about a day or
two ago. I'm working on a page at
http://www.geozoo.org/stacks/ that draws data from a
table that lists animal taxons (orders, families,
species, etc.) in a child-parent rela
--- [EMAIL PROTECTED] wrote:
-
In my opinion:
The easiest thing for you to do right now would be a
table like
ID (primary key) NAME PARENTID
You don't need PARENT, because you have the PARENTID,
you can always retrieve parent. Although... i still
think it
--- [EMAIL PROTECTED] wrote:
> You have confused front end representation with
> back-end data design. How
> you store your data and create your data
> relationships is only marginally
> related to what your code makes it look like when it
> presents your data
> for the user. Why just create lo
--- Peter Brawley <[EMAIL PROTECTED]> wrote:
"As you note, the names [of animal taxons] aren't
guaranteed to be unique, or to stay the same . . .
> One way out is to give every table an
> auto-incrementing integer PK, and
> use those keys, which will never change, to mark
> parent-child relatio
--- Peter Brawley <[EMAIL PROTECTED]> wrote:
> David,
>
> >1. Some species names are shared by more than one
> >mammal. For example, there's a marsupial named
> >Antechinus leo.
>
> >2. Species are more properly cited with the name
> of
> >their parent (genus), so I eventually want my
> spe
I'll give that a try. Thanks.
--- [EMAIL PROTECTED] wrote:
>
>
> David Blomstrom wrote:
>
> >-- [EMAIL PROTECTED] wrote:
> >
> >
> >
> >>Can
> >>you just concatenate
> >>the two strings together after you get them fro
-- [EMAIL PROTECTED] wrote:
> Can
> you just concatenate
> the two strings together after you get them from the
> database? e.g.
> $parent.$name? And, just split() or explode() the
> string when you get it from the URL?
Consider the following URL's:
1. stacks/leo
2. stacks/Panthera_leo
The
I'm trying to make my first content management system
and am wrestling with a problem that seems to be about
equal parts PHP, Apache mod_rewrite and MySQL. I
wondered if anyone on this list can suggest a MySQL
solution - or partial solution.
I'm dealing with a single database table named
gzanimals
I just thought of a possible solution. Instead of
listing all the phyla, orders, classes, families,
genera and species in one big table, create separate
tables for each taxonomic level.
Each taxon would then have two parents. the genus Sus'
(pigs) parents would be both the subfamily Suinae and
fam
Suppose I want to create an animal kingdom database
that gives me the option of displaying the following
taxonomic hierarchies:
1) A bread crumbs navigation string, including ALL
taxons; e.g. Animalia (kingdom) > Chordata (phylum) >
Vertebrata (a SUBphylum) > Mammalia (class) > Eutheria
(a SUBclas
OK, I think that worked. I didn't get any error
messages at least. :)
Thanks.
--- Eugene Kosov <[EMAIL PROTECTED]> wrote:
> David Blomstrom wrote:
> > What's the easiest way to create a username and
> > password for a new database? It's been so long
> sinc
I've been experimenting with databases, both Drupal
and Plone. Plone is a can of worms, but it's
intriguing, partly because it's so different. It
sounds like they replace LAMP with something
completely different, though it's a complete mystery
to me at present.
I wondered if anyone on this list ha
What's the easiest way to create a username and
password for a new database? It's been so long since I
created my original database, I forgot how.
When I created my new database with phpMyAdmin, I
scanned the page looking for anything mentioning
username or password but I couldn't find anything. I
Wow, this is turning into quite a research project.
Thanks for the tip about ontologies; it doesn't make
much sense to me yet, but I'll take a closer look at
the article.
In the meantime, I'm thinking of using a content
management system called Plone. Unfortunately, I've so
far been unable to inst
Thanks for all the tips. That makes it much clearer. I
think I'll stick with PHP and MySQL and gradually
introduce a little XML if it fits in.
I just downloaded a content management system called
Plone, which is supposed to be a good choice for
hierarchical databases.
_
I've been gathering data for an animal kingdom
database for quite some time and am now trying to
figure out how to organize and display it. So far, I
have a table that lists every order, suborder, family,
subfamily, genus and species of mammal in a
child-parent relationship, like this:
NAME | PARE
--- Kim Briggs <[EMAIL PROTECTED]> wrote:
> David,
>
> In reading through miscellaneous database design
> text on the web, I
> read just the other day that you should not try to
> include meaningful
> data in your key values. I assume there will be
> some kind of "lookup"
> tables for species, p
I think my question is more oriented towards PHP, but
I'd like to ask it on this list, as I suspect the
solution may involve MySQL.
I'm about to start developing an enormous database
focusing on the animal kingdom and want to find a key
system more user friendly than the traditional
scientific nam
OM
> for Access database.
>
> Mikhail
>
> -Original Message-
> From: Rhino [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 30, 2005 9:10 AM
> To: David Blomstrom; mysql@lists.mysql.com
> Subject: Re: Need Help with 813-MDB File
>
>
> - Origin
e FreeWare version and then use the TOOLS
> > DAO Import Wizard.
>
> J.R.
>
> -Original Message-
> From: David Blomstrom
> [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 29, 2005 11:29 PM
> To: mysql@lists.mysql.com
> Subject: Need Help with 813-MDB File
&
I acquired a CD-ROM that lists many thousands of
animal species. The main file is a 813-MB MDB file.
I'm not sure if it's a spreadsheet or database, but
it's apparently designed to work with Microsoft
Access, which I THINK is a spreadsheet. (I don't have
it.)
I have just enough memory to open the
Please ignore this thread. I think my main problem is
I need glasses!
--- David Blomstrom <[EMAIL PROTECTED]> wrote:
> Can someone tell me what I'm doing wrong? When I
> first
> tried to create this table, I got an error message
> pointing out two fields that looked perf
Can someone tell me what I'm doing wrong? When I first
tried to create this table, I got an error message
pointing out two fields that looked perfectly fine to
me. I couldn't figure it out, so I just deleted the
fields - but it then fingered two different fields. I
deleted them, and now it says the
--- Dan Nelson <[EMAIL PROTECTED]> wrote:
> In the last episode (Mar 25), David Blomstrom said:
> > If you accidentally drop a database instead of a
> database TABLE in
> > phpMyAdmin, is there any way to recover the lost
> database, or is it
> > gone foreve
If you accidentally drop a database instead of a
database TABLE in phpMyAdmin, is there any way to
recover the lost database, or is it gone forever?
Thanks.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://ma
I can't figure out why I get an error message relating
to fiels "borderstates" and "bordernotes" when I try
to create a new table. One is VARCHAR, the other TEXT,
and both are NULL, like almost every field on the
table.
Can someone tell me what I'm doing wrong? Thanks.
SQL-query:
CREATE TABLE `
I was trying to imnport a csv file into an online
databse table, but I kept getting error messages
alluding to a "child row," foreign key, etc. So I
decided to delete both keys (primary and index), then
import the csv file.
I finally managed to delete the primary key, but I
can't zap the index. Wh
--- Brent Baisley <[EMAIL PROTECTED]> wrote:
There are advantages to one large
> table over many
> smaller tables. A large table will take advantage of
> query caching
> better (if you have query cache enabled). Lots of
> smaller table would
> probably cause the query cache to get flushed more
I discovered by accident that I can link any website
on my reseller account to one database. That would be
far more convenient than working with six separate
databases, and it would also cut down on file size
overall, since there are certain tables that I share
between websites.
But my host warned
Please ignore this thread; I suddenly stumbled over
the solution, even if I can't explain it. :)
__
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/
--
MySQL General Mailing List
For
I've spent the last few days modifying my website, and
when I published my files online, one of my tables was
knocked out of commission. It was really bizarre -
everything between the tags
disappeared online. In other words, I didn't just lose
everything related to PHP/MySQL, I couldn't even see
I apologize if this is a double post, but it appears
that my first message didn't transmit for some reason.
Anyway, I'm having a weird problem with decimals.
Imagine a field with just two numerals - 450 and 24.8.
You want to display them as 450 and 24.8, not 450.05
and 24.8 or 450 and 3.
I design
Imagine a field with just two numerals, 250 and 2.8.
How would I designate that field if I want to display
them?
First, I tried decimal 3,1. It displayed numerals like
250 perfectly, but it rounded all the decimals off,
turning 2.8 into 3.
So I converted the field to char 3 and made sure the
cell
Peter Brawley wrote,
"The earliest possible MySQL date is around 1000CE, so
you could not store geologic dates in MySQL date cols.
"Million years before present" is the geologic time
unit that would most likely cohere with other geo
databases, isn't it? Then the Cambrian would show up
around 580 m
I'm working on a geologic time database and want to
ask a question about geologic time. Can/should you
apply MySQL's date function to geologic time?
In other words, if I create a field for the number of
years ago a certain geologic period began or ended -
say 260 million years ago - could I design
Oops, I guess I added wrong.
Nevertheless, unrestricted linking to database tables
with no keys would increase loading time, right? Is
there some way to gauge the effect, other than
tweaking all my scripts and tables and checking the
load time again?
Thanks.
--- Jay Blanchard
<[EMAIL PROTECTED]>
Someone sent me the following comments on one of my
webpages:
Global Statistics
Total HTTP Requests: 51
Total Size: 133537 bytes
Object Size Totals
Object type Size (bytes)
HTML: 26538
Images: 69020
Javascript: 12863
CSS: 25116
Multimedia: 0
O
I used to use Navicat to import CSV files into MySQL.
Now I find that I can use either Navicat or the latest
phpMyAdmin upgrade, and one or the other usually
works, even when I'm battling collation errors.
But I'm stumped on a relatively large but simple
table. I wondered if I might make it work i
--- Andy Bakun <[EMAIL PROTECTED]> wrote:
> On Sat, 2005-02-19 at 23:55, David Blomstrom wrote:
>
> > > Why not set columns to NOT NULL and default to
> space
> > > for character and 0
> > > for numeric?
> >
> > OK, you're suggesting
--- Alex S Moore <[EMAIL PROTECTED]> wrote:
> David Blomstrom wrote:
>
> > So I THINK I may have a good idea for a
> workaround. I
> > simply change all my fields to NOT NULL, then fill
> > every cell that would ordinarily be NULL with a
> unique
> > c
I'm having a terrible time with MySQL's new collation
feature. It frequently fills cells that should be NULL
with 0's and pushes data from one column to another. I
can usually import csv files into my tables using
either Navicat or phpMyAdmin, but I have to experiment
with a lot of settings, and so
I just installed a new software package that included
a MySQL upgrade. Everything was working fine until I
tried to import one of my tables to my online database
and got this error:
#1064 - You have an error in your SQL syntax. Check
the manual that corresponds to your MySQL server
version for th
--- Osvaldo Sommer <[EMAIL PROTECTED]> wrote:
> David:
>
> If you have windows XP go:
> Start/Control Panel in ther choose "Administrative
> Tools" and in there
> is "Data Sources (ODBC)" where you can define your
> dsn.
I can't see Administrative Tools anywhere in my
Control Panel, but I now ha
--- Andrew Pattison <[EMAIL PROTECTED]> wrote:
> < rewarded with
> something similar to what I got before.>>
>
> Not sure what you are looking for then. The myODBC
> driver should not need configuring, beyond setting
> up data sources, which is exactly what the control
> panel applet does for y
--- Andrew Pattison <[EMAIL PROTECTED]> wrote:
> The ODBC control applet in Windows can be found in
> two places:
>
> 1. Control Panel.
> 2. Administrative Tools (if you are using Windows
> 2000 or XP).
>
> If you have Windows 2000 or XP, the easiest way to
> find it is to find
> your "Administ
u, so it's probably there somewhere,
> but if you want a
> desktop icon for ODBC Administrator, right click on
> it in Windows
> Explorer and select 'Create a Shortcut'.
>
> PB
>
>
> David Blomstrom wrote:
>
> >--- Neculai Macarie <[EMAIL
--- Neculai Macarie <[EMAIL PROTECTED]> wrote:
> > I just installed MySQL's ODBC program, but I can't
> > figure out how to launch it. I see no reference to
> > ODBC when I go to Start > Programs. The only thing
> > resembling an executable icon I can find is in my
> > Add/Remove programs directo
I just installed MySQL's ODBC program, but I can't
figure out how to launch it. I see no reference to
ODBC when I go to Start > Programs. The only thing
resembling an executable icon I can find is in my
Add/Remove programs directory. I did a Windows search
and found many files named ODBC, most of t
Aha - that's why I like to ask questions on newsgroups
rather than get secondhand news from Google! :)
This sounds really cool. One question, though...when
you talk about downloading the "source code," are you
saying your program is for Linux only? As much as I
hate Microsoft, I'm still stuck with
I want to import some data into my database, but it's
in an ArcView Shapefile, which I've never worked with.
Does anyone know what kind of software I can use to
access this data? Actually, I'd probably import it
into a spreadsheeet first, then save it as a csv file
and import it into my database.
I already have a series of tables defining the world's
continents, oceans, nations, states, etc. Actually,
it's just two tables. Type defines the kinds of
divisions, like this:
TABLE: TYPE
(ID) (Type)
pla | planet
kon | continent
oce | ocean
nat | nation
sta | state
pro | province
Table famarea l
If I revise a MySQL table and try to publish it
online, I often get the error message, "Table my_table
already exists." So I have to delete the online
version before I can import the revised version.
Is there a way to just publish one table over another,
as long as both have the same name?
Thanks
--- Tom Crimmins <[EMAIL PROTECTED]> wrote:
> It's all there in the manual.
I like your explanation a lot better; it works, too!
:)
Thanks.
__
Do you Yahoo!?
All your favorites on one personal page Try My Yahoo!
http://my.yahoo.com
--
M
Wow, I don't remember dealing with all that code the
first time around. Can someone show me EXACTLY what I
would write if my database is named my_database, and I
want to add the username private_host and the password
superstar? And if I don't have mysqladmin, can I type
it into the SQL Query window
I just recreated a database after my computer crashed.
All my MyISAM tables survived, but my InnoDB tables
vanished. The other problem is that I need to reassign
a username and password, and I can't remember how I
did that originally.
I now have the latest version of phpMyAdmin, but I
can't find a
o
> not have an
> archived backup you will more than likely have to
> recreate the table
> structures.
>
>
> David Blomstrom wrote:
>
> >Yikes...I've been replying to myself! I forgot that
> >when I reply to messages from the MySQL newsgroup
> on
> >
Yikes...I've been replying to myself! I forgot that
when I reply to messages from the MySQL newsgroup on
this e-mail account, it doesn't include
mysql@lists.mysql.com, for some odd reason.
At any rate, I wanted to say that I have just ONE file
type left - FRM. My MYD and MYI files have both
vanish
I've been using a preconfigured package (Apache, PHP,
MySQL) from Apache Friends/XAMPP for several months.
About a week ago, my computer crashed, and I'm now
getting back on my feet. I downloaded the latest
XAMPP, which features upgrades for PHP, phpMyAdmin and
I think MySQL, too.
Everything seems
I did a lot of homework on IF statements recently.
Below are copies of some of the scripts I'm using now.
This first example draws on a database filled with the
names of the world's continents, oceans, nations and
states, each given an ID in a field named IDArea. Each
page on my site has an echo s
Thanks - that works great!
--- Jay Blanchard
<[EMAIL PROTECTED]> wrote:
> [snip]
>
> Cal_ID | Cal_Date | Cal_Event
> 1 | 1972-01-01 | A new species of whale was
> discovered.
> 7 | 1898-01-07 | The dodo was declared extinct.
> 8 | 1972-01-08 | The first Earth Day was observed.
>
> Then I used t
I think mine is a fairly simple question. In fact, I
think my script may just need a simple tweak. It's
also possible that my problem relates to displaying
the data with PHP, but I want to make sure I've got my
MySQL table set up correctly.
Anyway, I've collected historic events for every day
of t
> > -Ursprüngliche Nachricht-
> > Von: mail.pmpa [mailto:[EMAIL PROTECTED]
> > Gesendet: Freitag, 31. Dezember 2004 03:27
> > An: mysql@lists.mysql.com
> > Betreff: RE: [PHP] How to argue with ASP people...
> >
> > Don't mean to start a discussion whatsoever, I
> love php, but
> > one th
ould be able to
> read their docs, understand their commands and
> translate this script into
> something MySQL-compatible.
>
> Here are my best guesses (not being 100% certain
> precisely which DB system
> it's written for)
>
> David Blomstrom <[EMAIL
I have some questions about some instructions for
recreating tables I'm trying to follow:
1. This first table is the simplest. The only thing I
don't understand is "serial." I created char and date
columns easily enough, but I don't see "serial" listed
in phpMyAdmin.
create table "itis".kingdoms
I downloaded a TAR file from a link I found at
http://www.itis.usda.gov/ftp_download.html
The page also includes the following instructions:
* The schema file (itis.sql) is an ASCII file that
includes all of the create table statements plus
additional information. This will allow comparison to
t
I was having trouble importing a particular csv file
into a MYSQL table, so I designated most of the fields
VARCHAR. Now that all my data is finally in the table,
I'm weeding out various mistakes and redesignating the
fields. But I'm hung up on a numerical field which
features 1) some numerals that
Please disregard my last post. I found another
workaround - I saved the database table on my computer
in an unzipped format, and I was able to export it to
my website.
It looks good!
http://www.geoworld.org/north_america/usa/az/counties/index.php
Thanks.
___
--- [EMAIL PROTECTED] wrote:
> hi,
>
> in the script you have
> " CONSTRAINT `0_132` FOREIGN KEY ( `SCode` )
> REFERENCES
> `statesarticles` ( `SCode` ) ON UPDATE CASCADE "
> and this code it's a definition of the foreign key.
> run the script without this part of the code.
* * * * * * * * * *
When I was first learning to work with MySQL, I
discovered that I couldn't publish my databases to the
Internet if they had foreign keys. So I stripped out
all the foreign keys and got them online.
I'm not trying to publish a table I haven't worked
with in a while, but I just get error messages. T
--- Ligaya Turmelle <[EMAIL PROTECTED]> wrote:
> Think I found it. I made the changes with
> explanations of what I did.
> If you have any further questions feel free to ask.
> Oh and this should
> be on the list for others to see and maybe learn
> from
Wow, thanks so much for going to all th
This may be a purely PHP problem, but the error
message says "SQL syntax. Check the manual that
corresponds to your MySQL server version..."
More important, I haven't been able to find a solution
on any PHP forums. :)
This is the complete error message:
Failed to run SELECT F.IDArea, C.IDArea, C
up in the terminology he uses but
> pay close attention to
> how he organizes his sample data.
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
> David Blomstrom <[EMAIL PROTECTED]> wrote on
> 11/08/2004 09:30:41
> PM:
>
>
minology he uses but
> pay close attention to
> how he organizes his sample data.
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
> David Blomstrom <[EMAIL PROTECTED]> wrote on
> 11/08/2004 09:30:41
> PM:
>
> > I have a se
I have a series of database tables focusing on the
world's nations. There are basic tables that give each
nation's abbreviation and parent (e.g. Eurasia) and
other tables that focus on information about the
people, government, etc.
Now I want to introduce some regional headers. For
example, curren
I'm working on several websites that will be driven
primarily by two databases - Geography and Animals.
The Geography database will feature information about
nations, provinces and states, such as capitals,
population, etc. The Animals database features lots of
taxonomic tables (orders, families, s
--- Robb Kerr <[EMAIL PROTECTED]> wrote:
> I'm trying to inform myself about exactly what
> Dreamweaver's PHP/MySQL code
> is doing when creating a recordset and repeat
> region. Please help if you
> can.
>
> DW MX generates the following to create a simple
> recordset...
> Line 1) require_once(
1 - 100 of 213 matches
Mail list logo
