Editor to create table from MySQL

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.

re: Editor to create table from MySQL

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




"Shane McBride" <shane@rditech.net> wrote in message
news:2952965f.0402090719.3fd56749@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.

re: Editor to create table from MySQL

I noticed that Message-ID:
<2952965f.0402090719.3fd56749@posting.google.com > from Shane McBride
contained the following:
[color=blue]
>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.[/color]

/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/

re: Editor to create table from MySQL

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" <blthecat@ckdog.co.uk> wrote in message
news:koif205mejk295pracds4klksghurkgv5o@4ax.com...[color=blue]
> I noticed that Message-ID:
> <2952965f.0402090719.3fd56749@posting.google.com > from Shane McBride
> contained the following:
>[color=green]
> >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.[/color]
>
> /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/[/color]

re: Editor to create table from MySQL

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

--
Shane McBride
President
RDI Technologies
www.rditech.net
"furry" <cbtsys@iol.ie> wrote in message
news:c08d7o$502$1@kermit.esat.net...[color=blue]
> http://www.mysqlfront.de/ would be my recommendation
>
>
>
>
> "Shane McBride" <shane@rditech.net> wrote in message
> news:2952965f.0402090719.3fd56749@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.
>
>[/color]

re: Editor to create table from MySQL

I noticed that Message-ID: <Of2dnVprK-z1abrdRVn-hQ@comcast.com> from
Shane McBride contained the following:
[color=blue]
>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....[/color]

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/