Editor to create table from MySQL

[Shane McBride]

Does anyone know of a Windows editor I can use to design a table from
a MySQL database?

I have a end-user catalog I need to create. Nothing fancy - just
display a few fields. I could hand code it, but do not have the time
to relearn all the sql. No shopping-cart or anthing, just display
fields.

[furry]

http://www.mysqlfront.de/ would be my recommendation


"Shane McBride" <sh***@rditech.net> wrote in message
news:29**************************@posting.google.c om...
Does anyone know of a Windows editor I can use to design a table from
a MySQL database?

I have a end-user catalog I need to create. Nothing fancy - just
display a few fields. I could hand code it, but do not have the time
to relearn all the sql. No shopping-cart or anthing, just display
fields.

[Geoff Berrow]

I noticed that Message-ID:
<29**************************@posting.google.com > from Shane McBride
contained the following:

I have a end-user catalog I need to create. Nothing fancy - just
display a few fields. I could hand code it, but do not have the time
to relearn all the sql.

/all/ the sql?

SELECT field1,field2,...fieldn FROM table;

Was there anything else?

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Shane McBride]

I knew someone would get me for being lazy.....lol

The sql queries are not that hard. The part that always gets me is when I
have to populate a table with the results. So the size of the table has to
dynamic etc...I can do it, but for what is is worth I would like to have a
GUI to do it for me.....lazy, I know....

--
Shane McBride
President
RDI Technologies
www.rditech.net
"Geoff Berrow" <bl******@ckdog.co.uk> wrote in message
news:ko********************************@4ax.com...

I noticed that Message-ID:
<29**************************@posting.google.com > from Shane McBride
contained the following:

I have a end-user catalog I need to create. Nothing fancy - just
display a few fields. I could hand code it, but do not have the time
to relearn all the sql.

/all/ the sql?

SELECT field1,field2,...fieldn FROM table;

Was there anything else?

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Shane McBride]

I should have said "HTML table", not sql table.

--
Shane McBride
President
RDI Technologies
www.rditech.net
"furry" <cb****@iol.ie> wrote in message
news:c0**********@kermit.esat.net...

http://www.mysqlfront.de/ would be my recommendation


"Shane McBride" <sh***@rditech.net> wrote in message
news:29**************************@posting.google.c om...
Does anyone know of a Windows editor I can use to design a table from
a MySQL database?

I have a end-user catalog I need to create. Nothing fancy - just
display a few fields. I could hand code it, but do not have the time
to relearn all the sql. No shopping-cart or anthing, just display
fields.

[Geoff Berrow]

I noticed that Message-ID: <Of********************@comcast.com> from
Shane McBride contained the following:

I knew someone would get me for being lazy.....lol

The sql queries are not that hard. The part that always gets me is when I
have to populate a table with the results. So the size of the table has to
dynamic etc...I can do it, but for what is is worth I would like to have a
GUI to do it for me.....lazy, I know....

Well once you've done the query, you just expand something like this to
fit (untested)

<table>
<tr>
<td>field1</td>
<td>field2</td>
<td>fieldn</td>
</tr>
<?php
while ($myrow = mysql_fetch_array($result)) {
printf(
"<tr><td>%s</td><td>%s</td><td>%s</td></tr>",$myrow["field1"],$myrow["field2"],$myrow["fieldn"]);
}
?>
</table>

--
Geoff Berrow (put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/