Jump to content


Photo

delete records form


  • Please log in to reply
8 replies to this topic

#1 shaunmckinnon

shaunmckinnon
  • Members
  • PipPipPip
  • Advanced Member
  • 30 posts

Posted 11 January 2004 - 02:08 AM

Okay, Dreamweaver has an insert records form, an update records form, but no delete records form...i need this...can i modify the insert records form to do this? and if so, how?

Thanks in advance,
Shaun McKinnon

#2 shocker-z

shocker-z
  • Members
  • PipPipPip
  • Advanced Member
  • 864 posts
  • LocationNottingham

Posted 11 January 2004 - 04:25 PM

Hey yes i no what you mean, i never played with dreamweavers MYSQL functions and that until i had learnt php/mysql its a good way to go about leaning webdesign leanr the code before using programs that do all the coding for you

$sql = "DELETE FROM table WHERE field='somevalue'";
  $result = mysql_query($sql);

hope you can insert this successfully into your page
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge

#3 shaunmckinnon

shaunmckinnon
  • Members
  • PipPipPip
  • Advanced Member
  • 30 posts

Posted 11 January 2004 - 07:13 PM

Hey thanks a lot!!!

That was a big help. And do you know of any good php teaching sites?

Thanks,
Shaun McKinnon

#4 shocker-z

shocker-z
  • Members
  • PipPipPip
  • Advanced Member
  • 864 posts
  • LocationNottingham

Posted 12 January 2004 - 02:45 AM

I personaly started at http://www.webmonkey.com under the programming menu on the right hand side of the page, it is very simple things but then if you start looking at code on forums like this and at other script you soon get the hang of where things go and what they do. :) im writing some tutorials in my spare time at the moment i should have a few done in the next month or so, im kinda just writing them in spare time like on bus rides to college and work, so i proberly wont be able to read what ive writen any way :P lol
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge

#5 briwal222

briwal222
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 12 January 2004 - 04:09 AM

I am wondering what this is:
....
I have not seen this in either php book I have, but I have seen it on some forums in the last day. Is this a diferent kind of syntax than <?php
I am wondering in what context it is used in.

Brian

#6 shaunmckinnon

shaunmckinnon
  • Members
  • PipPipPip
  • Advanced Member
  • 30 posts

Posted 12 January 2004 - 01:45 PM

Shocker-z:

Great! Thanks for the suggestion, i'll check it out. I just recently started up a company for web design...well, actually it's so I can sub-contract for an installer for an alarm company, but the main focus of my business will be e-commerce. I'm thinking about taking it correspondently at the Academy of Learning (a Canadian correspondent college).

What are you taking in college?

Shaun McKinnon
256 FX Designs
homepage (definitely not complete)

#7 shocker-z

shocker-z
  • Members
  • PipPipPip
  • Advanced Member
  • 864 posts
  • LocationNottingham

Posted 12 January 2004 - 02:55 PM

In reply to briwal222:

I am wondering what this is:

....


it colour codes the PHP code that people put in the forum, it helps tuns when you have long peices of code with quotes and comments and so on.
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge

#8 ErikS

ErikS
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 16 January 2004 - 04:43 PM

I could see why it would be nice to have the delete functionality, however I generally will program an application without a delete function on purpose. For archival purposes I usually want things to stick around in the database. What I do is have a field for active/inactive and than set it to a default bit of "1", if I want to "delete" it than I have a form set that bit to "0" and eliminate it from any of my listings.
SELECT * from table WHERE active <> 0


#9 shaunmckinnon

shaunmckinnon
  • Members
  • PipPipPip
  • Advanced Member
  • 30 posts

Posted 17 January 2004 - 04:28 PM

Dreamweaver MX 2004 has the delete records function...just decided to let everyone know...I've been reading web monkey tutorials, and I've learned a bit about php...i'm not a coder, but at least i understand a bit more about the code :rolleyes:

Shaun McKinnon
256FX Designs




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users