PHP - Problem With Apostrophes

i'm having problems with apostrophes causing an error on my contact form. I've tried stripslash and also str_replace but i can't get it to work. what am i doing wrong?

thanks 


Code: [Select]
<?php
if(isset($_POST['email'])) {
     
    // EDIT THE 2 LINES BELOW AS REQUIRED
    $email_to = "test@test.com";
    $email_subject = "test";
     
     
    function died($error) {
        // your error code can go here
        echo "We are very sorry, but there were error(s) found with the form you submitted. ";
        echo "These errors appear below.<br /><br />";
        echo $error."<br /><br />";
        echo "Please go back and fix these errors.<br /><br />";
        die();
    }
     
    // validation expected data exists
    if(!isset($_POST['contact_name']) ||
        !isset($_POST['last_name']) ||
        !isset($_POST['email']) ||
        !isset($_POST['telephone']) ||
        !isset($_POST['comments'])) {
        died('We are sorry, but there appears to be a problem with the form you submitted.');      
    }
    
    foreach($_POST['check'] as $value) { 
$check_msg .= "Checked: $value\n"; 
} 

    $contact_name = str_replace("'", "&#38;#039;", $contact_name); 
    $contact_name = $_POST['contact_name']; // required
    $last_name = $_POST['last_name']; // required
    $email_from = $_POST['email']; // required
    $telephone = $_POST['telephone']; // not required
    $comments = $_POST['comments']; // required
     
    $error_message = "";
    $email_exp = '/^[A-Za-z0-9._%-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$/';
  if(!preg_match($email_exp,$email_from)) {
    $error_message .= 'The Email Address you entered does not appear to be valid.<br />';
  }
    $string_exp = "/^[A-Za-z .'-]+$/";
    
  if(!preg_match($string_exp,$contact_name)) {
    $error_message .= 'The First Name you entered does not appear to be valid.<br />';
  }
  if(!preg_match($string_exp,$last_name)) {
    $error_message .= 'The Last Name you entered does not appear to be valid.<br />';
  }
  if(strlen($comments) < 2) {
    $error_message .= 'The Comments you entered do not appear to be valid.<br />';
  }
  if(strlen($error_message) > 0) {
    died($error_message);
  }
    $email_message = "Form details below.\n\n";
     
    function clean_string($string) {
      $bad = array("content-type","bcc:","to:","cc:","href");
      return str_replace($bad,"",$string);
    }
     
    $email_message .= "Contact Name: ".clean_string($contact_name)."\n";
    $email_message .= "Agency/Company Name: ".clean_string($last_name)."\n";
    $email_message .= "Email Address: ".clean_string($email_from)."\n";
    $email_message .= "Dates Required: ".clean_string($telephone)."\n";
    $email_message .= "Type Required: ".clean_string($check_msg)."\n";
    $email_message .= "Any other info: ".clean_string($comments)."\n";


     
     
// create email headers
$headers = 'From: '.$email_from."\r\n".
'Reply-To: '.$email_from."\r\n" .
'X-Mailer: PHP/' . phpversion();
@mail($email_to, $email_subject, $email_message, $headers); 
?>
 
thanks
 
<?php
}
?>

Hi there,   I am getting this in a PHP generated email:   ACWA Member/Subscriber: Melody’s Children’s Service   The line of code in the php is:     $subject = "ACWA Member/Subscriber: $membername";   I have tried htmlentitiies, html_entity_decode, htmlspecialchars but nothing seems to work.   I haven't used htmlentities anywhere else in the code for this variable.   Any suggestions?   All advice gratefully received.

Hello, im trying to update my database with a paragraph of text in a texbox.

The thing is my paragraph has apostrophes

Look:
Code: [Select]
In the run up to the return of the Wilderness, we've released a new wallpaper depicting a green dragon, plus a couple of 'getting started' guides about the Wilderness and free trade.
It doesn't want to update my table and it shows the old paragraph.

Here is how my update database looks like.

<?php
if (isset($_POST['Submit'])) { 
for($i=0;$i<$count;$i++){
$month = $_POST['month'];
$date = $_POST['date'];
$message = $_POST['message'];



$title = $_POST['title'];
$monthday = $month[$i]."<br>".$date[$i];
$sql1="UPDATE $tbl_name SET monthday='$monthday', month='$month[$i]', date='$date[$i]', message='$message[$i]', title='$title[$i]' WHERE id='$id[$i]'";
$result1 = mysql_query($sql1);
} 
header("location:update2.php");
}
?>


Can someone show me to to make it add the strip slashes to the $message variable.

Thanks Alot!

onlinegamekey. com/MTGT-Auction.php is the page I'm working on.

The problem I'm having is cards with an apostrophe in the name breaks the operation.

I am populating the Select Box with the Card Names and those are coming in fine, its not until I try to use the select value to get that specific card data do I have an issue.
This query specifically
Code: [Select]
$quer2=mysql_query("SELECT * FROM auctions WHERE Card_Name ='$cards' Order By Price_Per") or die;
I've tried
$quer2=mysql_query("SELECT * FROM auctions WHERE Card_Name =" . htmlspecialchars($cards) . " Order By Price_Per") or die;
but then I get no data for any card.

Here is the page code I'm working with.

Code: [Select]
<?php
$cards = $_POST['cards'];
//SELECTING DATA FOR THE DROPDOWN
$sql = "Select Card_Name From auctions Group BY Card_Name ASC" or die;
$result = mysql_query($sql);
?>
<script type="text/javascript">
<!--
var optList;
var optsValue = new Array();
var optsText = new Array();
//when the page loads get the original options values and text and store them in arrays
window.onload = function() {
optList = document.getElementsByTagName("option");
for(var i=0; i<optList.length; i++) {
     optsValue[i] = optList[i].value;
     optsText[i] = optList[i].text.toLowerCase();   
}   
}
function searchSel(txtSearch) {
//clear all the current options
document.getElementById("items").options.length = 0;
var count = 0;
for(var i=0; i < optsValue.length; i=i+1) {
    if(optsText[i].indexOf(txtSearch.toLowerCase()) == 0) {  //match found
         //add this option to the select list options
         var newOpt = new Option(optsValue[i],optsText[i],false,false);
         document.getElementById("items").options[count] = newOpt;
         count = count+1;
    }
    }
}
function reload(form)
{
var f1 = document.forms['f1']
var val=f1.cards.options[f1.cards.options.selectedIndex].value;
self.location='MTGT-Auction.php?card=' + val ;
}
//-->
</script>
<style type="text/css">
body {
background-color:#000000;
}
.row-one {
    background-color: #666666;
    font-family: Arial, Helvetica, sans-serif;
font-size:12px;
font-weight: bold;
    line-height: 17px;
    color:#CCFF33;
}
.row-two {
    background-color: #333333;
    font-family: Arial, Helvetica, sans-serif;
font-size:12px;
font-weight: bold;
    line-height: 17px;
    color: #FF0;
}
.th {
background-color:#000000;
font-family:Arial, Helvetica, sans-serif;
font-size:14px;
font-weight:bold;
color:#CC0000;
padding: 2;
}
</style>
<!-- CREATE FORM & SELECT BOX -->
<form method="post" name="f1" action="MTGT-Auction.php">
    <select name="cards" id="items">
    <option value='0'>Select...</option>
    <?php while ($row=mysql_fetch_array($result)) {
if ($row['Card_Name']==@$cards) {
echo "<option selected value='$row[Card_Name]'>$row[Card_Name]</option>";
} else {
echo "<option value='$row[Card_Name]'>$row[Card_Name]</option>";
}
}
 ?>
    </select>
    <br />
     <input type="text" id="txt" value="Card Name?" onfocus="this.value==this.defaultValue?this.value='' :null" onkeyup="searchSel(this.value);" style="color:#000000; font:Arial; font-size:12px; background-color:#e1e1e1;" />
     <BR />
<input type="submit" value="Submit" name="submit" />
                        <input type=button onClick="location.href='MTGT-Auction.php'" value='Reset' />
            </form>
            <!-- CREATE TABLE WHERE DATA GOES -->
<table border="1" bordercolor="#000000">
<tr align="center">
<th class="th">Auction ID</th>
<th class="th">Card Name</th>
<th class="th">Cards Per Auction</th>
<th class="th">Auction Price</th>
<th class="th">Cost Per Card</th>
<th class="th">Date Listed</th>
<th class="th">Seller Name</th>
</tr>
<?php
//GET DATA FOR TABLE BASED ON SELECTED CARD & LOOP THROUGH
$quer2=mysql_query("SELECT * FROM auctions WHERE Card_Name ='$cards' Order By Price_Per") or die;
$i =1;
WHILE($row = mysql_fetch_array($quer2)) { 
if ($i%2 !=0)
$rowColor = "class='row-one'";
else
$rowColor = "class='row-two'";
echo "<tr $rowColor>" . "<td>" . $row[Auction_ID] . "</td><td>" . $row[Card_Name] . "</td><td>" . $row[Qty_Listed] . "</td><td>" . $row[Price] . "</td><td>" . $row[Price_Per] . "</td><td>" . $row[Date] . "</td><td>" . $row[Seller] . "</td></tr>";
$i++;
}
//}
?>
<?php
//QUICK CHECK IS OUR VARIABLE SET???
echo "<font color=\"#FFFFFF\">". $cards . "</font>";
?>
</table>
I image this is probably a very common problem & easy fix that has been answered many times, but I haven't found any thing that worked for me so any help.. or links to similar issues would really be appreciated.

Thank you,

Guys thanks for helping me solve the problem i had but now i have another problem and i am lost. i have included the code below for you to have overview.

On the home page the url shows how it should be: http://localhost/board/italian.php?country=Italian
BUT 
When you mouse over the NEXT link to go to next page you get this : http://localhost/board/?page=1&country=Italian  and then an error 404 when you click on the link
page = 1  no matter if you are mousing over link for page 5 or 2

This is the code:

<table style="width:100%; margin-left:auto; margin-right:auto">
        <?php    
            
            $items_per_page = 5;//how many records/rows to display per page
                        
            $page_url      = "http://".$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'];
                                    
            $cleaned_current_page_country = htmlspecialchars($_GET["country"]);
                        
            $page_number = (isset($_GET['page']))? filter_var($_GET['page']) : 1;
            //$page_number = filter_var($_GET['page']);
            //$page_number = $_GET['page'];
                
            $selected_restaurant_type = $_GET['country'];
                                                            
            // find number of rows in the db
                $query = "SELECT * FROM menu_update WHERE special_of_theday = 1 AND restaurant_type = '".$selected_restaurant_type."' ";
                $query_result = mysqli_query($connection, $query); 
                $row_count = mysqli_fetch_array($query_result);
                $total_rows = mysqli_num_rows($query_result);
                                                
            $expected_number_of_pages = ceil($total_rows/$items_per_page); //expected number of pages 
                                                
            $page_position = (($page_number - 1) * $items_per_page); //get starting position to fetch record
                        
            //fetch a group of records using sql LIMIT clause
                $query = "SELECT * FROM menu_update WHERE special_of_theDay = 1 AND restaurant_type = '".$selected_restaurant_type."' LIMIT " .$page_position. ',' .$items_per_page;
                $query_result = mysqli_query($connection, $query);
        ?>
                        
            <table width="100%" border=0>
                <tr bgcolor = "#cccccc">
                    <td>Meal</td>
                    <td>Meal name</td>
                    <td>Meal Price</td>
                    <td>Order Now</td>
                    <td>Full Menu</td>
                    <td>Our Gallery</td>
                    <td>Find Us</td>
                    <td>Our Chef</td>
                    <td>Our Manager</td>
                </tr>
        <?php
                while($row_count = mysqli_fetch_array($query_result)){
                    echo "<tr>";
                        echo"
                            <td style ='width:200px; text-align:center; height:120px; background:#eaedf2'><a href='meal_fullPic.php'><img src= ".$row_count['img']." /></a></td>
                            <td style ='width:119px; text-align:center; height:120px; background:#eaedf2'> ".$row_count['meal_name']."</td>
                            <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'>".$row_count['price']."</td>
                            <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'><a href='order_processor.php'><img src= ".$row_count['order_now']." /></a></td>
                            <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'><a href='full_menu.php'><img src= ".$row_count['full_menu_img']." /></a></td>
                                    
                            <td style ='width:170px; text-align:center; height:120px; background:#eaedf2'><a href='restaurant_gallery.php'><img src= ".$row_count['restaurant_pic']." /></a></td>
                            <td style ='width:100px; text-align:center; height:120px; background:#eaedf2'><a href='restaurant_location.php'><img src= ".$row_count['location_pic']." /></a></td>
                            <td style ='width:119px; height:120px; background:#eaedf2'> ".$row_count['chef_name']."</td>
                            <td style ='width:119px; height:120px; background:#eaedf2'> ".$row_count['admin']."</td>
                        "; 
                    echo "</tr>";
                }
                mysqli_close($connection);
        ?>    
            </table>
        <div class="board_pagination">
        <?php
            //display the links to the pages
            for($current_page = 1; $current_page <= $expected_number_of_pages; $current_page++){
                 if ($page_number != $expected_number_of_pages){
                    $data = array(
                        'page' => $page_number,
                        'country' => $cleaned_current_page_country,
                    );
                    $the_query = http_build_query($data);
                    $page_url .= '?' . $the_query;
                    echo '<li><a href=" '.$the_query.' ">'.$current_page.'</a></li> ';
                }
            }
        ?>
        </div>
    </table>
 

Hello everyone

Just found this forum and really need some help. I'm trying to create a popup contact form for my product pages. I managed to get a php form from a random site and i cant get the form to pop up.

http://www.e-sol.co.uk/printer-scanner-copier.php

If someone could help i would be very grateful.

so i want to call my php file with a query string to select a record out of a XML file... im close but cant get the variable i pass to be the record selected..

example... index.php?auction=1

i highlighted in red, where it doesnt pick up the proper row


Code: [Select]
<?php
ini_set('display_errors', 1); 
error_reporting(E_ALL);

$auction = $_GET{auction}; 


// parse the xml
$xmlFileData = file_get_contents("items.xml");
$xmlData = new SimpleXMLElement($xmlFileData);

[color=red]$location = $xmlData->item[$auction];[/color]

//Retrieving the content from the selected item
$title = $location->title;
$value = $location->value;
$itemnumber = $location->itemnumber;
$description = $location->description;
$donatedby = $location->donatedby;
$image1 = $location->image1;
$image2 = $location->image2;
$image3 = $location->image3;
$image4 = $location->image4;
$image5 = $location->image5;
$image6 = $location->image6;
$image7 = $location->image7;
$image8 = $location->image8;

?>


<style>
.itemimages img {width: 10px; height: 10px;}
img.large {width: 100px; height: 100px;}
</style>
<script language="JavaScript" src="http://code.jquery.com/jquery-1.5.min.js" type="text/javascript"></script>
<script>
$().ready(function() {

$(".itemimages img").click(
$("#largepic").attr("src","this");
 });


});
</script>


<table border="1" cellpadding="10">
<tr>
<td valign="top">
<img src="<?php echo $image1 ?>" alt="" border="0" class="large" id="largepic"><br>
<div class="itemimages">
<?php 
// image 1
if (trim(''.$image1) != '') { 
echo "<img src='";
echo $image1;
echo "' alt='' border='0'/> ";
}
// image 2
if (trim(''.$image2) != '') { 
echo "<img src='";
echo $image2;
echo "' alt='' border='0'/> ";
}
// image 3
if (trim(''.$image3) != '') { 
echo "<img src='";
echo $image3;
echo "' alt='' border='0'/> ";
}
// image 4
if (trim(''.$image4) != '') { 
echo "<img src='";
echo $image4;
echo "' alt='' border='0'/> ";
}
// image 5
if (trim(''.$image5) != '') { 
echo "<img src='";
echo $image5;
echo "' alt='' border='0'/> ";
}
// image 6
if (trim(''.$image6) != '') { 
echo "<img src='";
echo $image6;
echo "' alt='' border='0'/> ";
}
// image 7
if (trim(''.$image7) != '') { 
echo "<img src='";
echo $image7;
echo "' alt='' border='0'/> ";
}
// image 8
if (trim(''.$image8) != '') { 
echo "<img src='";
echo $image8;
echo "' alt='' border='0'/> ";
}
?>
</div>


</td>
<td valign="top">

<?php echo $title ?><br>
Estimated Value: <?php echo $value ?><br>
Item Number: <?php echo $itemnumber ?><br><br>

<?php echo $description ?><br><br>

Donated by: <?php echo $donatedby ?><br>
</td>
</tr>
</table>

Hi,

I am trying to write in an existing excel file. But for some reason, I can't open the workbook (but I know I have made similar code work before). Here I am just pasting the code upto the error line

$filename="C:\\apache\\htdocs\\GAC2\\dload\\template.xls";
$excel = new COM("excel.application") or die("Unable to instanciate excel");
$excel->Visible = 1;
$excel->DisplayAlerts = 1;
try{
     $wkb = $excel->Workbooks->Open($filename);
}catch (Exception $e) {
     echo 'Caught exception: ',  $e->getMessage(), "\n";
}

//........ Later part of the code


This returns the following error
Code: [Select]
Caught exception:
Source: Microsoft Office Excel
Description: Unable to get the Open property of the Workbooks class

For record, the I have already validated the file location. And I have tried the following line instead without any positive result.
Code: [Select]
$filename="C:\apache\htdocs\GAC2\dload\template.xls";
Looking for any help please.

-Abd

I am trying to use the following code snippet to return values from a database with a "," after each value apart form the last one. At the moment for testing I have 2 rows with values 1 and 3

$totalRows_Recordset3    equals 2 (I echoed this to check)

$i=1;
  while($row_Recordset3 = mysql_fetch_assoc($Recordset3))
  {
    if($i < $totalRows_Recordset3)
    {
      $str = $str.$row_Recordset3['reading'].",";
      $i=$i+1;
    }
    else
    {
      $str = $str.$row_Recordset3['reading'];
      $i=$i+1;
    }
  } 

I get the number 3 which is the last value in the database, but I can't see why I don't get "1,3"

I am sure it is something simple but it just escapes me.

Thanks in advance for any help

Gordon

You may see a lot of things wrong with the code below, but please bring it to my attention! I'm trying to advance my knowledge on OOP, but I'm trying my best to get the basics down. The below code, after selecting the two characters to fight, the page returns nothing, just blank. I'm pretty sure the error lyes within class_li.php, but I'm not exactly sure.

Script is attached.

I have a simple text file called bio.txt:
Code: [Select]
wohlersr; Richie Wohlers; Intermediate; Four Aces
meyersg; Greg Meyers; Novice; Four Aces
I wrote a little script, to return the info for Greg Meyers if the user id is correct, or say "Member not found" if incorrect.  For some reason, my output is giving me both.  I assume it's a context error, but can't figure it out.

Here's my script:
Code: [Select]
<?php
$file=file("bio.txt");
$count=count($file);

$i=0;
while($i<=$count)
{
$row = explode(";", $file[$i]);

$id = $row[0];
$name = $row[1];
$class = $row[2];
$club = $row[3];

if($id=="meyersg"){
echo $name."</br>";
echo $class."</br>";
echo $club."</br>";
}else{
echo "Member not found.";
} 

$i++;
}

?>
And here's the output I'm getting:
Code: [Select]
Member not found. Greg Meyers
Novice
Four Aces
Member not found.

Hi there,

I have a map of America made in flash, where you click on a state and the page should display the SQL database information for that state in the HTML table - but instead all it shows is the first entry of the database regardless of which state you click and it doesn't display the 2 radio buttons.

My code is as follows

Flash Actionscript 3 (just showing one state)
Code: [Select]
function waClick(event:MouseEvent):void {
var waURL:URLRequest = new URLRequest("restaurants.php?state=Washington");
navigateToURL(waURL, "_self");
}
wa_btn.addEventListener(MouseEvent.CLICK, waClick);
PHP code

Code: [Select]
<?php
  include("mvfconnect.php");
  $theChoice = $_GET['state'];
  $query = "SELECT * FROM restaurants WHERE" .$theChoice;
  $result = @ mysql_query($query);
  if (!$result) {
   $message="Unfortunately we are having problems with this page, we promise to have it fixed as soon as possible";
    die($message);
  }
  $num = mysql_num_fields($result);
  $i=0;
  while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
   $show1=substr($row['state'],0,50)."...";
   $show2=substr($row['city'],0,50)."...";
   $show3=substr($row['rname'],0,50)."...";
   $show4=substr($row['address'],0,50)."...";
   $show5=substr($row['pnum'],0,50)."...";
   $show6=substr($row['web'],0,50)."...";
   $show7=substr($row['dishes'],0,50)."...";
   $show8=substr($row['dish_details'],0,50)."...";
   $show9=substr($row['challenges'],0,50)."...";
   $show10=substr($row['challenge_details'],0,50)."...";
   $show11=substr($row['youtube'],0,50)."...";
   $show12=substr($row['images'],0,50)."...";
   echo "<tr>".
          "<td>".$row['city']."</td>". 
          "<td>".$row['rname']."</td>".
          "<td>".$row['address']."</td>".
          "<td>".$row['pnum']."</td>". 
          "<td>".$row['web']."</td>".
          "<td>".$row['dishes']."</td>".
          "<td>".$row['challenges']."</td>". 
              "<td id='state".$i."' style='display:none'>".$row['state']."</td>".
          "<td id='city".$i."' style='display:none'>".$row['city']."</td>".
          "<td id='rname".$i."' style='display:none'>".$row['rname']."</td>".
          "<td id='address".$i."' style='display:none'>".$row['address']."</td>".
          "<td id='pnum".$i."' style='display:none'>".$row['pnum']."</td>".
          "<td id='web".$i."' style='display:none'>".$row['web']."</td>".
          "<td id='dishes".$i."' style='display:none'>".$row['dishes']."</td>".
          "<td id='dish_details".$i."' style='display:none'>".$row['dish_details']."</td>".
          "<td id='challenges".$i."' style='display:none'>".$row['challenges']."</td>".
          "<td id='challenge_details".$i."' style='display:none'>".$row['challenge_details']."</td>".
          "<td id='youtube".$i."' style='display:none'>".$row['youtube']."</td>".                 
                  "<td id='images".$i."' style='display:none'>".$row['images']."</td>".        
                  "<td><input type='radio' name='vid' id='vid".$i."' onclick='openVideo(".$i.")' /></td>".
          "<td><input type='radio' name='pic' id='pic".$i."' onclick='openImage(".$i.")' /></td>".
          "<td class='last'style='display:none'>".$show1." ".$show2." ".$show3." ".$show4." ".$show5." ".$show6."
                  ".$show7." ".$show8." ".$show9." ".$show10."</td>".
         "</tr>";
    $i++;
   }
?>

I have used this code before and it has worked fine, can someone please help me out! 

 
 

Okay, so i'm using the basic php mysql insert into function but I have a strange (or maybe not so strange, I just don't get it..) problem..

I have two columns (do you call them columns? I don't really know for sure, whatever things that are in a table whatsoever).

Name and Trailer.

EDIT: they are TEXT's if that matters

Name is really nothing important, just the name.
But I want to embed trailers.. If I embed the Megavideo code below:

Code: [Select]
<object width="400" height="300"><param name="movie" value="http://www.megavideo.com/v/8UZFURZQ2b55ada04d73ae65c726a5383b9ee9d9"></param><param name="allowFullScreen" value="true"></param><embed src="http://www.megavideo.com/v/8UZFURZQ2b55ada04d73ae65c726a5383b9ee9d9" type="application/x-shockwave-flash" allowfullscreen="true" width="400" height="300"></embed></object>
Everything works fine, no problems and no bullshit.

But.. if I for an example try to embed this one (NovaMov):

Code: [Select]
<iframe style='overflow: hidden; border: 0; width: 400px; height: 300px' src='http://embed.novamov.com/embed.php?width=400&height=300&v=xngq7u8yejwbt' scrolling='no'></iframe>
It doesn't work. It just doesn't insert. Is inserting an "iframe" a problem or something? I just don't get why the hell it would do this?

Does anyone know anything about this? If so i'd be eager and very thankful to hear why and how to fix it.

thanks in advance

Hi
I make 3 querys first Order by DESC, second RAND() and third ASC. Now I want that in the second query can't be the same ids (produgg_users.id) that already taken in the first. And in the third not the ids from first and second. Like I have it now the same users can show up in the RAND() and the ASC like in DESC. Here my Script so far:

$rs = mysql_query("select produgg_users.id, twitterUser, credits from produgg_users where twitterUser != '' and  
                produgg_users.id IN (select concat_ws(',', id) from produgg_users where credits > 0 and id != ".$usersClass->userID().") and produgg_users.id NOT IN (select concat_ws(',', followedID) from produgg_activity where followerID = '".$usersClass->userID()."') and produgg_users.id NOT IN (select concat_ws(',', userid) from produgg_featured) ORDER BY credits DESC LIMIT 10") or die(mysql_error()); 


$nr = @mysql_num_rows($rs);



if($nr != 0) {
    
    print "<p>Simply click <strong>get 1 point</strong> and you will automatically FOLLOW the USER and earn the credit!</p>";

print "<p><font color=\"#0066FF\">Top Members</font></p>";
    
    while($row=@mysql_fetch_object($rs))
    {

        $divLeft = '<div id="thediv_'.$row->id.'"><div style="float:left;width:400px;">';
        $divRight = '<div style="float:left;width:150px;">';
        $clearDiv = '<div style="clear:both;"></div>';

        print "$divLeft<img src=\"http://api.twitter.com/1/users/profile_image/".strip_tags($row->twitterUser)."?size=mini\" alt=\"\" />&nbsp;&nbsp;".strip_tags($row->twitterUser)."&nbsp;&nbsp;<font color=\"#999999\" size=\"1\">$row->credits&nbsp;Points</font></div>$divRight <a href='javascript:void(0);' id='vote_$row->id' class='getPoint'>Get 1 Point</a></div>$clearDiv<hr /></div>";
$z = 1;
    }
}

//Lucky Riders

$rs = mysql_query("select produgg_users.id, twitterUser, credits from produgg_users where twitterUser != '' and  
                produgg_users.id IN (select concat_ws(',', id) from produgg_users where credits > 0 and id != ".$usersClass->userID().") and produgg_users.id NOT IN (select concat_ws(',', followedID) from produgg_activity where followerID = '".$usersClass->userID()."') and produgg_users.id NOT IN (select concat_ws(',', userid) from produgg_featured) ORDER BY RAND() LIMIT 5") or die(mysql_error());    
$nr = @mysql_num_rows($rs);

if($nr != 0) {
    

print "<p><font color=\"#0066FF\">Lucky Riders</font></p>";
    
    while($row=@mysql_fetch_object($rs))
    {
        $divLeft = '<div id="thediv_'.$row->id.'"><div style="float:left;width:400px;">';
        $divRight = '<div style="float:left;width:150px;">';
        $clearDiv = '<div style="clear:both;"></div>';

        print "$divLeft<img src=\"http://api.twitter.com/1/users/profile_image/".strip_tags($row->twitterUser)."?size=mini\" alt=\"\" />&nbsp;&nbsp;".strip_tags($row->twitterUser)."&nbsp;&nbsp;<font color=\"#999999\" size=\"1\">$row->credits&nbsp;Points</font></div>$divRight <a href='javascript:void(0);' id='vote_$row->id' class='getPoint'>Get 1 Point</a></div>$clearDiv<hr /></div>";
$z = 1;
    }
}

//Lucky Riders

$rs = mysql_query("select produgg_users.id, twitterUser, credits from produgg_users where twitterUser != '' and  
                produgg_users.id IN (select concat_ws(',', id) from produgg_users where credits > 0 and id != ".$usersClass->userID().") and produgg_users.id NOT IN (select concat_ws(',', followedID) from produgg_activity where followerID = '".$usersClass->userID()."') and produgg_users.id NOT IN (select concat_ws(',', userid) from produgg_featured) ORDER BY credits ASC LIMIT 5") or die(mysql_error());    
$nr = @mysql_num_rows($rs);

if($nr != 0) {
    

print "<p><font color=\"#0066FF\">Last Rides</font></p>";
    
    while($row=@mysql_fetch_object($rs))
    {
        $divLeft = '<div id="thediv_'.$row->id.'"><div style="float:left;width:400px;">';
        $divRight = '<div style="float:left;width:150px;">';
        $clearDiv = '<div style="clear:both;"></div>';

        print "$divLeft<img src=\"http://api.twitter.com/1/users/profile_image/".strip_tags($row->twitterUser)."?size=mini\" alt=\"\" />&nbsp;&nbsp;".strip_tags($row->twitterUser)."&nbsp;&nbsp;<font color=\"#999999\" size=\"1\">$row->credits&nbsp;Points</font></div>$divRight <a href='javascript:void(0);' id='vote_$row->id' class='getPoint'>Get 1 Point</a></div>$clearDiv<hr /></div>";
$z = 1;
    }

}