Yet one more problem.....

buddysal

inside the members area i need to have a delect account link... i know i need to use a db connection... would it look something like this?

$dbHost = "localhost";
$dbUser = "buddysal_admin";
$dbPass = "3585835";
$dbDatabase = "buddysal_rtr";

$db = mysql_connect("$dbHost", "$dbUser", "$dbPass") or die ("Error connecting to database.");

mysql_select_db("$dbDatabase", $db) or die ("Couldn't select the database.");

$query = mysql_query("SELECT * FROM USERS WHERE username='$username'"); 
$count = mysql_del_row($query);

how would i turn that into a "do not execute unless clicked" type of query?

cgraz

I'm not sure if you're looking for a javascript confirm (basically a popup that says are you sure you want to delete this) or if you want to only execute the query if it's a delete query?? Anyways, I'd use two pages to keep it simple. Something like this

<a href="delete.php?id='$id'" onClick="return confirm('Are you Sure you want to delete this record')">Delete</a>

Then on delete.php

$query = mysql_query("DELETE FROM your_table WHERE id='" . $_GET["id"] . "'") or die(mysql_error());

Cgraz

Loafin

I'd change the query to

$query = mysql_query("Delete FROM USERS WHERE username='$username'");

to help speed up the whole proccess and encapsulate the code in an if() statement to see if the button was clicked...

if($_POST['confirm_delete'])
{
//run SQL here
}

Then add to your HTML page ...

<input type=submit name=confirm_delete value="Delete Account">

This is one of about a thousand ways to do this, but it should work... mileage may vary.

buddysal

how could a script an admin page to view all of my members plus for each member show how many referrals they have?

buddysal

ignore that last post.. i need to know how to record the date the form was put into the db.. like the date they signed up?

cgraz

make a mysql timestamp field for example, then when you INSERT

$query = mysql_query("INSERT INTO your_table (name, time) VALUES('$name', now())") or die(mysql_error());

You can lookup now() at mysql.com for more info.

Cgraz