kdub718

Would it be possible to make a media page with a place to upload a image gallery and a video gallery per event?  For example there is an event I go to and I take a bunch of pictures and maybe some video and I want to upload it per that event... so could I make a folder of the images and I want to upload that entire folder to my site but I do want it to resize the pics for me but for it to upload all the photos...  then when you go to the site you can click on that event and it will take you to all the photos? 

Is there a way I can just put an update button next to my delete button?  My delete button works and it deletes all the fields for each event... but I just want to add the update button on there so I can update a finish ect.  I have the update button showing and everything but when I type in something different in the field and hit update it doesn't update... but If I hit the delete button that works fine?  so am I just missing something for the update so it will save the update to the row?  does that make any sense? My updated editevent.php page code: [code] <? include("../secure.php");?> <?if (isset($delete)) @mysql_query ("DELETE FROM events WHERE id = '$delete'"); ?> <?if (isset($update)) @mysql_query ("UPDATE FROM events WHERE id = '$update'"); ?> <center> <table width=809 align=center border=0 cellspacing=1 cellpadding=3> <tr align=center> <td width="177" bgcolor=silver><B><font size=1 face="verdana">DATE</b></td> <td width="216" bgcolor=silver><B><font size=1 face="verdana">EVENT</b></td> <td width="242" bgcolor=silver><B><font size=1 face="verdana">LOCATION</b></td> <td width="64" bgcolor=silver><B><font size=1 face="verdana">FINISH</b></td> </tr> <?  $result = @mysql_query("SELECT * FROM events ORDER BY id DESC LIMIT 20"); while ( $row = mysql_fetch_array($result) ) { echo ( " <tr align=center> <td><input name=newsubject type=text maxlength=100 size=25 value='" . $row["date2"] . "'></td> <td><input name=newsubject type=text maxlength=100 size=25 value='" . $row["event"] . "'></td> <td><input name=newsubject type=text maxlength=100 size=25 value='" . $row["location"] . "'></td> <td><input name=newsubject type=text maxlength=100 size=25 value='" . $row["finish"] . "'></td> <td><B><font size=1 face=verdana> <a href='$PHP_SELF?delete=$row[id]'>Delete</a>&nbsp;<a href='$PHP_SELF?update=$row[id]'>Update</a></b></td> </tr> " ); } ?> </TD> </TR> </TABLE>[/code]

thanks for the response...  I'm really green (noobie as my user title says) when it comes to php coding...  I have tried so many different ways and it just doesn't seem to be working for me at all... could you possible give me an example?  I'm a little confused... okay maybe a lot confused!  LOL  =)  Thanks, KW

well since nobody here wants to help me can someone suggest a site where I can get some help? 

please?  anyone?

any more information needed?  that I may be missing?  Anyone that can help me out?  Thanks

Well basically I have a schedule page.  With Date, Event, Location, and Finish...  I have it setup right now to where I can just delete the hole line...  well I want to add an edit feature so I don't have to delete the entire line I can just edit each line to put a finishing place in or just edit the line in general incase I miss spell something or a date gets changed for an event... also is there a way to order the entries by date?  right now I have to order them backwards to make the most recen events show up on top... but if a date changes I have to re-do the entire schedule...  here is what I have... I'm really new to php and the whole database stuff...  also what is the difference with php and asp? (that might be a little off subject but incase someone out there wants to give me some insight that would be great) this is my editevent page code: [code]<? include("../secure.php");?> <?if (isset($delete)) @mysql_query ("DELETE FROM events WHERE id = '$delete'"); ?> <center> <table width=728 align=center border=0 cellspacing=1 cellpadding=3> <tr align=center> <td width="140" bgcolor=silver><B><font size=1 face="verdana">DATE</b></td> <td width="133" bgcolor=silver><B><font size=1 face="verdana">EVENT</b></td> <td width="139" bgcolor=silver><B><font size=1 face="verdana">LOCATION</b></td> <td width="140" bgcolor=silver><B><font size=1 face="verdana">QUALIFIED</b></td> <td width="140" bgcolor=silver><B><font size=1 face="verdana">FINISH</b></td> </tr> <?  $result = @mysql_query("SELECT * FROM events ORDER BY id DESC LIMIT 20"); while ( $row = mysql_fetch_array($result) ) { echo ( " <tr align=center> <td><B><font size=1 face=verdana>" . $row["date2"] . "</b></td> <td><B><font size=1 face=verdana>" . $row["event"] . "</b></td> <td><B><font size=1 face=verdana>" . $row["location"] . "</b></td> <td><B><font size=1 face=verdana>" . $row["qualified"] . "</b></td> <td><B><font size=1 face=verdana>" . $row["finish"] . "</b></td> <td><B><font size=1 face=verdana> <a href='$PHP_SELF?delete=$row[id]'>Delete</a></b></td> </tr> " ); } ?> </TD> </TR> </TABLE>[/code] this is my addevent page code: [code]<? include("../secure.php");?> <? if (!isset($submitok)): ?> <br> <form method=post action="<?=$PHP_SELF?>"> <table align=center border=0 cellspacing=0 cellpadding=3> <tr valign=top> <td colspan=2 align=middle bgcolor=silver width=100% height=10> <b><font face="verdana" color=black size=1>Add Event</font></b> </td> <tr valign=top>         <td align=right>         <font size=1 face="verdana"><b>Date:</b></font>        </td>         <td> <input name="date2" maxlength=100 size=25>        </td>     </tr>    <tr valign=top>         <td align=right>         <font size=1 face="verdana"><b>Event:</b></font>        </td>         <td><input name="event" maxlength=100 size=25>        </td>     </tr> <tr valign=top>         <td align=right>         <font size=1 face="verdana"><b>Location:</b></font>        </td>         <td><input name="location" maxlength=100 size=25>        </td> </tr> <tr valign=top>   <td align=right><font size="1" face="verdana"><b>Qualified:</b></font></td>   <td><input name="qualified" maxlength="100" size="25" /></td> </tr> <tr valign=top>   <td align=right><font size="1" face="verdana"><b>Finish:</b></font></td>   <td><input name="finish" maxlength="100" size="25" /></td> </tr>    <tr>         <td colspan=2 align=middle>         <input type=submit name="submitok" value="  Add Event  ">        </td> </tr> </table> </form> <BR><BR> <? else: $sql="INSERT INTO events SET date2='$date2', event='$event', location='$location' , qualified='$qualified' , finish='$finish'"; ?>   <table width=350 align=center border=0 cellspacing=0 cellpadding=3> <tr valign=top> <td colspan=2 align=middle bgcolor=silver width=100% height=10> <b><font face="verdana" color=black size=1>Success</font></b> </td> <tr valign=top>         <td><BR><center>         <font size=1 face="verdana">Event Added successfully</font></center><BR>         </td>     </tr>    <tr>         <td colspan=2 align=middle>         <form action=main.php><input type=submit value="   Thank You   "></form>         </td> </tr> </table>[/code] Thanks in advance,