suggested mysql_num_rows use...

Anon

Background: I have a drop down user select field that chooses an entry for deletion based on a date on one page. After selecting a date, that variable is passed to a query against a database, and all the records for that date are to be displayed for editing.

What I need: I think using mysql_num_rows I can check for duplicate dates, and if it finds more than one entry of the same date, it displays the ID numbers in another drop down, as well as prompting the user to select an ID, if a dupe is NOT found, continue displaying the results.

How would I get from a to b on this?

Any suggestions? Any code snippets? I'm not looking for someone to write this out for me.. just give me a carrot I can work with. =]

Anon

I suggest that if mysql_num_rows is greater than 1 then display a list a records with a radio button or checkbox next to each one so the user can check which records they want to edit/delete.

<?
// pull out records based on input date
if (mysql_num_rows ($result) > 1) {
// while loop displaying each record with a checkbox next to each one
}
else {
// show the edit form for the one record that matched the input date
}
?>

Anon

I think I know what you meen.
Run a query something like this: SELECT * FROM table WHERE date = $date.
Then put the result in an array, if the array has more that one element "count(array)" show a drop down with the query values, if only one was found then display the data.

if (count($results) >0) {
... show drop down
} else {
.... show the data
}

hope this helps

Anon

I don't understand your question....the user selects a date from a dropdown and hits "Submit". The date variable is passed to a script to develop a query, selecting all records on that particular date. Correct?

Now your question was : "if it finds more than one entry of the same date..."

Won't it always? If you're selecting records based on a date, and multiple records have the same date, they will always be selected in the query.

This way, you can output the records of that date inside a loop, right?

$query_id = mysql_query("SELECT id FROM table WHERE date = $date")

while($result = mysql_fetch_array($query_id)){
print "$result[ID]"
}

Anon

Well, here's some more info that might help:

I have given users the ability to add an entry to a calendar based system. I'm working on the modify/delete portion of the script and am running into duplicate record issues.

The problem is, there's not always a chance the user will have entered in multiple entries for the same date, but if they do, I don't want the user to delete one record, and based on date, ALL records for that date get deleted.

Make sense?

The script has to be intuitive enough to see if multiple records for the same date exist, and if they do, give the option for the user to be more specific.

I'll try out some of the methods you guys suggested and see what I can cook up... If you guys have anymore suggestions, I'm all eyes.

Thanks!

Anon

If that's the logic of your script I would not even bother with mysql_num_rows(). Just display all records that match that date (even if it's just one) and allow the user the edit/delete records via a radio/checkbox.

Anon

Problem is, I don't want a user to delete a record they did not create, so I'm querying based on uid, date.

Anon

Just realized what you meant..and that makes more sense.. heh.. I need to lay off the beer on the weekends apparently.

Thanks for all your help folks..you guys rock!