PHP - Wont Md5?

i need help trying to get this delete feature to work its not deleting from the database (by the way i took out my database names and passwords at the top of the file)

is it possible someone could help me, ive been working on this for like a week and cant figure out the problem. thanks! you can email me at spr_spng@yahoo.com


picture 2.png is showing what it looks like




Code: [Select]
<?php
$host="localhost"; // Host name
$username="username"; // Mysql username
$password="password"; // Mysql password
$db_name="database_name"; // Database name
$tbl_name="table_name"; // Table name

// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);

$count=mysql_num_rows($result);


?>
<style>
/*table affects look of the whole table look */
table {
margin-left: auto;
margin-right: auto;
border: 1px solid #330000;
border-collapse:collapse;
width:70%;

border-width: 5px 5px 5px 5px;
border-spacing: 1px;
border-style: outset outset outset outset;
border-color: #330000 #330000 #330000 #330000;
border-collapse: separate;
background-color: #330000;


#800517

f535aa

#330000 school color
#9A0000 school color2
#991B1E school color3
#CCCC99 school color4
#9A0000

}
/*th is table header */
th {
text-align: left;
height: 2.5em;
background-color: #330000;
color: #FC0;
font-size:1.5em;
}
/*td is table data or the cells below the header*/
td {
text-align: left;
height:1.0em;
font-size:1.0em;
vertical-align:bottom;
padding:10px;

border-width: 5px 5px 5px 5px;
padding: 8px 8px 8px 8px;
border-style: outset outset outset outset;
border-color: #9A0000 #9A0000 #9A0000 #9A0000;
background-color: #CCCC99;
-moz-border-radius: 0px 0px 0px 0px;

}
</style>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><form name="form1" method="post" action="">
<table width="400" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF">&nbsp;</td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Pick Which Rows you want to delete, Then press delete.</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF"><strong>Id</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Name</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Lastname</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
<td align="center" bgcolor="#FFFFFF">delete</td></tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#FFFFFF"><? echo $rows['id']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['name']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['lastname']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['email']; ?></td>
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['id']; ?>"></td>
</tr>
<?php
}
?>
<tr>
<td colspan="5" align="center" bgcolor="#FFFFFF"><input name="delete" type="submit" id="delete" value="Delete"></td>
</tr>
<?
// Check if delete button active, start this // edited
if($delete){
for($i=0;$i<$count;$i++){
$del_id = $checkbox[$i];
$sql = "DELETE FROM $tbl_name WHERE id='$del_id'";
$result = mysql_query($sql);
}

// if successful redirect to delete_multiple.php
if($result){
echo "<meta http-equiv=\"refresh\" content=\"0;URL=delete_multiple.php\">";
}
}
mysql_close();
?>
</table>
</form>
</td>
</tr>
</table>

$last = mysql_query("SELECT MAX('id') FROM comments WHERE submittedby='$username'");


can any1 help me?

Ok, I am a complete noob when it comes to php. I am slowly learning it but I turned to youtube for a tutorial on a registration/login page. I found a good tutorial http://www.youtube.com/watch?v=ngqeWUIDlnk&feature=channel but for some reason my php is NOT working. I have it exactly the way he does but it wont echo anything or work at all. The login page worked great in his tutorial. What do I have wrong? I cant figure it out. Please help!

 

echo "<h1>Register</h1>";

 $submit = $_POST['submit'];
 $fullname = strip_tags($_POST['name']);
 $username = strip_tags($_POST['user']);
 $password = strip_tags($_POST['password']);
 $verifypassword = strip_tags($_POST['verifypassword']);
 $date = date("Y-m-d");

 if ($submit)
 {
     if($fullname&&$username&&$password&&$verifypassword)
     {
          password = md5($password);
          verifypassword= = md5($verifypassword);
     }
     else
         echo "Please fill in all fields!";

 }
Code: [Select]
<html>
<form action='register.php' method='POST'>
      <table>
              <tr>
                   <td>Full Name:</td>
                   <td><input type='text' name='name'></td>
              </tr>
             
              <tr>
                   <td>Username:</td>
                   <td><input type='text' name='user'></td>
              </tr>
               
               <tr>
                   <td>Password:</td>
                   <td><input type='password' name='password'></td>
              </tr>

              <tr>
                   <td>Verify Password:</td>
                   <td><input type='password' name='verifypassword'></td>
              </tr>
      </table>
      <p><input type='submit' name='submit' value='Submit'></p>
</form>

</html>

For some reason i cannot for the life of me find, from the below code, <? echo $price ?> is returning nothing, could someone please take a look at this and explain to me where I'm going wrong, Would appreciate it tonnes, Thanks Freddy.

Code: [Select]
<?php
//get item information
$AttributeID = mysql_real_escape_string($_GET['AttributeID']);
$sql = "SELECT * FROM attributes as a WHERE a.id = $AttributeID";
$query = mysql_query($sql) or die(mysql_error());
$attribute = mysql_fetch_array($query);
$price = $attribute['SkillPoints'];
//check for attribute
$sql = "SELECT * FROM player_attributes WHERE player_id = $playerID AND attribute_id = $AttributeID";
$query = mysql_query($sql) or die(mysql_error());
$att = mysql_fetch_array($query);
$quan = $att['quantity'];
if ($quan == 0){
$quan = 0;
}else{
$quan = ($quan);
}
if($quan == 0) {
$price = ($price);
}else{
}
if ($quan >='1'){
$price = ($quan + $price);
}
?>

Hey all, I have an odd problem that I hope someone here has had and knows how to fix.

I recently installed Apache, PHP, and MySQL on a new server we have at work. Everything works fine, oddly enough, except for PHP parsing.

You see the following code:

Code: [Select]
<?
echo "test";
?>

Will display the PHP code, while

Code: [Select]
<?php
echo "test";
?>

Will echo "test". The problem seems to be that PHP isnt parsing the <? directive as a start command. Does anyone have any idea why this might be?

Thanks for any help.