Jo wrote:If you played with Access, I suppose you at least know some bits of SQL.> Hello
> I am a web designer who is slowly trying to learn more about web
> development. I have a client who would like to drive their website
> using a database so I am now in the perfect situation to move my
> skills forward.
> I know a little about databases or the scripting languages that
> connect them to web pages (is that the right terminology?!) but I am
> determined to improve my skills in this area.
> However, I have a few constraints:
> The little that I know about databases is centered around Access so I
> would prefer to use that if I can. I have played with MySQL but seeing
> as I am a novice, I find it a little tricky to work with.
If not, nothing prevent you from looking at the SQL code outputed py the
QBE. Even if it may have some pitfalls, SQL is quite straightforward for
MySQL is pretty simple to use, is a real database server, and is quite
fast for read access (no pun). No mystery why it's the de facto standard
for web development.
No, you may use Java, Python, Perl etc... And probably even ASP (yuck),> Also, all my clients use unix servers so, after a little research, I
> have come to the conclusion that PHP is my only option - is this the
> correct assumption?
but in your case, PHP is probably (with a very high probability) the
BTW, if your clients use unix servers, definitively forget about Access,
<troll>and step into the real OS world</troll>.
Seriously, why would you get stuck with a stupid proprietary
non-standard indexed-file-based so called DBMS, when you can get a good
fast standard SQL server ?-)
I guess you could, but why would you ? I strongly advise you not to do> So, my main question is: can I use Access and PHP together?
this. Take some time to install and learn MySQL, and go for it.
There are PHP/Apache/MySQL packages that are easy to install, like
EasyPhp (someone else might tell you more about this...).