A problem to grab data through JDBC and PHP

------=_Part_19732_30823302.1205476394486
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Dear Everyone,

I am using JDBC to connect from WinXP system to LinUX with MySQL database.
We use PHP webpage to locate the time and date of the data we want. And then
grab the data through a MatLab program.

Now there is a problem, no matter what time we specific through the PHP, the
data I got from the program are always the same ,which should be different
at any time.

So, could you please help me find what's the problem? what is the possible
reasons? how to solve this problem?

Thanks a lot!!!

Best,
Shutao

On 3/9/08, Daniel Kasak wrote:
>
> On Fri, 2008-03-07 at 08:01 -0600, Kenn Murrah wrote:
>
> > I'm trying to use Excel to see mysql databases on my Linux server.
>
> Hmmmmmm ... Excel isn't exactly the best tool for the job ( take our
> current example ). Are you planning on using Excel to manipulate the
> data, or are you just using 'whatever is available' to view data?
>
> > I've created an account in mysql, I've installed the odbc driver, I've
> created a
> > new datasource on my Windows box, and now I can access one of the tables
> in
> > my database, but on all the others, I get an error: "You have an error
> in
> > your SQL syntax. Check the manual that corresponds to your MySQL server
> > version for the right syntax to sue near 'paymentech'.'contacts' LIMIT
> 0' at
> > line 1" .... but not the others ... what have I done wrong?
>
> You didn't really describe how you got to this point. Do you have the
> entire SQL that Excel is sending? Are you using Excel's 'query builder'?
>
> > so if it works on one table, why doesn't it work on the other tables in
> the
> > same database? What have I done wrong?
>
> It's not a permission problem. It's an SQL problem, as the error above
> indicates.
>
> Personally I avoid Excel like the plague. If you just want to see / edit
> data, try MySQL's query browser & administrator products. What are you
> trying to do with your data?
>
> --
> Daniel Kasak
> IT Developer
> NUS Consulting Group
> Level 5, 77 Pacific Highway
> North Sydney, NSW, Australia 2060
> T: (+61) 2 9922-7676 / F: (+61) 2
> 9922 7989
> email: dkasak@nusconsulting.com.au
> website:
> http://www.nusconsulting.com.au
>
>
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:
> http://lists.mysql.com/myodbc?unsub=shutao.xing@aggiemail.us u.edu
>
>


--
Best Regards,
Shutao XING

------=_Part_19732_30823302.1205476394486--