mariocesar

Thanks Crayon Violent, I include my config.php in the function, and now is OK.

yes is allready there, what happen this script comes from welcome.php when you hit change password gives you all the messages I mentioned before, this is the welcome.php that work together with the script I allready posted before: [<? echo $_SESSION['username'];?>,WELCOME TO MY PAGE<br> You have passed all security checks!<br> <? echo "You've been logged in since" . $_SESSION['time'] . "<br>"; echo '<a href="logout.php">Click here to logout</a>'; echo "<br>"; echo '<a href="' .$_SERVER['PHP_SELF']. '?action=change"> Change Password</a>'; ?> <? include "fns.php"; $action=$_GET['action']; if($action=="change"){ changepw($_SESSION['username']); update($newpass,$_SESSION['username']); }else{ } ?>/code]

Yes the connection is in config.php here it is: <?php $dbhost='test.net'; $dbusername='test'; $dbuserpass='test'; $dbname='test'; // connect to the mysql database server. mysql_connect ($dbhost, $dbusername, $dbuserpass); mysql_select_db($dbname) or die('I cannot select the database because: ' . mysql_error()); ?>

hi here is the script, I receiving a warning message: Warning: mysql_query(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/C/o/p/Copymail/html/fns.php on line 35 Warning: mysql_query(): A link to the server could not be established in /home/content/C/o/p/Copymail/html/fns.php on line 35 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/C/o/p/Copymail/html/fns.php on line 37 <? function userexist($username){ include('config.php'); $result=mysql_query("Select * from user where uname='$username'") or die(mysql_error()); if(mysql_num_rows($result)>0) return true;//username exist else return false;//username not in db } function sendpass($user){ include("config.php"); $result =mysql_query("Select pw from user where uname='$user'") or die(mysql_error()); if(mysql_num_rows($result)>0) return true;//password exist else return false;//password not in db } function filledin($form_vars){ foreach($form_vars as $key=> $value) { if(!isset($key) || ($value == '')) return false; } return true; } function changepw($name){ $query="Select pw from user where uname='$name'" or die(mysql_error()); $result= mysql_query($query); if(mysql_num_rows($result)>0){ for ($i=0; $i<mysql_num_rows($result); $i++) { $row = mysql_fetch_assoc($result); $pass=$row['pw']; echo ' <center><form name="form1" method="post" action="forgotten.php">'; echo 'Please fill in the following:<br>'; echo ' <table width="445" border="0">'; echo ' <tr> <td width="187"><div align="left">Old Password</div></td> <td width="242"><input name="oldpass" type="text" size="40" value="'.$pass.'"></td> </tr> <tr> <td><div align="left">New Password </div></td> <td><input name="newpass" type="text" size="40"></td> </tr>'; echo '</table>'; echo '<br> <input name="submit" type="submit" value="Save">'; echo '</form>'; } } } function update($newpass,$uname){ if(isset($_POST['submit'])){ if (!filledin($form_vars)){ echo "Please ensure that you have filled in ALL fields."; exit; }else{ $newpass=$_POST['newpass']; } include "config.php"; $query="Update user SET pw='$newpass' Where uname=$uname Limit 1 "; $result=mysql_query($query); if(mysql_affected_rows()==1){ echo "Record number <b>$id</b> has been updated"; }else{ echo "Could not update record number <b>$id</b> because " .mysql_error() . ""; } } } ?> here is line 35: $result= mysql_query($query); here is line 37: if(mysql_num_rows($result)>0){ thanks.

Hello this sis the message I receive : Warning: mail(): Bad parameters to mail() function, mail not sent. in /home/content/C/o/p/Copymail/html/password.php on line 36 Warning: Cannot modify header information - headers already sent by (output started at /home/content/C/o/p/Copymail/html/password.php:36) in /home/content/C/o/p/Copymail/html/password.php on line 41 this is the code: <? include("fns.php"); include "config.php"; if(isset($_POST['Submit'])){ //1. Check if form fields are filled in if(!filledin($_POST)){ header( "Location:Messages.php?msg=7" ); exit(); } $name=$_POST['name']; $em=$_POST['mail']; //2. Check if entered name exist $query="Select pw from user where uname='$name'" or die(mysql_error()); $result= mysql_query($query); if(mysql_num_rows($result)>0){ for ($i=0; $i<mysql_num_rows($result); $i++) { $row = mysql_fetch_assoc($result); $pass=$row['pw']; $to="$em\r\n"; $from="From: Admin@jacquesnoah.co.uk\r\n"; $msg="Password:$pass\r\n"; $msg .="Username:$name\r\n"; $msg .="Please change your password as soon as you logon\r\n"; $subject="From Admin re:Your Login Password\r\n"; } }else{ header( "Location:Messages.php?msg=8" ); exit(); } //4. Send password to user if(mail($to,$subject,$msg,$from)){ header( "Location:Messages.php?msg=9&email=<?php echo $em; ?>" ); exit(); //echo "Please click here to log"; }else{ header( "Location:Messages.php?msg=10"); exit(); } } ?> this is lne 36 : if(mail($to,$subject,$msg,$from)){ this is 41: header( "Location:Messages.php?msg=10"); Thanks.

I running this login system the register page is working fine, but something wrong with the login.php page when I login an allready registered visitor gives me this message: Warning: Cannot modify header information - headers already sent by (output started at /home/content/C/o/p/Copymail/html/login.php:11) in /home/content/C/o/p/Copymail/html/login.php on line 80 here is the script of the login.php: [code]<?php //session_start(); // set your infomation. $dbhost='secureserver.net'; $dbusername='loco'; $dbuserpass='loco'; $dbname='mydb'; if (isset($_COOKIE['user'])) { echo "Welcome $_COOKIE[user]"; }else{ //connect to the mysql database server. mysql_connect ($dbhost, $dbusername, $dbuserpass); mysql_select_db($dbname) or die('Cannot select database'); if ($_POST['username']) { //did they supply a password and username $username=$_POST['username']; $password=$_POST['password']; if ($password==NULL) { echo "A password was not supplied"; }else{ $query = mysql_query("SELECT name,password FROM usersreg WHERE name = '$username'") or die(mysql_error()); $data = mysql_fetch_array($query); if($data['password'] != $password) { echo "The supplied login is incorrect"; }else{ $query = mysql_query("SELECT name,password FROM usersreg WHERE name = '$username'") or die(mysql_error()); $row = mysql_fetch_array($query); setcookie("user", "$username", time()+3600); } } } ?>[/code] this is line 80: [code]setcookie("user", "$username", time()+3600);[/code] Thanks

Thanks, but there is not the real info to connect to dbase, here is the code where I inser the password. [code]<? if ($_POST[user] && $_POST[pass]) {       $db = mysql_connect('localhost', $user = "digitalz_loco", $pass = "baby" ); mysql_select_db("digitalz_login", $db); $result = mysql_query ("SELECT * FROM usersreg WHERE name = '".$_POST[user]."'"); if (mysql_num_rows($result) == 0) { $result = mysql_query ("INSERT INTO usersreg (name, password, company, email, address, city, state, zipCode) VALUES ('".$_POST[user]."', PASSWORD('".$_POST[pass]."'),'".$company."', '".$email."', '".$address."', '".$city."', '".$state."', '".$zipCode."')"); if ($result) { $logged_in_user = $_POST[user]; session_register("logged_in_user"); echo "Your details have been added to the database, ".$_POST[user]. "<BR><BR>"; echo "to upload files go to your account.<BR><BR>"; echo "<div class='quote'><img src='images/orange_arrow.gif'>&nbsp;&nbsp;<A HREF='main.php'>My Account</A></div><br>"; echo "<div class='quote'><img src='images/orange_arrow.gif'>&nbsp;&nbsp;<A HREF='logout.php'>Logout</A></div><br>"; exit; } else { echo "Sorry, there has been a technical hitch. We cannot enter your details."; exit; } } else { echo "Sorry, that username has been taken. Please try another.<BR>"; } } else if ($_POST[user] || $_POST[pass]) { echo "Please fill in all fields.."; } ?>[/code] Thanks.

hello, the script is working fine, but when it sends the email, to the user with the password in it, the password is a group of different characters something like this: Password: 48a11be00bc8ed47 [code]<?php mysql_connect('localhost', $user = "user_mar", $pass = "rocki" ) or die("Cannot connect to DB!"); mysql_select_db("digitalz_login") or die("Cannot select DB!"); $sql="SELECT password, email FROM usersreg WHERE name='".$_POST[user]."'"; $r = mysql_query($sql); if(!$r) {   $err=mysql_error();   print $err;   exit(); } if(mysql_affected_rows()==0){   print "no such login in our records please try again";   exit(); } else {   $row=mysql_fetch_array($r);   $password=$row["password"];   $email=$row["email"]; $toAddress="login@digitalzonenyc.com"; $subject="Your Password";  $receiptMessage = "Thank you ".$row['name']." Your password is:\n\n" ."Password: ".$row["password"]."\n";          mail($row['email'], $subject, $receiptMessage,"From:$toAddress");     print "An email containing the password has been sent to you"; } ?>[/code] Thanks,

The script was working fine, I changed the hosting Co, now I think is php 5, here is the message: Warning: Unknown(): Your script possibly relies on a session side-effect which existed until PHP 4.2.3. Please be advised that the session extension does not consider global variables as a source of data, unless register_globals is enabled. You can disable this functionality and this warning by setting session.bug_compat_42 or session.bug_compat_warn to off, respectively. in Unknown on line 0 [code]<? if ($_POST[user] && $_POST[pass]) {       $db = mysql_connect('*****', $user = "****", $pass = "***" ); mysql_select_db("copymailregister", $db); $result = mysql_query ("SELECT * FROM usersreg WHERE name = '".$_POST[user]."'"); if (mysql_num_rows($result) == 0) { $result = mysql_query ("INSERT INTO usersreg (name, password, company, email, address, city, state, zipCode) VALUES ('".$_POST[user]."', PASSWORD('".$_POST[pass]."'),'".$company."', '".$email."', '".$address."', '".$city."', '".$state."', '".$zipCode."')"); if ($result) { $logged_in_user = $_POST[user]; session_register("logged_in_user"); echo "<div class='templine'>Your details have been added to the database, ".$_POST[user]."<BR><BR>"; echo "<div class='powerftp'><img src='images/arrow2.gif'>&nbsp;&nbsp;<A HREF='main.php'>My Account</A></div><BR>"; echo "<div class='powerftp'><img src='images/arrow2.gif'>&nbsp;&nbsp;<A HREF='logout.php'>logout</A></div>";         exit; } else { echo "<div class='templine'>Sorry, there has been a technical hitch. We cannot enter your details.</div>"; exit; } } else { echo "<div class='templine'>Sorry, that username has been taken. Please try another.<BR></div>"; } } else if ($_POST[user] || $_POST[pass]) { echo "<div class='templine'>Please fill in all fields..</div>"; } ?>[/code] Thanks. (edited by kenrbnsn to remove db login info)

Hi Trochia, Are you in love with this girl?

Hi Jesirose, don't try to be all that, I know you know how to run this script, sometime you will need from some one else and then you won't like if they told you to go read a topic and solve your problem by your self, thanks any way, I solved it a friend gave me what I need and now the script is runnig fine, here is the script: echo ("<meta http-equiv=\"Refresh\" content=\"2; URL=orderpstcards_main.php\"/>Thank You! You will be redirected");

I allready changed the line, but it gives me an error: Warning: Cannot modify header information - headers already sent by (output started at /home/digitalz/public_html/orderpstcards_login.php:10) in /home/digitalz/public_html/orderpstcards_login.php on line 85 here is the code, [code]<? $links = "<div class='quote'><img src='images/orange_arrow.gif'>&nbsp;&nbsp;<A HREF='main.php'>My Account</A></div><br> <div class='quote'><img src='images/orange_arrow.gif'>&nbsp;&nbsp;<A HREF='logout.php'>Logout</A></div><br>"; if ($_POST[user] && $_POST[pass]) {     if ($logged_in_user == $_POST[user]) { echo $_POST[user].", you are already logged in.<BR><BR>"; echo $links; exit; } $db = mysql_connect('localhost', $user = "digitalz_mario", $pass = "mario" ); mysql_select_db("digitalz_login", $db); $result = mysql_query("SELECT * FROM usersreg WHERE name = '".$_POST[user]."' AND password = PASSWORD('".$_POST[pass]."')"); if (!$result) { echo "Sorry, there has been a technical hitch. We cannot enter your details."; exit; } if (mysql_num_rows($result) > 0) { $logged_in_user = $_POST[user]; session_register("logged_in_user"); header('Location: orderpstcards_main.php'); exit; } else { echo "Invalid login. Please try again.<BR><BR>"; } } else if ($_POST[user] || $_POST[pass]) { echo "Please fill in both fields.<BR><BR>"; } ?>[/code] thanks in advance.

Hello, this script is what you got after you login, if is something wrong it gives you a message if somenthing wrong when you're login,  and if is ok it welcomes you and display 2 links, one to your account and another one to logout, how can I sent the visitor allready login to a different page without giving the welcome and the two links, just to a different page. thanks, here is the script. [code]<? if ($_POST[user] && $_POST[pass]) {       $db = mysql_connect('localhost', $user = "digitalz_mario", $pass = "mario" ); mysql_select_db("digitalz_login", $db); $result = mysql_query ("SELECT * FROM usersreg WHERE name = '".$_POST[user]."'"); if (mysql_num_rows($result) == 0) { $result = mysql_query ("INSERT INTO usersreg (name, password, company, email, address, city, state, zipCode) VALUES ('".$_POST[user]."', PASSWORD('".$_POST[pass]."'),'".$company."', '".$email."', '".$address."', '".$city."', '".$state."', '".$zipCode."')"); if ($result) { $logged_in_user = $_POST[user]; session_register("logged_in_user"); echo "Your details have been added to the database, ".$_POST[user]. "<BR><BR>"; echo "to upload files go to your account.<BR><BR>"; echo "<div class='quote'><img src='images/orange_arrow.gif'>&nbsp;&nbsp;<A HREF='main.php'>My Account</A></div><br>"; echo "<div class='quote'><img src='images/orange_arrow.gif'>&nbsp;&nbsp;<A HREF='logout.php'>Logout</A></div><br>"; exit; } else { echo "Sorry, there has been a technical hitch. We cannot enter your details."; exit; } } else { echo "Sorry, that username has been taken. Please try another.<BR>"; } } else if ($_POST[user] || $_POST[pass]) { echo "Please fill in all fields.."; } ?>[/code] Thanks.

THis is a set of JavaScript buttons that when you click one opens a set of scroll buttons with different links each, when I test it on a top of a .gif, works, but when I changed the .gif for a flash; this one covers the set of buttons, how can I make it work on top of flash, thanks, Mario.

THis is a set of JavaScript buttons that when you click one opens a set of scroll buttons with different links each, when I test it on a top of a .gif, works, but when I changed the .gif for a flash; this one covers the set of buttons, how can I make it work on top of flash, thanks, Mario.

thanks, I just add{} and is working. [code]mail($toAddress,$recipientSubject,$mailContent,"From:{$row['email']}");[/code]

thanks is working now.

Thanks for everything Alpine, here is what I'm talking about: [code]<? session_start(); // Is user logged in if ($logged_in_user){     // Connect to the database   $user="userregister";     $host="mysql103.secureserver.net";     $password="userregister";     $database = "userregister";     mysql_connect($host,$user,$password);     mysql_select_db($database);   // select and execute the query   $sql = "SELECT * FROM `usersreg` WHERE `name`= '$logged_in_user'";   $result = mysql_query($sql) or printerror($sql, mysql_error());   $row = mysql_fetch_array($result) or printerror($sql, mysql_error()); //grabs the POST variables and puts them into variables that we can use */ $Projectname=$_POST['Projectname']; $Duedate=$_POST['Duedate']; $Reference=$_POST['Reference']; $Copiesrequired=$_POST['Copiesrequired']; $Artworkprovided=$_POST['Artworkprovided']; $Flatsize=$_POST['Flatsize']; $Finishedsize=$_POST['Finishedsize']; $Stockforcolorcopies=$_POST['Stockforcolorcopies']; $Stockforbw=$_POST['Stockforbw']; $Printcoverson=$_POST['Printcoverson']; $Bworiginals=$_POST['Bworiginals']; $Bworiginalsare=$_POST['Bworiginalsare']; $Bwprint=$_POST['Bwprint']; $Collatebw=$_POST['Collatebw']; $Additionalbw=$_POST['Additionalbw']; $Filetype=$_POST['Filetype']; $Applicationtype=$_POST['Applicationtype'];   if($Copiesrequired){         }         else{             $error.="";             }     if($error==""){         echo "Thank you! A receipt of your submission will be e-mailed to you immediately."; $mailContent="--------Contact--------\n"             ."Projectname: ".$Projectname."\n"             ."Reference: ".$Reference."\n" ."Copiesrequired: ".$Copiesrequired."\n" ."Artworkprovided: ".$Artworkprovided."\n" ."Filetype: ".$Filetype."\n"             ."Applicationtype: ".$Applicationtype."\n";             $toAddress="upload@copymailforyou.com"; $subject="Copyroominc.com Upload Form";  $recipientSubject="Copyroominc.com Upload Form"; $receiptMessage = "Thank you ".$row['name']." Our Representative will contact you as soon as possible.\n\n\nHere is what you submitted to us:\n\n"             ."----------------\n"             ."Projectname: ".$Projectname."\n"             ."Reference: ".$Reference."\n" ."Copiesrequired: ".$Copiesrequired."\n" ."Artworkprovided: ".$Artworkprovided."\n" ."Filetype: ".$Filetype."\n"             ."Applicationtype: ".$Applicationtype."\n";             //---------------------------------- mail($row['email'], $subject, $receiptMessage,"From:$toAddress"); mail($toAddress,$recipientSubject,$mailContent,"From:$row['email']"); $connection=mysql_connect('mysql103.secureserver.net', $user = "quoteupload", $pass = "quoteupload") or die("Unable to connect!"); mysql_select_db("quoteupload") or die("Unable to select database!"); $query="INSERT INTO quoteupload ( Name, Company, Projectname, Duedate,  Reference, Copiesrequired, Artworkprovided, Flatsize, Finishedsize, Stockforcolorcopies, Stockforbw, Printcoverson, Bworiginals, Bworiginalsare, Bwprint, Collatebw, Additionalbw, Filetype, Applicationtype)         VALUES( '".$row['name']."', '".$row['company']."', '".$Projectname."', '".$Duedate."', '".$Reference."', '".$Copiesrequired."', '".$Artworkprovided."', '".$Flatsize."', '".$Finishedsize."', '".$Stockforcolorcopies."', '".$Stockforbw."', '".$Printcoverson."', '".$Bworiginals."', '".$Bworiginalsare."', '".$Bwprint."', '".$Collatebw."', '".$Additionalbw."', '".$Filetype."', '".$Applicationtype."')"; $result=mysql_query($query) or die("Error in query:".mysql_error()); mysql_close($connection);         } }     else{             print "Sorry, but the form cannot be sent until the fields indicated are filled out completely - <br>\n";             print "$error<br>\n";             print "<br>\n";             print "<br>\n";             print "Please use your \"Back\" button to return to the form to correct the omissions.  Thank you.<br>\n";         } ?>                           <?php include ("uploadclass.php"); $upload_class = new FileUpload; $upload_class->temp_file_name = trim($_FILES['upload']['tmp_name']); $upload_class->file_name = trim(strtolower($_FILES['upload']['name'])); $upload_class->upload_dir = "php_uploads/"; $upload_class->upload_log_dir = "php_uploads/upload_logs/"; $upload_class->max_file_size = 5242880; $upload_class->banned_array = array(""); $upload_class->ext_array = array(".zip",".rar",".ace",".tar",".jpg",".gif",".jpeg",".png",".xls",".pdf",".doc",".ppt"); $valid_ext = $upload_class->validate_extension(); $valid_size = $upload_class->validate_size(); $valid_user = $upload_class->validate_user(); $max_size = $upload_class->get_max_size(); $file_size = $upload_class->get_file_size(); $file_exists = $upload_class->existing_file();     if (!$valid_ext) {         $result = "The file extension is invalid, please try again!";     }     elseif (!$valid_size) {         $result = "The file size is invalid, please try again! The maximum file size is: $max_size and your file was: $file_size";     }     elseif (!$valid_user) {         $result = "You have been banned from uploading to this server.";     }     elseif ($file_exists) {         $result = "This file already exists on the server, please try again.";     } else {         $upload_file = $upload_class->upload_file_with_validation();         if (!$upload_file) {             $result = "Your file could not be uploaded!";         } else {             $result = "Your file has been successfully uploaded to the server.";         }     } echo $result; ?>[/code] This code is working fine, but in line 73 wich is this one [code]mail($toAddress,$recipientSubject,$mailContent,"From:$row['email']");[/code] I got this error: Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/content/m/a/r/mariocesar/html/qteuploadcode.php on line 73 Thanks

Please help, I got this message: Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/content/m/a/r/mariocesar/html/qteuploadcode.php on line 73 in this line: [code]<? mail($toAddress,$recipientSubject,$mailContent,"From:$row['email']"); ?>[/code] thanks.

thanks a lot, as I mentioned before I have to send a message to this e-mail saying that  I received their info and we received the file, now that I pull out the e-mail how can I send the message? thanks fo all

here this one is working but don't pull the e-mail info from the dbase [code]<?php // Create session session_start(); // Is user logged in if ($logged_in_user){   echo "You are login as, ".$logged_in_user.".";   // Connect to the database   $user="userregister";     $host="mysql103.secureserver.net";     $password="userregister";     $database = "userregister";     mysql_connect($host,$user,$password);     mysql_select_db($database);   // select and execute the query   $sql = "SELECT * FROM `usersreg` WHERE `name`= '$logged_in_user'";   $result = mysql_query($sql) or printerror($sql, mysql_error());   $row = mysql_fetch_array($result) or printerror($sql, mysql_error());   //then to grab the users email just do:   echo "An email was sent to {$result['email']} with the information."; } function printerror($code, $message){   echo "Couldn't run the following code: $code\n\nFailed with the following error: $message\n\n"; } ?>[/code]

I still got thia message: You are login as, Mario Balarezo.Couldn't run the following code: SELECT * FROM userregister WHERE name = 'Mario Balarezo' Failed with the following error: No Database Selected Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/m/a/r/mariocesar/html/getemail2.php on line 15 Couldn't run the following code: SELECT * FROM userregister WHERE name = 'Mario Balarezo' Failed with the following error: No Database Selected An email was sent to with the information. here is the code: [code]<?php // Create session session_start(); // Is user logged in if ($logged_in_user){   echo "You are login as, ".$logged_in_user.".";   // Connect to the database   mysql_connect("mysql103.secureserver.net", "userregister", "userregister");   // select and execute the query   $sql = "SELECT * FROM userregister WHERE name = '$logged_in_user'";   $result = mysql_query($sql) or printerror($sql, mysql_error());   $row = mysql_fetch_array($result) or printerror($sql, mysql_error());   //then to grab the users email just do:   echo "An email was sent to {$result['email']} with the information."; } function printerror($code, $message){   echo "Couldn't run the following code: $code\n\nFailed with the following error: $message\n\n"; } ?>[/code]

here is the code: [code]<?php // Create session session_start(); // Is user logged in if ($logged_in_user){   echo "You are login as, ".$logged_in_user.".";   // Connect to the database   mysql_connect("mysql103.secureserver.net", "userregister", "userregister");   // select and execute the query   $sql = SELECT * FROM userregister WHERE name = '$logged_in_user';   $result = mysql_query($sql) or printerror($sql, mysql_error());   $row = mysql_fetch_array($result) or printerror($sql, mysql_error());   //then to grab the users email just do:   echo "An email was sent to {$result['email']} with the information."; } function printerror($code, $message){   echo "Couldn't run the following code: $code\n\nFailed with the following error: $message\n\n"; } ?>[/code]

thanks, I changed and know is giving me this: Parse error: parse error, unexpected T_STRING in /home/content/m/a/r/mariocesar/html/getemail2.php on line 13

No Is not the full code, but I tryed to get the email from  the user register dbase now I have this message: You are login as, Mario Balarezo.Couldn't run the following code: SELECT * FROM 'userregister' WHERE 'name'= 'Mario Balarezo' Failed with the following error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''userregister' WHERE 'name'= 'Mario Balarezo'' at line 1 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/m/a/r/mariocesar/html/getemail2.php on line 15 Couldn't run the following code: SELECT * FROM 'userregister' WHERE 'name'= 'Mario Balarezo' Failed with the following error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ''userregister' WHERE 'name'= 'Mario Balarezo'' at line 1 An email was sent to with the information.