Connect directly to mysql db
Posted: Tue Mar 22, 2011 2:02 pm
Hi everyone
,
Im having issues connecting to a mysql db I have created in Toad.
Im working directly from a server and am connecting directly to a database (swdata) using the function 'database_connect'.
I can connect to the database with this function but when I attempt to execute a query it fails.
Does anyone have a general script I can use to connect and execute a query in this way?
Its not just as simple as a mysql_query() function because I have tried this numerous times and it doesnt work.
Sorry if Im being stupid and perhaps a bit vague but Im going insane because it is probably so simple.
Any help would be very much appreciated.
Thanks,
tdsrogers
Im having issues connecting to a mysql db I have created in Toad.
Im working directly from a server and am connecting directly to a database (swdata) using the function 'database_connect'.
I can connect to the database with this function but when I attempt to execute a query it fails.
Does anyone have a general script I can use to connect and execute a query in this way?
Its not just as simple as a mysql_query() function because I have tried this numerous times and it doesnt work.
Sorry if Im being stupid and perhaps a bit vague but Im going insane because it is probably so simple.
Any help would be very much appreciated.
Thanks,
tdsrogers