470,815 Members | 1,231 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,815 developers. It's quick & easy.

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.
Jul 17 '05 #1
5 2103
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.
Jul 17 '05 #2
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/
Jul 17 '05 #3
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/

Jul 17 '05 #4
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.

Jul 17 '05 #5
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/
Jul 17 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by monika | last post: by
71 posts views Thread by tomy_baseo | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.