PHP - Problems With An Array

i have a users online section and i am using an aray and implode so the comma is displayed on every username but the last, but it displays the same usernames several times. This could be due to the switch i am using to define user group. Heres the code:

$online_query = $db->query("SELECT user_id, user_group, user_username
                            FROM ".DB_PREFIX."sessions");
while ($online_info = mysql_fetch_object($online_query)) {

switch($online_info->user_group)
        {
            case 1:
                $userClass = 'admin';
                break;
            case 2:
                $userClass = 'mod';
                break;
            case 3:
            case 0:
            default:
                $userClass = 'user';
                break;
        }

$users2[] = "<span class=\"{$userClass}\">{$online_info->user_username}</span>"; 

echo '<p>' . implode(', ', $users2) . '</p>';
}

is there something i am doing wrong?

Hello,   Can anyone tell me what I'm doing wrong here?  I am trying to run a query against a table for scenes from movies.  Each movie would have up to 8 scenes.  For the life of me I can't get this loop to work.  The movie id is being passed in the url, tested to make sure it's being passed and it is.  The code is pasted below. 

require_once ('../mysqli_connect.php');

$movie_id = $_GET['movie_id'];

$q = "SELECT * FROM scenes WHERE movie_id = $movie_id";

$r = @mysqli_fetch_array($dbc, $q);

$row = @mysqli_fetch_array($r, MYSQLI_ASSOC);

while ($row = @mysqli_fetch_array($r, MYSQLI_ASSOC));{
 
echo '<a href=" '.$row['scene_id'].'.mp4 ">'.$row['scene_name'].'</a>';}

In advance thanks a million!!
Edited by Zane, 28 May 2014 - 10:01 AM.

I have a db table with 1500 street names inside - id, tfare, ptown, pcode, area.

The 'area' column is specific to the company i work for and each street belongs to an 'area' number defined by the company.

Currently each area is '0' - unassigned. The company areas are numbered 1 - 18. I need to list each street (LIMIT 10 at a time), and have an input box for the area to be edited and saved.

The following code works perfectly well when dealing with 1 record at a time (LIMIT 0, 1), but breaks when i change the LIMIT to 10.

I'm trying to show the dinosaur management that we need to upgrade our paper, yes, paper system to computers. I'm a transport manager, but in my spare time since 2004 I'm fluent in HTML and CSS, but only in the last few months really decided to give PHP and MySQL a *real* go.

I'm 'guessing' I need to look into arrays for this to work? I've tried searching about but I dont even know how to articulate what i need to search for, so I have to publicly ask for help via this long winded post, sorry

Here is my code:



<?php

include($_SERVER['DOCUMENT_ROOT'].'/!SYSTEM/bootstrap.php');

if(isset($_POST['savearea']))
{
    $id = $_POST['hideID'];
    $area = $_POST['area'];
   
    $sql = "UPDATE bmth_streetindex SET area='$area' WHERE id='$id'";
   
    if ($query = mysql_query($sql)or die(mysql_error()))
        {
         print "saved ???";
        }
}

    // grab data from bmth street index where the area is = 0 (which means its area is un-assigned)
    $sql = "SELECT * FROM bmth_streetindex WHERE area='0' LIMIT 0, 10";
    $rs = mysql_query($sql) or die(mysql_error());


print $HTML::form('action="" name="inputAreaForm" method="POST"')."\n\n";
   
    // 'while' thru and print them 1 at a time
    while($row = mysql_fetch_array($rs))
    {
        $id = $row['id'];
        $tfare = $row['tfare'];
        $ptown = $row['ptown'];
        $pcode = $row['pcode'];
        $area = $row['area'];
        $urlQ = $tfare. ", " .$ptown. ', ' .$pcode;
       
        print "<div>\n";
       
            print "\n<input type=\"hidden\" name=\"hideID\" value=\"$id\">";
           
            print "\n[$id] $tfare, $ptown, $pcode &nbsp;&nbsp;&nbsp;";
            print "\nArea <input type=\"text\" name=\"area\" value=\"$area\" />";
            print "\n<input type=\"submit\" name=\"savearea\" value=\"Save Area\">";
           
            print "\n<a href=\"http://www.google.com/maps?q=$urlQ&hl=en&ie=UTF8&z=17\" target=new>SHOW ON MAP</a>";
           
        print "\n<>\n<hr>\n\n";
    }

print $HTML::endForm();


?>




Thank you for taking the tie to read this, I hope someone can point me in the right direction for what i need to look into making this work

I'd like some help debuging my code, I can't seem to figure out why it isn't creating the variables... Here it is:


<?php
$template_settings = array(
"index"=>"index.php",
"announcements"=>"announcements.php"
);

extract($template_settings, EXTR_PREFIX_ALL, "template_");
echo $template_index;
?>


No matter what I do $template_index still equals null and I'm wondering what I'm doing wrong. There are no errors of anykind.

Having problem with a bit of code.   I am trying to fetch data from the database, I have used mysql_fetch_array before, and even in later bits of code.  I want to use this data for an IF statement later on.  The IF statement isn't there, because this code is catching somewhere.  The fetch array is working fine, and it echos out the correct row in database that it should.  The issue, it stops displaying code that follows it.   

In the code, I have put a comment (// Code kills here ....) where the code is killing.  I have identified the few lines of code that is killing the script.

You can see the page.. The number 71 is what is supposed to be supplied by the query and array.  This is the page as it is with the trouble code. 



Here is the page without the trouble bit of code, and it displays all that it should.  But it doesn't have the functionality I want to build in with the array obviously.




Here is the code with highlight bit of trouble:

/source/userinfo.php
Code: [Select]
<?php
include ("db.php");


$get_info = mysql_query ("SELECT * FROM registrations WHERE u_id=$uid AND appid=$appid" , $link2);

//Begin Trouble Code

while ($check = mysql_fetch_array($get_info))
{

echo $check['assign_id'];

}

//End Trouble Code

// Code kills here, for some reason....  Proper assign_id displayed, but it kills script.




$count = mysql_num_rows($get_info);


if ($count >= 1)

{

$get_jos_info = mysql_query ("SELECT * FROM jos_users WHERE id=$appid" , $link);

$get_avatar = mysql_query ("SELECT * FROM jos_comprofiler WHERE user_id=$appid" , $link);


while ($avatar_link = mysql_fetch_array($get_avatar))

$avatarurl = $avatar_link['avatar'];

echo $avatar_link['avatar'];
echo "<table border='0' width='70%' align='center' cellpadding=5>";
 
while ($rowteam = mysql_fetch_array($get_info))
{

while ($rowjos = mysql_fetch_array($get_jos_info))
{
$urlbegin = "<img src='http://versionxlegends.com/images/comprofiler/tn";
$urlend =  "'>";

echo "<tr><td width=100% align=center colspan=2>".$urlbegin.$avatarurl.$urlend."</td></tr>";

echo $avatar;




echo "<tr><td width=40% align=right><strong>Registration #</strong></td><td width=60% align=center>$rowjos[id]</td></tr>";

echo "<tr><td width=40% align=right><strong>User's Username</strong></td><td width=60% align=center>$rowteam[username]</td></tr>";

echo "<tr><td width=40% align=right><strong>User's Name</strong></td><td width=60% align=center>$rowteam[name]</td></tr>";

echo "<tr><td width=40% align=right><strong>Provided Skype Username</strong></td><td width=60% align=center>$rowteam[skype]</td></tr>";

//Add script for lead only view Email Address.  Team Member, field is hidden.  Lead sees email and a YES/NO if email matches.  If not, lead will email user to get email verification, to edit account before assignments occur.

echo "<tr><td width=40% align=right><strong>E-Mail Address</strong></td><td width=60% align=center>$rowteam[email]</td></tr>";

echo "<tr><td width=40% align=right><strong>Registration Date</strong></td><td width=60% align=center>$rowjos[registerDate]</td></tr>";

// Add script for lead only view age.  Team Member, field is hidden.  Lead sees birthdate and/or age and a YES/NO if age matches.  If not, lead will email user with ID verification e-mail, to verify age before assignments occur.
echo "<tr><td width=40% align=right><strong>Age</strong></td><td width=60% align=center>$rowteam[age]</td></tr>";





}}


echo "</table>"; 

}
else

{ 

echo "Invalid URL.  Registration does not exist";

}



?>
This code is included within this page:

viewregistration.php

Code: [Select]
<?php 
session_start();

 $user_id = $_SESSION['user_id']; 
 $uid = $_GET['u_id']; 
 $appid= $_GET['appid'];

include ("db.php");

$get = mysql_query ("SELECT * FROM registrations WHERE u_id = $uid AND appid=$appid", $link2);

echo $get;

 ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252" />
<title>Nuke Ice By ThemeKings</title>
<link rel="stylesheet" type="text/css" href="nuke-ice.css" />







</head>
<body>
<div id="wrapper">


<div id="banner">
<div id="banner-edit"></div>
</div>


<div id="container">


<?php
include ("sidebar.php");

?>




<div id="col-2">
<?php
$uid = $_GET['uid']; 
$appid= $_GET['appid'];
 
?>

<div class="CntBox">
<div class="CntHead">
<div class="CntHeadInfo">User Information</div>
</div>
<div class="CntFill">
       
<div class="CntInfo">
<?php  include ("./source/userinfo.php");

 ?>
</div>
</div>
<div class="CntFooter"></div>
</div>
I included this bit of code so you can see some of the variables that were assigned in another file.