Two-part question..

zTagged

I have two.. "Offending" pieces of code that aren't working just right.

One is a form field "Email updater" with the current data (In the table) already echoed, only it's not echoing the data, but the actual '.$result['email'].' .

else {
//Let's begin with a query.
$sqlquery2 = "SELECT email from pilots WHERE pilot_id=('".$_SESSION['SESS_MEMBER_ID']."')";

//Run it!
$run=mysql_query($sqlquery2);


//Manditory Numrows.
$rows=mysql_num_rows($run);

//Kick it!
echo '<table>';
for ($i=0; $i<$rows; $i++)

{
//Dum dee dum..
$result=mysql_fetch_array($run);


print '<head>';
print '<link href="lulz.css" rel="stylesheet" type="text/css" />';
print '<body bgcolor="#3C4673">';
print '<title>#</title>';

print '</head>';

print '<form action="" method="post">';
print '<table border="0">';
print '<tr><td><img border="0" src="../images/codan.jpg"></td></tr>';
print '<tr><td bgcolor="#F3EEEB">Current Email Address:';
echo '<input type="text" input name="email\'.$i.\'" maxlength="256" class="textfield" value="(\'.$result[\'email\'].\')"> 

<input type="submit" name="submit" value="Go!" class="textfield">';
print '</td><tr><td bgcolor="#FF9900">'; include "mainmenu.php"; print '</td></tr>';

print '</table>';
print '</form>';

}
}

And then an auto-emailer which is being odd.. It's not sending any ( :rolleyes: ) messages, even though it is saying it sent a message.

// If the manager rejects the application..
if($_GET['delete']){
$item = $_GET['delete'];
//Gets that pilot's info from the database..
$declinequery = "SELECT * FROM pilots WHERE pilot_id='$item'";
$result3 = mysql_query($declinequery) or die(mysql_error());
while($row = mysql_fetch_array( $result3 ))
{
$name = ('.$row["name"].');
$email = ('.$row["email"].');

//Sends them a Dear John Letter..

//Let's start with his email, already stored in the database.
$to = "$email";

//The heartbreaking line..
$subject = "Subject line";

//OH THE HUMANITY
$body = "Dear $name , thank you for applying at PIP.\n
At this time, we have decided to decline your application. You may re-apply at any time.\n
We appreciate your time and understanding in our decision. Thank you.";
$headers = 'From: Null' . "\r\n" .
    'Reply-To: Null' . "\r\n" .
    'X-Mailer: PHP/' . phpversion();
if (mail($to, $subject, $body, $headers)) {

//John got his letter, and can kiss my ass.
  echo("Decline notice sent.");
 } else {

 //If the mail didn't send, it'll shoot back a failed notice.
  echo("<p>Message delivery failed...</p>");
 }
 //either way, Dear John is getting his ass deleted.
mysql_query("DELETE FROM pilots WHERE pilot_id='$item'") or die(mysql_error());

//And the confirmation.
print "Application declined.<br>";
}
}

(Edit: Went ahead and tried a whole bunch of stuff on the $ variables, but still it doesn't do anything.. :mad: )

Piranha

When you use single quotes the content is just printed exactly as it is. Use double quotes to have variables printed instead. And don't use quotes in the variables. The following should work:

$var = "variable";
echo "This is a $var";
echo 'This is a ' . $var;
$var2['name'] = "Smith"; // This row might not work
echo "My name is $var2[name]";
echo "My name is " . $var2['name'];
echo 'My name is ' . $var2['name'];

zTagged

Alrighty Mr. Piranha, I went back and tried it again a bit differently.
Now it's not echoing anything in the field. 😕

for ($i=0; $i<$rows; $i++)
{
//loading returned values from database into an array
$result=mysql_fetch_array($run);
$email = $row['email'];

//Useless crap removed

echo "<input type=\"text\" input name=\"email'.$i.'\" maxlength=\"256\" class=\"textfield\" value=\"$email\"> 

<input type=\"submit\" name=\"submit\" value=\"Go!\" class=\"textfield\">";

Piranha

Look at the source of the generated page and you will probably find the answer.

igorlopez

I might be missing something here but shouldn't the code where you extract the email look like:

//loading returned values from database into an array
$result=mysql_fetch_array($run);
$email = $result['email'];

Piranha

You are not missing it at all igorlopez. I just assumed that it worked and didn't look at it.

zTagged

I have no idea what's up with this. 😕
Piranha, the page source is just saying value="" , so that's not helping much.

Igor, I went back and tried it with your version, still no luck.

$sqlquery2 = "SELECT * from pilots WHERE pilot_id=('".$_SESSION['SESS_MEMBER_ID']."')";

//run the query into your SQL server
$run=mysql_query($sqlquery2);


//get the number of rows your query has returned.
$rows=mysql_num_rows($run);

//make a simple cycle to run through all your returned records
echo '<table>';


//loading returned values from database into an array
$result=mysql_fetch_array($run);
$email = $result['email']; 

print '<tr><td bgcolor="#F3EEEB">Current Email Address:';
echo "<input type=\"text\" input name=\"email\" maxlength=\"256\" class=\"textfield\" value=\" $email \">

And it still gives no value.
:queasy:

$query = "SELECT * from pilots WHERE pilot_id=('".$_SESSION['SESS_MEMBER_ID']."')";

$result = mysql_query($query);

/* Determine the number of reports */
$number = mysql_numrows($result);


echo '<table>';

   for ($i=0; $i<$number; $i++) {
$email = mysql_result($result,$i,"email");

Also returns no value.

?><input type="text" input name="email" maxlength="256" class="textfield" value="<?php echo $email; ?>"><?php

Also no value.

EDIT: The last one worked, I don't know what I did but it worked. Now all I need to figure out is the email thing, and I'm all set. 😃

And the final edit: Using the same code from the other problem, the email works.

decline_query = "SELECT * FROM pilots WHERE pilot_id='$item'";

$result3 = mysql_query($decline_query) or die(mysql_error());

$number = mysql_numrows($result3);

for ($i=0; $i<$number; $i++)

{
$email = mysql_result($result3,$i,"email");
$name = mysql_result($result3,$i,"name");

Man that had me frustrsted. Glad to be done with it. Piranha, Igor, you two rock. Thank you!

igorlopez

Maybe your query comes up empty?
Perform an echo of the query string and copy that result in to your mysql command line if you have access to it.

zTagged

igorlopez wrote:
Maybe your query comes up empty?
Perform an echo of the query string and copy that result in to your mysql command line if you have access to it.

Nah, it had data but hey, it works now! I can't complain. 😃