[escaping error (I think)]

Thanks, I got it to work (I'm excited).  But I had to change that whole line to be:

 

<form action='php/del.php' method='post' onsubmit='return confirm(\"Really?\");'>

 

I kept getting a dividing by 0 error otherwise.

[escaping error (I think)]

I've got this code and it works fine.  All I want to do is, when people click on the x to delete something they submitted erroneously, I want a confirmation...really want to delete this?  (sometimes that x is too tempting you know)

 

But I *think* I'm having trouble escaping the line (near bottom):  onsubmit='".return confirm('Really Delete');."'

 

I'm not sure if it will work anyhow...but right now it doesn't.

 

Thanks for any suggestions.

 

<code>

<?php

 

include '../php/config_conn.php';

 

$querysum = "SELECT SUM(total_time) FROM `coop_hours` where user = '".$_SESSION['user_name']."'";

$resultsum = mysql_query($querysum);

$arr = mysql_fetch_row($resultsum);

$resulthours = $arr[0];

 

$querytime = "SELECT * FROM `coop_hours` WHERE user = '".$_SESSION['user_name']."' ORDER BY `date_completed`";

$result = mysql_query($querytime);

 

$num = mysql_num_rows($result);

 

mysql_close();

 

 

echo "<table width='1000' cellpadding='0' cellspacing='0' border='0'><tr>

<td width='200'><strong>Coop Job</strong></td>

<td align=center width='200'><strong>Date Completed</strong></td>

<td align=center width='120'><strong>Total Time</strong></td>

<td width='380'><strong>Comments</strong></td>

<td width='100'>Delete Entry</td></tr>";

 

$i=0;

while ($i < $num) {

 

$hours_id = mysql_result($result, $i, "hours_id");

$user = mysql_result($result, $i, "user");

$coop_job = mysql_result($result, $i, "coop_job");

$date_completed = mysql_result($result, $i, "date_completed");

$start_time = mysql_result($result, $i, "start_time");

$end_time = mysql_result($result, $i, "end_time");

$total_time = mysql_result($result, $i, "total_time");

$comments = mysql_result($result, $i, "comments");

 

 

echo "<tr><td>$coop_job</td>

<td align=center>$date_completed</td>

<td align=center>$total_time</td>

<td>$comments</td>

<td align=center valign='middle'>

<form action='".php/del.php."' method='".post."' onsubmit='".return confirm('Really Delete');."'>

<input type='".hidden."' name='".hours_id."' value='".$hours_id."'>

<input TYPE='image' SRC='images/del.png' width='11' height='11' border='0' alt='Delete'>

</form>

</td>

</tr>";

 

$i++;

}

echo "<tr><td colspan=5><hr></td></tr>";

echo "<tr><td></td><td align=right>Total hours:</td><td align=center>$resulthours</td><td></td></tr>";

echo "<table>";

 

?>

</code>

[Delete row from db]

Figured it out. Not as pretty as I want it to be, but it works...

[Delete row from db]

so I tried:      <input type="hidden" name="hours_id" value="<?php echo $_POST['hours_id']; ?>">

   

but I know it's in the wrong place and won't work.  The hours_id is an auto increment created when the info from the form is inserted into the database

 

I have to pull that out of the db, and then pass it. 

 

[Delete row from db]

I'm trying.

 

I can add this to the form <input type="hidden" name="hours_id" value="">

and this to the del.php file:  $hours_id = $_POST["hours_id"];

 

But it still doesn't work

[Delete row from db]

I need a bit of help.  I am displaying records from a db, and want the user to be able to delete a record.  I'm almost there (I think) but it doesn't pass the variable ($hours_id) to the delete query.  Any ideas?  Should be easy...but I'm just at my end.

 

<?php

 

include '../php/config_conn.php';

 

$querysum = "SELECT SUM(total_time) FROM `coop_hours` where user = '".$_SESSION['user_name']."'";

$resultsum = mysql_query($querysum);

$arr = mysql_fetch_row($resultsum);

$resulthours = $arr[0];

 

$querytime = "SELECT * FROM `coop_hours` WHERE user = '".$_SESSION['user_name']."' ORDER BY 'date_completed'";

$result = mysql_query($querytime);

 

$num = mysql_num_rows($result);

 

mysql_close();

 

 

echo "<table width='800' cellpadding='0'><tr>

<td><strong>Coop Job</strong></td>

<td align=center><strong>Date Completed</strong></td>

<td align=center><strong>Total Time</strong></td>

<td><strong>Comments</strong></td><td>Delete Entry</td></tr>";

 

$i=0;

while ($i < $num) {

 

$hours_id = mysql_result($result, $i, "hours_id");

$user = mysql_result($result, $i, "user");

$coop_job = mysql_result($result, $i, "coop_job");

$date_completed = mysql_result($result, $i, "date_completed");

$start_time = mysql_result($result, $i, "start_time");

$end_time = mysql_result($result, $i, "end_time");

$total_time = mysql_result($result, $i, "total_time");

$comments = mysql_result($result, $i, "comments");

 

 

echo "<tr><td>$coop_job</td>

<td align=center>$date_completed</td>

<td align=center>$total_time</td>

<td>$comments</td>

<td align=center>

 

<a href='php/del.php'><img src='images/del.png'></a></td>

</tr>";

 

$i++;

}

echo "<tr><td colspan=5><hr></td></tr>";

echo "<tr><td></td><td align=right>Total hours:</td><td align=center>$resulthours</td><td></td></tr>";

echo "<table>";

 

?>

 

And here is del.php:

 

<?php

 

include '../../php/config_conn.php';

 

$del_query = ("DELETE FROM coop_hours WHERE hours_id = '".$hours_id."' LIMIT 1");

$result = mysql_query($del_query);

 

header("Location: http://.../myaccount-testing.php");

 

?>