SQL newbie

[Jacob Stetser]

Hi http://www.aota.net/ubb/smile.gif

I just joined the ranks of SQL users and got a gold account on FQ. I have a couple o' questions..

#1... I only have one database (xicongarden). Do I put all my tables from all the different things I use in the same database? Are there ever conflicts? How do I resolve this?

#2... I think MySQL is choking on the ' mark. I just installed a program that keeps saying: '1064: You have an error in your SQL syntax near 'm getting SERIOUSLY pissed off at these multibillion-dollar companies that treat' at line 1 '... how do I fix that?

Jake

[stan]

(1) You will run into problems if you want different people accessing the database directly to have diferent privileges.

If you yourself (and your CGI/PHP/Perl scripts) are the only ones accessing the database, there's no problem.

I have a database with 2 tables. One, I can only change, the second, people can change their own record. They can only change it through a web pages (a PHP script) that checks their credentials.

Having all tables of different applications in one database is (besides the priviliges problem) just a bit messy, not a real problem

(2) If it's PHP or Perl I might be able to help. Do you have more information on this program?

Stan


------------------
Stan P. van de Burgt stan@dmo.com (PGP 0x853296C5)
DMO, P.O. box 1248, 3500 BE, Utrecht, the Netherlands



[This message has been edited by stan (edited 03-28-99).]