RE: [PHP] mysql newbie
| From: | John Corry | Date: | Sun, 27 Aug 2000 01:29:34 +0000 |
| Subject: | RE: [PHP] mysql newbie | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-13821@lists.php.net to get a copy of this message | ||
>>From: Justin French [mailto:justin@indent.com.au]
>
>hi,
>
>i'm running a local freeBSD box with apache, mysql, php3, blah blah.
>
>can any one point me to some simple documentation for doing the
>following FROM WITHINA PHP3 script
>
> - creating a new table in a db
do that with this function:
http://www.php.net/manual/function.mysql-query.php
> - showing a list of all tables in a given db
...and that's done with this one:
http://www.php.net/manual/function.mysql-list-tables.php
> - adding new data into tables
you do that with this one too:
http://www.php.net/manual/function.mysql-query.php
> - deleting data into tables
you mean deleting from tables?
I guess you'd use a mysql_query() and give it DELETE FROM tbl_name...
> - searching tables
> - querying the tables.
That again is mysql_query, you might want to look over a good SQL reference
I'm a newbie too and with these references and a little imagination about
how to approcah stuff...I'm getting it!
hope this helps,
John Corry
Neon Cowboy Design
www.neoncowboy.com
email: webshot@neoncowboy.com
phone: 808.572.8494
mobile: 808.283.7063
PMB 224 120 Hana Hwy. #9
Paia, Hawaii 96779