Jump to content

Archived

This topic is now archived and is closed to further replies.

shaunmckinnon

delete records form

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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)

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.