echohing a success to a SQL query

[webguync]

I want to add an echo to this Query if successfull. Please assist.

 

<?
session_start();
//DELETE QUERY TO SELECT RECORD TO DELETE BASED ON LOGIN INFO.
$query_delete = "DELETE FROM log_March2010 WHERE user_id = $user_id AND roster_March2010.user_id = $user_id";
//echo $query; //for debugging test
$result_delete = mysql_query($query_delete) or die(mysql_error());
?>

 

something like echo ("Deletion Successful");

 

would it just go below $result_delete or do I need to add an if/then?

[Jax2]

if ($result_delete)

{

echo "Bla Bla"

}// end if

ELSE

{

echo "Failed"

} //end else

 

[webguync]

thx, would I still need this line as is?

 

$result_delete = mysql_query($query_delete) or die(mysql_error());

[Jax2]

Yep, just leave that there. That is what you need to check if it was successful or not ...

[Maq]

webguync, please do not use shorthand PHP tags, use <?php instead.  You also shouldn't be killing your script if a query fails, instead, handle it properly.  Read more here.

[webguync]

thanks, I'll try that out Maq. For my benefit what is the advantage of using <?php  over shorthand?

[Maq]

thanks, I'll try that out Maq. For my benefit what is the advantage of using <?php  over shorthand?

 

The main reason is if you ever want to port your code elsewhere and that server has short_open_tag disabled, your code will not work.