Page 1 of 1

Different Databases?

Posted: Fri Jun 06, 2003 1:17 am
by Mr. Tech
Hi!

Does all databases do the same thing when it somes to insertinf, showing etc. info from the database? For example, does all databases use this to select data:

Code: Select all

select this from that where this='$this' order by this
Thanks

Posted: Fri Jun 06, 2003 1:27 am
by delorian
Yes all, databases usign SQL to query the data. But some instuctions may be a BIT different in every RDBMS, so you always must check the documenation.

Posted: Fri Jun 06, 2003 1:58 am
by Mr. Tech
delorian wrote:Yes all, databases usign SQL to query the data. But some instuctions may be a BIT different in every RDBMS, so you always must check the documenation.
Thanks!

RDBMS? Whats that mean? Does all databases us SQL to query the data?

Thanks

Posted: Fri Jun 06, 2003 2:19 am
by delorian
Relationship Data Base Managment System or something like this.

No, not every database systems use SQL.

Posted: Fri Jun 06, 2003 2:21 am
by Mr. Tech
Thanks

So if I wanted to write a script that allows you to use different kinds of database, how would be the best way to do this?

Thanks again!

Posted: Fri Jun 06, 2003 2:50 am
by delorian
There isn't the best way. I can give you a piece of advice. Read the manual first (hint: search for ODBC php functions). Second, think about the script (input, output). Then write the mind map for the problem http://www.mind-mapping.com , think about it, write the script and test it. That's always work. :D

Posted: Fri Jun 06, 2003 5:39 am
by Mr. Tech
thx