Jump to content

MySQL and PHP trouble

moneybux

By moneybux
in Microsoft SQL - MSSQL

 Share

Recommended Posts

moneybux Newbie

moneybux

Posted
Posted

I don't know if this is the right spot but, I am going to try anyway. I am having trouble with my web site at http://www.moneybux.biz... Can someone help me out.. here is the code:

 

<?

 

if ($_GET["action"]=="logout") {

 

if(isset($_COOKIE["usNick"]) && isset($_COOKIE["usPass"]))

{

 

$HTTP_COOKIE_VARS["usNick"] = "";

setcookie(usNick,"x",time() - 7776000);

 

$HTTP_COOKIE_VARS["usPass"] = "";

setcookie(usPass,"x",time() - 7776000);

 

?>

 

<META HTTP-EQUIV="REFRESH" CONTENT="2;URL=index.php">

 

<? exit(); } } ?>

 

<html>

<head>

<title>Welcome to MoneyBux</title>

<link rel="stylesheet" type="text/css" href="estilo.css">

</head>

<body>

<center>

 

 

 

<tr>

<td>

<? include('header.php'); ?>

</td>

</tr>

 

 

 

<table width="900" cellpadding="0" cellspacing="0" align="center">

<tr>

<td bgcolor="#ffffff" align="center">

<div id="wrap"> <? include('menu.php'); ?> </div>

</td>

</tr>

</table>

 

 

<table bgcolor="#ffffff" width="900" cellpadding="0" cellspacing="0">

<tr>

<td>

<table width="450" cellpadding="0" cellspacing="0" align="left" style="padding:5px;">

<tr>

<td>

<p><font style="font-size:12px;" face="verdana">

    <b><font style="font-size:15px;">Members, Get Paid to Visit Websites!</font></b>

    <br>

    <br>

    <? include('config.php'); ?>

    <?

$sql = "SELECT * FROM tb_config WHERE item='click' and howmany='1'";

$result = mysql_query($sql);       

$row = mysql_fetch_array($result);

?>

 

    At MoneyBux, you get paid to click on ads and visit websites. The process is easy! You simply click a link and view a website for a few seconds to earn money. You can earn even more by referring friends.

    <br>

    <br>

    <b>Here is some of what YourOwnBux offers</b>

    <br>

    - Membership is FREE.<br>

    - Get paid to visit our advertiser's websites.<br>

    - Earn a very generous $<? echo $row["price"]; ?> per link clicked.<br>

    - Earn a very generous $

    <?

 

$sql = "SELECT * FROM tb_config WHERE item='referalclick' and howmany='1'";

$result = mysql_query($sql);       

$row = mysql_fetch_array($result);

 

echo $row["price"]; ?>

    for each website your referals view.<br>

    - Realtime reports of your earnings.<br>

    - Payment requests can be made every day and are processed through PayPal/Alertpay.<br>

    - The minimum payout is $

    <?

 

$sql = "SELECT * FROM tb_config WHERE item='payment' and howmany='1'";

$result = mysql_query($sql);       

$row = mysql_fetch_array($result);

 

echo $row["price"]; ?>

    .

    <br>

    <br>

    <a href="register.php"><b>Sign-up Now!</b></a>

    </font>     </p>

<p>NEWS!!</p>

<p>02/09/08-We are trying to get the site up and running. It is taking some time to get it going. Please come back in a few days if you want to sign up.. Thanks </p></td>

</tr>

</table>

 

 

<table width="450" cellpadding="0" cellspacing="0" align="left" style="padding:5px;">

<tr>

<td>

<font style="font-size:12px;" face="verdana">

<b><font style="font-size:15px;">Advertisers, Get Tons of Traffic!</font></b>

<br><br>

<? include("config.php"); ?>

<?

$sql = "SELECT * FROM tb_config WHERE item='hits' and howmany='1000'";

$result = mysql_query($sql);       

$row = mysql_fetch_array($result); ?>

 

Setting up and displaying your link for MoneyBux members to visit is fast and simple. We charge $

<?=

$row["price"]

 

?> per <?

 

$sql = "SELECT * FROM tb_config WHERE item='hits' and howmany='1000'";

$result = mysql_query($sql);       

$row = mysql_fetch_array($result);

echo $row["howmany"];

 

?> member visits and each visit will last at least 20 seconds.

Outside visits are unlimited and included within the price.

We will review your website and will have it active within 24 hours. <a href="advertise.php">More info...</a>

<br><br>

<form method="post" action="advertise.php">

 

<table>

<tr>

<td><font style="font-size:12px;" face="verdana">

Your PayPal E-mail: </td>

<td>

<input type="text" name="pemail" size="25" maxlength="100"> </td>

</tr>

<tr>

<td><font style="font-size:12px;" face="verdana">

Link's Text: </td>

<td>

<input type="text" name="description" size="25" maxlength="100"> </td>

</tr>

<tr>

<td><font style="font-size:12px;" face="verdana">

Link's URL (include http://): </td>

<td>

<input type="text" name="url" size="25" maxlength="150"> </td>

</tr>

<tr>

<td><font style="font-size:12px;" face="verdana">

Choose plan: </td>

<td>

<select name="plan">

<option value="<?

 

$sql = "SELECT * FROM tb_config WHERE item='hits' and howmany='1000'";

$result = mysql_query($sql);       

$row = mysql_fetch_array($result);

 

echo $row["howmany"];

 

?>"><?= $row["howmany"] ?> Member visits $<?= $row["price"] ?></option>

<option value="<?

 

$sql = "SELECT * FROM tb_config WHERE item='hits' and howmany='2000'";

$result = mysql_query($sql);       

$row = mysql_fetch_array($result);

 

echo $row["howmany"];

 

?>"><?= $row["howmany"] ?> Member visits $<?= $row["price"] ?></option>

<option value="<?

 

$sql = "SELECT * FROM tb_config WHERE item='hits' and howmany='3000'";

$result = mysql_query($sql);       

$row = mysql_fetch_array($result);

 

echo $row["howmany"];

 

?>"><?= $row["howmany"] ?> Member visits $<?= $row["price"] ?></option>

<option value="<?

 

$sql = "SELECT * FROM tb_config WHERE item='hits' and howmany='5000'";

$result = mysql_query($sql);       

$row = mysql_fetch_array($result);

 

echo $row["howmany"];

 

?>"><?= $row["howmany"] ?> Member visits $<?= $row["price"] ?></option>

<option value="<?

 

$sql = "SELECT * FROM tb_config WHERE item='hits' and howmany='10000'";

$result = mysql_query($sql);       

$row = mysql_fetch_array($result);

 

echo $row["howmany"];

 

?>"><?= $row["howmany"] ?> Member visits $<?= $row["price"] ?></option>

</select> </td>

</tr>

<tr>

<td><font style="font-size:12px;" face="verdana">

<b>Bold</b> Link ($2.00) </td>

<td><font style="font-size:12px;" face="verdana">

<input name="bold" type="checkbox" id="bold" value="1"> </td>

</tr>

<tr>

<td>

<font style="font-size:12px;" face="verdana">

Highlighted Link ($3.00) </td>

<td>

<input name="highlight" type="checkbox" id="bold" value="1"> </td>

</tr>

<tr>

<td><font size="2" face="verdana">

* Security Code:

</font> </td>

<td>

<input type="text" name="code" size="5" maxlength="5"><img src="image.php"> </td>

</tr>

</table>

 

<input type="submit" value="Procceed to payment">

</form>

</font> </td>

</tr>

</table>

 

 

</td>

</tr>

</table>

 

 

<table width="900" cellpadding="0" cellspacing="0">

<tr>

<td bgcolor="#ffffff">

<? include('menu1.php'); ?>

</td>

</tr>

</table>

 

</center>

 

</body>

</html>

 

All the $row = mysql_fetch_array($result); causing errors on my site and I would like to know why?

Link to comment
https://forums.phpfreaks.com/topic/95902-mysql-and-php-trouble/
Share on other sites
peranha Regular Member

peranha

Posted
Posted

Try this and see if it works

 

<?php

if ($_GET["action"]=="logout") {

if(isset($_COOKIE["usNick"]) && isset($_COOKIE["usPass"]))
{

$HTTP_COOKIE_VARS["usNick"] = "";
setcookie(usNick,"x",time() - 7776000);

$HTTP_COOKIE_VARS["usPass"] = "";
setcookie(usPass,"x",time() - 7776000);

?>

<META HTTP-EQUIV="REFRESH" CONTENT="2;URL=index.php">

<?php exit(); } } ?>

<html>
<head>
<title>Welcome to MoneyBux</title>
<link rel="stylesheet" type="text/css" href="estilo.css">
</head>
<body>
<center>



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



<table width="900" cellpadding="0" cellspacing="0" align="center">
   <tr>
      <td bgcolor="#ffffff" align="center">
      <div id="wrap">   <?php include('menu.php'); ?> </div>
      </td>
   </tr>
</table>


<table bgcolor="#ffffff" width="900" cellpadding="0" cellspacing="0">
   <tr>
      <td>
         <table width="450" cellpadding="0" cellspacing="0" align="left" style="padding:5px;">
            <tr>
               <td>
                  <p><font style="font-size:12px;" face="verdana">
                   <font style="font-size:15px;">Members, Get Paid to Visit Websites!</font>
                  

                  

                   <?php include('config.php'); ?>
                   <?php
                  $sql = "SELECT * FROM tb_config WHERE item='click' and howmany='1'";
                  $result = mysql_query($sql);       
                  $row = mysql_fetch_row($result);
                  ?>
                   
                   At MoneyBux, you get paid to click on ads and visit websites. The process is easy! You simply click a link and view a website for a few seconds to earn money. You can earn even more by referring friends.
                  

                  

                   Here is some of what YourOwnBux offers
                  

                   - Membership is FREE.

                   - Get paid to visit our advertiser's websites.

                   - Earn a very generous $<?php echo $row["price"]; ?> per link clicked.

                   - Earn a very generous $
                   <?php

                  $sql = "SELECT * FROM tb_config WHERE item='referalclick' and howmany='1'";
                  $result = mysql_query($sql);       
                  $row = mysql_fetch_row($result);

                   echo $row["price"]; ?>
                   for each website your referals view.

                   - Realtime reports of your earnings.

                   - Payment requests can be made every day and are processed through PayPal/Alertpay.

                   - The minimum payout is $
                   <?php

                  $sql = "SELECT * FROM tb_config WHERE item='payment' and howmany='1'";
                  $result = mysql_query($sql);       
                  $row = mysql_fetch_row($result);

                  echo $row["price"]; ?>
                   .
                  

                  

                   <a href="register.php">Sign-up Now![/url]
                   </font>                </p>
               <p>NEWS!!</p>
               <p>02/09/08-We are trying to get the site up and running. It is taking some time to get it going. Please come back in a few days if you want to sign up.. Thanks </p></td>
            </tr>
         </table>


         <table width="450" cellpadding="0" cellspacing="0" align="left" style="padding:5px;">
            <tr>
               <td>
                  <font style="font-size:12px;" face="verdana">
                  <font style="font-size:15px;">Advertisers, Get Tons of Traffic!</font>
                  


                  <?php include("config.php"); ?>
                  <?php
                  $sql = "SELECT * FROM tb_config WHERE item='hits' and howmany='1000'";
                  $result = mysql_query($sql);       
                  $row = mysql_fetch_row($result);                  ?>

                  Setting up and displaying your link for MoneyBux members to visit is fast and simple. We charge $
                  <?php=
                  $row["price"]

                  ?> per <?php

                  $sql = "SELECT * FROM tb_config WHERE item='hits' and howmany='1000'";
                  $result = mysql_query($sql);       
                  $row = mysql_fetch_row($result);
                  echo $row["howmany"];

                  ?> member visits and each visit will last at least 20 seconds.
                  Outside visits are unlimited and included within the price.
                  We will review your website and will have it active within 24 hours. <a href="advertise.php">More info...[/url]
                  


                  <form method="post" action="advertise.php">
                  
                  <table>
                     <tr>
                        <td><font style="font-size:12px;" face="verdana">
                           Your PayPal E-mail:                        </td>
                        <td>
                           <input type="text" name="pemail" size="25" maxlength="100">                        </td>
                     </tr>
                     <tr>
                        <td><font style="font-size:12px;" face="verdana">
                           Link's Text:                        </td>
                        <td>
                           <input type="text" name="description" size="25" maxlength="100">                        </td>
                     </tr>
                     <tr>
                        <td><font style="font-size:12px;" face="verdana">
                           Link's URL (include http://):                        </td>
                        <td>
                           <input type="text" name="url" size="25" maxlength="150">                        </td>
                     </tr>
                     <tr>
                        <td><font style="font-size:12px;" face="verdana">
                           Choose plan:                        </td>
                        <td>
                           <select name="plan">
                           <option value="<?php

                           $sql = "SELECT * FROM tb_config WHERE item='hits' and howmany='1000'";
                           $result = mysql_query($sql);       
                           $row = mysql_fetch_row($result);

                           echo $row["howmany"];

                           ?>"><?php= $row["howmany"] ?> Member visits $<?php= $row["price"] ?></option>
                           <option value="<?php

                           $sql = "SELECT * FROM tb_config WHERE item='hits' and howmany='2000'";
                           $result = mysql_query($sql);       
                           $row = mysql_fetch_row($result);

                           echo $row["howmany"];

                           ?>"><?php= $row["howmany"] ?> Member visits $<?php= $row["price"] ?></option>
                           <option value="<?php

                           $sql = "SELECT * FROM tb_config WHERE item='hits' and howmany='3000'";
                           $result = mysql_query($sql);       
                           $row = mysql_fetch_row($result);

                           echo $row["howmany"];

                           ?>"><?php= $row["howmany"] ?> Member visits $<?php= $row["price"] ?></option>
                           <option value="<?php

                           $sql = "SELECT * FROM tb_config WHERE item='hits' and howmany='5000'";
                           $result = mysql_query($sql);       
                           $row = mysql_fetch_row($result);

                           echo $row["howmany"];

                           ?>"><?php= $row["howmany"] ?> Member visits $<?php= $row["price"] ?></option>
                           <option value="<?php

                           $sql = "SELECT * FROM tb_config WHERE item='hits' and howmany='10000'";
                           $result = mysql_query($sql);       
                           $row = mysql_fetch_row($result);

                           echo $row["howmany"];

                           ?>"><?php= $row["howmany"] ?> Member visits $<?php= $row["price"] ?></option>
                           </select>                        </td>
                     </tr>
                     <tr>
                        <td><font style="font-size:12px;" face="verdana">
                           Bold Link ($2.00)                        </td>
                        <td><font style="font-size:12px;" face="verdana">
                           <input name="bold" type="checkbox" id="bold" value="1">                        </td>
                     </tr>
                     <tr>
                        <td>
                           <font style="font-size:12px;" face="verdana">
                           Highlighted Link ($3.00)                        </td>
                        <td>
                           <input name="highlight" type="checkbox" id="bold" value="1">                        </td>
                     </tr>
                     <tr>
                        <td><font size="2" face="verdana">   
                           * Security Code:
                           </font>                        </td>
                        <td>
                           <input type="text" name="code" size="5" maxlength="5"><img src="image.php">                        </td>
                     </tr>
                  </table>

                  <input type="submit" value="Procceed to payment">
                  </form>
                  </font>               </td>
            </tr>
         </table>


      </td>
   </tr>
</table>


<table width="900" cellpadding="0" cellspacing="0">
   <tr>
      <td bgcolor="#ffffff">
         <?php include('menu1.php'); ?>
      </td>
   </tr>
</table>

</center>

</body>
</html>

Link to comment
https://forums.phpfreaks.com/topic/95902-mysql-and-php-trouble/#findComment-491005
Share on other sites
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.