$HTTP Question

Kudose

Could someone please direct me to a site that has a list of all $HTTP and $SERVER commands?

I have this script but it doesnt seem to work:


<? include('css.css');
include('top.php');
include('dbinfo.inc.php');
?>

<tr> 
          <td width=593 height=1 colspan=2><img src="/images/black.gif" width=100% height=1></td>
        </tr>
        <tr> 
          <td width=593 height=1 colspan=2><img src="/images/black.gif" width=100% height=1></td>
        </tr>
      </table>


  <table cellpadding="0" cellspacing="0" border="0" width="656" align="center">

		<tr>
			<td colspan="2" width="621" bgcolor="#000000"><img src="/images/spacer.gif" width=1 height=1 alt="" border="0"></td>
		</tr>
		<tr>
			<td colspan="2" width="621" bgcolor="#D1DADE"><img src="/images/spacer.gif" width=1 height=1 alt="" border="0"></td>
		</tr>
		<tr>
			<td colspan="2" width="621" bgcolor="#687B8C" valign="top">

			<table cellpadding="10" cellspacing="0" border="0" width="654">
    <tr> 
      <td width="318" valign="top"> <div align="center"></div>
        <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr> 
            <td bgcolor="#415369" width="465"><img src="/images/leftcorners_smallboxes.gif" alt="" border="0" width="32" height="32"> 
              <font face="Tahoma" color="#ffffff" size="4"><b>Registered Usernames</b></font></td>
          </tr>
          <tr> 
            <td bgcolor="#415369" height="120" width="465"><div align="center"> <?
$username = $HTTP_GET_VARS['username'];
$listquery = "select * from users where username='$username'"; 
$listresult = mysql_query($listquery); 
$users = $listresult;
if ($users > 0) { 
?>
                    <font face="tahoma" size="2" color="#FFFFFF"> 
                    That username has been taken.  Please try another.
                    <br>
                    </font> 
                    <?
} else {
?>
                    <font face="tahoma" size="2" color="#FFFFFF"> 
                    That username is not in use.
                    <br>
                    </font> 
                    <?
					}
?> 

 </div></td>
              </tr>
            </table>
            &nbsp; </td>
          <td width="296" valign="top"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
              <tr> 
                <td bgcolor="#415369" width="465"><img src="/images/leftcorners_smallboxes.gif" alt="" border="0" width="32" height="32"><b><font color="#ffffff" size="4" face="Tahoma">Members</font></b></td>
              </tr>
              <tr> 
                <td bgcolor="#415369" height="120" width="465"><div align="center"><font color="#FFFFFF" size="4" face="Tahoma"><a href="index.php">Login</a> 
                     <a href="register.php">Signup</a></font> </div></td>
              </tr>
            </table></td>
        </tr>
      </table>

			</td>
		</tr>

	</table>
	</td>
</tr>
</table>
<?
include('bottom.php');
?>

No matter what it returns username as taken. I have tried taking out the $HTTP and also trying $HTTP_POST_VARS['username']; but to no avail. Any help is always appreciated 🙂

sarahk

first up, you didn't need to post ALL that code. Here's the crux of the matter

$username = $HTTP_GET_VARS['username'];
$listquery = "select * from users where username='$username'"; 
//and you need this
echo "***$username***<br>\n***$listquery***<br>\n";

so, is username what you expect. if so, then that's not your problem.

if you run the query manually is it what you expect? copy and paste the query from the browser.

Use standard programming debugging techniques to identify your problem. You've stated that you think it is an HTTP problem when infact you don't know which line of code is letting you down.

Sphynx

At any rate, look here