[SOLVED] why can't call the information from the field called authorised

madspof · October 3, 2007

I have this login script which i want to only let authorised people sign in i have the database bit all setup and i no how to put the If function in but the thing is that when i try to call the authorised part from the database i get resource id#4

in the script i have not put the if statment in because i cannot get the script the call the authorised part form the database anyone know why i keep getting resourceid#4

here is it live www.deskfun.co.nr/halo 3 clan/

<?php
$message = "";
include "connect.php";
$username = $_POST["user"];
$password = $_POST["pass"];
      if (!$username) {
          header("Location: statuscheck.php?check=4"); exit;
      }
      if (!$password) {
          header("Location: statuscheck.php?check=4"); exit;
      }
$password = MD5($password);
           $issuchusername = mysql_query("SELECT * FROM members WHERE Gamertag = '$username'");
      $usernamelogin = mysql_num_rows($issuchusername);
      $auth1 = mysql_query("SELECT * FROM members WHERE Gamertag = '$username'");
      

	  if ($usernamelogin == 1) {

		  $issuchpassword = mysql_query("SELECT * FROM members WHERE Gamertag = '$username' AND Password = '$password'");
		  $passwordlogin = mysql_num_rows($issuchpassword);

	  
		  if ($passwordlogin == 1) {

			  $time = time();
			  $cookie_data = $username.'-'.$password;
			  if(setcookie ("cookie_info",$cookie_data, $time+1800)==TRUE) {
			  }
			  else {
				  $message .= "You computer does not support cookies. <BR> To view other pages after logged in you need to have cookies enabled.<BR>";
			  }

		  }
		  else {
			  $message .= "your password/username is incorrect";
			  exit;
		  }
	  }
	  else {
		  $message .= "your password/username is incorrect";
		  exit;
	  }
  
?>
<html>
<head>
<meta name="Microsoft Theme 2.00" content="Slate 011">
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 11">
<meta name=Originator content="Microsoft Word 11">
<link rel=File-List href="index_files/filelist.xml">
<link rel=Edit-Time-Data href="index_files/editdata.mso">

<title>Xxxxx Clan</title>

<style>
<!--
/* Font Definitions */
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;
mso-font-charset:0;
mso-generic-font-family:swiss;
mso-font-pitch:variable;
mso-font-signature:-1593833729 1073750107 16 0 415 0;}
@font-face
{font-family:Halo;
panose-1:0 0 0 0 0 0 0 0 0 0;
mso-font-charset:0;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:-2147483645 0 0 0 1 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:Verdana;
mso-fareast-font-family:"Times New Roman";
mso-bidi-font-family:"Times New Roman";
color:white;}
h1
{mso-style-next:Normal;
margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
mso-pagination:widow-orphan;
page-break-after:avoid;
mso-outline-level:1;
font-size:16.0pt;
font-family:Verdana;
mso-bidi-font-family:Arial;
color:white;
mso-font-kerning:16.0pt;
font-weight:bold;}
h2
{mso-style-next:Normal;
margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
mso-pagination:widow-orphan;
page-break-after:avoid;
mso-outline-level:2;
font-size:14.0pt;
font-family:Verdana;
mso-bidi-font-family:Arial;
color:white;
font-weight:normal;}
h3
{mso-style-next:Normal;
margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
mso-pagination:widow-orphan;
page-break-after:avoid;
mso-outline-level:3;
font-size:13.0pt;
font-family:Verdana;
mso-bidi-font-family:Arial;
color:white;
font-weight:normal;}
h4
{mso-style-next:Normal;
margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
mso-pagination:widow-orphan;
page-break-after:avoid;
mso-outline-level:4;
font-size:14.0pt;
font-family:Verdana;
color:white;
font-weight:normal;}
h5
{mso-style-next:Normal;
margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
mso-pagination:widow-orphan;
mso-outline-level:5;
font-size:13.0pt;
font-family:Verdana;
color:white;
font-weight:normal;}
h6
{mso-style-next:Normal;
margin-top:12.0pt;
margin-right:0cm;
margin-bottom:3.0pt;
margin-left:0cm;
mso-pagination:widow-orphan;
mso-outline-level:6;
font-size:11.0pt;
font-family:Verdana;
color:white;
font-weight:normal;}
a:link, span.MsoHyperlink
{color:#B6B04D;
text-decoration:underline;
text-underline:single;}
a:visited, span.MsoHyperlinkFollowed
{color:#707849;
text-decoration:underline;
text-underline:single;}
p
{font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p.style1, li.style1, div.style1
{mso-style-name:style1;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";
color:black;}
p.style2, li.style2, div.style2
{mso-style-name:style2;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";
color:white;}
span.style11
{mso-style-name:style11;
color:black;}
span.style21
{mso-style-name:style21;
color:white;}
@page Section1
{size:612.0pt 792.0pt;
margin:0cm 90.0pt 72.0pt 90.0pt;
mso-header-margin:35.4pt;
mso-footer-margin:35.4pt;
mso-paper-source:0;}
div.Section1
{page:Section1;}
.style1 {color: #FFFFFF}
.style3 {font-size: 24pt}
-->
</style>

</head>

<body bgcolor=white background="index_files/image001.gif" lang=EN-US
link="#B6B04D" vlink="#707849" style='tab-interval:36.0pt'>


<div class=Section1>

<p class=MsoNormal style='margin-right:-54.0pt'><span lang=EN-GB
style='mso-ansi-language:EN-GB'><o:p> </o:p></span></p>

<p class=MsoNormal><span lang=EN-GB style='mso-ansi-language:EN-GB'><o:p> </o:p></span></p>

<div align=center>

<table class=MsoTableTheme border=1 cellspacing=0 cellpadding=0
style='margin-left:.65pt;border-collapse:collapse;border:none;mso-border-alt:
solid #989898 .25pt;mso-yfti-tbllook:480;mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-border-insideh:.75pt solid #989898;mso-border-insidev:.75pt solid #989898'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;height:141.0pt;background-image:url("index_files/header_short.jpg");'>
  <td colspan=2 valign=top style='width:680.0pt;border:solid #989898 1.0pt;
  mso-border-alt:solid #989898 .25pt;mso-border-bottom-alt:solid #989898 .75pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:141.0pt'>
  <p class=MsoNormal align=center style='margin-top:0cm;margin-right:-9.75pt;
  margin-bottom:0cm;margin-left:-4.45pt;margin-bottom:.0001pt;text-align:center;
  text-indent:-9.0pt'><![if !vml]><![endif]><span lang=EN-GB style='mso-ansi-language:
  EN-GB'><![if !vml]><![endif]><o:p></o:p></span></p>
  <p class=MsoNormal align=center style='margin-top:0cm;margin-right:-9.75pt;
  margin-bottom:0cm;margin-left:-4.45pt;margin-bottom:.0001pt;text-align:center;
  text-indent:-9.0pt'><span lang=EN-GB style='mso-ansi-language:EN-GB'><o:p> </o:p></span></p>
  <p class=MsoNormal><span lang=EN-GB style='font-size:10.0pt;font-family:"Times New Roman";
  color:windowtext;mso-ansi-language:EN-GB'><o:p> </o:p></span></p>
  <p class=MsoNormal align=center style='text-align:center'><strong><span
  lang=EN-GB style='font-size:10.0pt;color:windowtext;mso-ansi-language:EN-GB'>XXXXXX</span></strong><span
  lang=EN-GB style='font-size:10.0pt;font-family:"Times New Roman";color:windowtext'>
  </span><strong><span style='font-family:Verdana'><o:p></o:p></span></strong></p>
  <p align=center style='text-align:center'><o:p> </o:p></p>
  <p align=center style='text-align:center'><span lang=EN-GB style='font-size:
  10.0pt;mso-ansi-language:EN-GB'><o:p> </o:p></span></p>
  <p align=center style='text-align:center'><strong><span lang=EN-GB
  style='font-size:10.0pt;mso-ansi-language:EN-GB'>Here to Finish the fight </span></strong><span
  lang=EN-GB style='font-size:10.0pt;mso-ansi-language:EN-GB'><o:p></o:p></span></p>
  </td>
</tr>
<tr bgcolor="#FFFFFF" style='mso-yfti-irow:1;height:14.5pt'>
  <td colspan=2 valign=top style='width:680.0pt;border:solid #989898 1.0pt;
  border-top:none;mso-border-top-alt:solid #989898 .75pt;mso-border-top-alt:
  .75pt;mso-border-left-alt:.25pt;mso-border-bottom-alt:.75pt;mso-border-right-alt:
  .25pt;mso-border-color-alt:#989898;mso-border-style-alt:solid;background:
  #000000;padding:0cm 5.4pt 0cm 5.4pt;height:14.5pt'>
  <p class=MsoNormal align=right style='text-align:right'><b style='mso-bidi-font-weight:
  normal'><span lang=EN-GB style='mso-ansi-language:EN-GB'><a href="index.html"><span
  style='color:white'>Menu</span></a>   <a href="members.php"><span
  style='color:white'>Members</span></a>   <a href="video's.php"><span
  style='color:white'>Video’s</span></a>    <a href="pictures.php"><span style='color:white'>Pictures</span></a><span
  class=style21>     </span></span></b>                         <a href="login.html" class="style1">Login</a>            <a href="video's.php"><span
  class=style21><o:p> </o:p></span></p>
  </td>
</tr>
<tr style='mso-yfti-irow:2;height:467.7pt'>
  <td width=747 valign=top style='width:549.75pt;border:solid #989898 1.0pt;
  border-top:none;mso-border-top-alt:solid #989898 .75pt;mso-border-alt:solid #989898 .75pt;
  mso-border-left-alt:solid #989898 .25pt;padding:0cm 5.4pt 0cm 5.4pt;
  height:467.7pt' background="index_files/bk2.jpg">
  <p class=MsoNormal style='margin-right:-9.1pt;text-indent:-4.75pt'><![if !vml]><![endif]><span lang=EN-GB style='mso-ansi-language:
  EN-GB'><!--[if gte vml 1]><v:shape id="_x0000_i1026" type="#_x0000_t75"
   style='width:562.5pt;height:466.5pt'>
   <v:imagedata src="index_files/image003.jpg" o:title="halo-3"/>
  </v:shape><![endif]--><![if !vml]><![endif]><o:p></o:p></span></p>
  <p><span class="style3"><span class="MsoNormal"><span lang=EN-GB style='mso-ansi-language:
  EN-GB'>
    <?php	
//message
echo $message;
echo $auth1;

  ?>
  </span></span></span><span
  style='font-size:10.0pt'><o:p><span class="MsoNormal">
  </span></o:p></span></p>
  </td>
  <td width=202 valign=top style='width:120.9pt;border-top:none;border-left:
  none;border-bottom:solid #989898 1.0pt;border-right:solid #989898 1.0pt;
  mso-border-top-alt:solid #989898 .75pt;mso-border-left-alt:solid #989898 .75pt;
  mso-border-alt:solid #989898 .75pt;mso-border-right-alt:solid #989898 .25pt;
  padding:0cm 5.4pt 0cm 5.4pt;height:467.7pt'>
  <p class=MsoNormal align=center style='margin-left:-14.4pt;text-align:center;
  text-indent:9.15pt'><u><span lang=EN-GB style='mso-ansi-language:EN-GB'>Clan
  Pictures<o:p></o:p></span></u></p>
  <p class=MsoNormal style='margin-top:0cm;margin-right:-5.4pt;margin-bottom:
  0cm;margin-left:-6.75pt;margin-bottom:.0001pt'><span lang=EN-GB
  style='mso-ansi-language:EN-GB'><o:p> </o:p></span></p>
  <p class=MsoNormal><span lang=EN-GB style='mso-ansi-language:EN-GB'><o:p> </o:p></span></p>
  <p class=MsoNormal style='margin-left:-14.4pt;text-indent:9.15pt'><u><span
  lang=EN-GB style='mso-ansi-language:EN-GB'><o:p><span style='text-decoration:
   none'> </span></o:p></span></u></p>
  </td>
</tr>
<tr style='mso-yfti-irow:3;mso-yfti-lastrow:yes'>
  <td colspan=2 valign=top style='width:680.0pt;border:solid #989898 1.0pt;
  border-top:none;mso-border-top-alt:solid #989898 .75pt;mso-border-alt:solid #989898 .25pt;
  mso-border-top-alt:solid #989898 .75pt;padding:0cm 5.4pt 0cm 5.4pt'>
  <p class=MsoNormal><span lang=EN-GB style='font-size:9.0pt;mso-ansi-language:
  EN-GB'>About us - Contact us - Copyright 2007<o:p></o:p></span></p>
  </td>
</tr>
</table>

</div>

<p class=MsoNormal><span lang=EN-GB style='mso-ansi-language:EN-GB'><o:p> </o:p></span></p>

</div>

</body>

</html>

wildteen88 · October 3, 2007

$auth1 will return 'resource id #4' because mysql_query only returns a result resource number which links to the returned record set. You will have to use mysql_fetch_assoc in order to get the data out of the record set.

Also why on earth are you using Word for creating a web page? Extremely bad idea! Puts in crap loads of invalid markup.

madspof · October 3, 2007

lol i know the only reason i used it "the used word being hte keyword" is beacuse i wanted to make a quick template and i am now using dreamweaver thanks for that anyway

madspof · October 3, 2007

so would i need something liek this because whe i use this it brings up ARRAY

   $auth = mysql_query("SELECT Authorised FROM members WHERE Gamertag = '$username'");
      $auth1 = mysql_fetch_assoc($auth);

wildteen88 · October 3, 2007

When you echo $athu1 you should use $auth1['Authorised']

madspof · October 3, 2007

oaky thanks

darkfreaks · October 3, 2007

please hit topic solved if this worked

Sign In

[SOLVED] why can't call the information from the field called authorised

Recommended Posts

madspof

Link to comment

Share on other sites

wildteen88

Link to comment

Share on other sites

madspof

Link to comment

Share on other sites

madspof

Link to comment

Share on other sites

wildteen88

Link to comment

Share on other sites

madspof

Link to comment

Share on other sites

darkfreaks

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information