Databases
StackOverflow2013
Postsdbo
POmysql_num_rows(): supplied argument is not a valid MySQL result resource Warning
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POmysql_num_rows(): supplied argument is not a valid MySQL result resource Warning
    text
    copied!<p>The problem is as follows:</p> <pre><code>Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a2138233/public_html/etc/e.conf/sys.proc/proc.reg/use.register.php on line 113 </code></pre> <p>Here's Line 113 of use.register.php:</p> <pre><code> $sql_email_check = mysql_query("SELECT uMail FROM eusers WHERE uMail='$rmail' "); $email_check = mysql_num_rows($sql_email_check); </code></pre> <p>Here's The Variable Set For "$rmail":</p> <pre><code>$rmail = mysql_real_escape_string(strip_tags($_POST['rmail'])); </code></pre> <p>Here's the HTML line:</p> <pre><code> &lt;input type="text" class="umail" id="ftxti" name="rmail" placeholder='email@server.com' style="width: 530px;" &gt; </code></pre> <p>Full code:</p> <pre><code>&lt;?php $mysql_host = ""; $mysql_database = ""; $mysql_user = ""; $mysql_password = ""; $link = mysql_connect($mysql_host, $mysql_user, $mysql_password, $mysql_database); mysql_select_db("tmpu"); ?&gt; &lt;?php if(isset($_POST['register'])){ //set form variables $rmail = mysql_real_escape_string(strip_tags($_POST['rmail'])); $fname = mysql_real_escape_string(strip_tags($_POST['fname'])); $lname = mysql_real_escape_string(strip_tags($_POST['lname'])); $rname = mysql_real_escape_string(strip_tags($_POST['rname'])); $rpass = mysql_real_escape_string(strip_tags($_POST['rpass'])); $vpass = mysql_real_escape_string(strip_tags($_POST['vpass'])); if(isset($_POST['gender'])){ $rgen = mysql_real_escape_string(strip_tags($_POST['gender'])); } if(isset($_POST['dobm'])){ $dobm = mysql_real_escape_string(strip_tags($_POST['dobm'])); } if(isset($_POST['$dobd'])){ $dobd = mysql_real_escape_string(strip_tags($_POST['dobd'])); } if(isset($_POST['doby'])){ $doby = mysql_real_escape_string(strip_tags($_POST['doby'])); } if(isset($_POST['TOS'])){ $TOS = mysql_real_escape_string(strip_tags($_POST['TOS'])); } $dab = $doby.$dobm.$dobd; //check empty feilds $error = FALSE; if(empty($rmail)){ $error = TRUE; $eh = "&lt;div class=em&gt; Please enter an &lt;b&gt;Email Adress&lt;/b&gt; to reach you from. This email will be used to Verify your acctount and activate it. &lt;/div&gt;"; } if(!empty($rmail)){ if(!preg_match("/^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$/", $rmail)){ $error = TRUE; $eh1 = "&lt;div class=em&gt; This is not a valid email... &lt;/div&gt;"; }} if(empty($fname) &amp;&amp; empty($lname)){ $error = TRUE; $eh2 = "&lt;div class=em&gt; Please enter your &lt;b&gt; First &lt;/b&gt; and &lt;b&gt; Last &lt;/b&gt; name. &lt;/div&gt;"; } if(!empty($fname)){ if(empty($lname)){ $error = TRUE; $eh3 = "&lt;div class=em&gt; Please enter a &lt;b&gt; Last &lt;/b&gt; name. &lt;/div&gt;"; } } if(!empty($lname)){ if(empty($fname)){ $error = TRUE; $eh4 = "&lt;div class=em&gt; Please enter a &lt;b&gt; First &lt;/b&gt; name. &lt;/div&gt;"; } } if(empty($rname)){ $error = TRUE; $eh5 = "&lt;div class=em&gt; Please enter a &lt;b&gt;Username&lt;/b&gt;. This will be used as your ewotty display name, You can Change it at anytime. &lt;/div&gt;"; } if(empty($rpass)){ $error = TRUE; $eh6 = "&lt;div class=em&gt; Please enter a &lt;b&gt;Password&lt;/b&gt;. This will be used to login to your account, Do not give it to anyone!&lt;/div&gt;"; } if($vpass != $rpass){ $error = TRUE; $eh7 = "&lt;div class=em&gt; Your Password Verifications Did nont match, Please try again. This is to help you make sure you entered the right password.&lt;/div&gt;"; } if(empty($dobm) &amp;&amp; empty($dobd) &amp;&amp; empty($doby)){ $error = TRUE; $eh8 = "&lt;div class=em&gt; Please Your valid &lt;b&gt;Birthday&lt;/b&gt;. &lt;/div&gt;"; } if(strlen($rname) &gt;15){ $error = TRUE; $eh9 = "&lt;div class=em&gt; Your username is too long. (Max 15 char)&lt;/div&gt;"; } $sql_email_check = mysql_query("SELECT uMail FROM eusers WHERE uMail='$rmail' "); $email_check = mysql_num_rows($sql_email_check); var_dump($sql_email_check); var_dump($rmail); if ($email_check &gt; 0){ $error = TRUE; $eh10 = "&lt;div class=em&gt; The &lt;b&gt;email: $rmail &lt;/b&gt; is already in use, Please register another.&lt;/div&gt;"; } $sql_tmpemail_check = mysql_query("SELECT uMail FROM tmpu WHERE uMail='$rmail'"); $tmpemail_check = mysql_num_rows($sql_tmpemail_check); if ($tmpemail_check &gt; 0){ $error = TRUE; $eh11 = "&lt;div class=em&gt; The &lt;b&gt;email: $rmail &lt;/b&gt; is already being registered.&lt;/div&gt;"; } $sql_user_check = mysql_query("SELECT uName FROM eusers WHERE uName='$rname'"); $user_check = mysql_num_rows($sql_user_check); if ($user_check &gt; 0){ $error = TRUE; $eh12 = "&lt;div class=em&gt; The &lt;b&gt;username: $rname&lt;/b&gt; is already in use by another user. Try another.&lt;/div&gt;"; } $sql_tmpuser_check = mysql_query("SELECT uName FROM tmpu WHERE uName='$rname'"); $tmpuser_check = mysql_num_rows($sql_tmpuser_check); if ($tmpuser_check &gt; 0){ $error = TRUE; $eh13 = "&lt;div class=em&gt; The &lt;b&gt;username: $rname&lt;/b&gt; is already being registered.&lt;/div&gt;"; } if(empty($tos)){ $error = TRUE; $ehTOS = "&lt;div class=em&gt; You did not agree to our &lt;a href=#&gt;TOS&lt;/a&gt; &lt;/div&gt;"; } /* display Error message if problem exists */ if($error == TRUE) { echo "&lt;style type='text/css'&gt;#ers{display: block;}&lt;/style&gt;"; }else{ echo "&lt;style type='text/css'&gt;#ers{display: none;}&lt;/style&gt;"; echo "&lt;style type='text/css'&gt;#srs{display: block;}&lt;/style&gt;"; $act = md5(crypt($umail)); $hash = mysql_real_escape_string(strip_tags(md5(crypt($rmail,$eupass)))); $verf = mysql_real_escape_string(strip_tags(md5(crypt($eupass)))); $eupass = strip_tags(md5(md5($rpass))); mysql_query("INSERT INTO tmpu ( uName, fName, lName, uMail, uPass, uDob, uAct, hash, verif) VALUES ( '$rname', '$fname', '$lname', '$rmail', '$eupass','$dab', '$act', '$hash','$verf' )") or die (mysql_error()); // ---------------- SEND MAIL FORM ---------------- $webmaster = "noreply@ewotty.cu.cc"; $to = $rmail; $subject = "ewotty activation"; $header = "From: Ewotty &lt;$webmaster&gt;"; $message = " Hello $fname \r Welcome to ewotty cloud community, You are atempting to register a new account with us, But to complete your registeration you will need to verify your account with the verfication link provided to you bellow. Once you've click this link and no errors have accured in the procces, You will be shown a green check to notate a successful registeration.\r Instructions: once you see the green check mark, do not navigate from page wait till the page redirects in about 3-4 seconds to the homepage If the page dose not redirect, you will be provided a maual redirect at the bottom of the screen. \r Here's the link you will need to activate your ewotty account: \r http://www.ewotty.cu.cc/activation/?ui=$act&amp;acthash=$hash&amp;verif=$verf"; mail($to, $subject, $message, $header); }}; </code></pre> <p>?></p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload