Re: db questions and newbie
| From: | namaide tajeryno | Date: | Sat, 24 Aug 2002 11:10:05 +0000 |
| Subject: | Re: db questions and newbie | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-21338@lists.php.net to get a copy of this message | ||
----- Original Message -----
From: Matt Zur <mattz@zurnet.com>
Date: Sat, 24 Aug 2002 02:50:08 -0400
To: php-db@lists.php.net
Subject: [PHP-DB] db questions and newbie...
> I have lots of questions and am new to the list
me too =D
> In PHP and MySQL... can you import and
> export to flat files?
yes you can. you want 'select...into outfile' for exporting
(http://www.mysql.com/doc/en/SELECT.html) and 'load data infile'
(http://www.mysql.com/doc/en/LOAD_DATA.html) for importing. (please
notice, searching 'import file' and 'export file' in the mysql
docs--http://www.mysql.com/doc/en/index.html--brought
up both results
within easy reach.)
> And then import
> those record by being able to set a filter to sort all people from
NY or
> all people that are 25 years old.
'order by,' part of the 'select' command
> Also, I've been trying to playing around with PHP and MySQL. I
haven't
> found a great tutorial. Anyone know of a good link?
i'm rather a fan of harald's online library. he has dl-able copies of
zillions of programming books and references, including 'php and
mysql web development', where i got my feet wet with php and mysql,
and 'a programmer's introduction to php 4.0,' my first php book.
(keep in mind, you can only access the site between 8pm and 8am cet
unless you pay.) webmonkey's php/mysql tutorial
(http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html)
is a good start. there's a list of mysql related functions at
http://www.php.net/manual/en/ref.mysql.php,
and check the links page
at php.net as well.
good luck!
namaide
monjoy
--
_______________________________________________
Get your free email from http://www.graffiti.net
Powered by Outblaze