whats wrong "everything looks right"

Chrysanthus

Hi my quest is this im trying to make a automaling funktin but i dosent work but everything is right....

Please look at it see if i have some thing i forgott!

By the way everythig works until line Query failed field.

The username and password is right alsow when i connects to the db in

include ("../login/mysqlcon.php");

sow that's not the problem ether

I hope you find some other problems in the code that makes i work..

<?

$username = $_POST['username'];

include ("../login/mysqlcon.php");

if (!$username) // they haven't filled out the form yet.
{
?>
<html>
<body>
<form action="getpassword.php" method="post" name="getpass">
Username:<br>
<input class="inputSidebar" type="text" name="username"<br>
<input class="button" type="submit" name="submit" value="Get password">
</form>
</body>
</html>
<?
}

else // form has been filled out
{

$mysqlcon = "select * from = '$start' reg_info where username = '$username';";
$result = mysql_query($mysqlcon) or die("Query failed");

if (mysql_num_rows($result) == '1') {

/*****Dont forget this*******/

$row = mysql_fetch_row($result);

print "<p><center><big>Welcome $username Please click <a href=\"index.php\">
here to continue to flameline.com in some seconds you will recive a email with your password in it.</big></center></p>";

/*******mail function here!***********/
if (mail($row['email'], "Your Password", "Your password is ".$row['password']))
echo "Email Sent Successfully";

}
else
{
print "<p><center><big>Sorry, incorrect $username.</big></big></center></p>";

print "<p><center><big>if not a member <a href=\"register.php\">
click here to register</big></center></p>";
}
}
?>

bad76

Hi,

look this

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10249513

and this

http://www.phpbuilder.com/board/showthread.php?s=&postid=10390788

cassius

I think there may bee something wrong with your sql-statement:

$mysqlcon = "select * from = '$start' reg_info where username = '$username';"

1) 'select from' chooses all data in the table specified.
2) you shouldn't write 'select from = , but 'select * from table_name'
3) what is the name of your table?
4) do you really want to choose all data in the rows that match your condition('where username='$username')??

I cannot understand where the variable $start comes from and why you put it in your sql-statement.

For your purpose, I guess i would have written one of these to sqls, depending on wether or not I needed all data fields from rows matching my condition(seems like you only need the 'username'-field = the last sql):

$sql = "SELECT * FROM reg_info WHERE username='$username'";

Now, to choose only the field 'username':

$sql = "SELECT username FROM reg_info WHERE username='$username'";

cassius

Like bad76 said, try writing out an error from mysql in your mysql_query().

something like this:

$sql = " SELECT * FROM Banned_Users WHERE USERNAME='$unban'";
$var  = mysql_query($sql) or die("Error: " . mysql_error());

This will give you good information to try working out your problem.

Chrysanthus

you where right i forgott that i don't need to lookup the holl tabel only the username row...

Thanks for the help it works fine now exept that's dosen send any mail any ides what that can be?

bad76

You can try to prepare args for mail function before, like that:

$To = "address@dest.com";
$Subject = "any subj";
$Body = "any message\n\n";

$res = mail (stripslashes($To), stripslashes($Subject), stripslashes($Body));

And may be you need the ending "\n\n"..

I hope this help you.

ducey

To send mail, you would need to use the mail() method.

Use it like this:

mail("sendingAddress@email.com","Subject of your Email","Message text of your email");

This would send an email to the address sendingAddress@email.com and the text Subject of your Email would be in the subject bar, and the Message text of your email will be in the message body of the email.

Enter your address instead of sendingAddress@email.com to see what is sent 🙂

Hope this helps,
Nathan

Chrysanthus

To bad76 what's the diffrence with this any your code "i wanna lern"
I does the same, what i see right or not right?

if (mail($row['email'], "Your Password", "Your password is ".$row['password']))
echo "Email Sent Successfully";

and

$To = "address@dest.com";
$Subject = "any subj";
$Body = "any message\n\n"; <What is this ment to bee?>

$res = mail (stripslashes($To), stripslashes($Subject), stripslashes($Body));

bad76

I've experienced out some error between mail and string function. (For example the code i posted before with single quote instead of double do error as here: http://www.phpbuilder.com/board/showthread.php?threadid=10239462#post10342660)

And there are other buggy error when using associative array directly.

And so the code is a bit more readable.

But mine it's only an hint, and may be don't work too...

Chrysanthus

i test to breack up the code in smaller pices insted and see if that's works insted..

I'll be back he he :p

Chrysanthus

dident work.. im making a ny thread now.... it is not the same problem anymore sow people ho are good at it can help me in the new thread...

bad76

I've looked.

If code is right check for php.ini:
what system you are running? both linux and window server need an external program, like sendmail. In window this program run as program, when for linux is like an extension.

The lines to check in php.in are:

[mail function]
; For Win32 only.
SMTP = localhost

; For Win32 only.
sendmail_from = me@localhost.com

; For Unix only. You may supply arguments as well (default: "sendmail -t -i").
;sendmail_path =

see you

Chrysanthus

thanks i had some ides about some mail sender thingi some thing must sedan the mail that why i started a new thread...

I test to modefie the php.ini file to point to the mail server

Chrysanthus

one thing does the php use realy if i activat this to point to de mail server inbound i mean?..

[mail function]
; For Win32 only.
SMTP = 192.168.100.20

; For Win32 only.
sendmail_from = autosender@mgi.se

; For Unix only. You may supply arguments as well (default: "sendmail -t -i").
;sendmail_path =

Arrgggg Dosent work 😕