Re: [PHP-DB] Connecting to MS Access DB in PHP, on Linux, Apache

2005-05-14 Thread Luis Morales
Sure!!! Take a look on: http://www.weberdev.com http://odbtp.sourceforge.net/ My personal suggest is to use odbtp whith pear DB interface. Regards, Luis Morales rob wrote: > Anyone got any good websites or resources on how to connect to an > access database and perform sql querrys etc, i

[PHP-DB] Connecting to MS Access DB in PHP, on Linux, Apache

2005-05-14 Thread rob
Anyone got any good websites or resources on how to connect to an access database and perform sql querrys etc, in Linux running apache? or if anyone has the connection strings required thanks in advance !! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.ne

RE: [PHP-DB] Error: "Resource id #3"

2005-05-14 Thread Marc Henri
Hello, Thank you very much to Bastien Koert and Firan Corneliu. You both solved my problem. Shame on me! _ Découvrez le nouveau Yahoo! Mail : 1 Go d'espace de stockage pour vos mails

RE: [PHP-DB] Error: "Resource id #3"

2005-05-14 Thread Bastien Koert
Actually, that is exactly what you are doing. $result is the handle to the dataset, not the dataset itself. Try this: //log to the server $db=mysql_connect("localhost","root",""); if ($db) { //test if the connexion works $sel=mysql_select_db("test"); if ($sel) { $sql_query="SELEC

Re: [PHP-DB] Error: "Resource id #3"

2005-05-14 Thread Firan Corneliu
The message that you receive is not an error, it is a description of the object $result after the query is done. So, you will not get anywhere just by echo $result, you have to process that information using one of the mysql_fetch_array(),mysql_fetch_assoc(), mysql_result(). In your case try :

[PHP-DB] Error: "Resource id #3"

2005-05-14 Thread Marc Henri
Hello, I'm starting to learn how to manage databases with MySQL/PHP. The program is very basic but I have a strange error: "Resource id #3". I read many things on Internet and understood that others have this error because they are trying to echo the pointer of the query and not the result itself.

Re: [PHP-DB] novice on table design

2005-05-14 Thread tony yau
Hi Tony, Miguel yes that was my intention at first, but to absorb all three, Shop, Employee, and Customer (and there may be 2 more to come) into an Address table would be inefficient both in storage space and search time,..no? having this compound keys at a separate Address table is essential