HostGator Hosting
 
Home Register FAQ Members List Calendar Search Today's Posts Mark Forums Read Web Directory

Go Back   Webmaster Forum > Designing and Developing Websites > Programming > PHP / MySQL

PHP / MySQL Discussions and help on PHP and MySQL.

Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 01-08-2008, 04:58 AM
alexd181 alexd181 is offline
WMG Resident Alien
 
Join Date: Jan 2008
Posts: 104
iTrader: (0)
alexd181 is on a distinguished road
Default Dreamweaver mySQL editor?

Hi,

I use the Dreamweaver mySQL module to get data but is there any way to use it to create tables, delete fields etc?

Which software do you use to do this? I've been using phpmyadmin but I wish there was an inbuilt option in DW so I didn't have to switch back and forth.
Reply With Quote
Sponsored Links
Register and sign in to hide this ad block

  #2 (permalink)  
Old 01-09-2008, 07:13 AM
c4cyber's Avatar
c4cyber c4cyber is offline
WMG Resident Alien
 
Join Date: Nov 2007
Location: asia
Posts: 243
iTrader: (0)
c4cyber is on a distinguished road
Default

If you carefully design the database, you may not have to switch back and forth. I would recommend you to have your database developed at first and than you can do the programming phase.
Module you are talking about may have these(create , delete etc) functionalities in near future.
__________________
Reply With Quote
  #3 (permalink)  
Old 01-09-2008, 07:48 AM
alexd181 alexd181 is offline
WMG Resident Alien
 
Join Date: Jan 2008
Posts: 104
iTrader: (0)
alexd181 is on a distinguished road
Default

Thanks.

Yeah I keep trying to do it that way but end up forgetting a field or think 'that feature would be nice' and add it, then get back to coding and think of something else. : S
Reply With Quote
  #4 (permalink)  
Old 01-09-2008, 04:15 PM
chrishirst's Avatar
chrishirst chrishirst is offline
WMG Sheriff
 
Join Date: Nov 2007
Posts: 170
iTrader: (0)
chrishirst is on a distinguished road
Default

Absolutely the WORST way to design data structures.

You will end up with data duplication, inefficient relationships, inefficient indexes etc etc
__________________
And how can we win, when fools can be kings
Reply With Quote
  #5 (permalink)  
Old 01-09-2008, 04:20 PM
alexd181 alexd181 is offline
WMG Resident Alien
 
Join Date: Jan 2008
Posts: 104
iTrader: (0)
alexd181 is on a distinguished road
Default

Quote:
Originally Posted by chrishirst;7***
Absolutely the WORST way to design data structures.

You will end up with data duplication, inefficient relationships, inefficient indexes etc etc
What is? Dreamweaver? Or revising your mySQL tables?
Reply With Quote
  #6 (permalink)  
Old 01-09-2008, 05:36 PM
chrishirst's Avatar
chrishirst chrishirst is offline
WMG Sheriff
 
Join Date: Nov 2007
Posts: 170
iTrader: (0)
chrishirst is on a distinguished road
Default

Quote:
What is?
Designing data structures "on the fly". it's the same with programming.

Every programmer thinks they can write a whole application from the keyboard and 99.9% of them can't.
If you do not start with a reasonably well formulated plan, the end result will be something like early versions of oSCommerce!
A mish mash of bits and pieces, loosely cobbled together with hacks and kludges.

When you come across a "feature" that "would be nice", add it to a "todo" list and build it in later as a "plugin" or "module".

And Dreamweaver cannot design databases.
__________________
And how can we win, when fools can be kings
Reply With Quote
  #7 (permalink)  
Old 01-11-2008, 02:10 AM
creek23 creek23 is offline
WMG Deputy Sheriff
 
Join Date: Mar 2007
Posts: 290
iTrader: (0)
creek23 is on a distinguished road
Default

I use SQLyog for 4 years now. Dreamweaver works better in what it was known to be good at -- WYSIWYG HTML editing.
Reply With Quote
  #8 (permalink)  
Old 01-11-2008, 02:24 AM
alexd181 alexd181 is offline
WMG Resident Alien
 
Join Date: Jan 2008
Posts: 104
iTrader: (0)
alexd181 is on a distinguished road
Default

creek23, how does that software work? Is it free to use? If you could tell us a bit about it then that would be great.

Thanks.
Reply With Quote
  #9 (permalink)  
Old 01-11-2008, 05:36 AM
creek23 creek23 is offline
WMG Deputy Sheriff
 
Join Date: Mar 2007
Posts: 290
iTrader: (0)
creek23 is on a distinguished road
Default

it is free (as in free speech not free beer) and open source MySQL GUI. visit webyog and get your (redistributable) copy.
Reply With Quote
  #10 (permalink)  
Old 01-11-2008, 08:39 AM
alexd181 alexd181 is offline
WMG Resident Alien
 
Join Date: Jan 2008
Posts: 104
iTrader: (0)
alexd181 is on a distinguished road
Default

Thanks for that it looks like an awesome piece of software. I'll take a closer look later on this week.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 08:11 PM.



Freelance Web Designers
Work At Home Forum
Ad Marketplace
Online Deals and Bargains
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.0.0