Hi !!
uhh, this sounds really stupid to be honest :-)
My first thought is, If they are so deep in MS junk
why should they port to PHP/MySQL in the first place ??
I think it's definitely easier to give then a quick-course
in PHP than writing these kind of workarounds...
You could maybe write another interface in PHP so
Your customers can easily edit queries without having
MS Access involved. One possibility is to have all queries
in an include file which can be easily maintained by using
a texteditor or via webinterface.
I haven't test PHP capabilities of #define stuff but
it should work, I think... like this.
// queries.inc
define("SQL_GETDATA", "SELECT col1,col2 FROM table1 WHERE id=%d");
// in php file itself
$sql = sprintf(SQL_GETDATA, $the_id);
mysql_query($sql);
I haven't prove this by myself though...
=d0Mi=
> well yeah, but the people who are going to be using the databse don;t know
> PHP and they want to edit the queries in Access, but still be able to access
> it online, and if they change the queries in Acces, then it won't be changed
> on the webpage (don't ask my why they want this, i'm just doing a job for
> them).
> So instead of tying all the queries for a reoprt over in php, can i make a
> query to access a query which is stored within MS Access?
> and if so where are the queries in Access stored
>
> thanks
>
>> Hey guys,
>> i'm still doing this web ODBC thing, and i was wondering since,
>> all the wqueries i'm going to use are in a database, is there
>> a way (using php/mysql/odbc) to access and call on those queries
>> without typing them over in my php script?
>> So basically i just want to connect to queries.mdb access the
>> queries in that database, and use them to pull
>> the data out of data/mdb..
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
