Question on recordset

Need a general overview

[n0xious]

Hi, I'm new to the scene so go easy on me!

Anyways, unfortunately my webhost does not allow me to connect to my database from within Dreamweaver (or any remote source for that matter). This causes a problem because I'm used to being pampered by Dreamweaver's user-friendly interface.

If someone could please explain the recordset MySQL command to me and how it works that would be great.

[ergophobe]

Welcome to WebmasterWorld n0xious.

The MySQL recordset command? Never heard of it so I did a search on mysql.com but didn't find any mention of such a command. I did turn up some "recordset" PHP classes.

There is a recordset "command" (I think it's a property actually) in Visual Basic for Applications for use with MS Access and probably DAO in general. I forget the details since it's been years since I did anything with that stuff (and never did that much).

Are you sure you aren't referring to some built-in function in Dreamweaver (I don't know Dreamweaver).

In any case, perhaps it would be better if you describe what your are trying to achieve and then we can take it from there.

[n0xious]

I'm not sure really how to explain this. What I am trying to do is get the MySQL coding for what Dreamweaver does in its Recordset option, since I cannot use Dreamweaver to accomplish this task with my web host. I am simply trying to find out what the coding is in the background.

If I'm not mistaken (I'm still learning MySQL and PHP) the Recordset appears as a rs attached to MySQL coding.

Here is a link to how you accomplish the Recordset task in Dreamweaver. tutorial [macromedia.com]

I know this is probably really vague. My ultimate goal is to create a web log, and all has gone well except for this huge road block my web provider has set in front of me.

Thanks!

[edited by: ergophobe at 7:05 pm (utc) on Feb. 28, 2005]
[edit reason] cleaned up - images not enabled on this forum software [/edit]

[n0xious]

I may also be able to accomplish this through phpMyAdmin, but I don't fully understand that either.

[ergophobe]

It is normal, if not universal, for hosting services on shared hosts to disallow connections of the sort you mention to the DB server.

I think the thing you really need to do it simply set up a test bed server on your desktop and develop there. Then you can use whatever tools you want and just upload the script when it's done.

Not to divert the question, but do you mean that you want to have a blog or do you mean that you want to create the underlying software? If all you want is a blog there are hundreds of perfectly functional scripts you can take off the shelf for free and just upload and install.

I know this has nothing to do with your question, but I'm just trying to figure out first what your exact final goal is. Then we can talk about the means to get there and the tools you need.