PHP - While Loop Through Sku Codes Not Working

It's only displaying the first result and not the others. What am I doing wrong?
I'm selecting the items the user occupies.
Then I'm selecting the name and image of that item from the item table.

Code: [Select]
echo "<table cellspacing=\"0\" class=\"news\" align=\"center\">";
echo "<tr>";
$sql = "SELECT * FROM useritems WHERE userid='".$_SESSION['userid']."' LIMIT $offset, $rowsperpage"; //selects all the users items to whoever is logged in
$result = mysqli_query($cxn,$sql) or die(mysqli_erro($cxn));
$imagecount = 0;
while ($row = mysqli_fetch_assoc($result)) //while there are still results
{
extract($row);

$quantity = $row['quantity'];
$itemid = $row['itemid'];

$sql = "SELECT * FROM items WHERE itemid='".$itemid."'"; //selecting the name and image of the item that is displaying
$result = mysqli_query($cxn, $sql) or die(mysqli_error($cxn));
$row = mysqli_fetch_assoc($result);

$name = $row['name'];
$image = $row['image'];

if ($imagecount%5 == 0) //after 5 items have been listed, start a new line
{
echo "</tr>";
echo "<tr>";
}
}

echo "<td width=\"120px\" align=\"center\">";
echo "<img src=\"http://www.elvonica.com/".$image."\"><br>";
echo $name." (".$quantity.")";
echo "</td>";

$imagecount++; //after one item has been displayed, redo the loop if there are still results
}
echo "</table>";

Okay I am trying to do a for loop within a while loop and its so far not working.
Here is what I currently have. It echo's nothing out. Also If I remove the Code that generates information from the for loop It echo's out perfectly so It has something to do with the for loop.
PHP Code so Far:
Code: [Select]
<?php
if(isset($_POST['system'])){
    
    $system = $_GET['system'];
    
    
    
}else{
    $system = 1;
}
$q = "SELECT * FROM `planets` WHERE `system` = '$system' ORDER BY `id` ASC LIMIT 9";
$res = mysql_query($q) or die("Error:<br />".mysql_error());
$couny = mysql_num_rows($res);
while($row = mysql_fetch_array($res)){ 
    
    for($i=1; $i>=$couny; $i++){    ?>
    <li>
            <span <?php if($i=1){echo "id='mercury'";}
            if($i=2){echo "id='venus'";}
            else if($i=3){echo "id='earth'";}
            else if($i=4){echo "id='mars'";}
            else if($i=5){echo "id='jupiter'";}
            else if($i=6){echo "id='saturn'";}
            else if($i=7){echo "id='uranus'";}
            else if($i=8){echo "id='neptune'";}
            else if($i=9){echo "id='pluto'";}?>id="mercury"><?php echo $row['name']; ?></span>
            <p><?php if($colony['building11'] >= $row['building11']){?>
            This Colony Currently Has the Following:<br />
            Hydrogen: <?php echo num($row['recource1']); ?><br />
            Gold: <?php echo num($row['recource1']); ?><br />
            Platinum: <?php echo num($row['recource1']); ?><br />
            Silver: <?php echo num($row['recource1']); ?><br />
            Bio-Waiste: <?php echo num($row['recource1']); ?><br />
            Plasma: <?php echo num($row['recource1']); ?><br />
            Metal:  <?php echo num($row['recource1']); ?><br />
            <?php }else{?>       <font color="red">Insufficiant Observatory Level!</font><br />
            Hydrogen: ???????????????<br />
            Gold: ???????????????<br />
            Platinum: ???????????????<br />
            Silver: ???????????????<br />
            Bio-Waiste: ???????????????<br />
            Plasma: ???????????????<br />
            Metal:  ???????????????<br /> <?php } ?></p>

            </li>
   
       <?php } }
?>
Thanks Brian.

PS. The Attached Image is what it looks on my end the for and while loops displays the planets in the system right under the red Solar System Star Text.

Thank you again for any help.

This is a code pinch from a webpage of my project. Here I want to display user selected categories and then want to display its subjects that belong to category. There, users could have more than 1 category and It no problem I can print all those category in my first while loop... but problem is when Im try to print subjects it has only one row as a result.. there are more subjects in each category. can anybody tell me what has happens?

this is my code.... Note: both queries are working properly.. I tried those user mysql client program.

Code: [Select]
<?php

require_once ('../../includes/config.inc.php');
require_once( MYSQL1 );

$q = "SELECT institute_category.category_id, category_name
FROM institute_category
INNER JOIN category ON institute_category.category_id = category.category_id
WHERE institute_category.institute_id = $instituteId";

$r = mysqli_query( $dbc, $q);


while ( $row = mysqli_fetch_array ( $r, MYSQLI_ASSOC) )   {

$categoryId = $row['category_id']; 
$category = $row['category_name']; 

echo '<fieldset class="alt">
<legend><span>Category : <em style="color: red;">' . $category . '</em></span></legend>';



$qy = "SELECT category_subject.category_id, category_subject.subject_id, subjects
FROM category_subject
INNER JOIN category ON category_subject.category_id = category.category_id
INNER JOIN subject ON category_subject.subject_id = subject.subject_id
WHERE category_subject.category_id = $categoryId";

$result = mysqli_query( $dbc, $qy);

$c = $i = 0;

echo '<table class="form_table" ><tr>'; 

while($row = mysqli_fetch_array( $result, MYSQLI_ASSOC  )){

// if remainder is zero after 2 iterations (for 2 columns) and when $c > 0, end row and start a new row:  
if( ($c % 2) == 0 && $c != 0){
echo "</tr><tr>";
}

echo '<td width="50%"><input type="checkbox" name="subject[]"  value="' . $row['category_id'] . ":" . $category . ":"  . $row['subject_id'] . ":". $row['subjects'] . '" />&nbsp;&nbsp;' . $row['subjects'] . '</td>' . "\n";

$c++; 

} // while..
// in case you need to fill a last empty cell:
if ( ( $i % 2 ) != 0 ){

// str_repeat() will be handy when you want more than 2 columns
  echo str_repeat( "<td>&nbsp;</td>", ( 2 - ( $i % 2 ) ) );
}
echo "</tr></table>";

} 

echo '</fieldset>';
?>

any comments are greatly appreciated..
thank you

I am a noob at php, looking to become great. My php loop only seems to draw 1 row from the database when listing it out. Here is the loop

<?php

require('header.php');

mysql_select_db('center');

$sql = "select username, password from users";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);

$user = $row['username'];
$pass = $row['password'];

echo "<table border='1'>";

while($row = mysql_fetch_array($result)) {

echo "<tr>";

echo "<td>$user</td>";

echo "<td>$pass</td>";

echo "</tr>";
}

echo "</table>";

?>

hello..

In this script. if part is working properly. but elseif part not working i expect. it display only 1 category and its subjects.

Anybody can tell me what the mistake that I have did...

Here is my script

Code: [Select]
} elseif ( isset($_POST['category']) && ( sizeof( $_POST['category']) == 2 || sizeof( $_POST['category']) == 3 )) {

$q = 'SELECT * FROM category ORDER BY category_id';
$r = mysqli_query( $dbc, $q);

while($row = mysqli_fetch_array( $r, MYSQLI_ASSOC  )) {

foreach( $category as $value ) {

if ( $value == $row['category_id']) {

echo '<input type="radio" name="category[]" value="' . $row['category_id'] . '" class="radio" />';
echo '<label for="" class="radio">&nbsp;&nbsp;' . $row['category_name'] . ' <strong>: Mark this category as my "Main Category"</strong></label><br />';

$q = "SELECT category_subject.category_id, category_subject.subject_id, subjects
FROM category_subject
INNER JOIN category ON category_subject.category_id = category.category_id
INNER JOIN subject ON category_subject.subject_id = subject.subject_id
WHERE category_subject.category_id = {$row['category_id']}";

$r = mysqli_query( $dbc, $q);

$c = $i = 0;

echo '<table class="form_table" ><tr>';

while($info = mysqli_fetch_array( $r, MYSQLI_ASSOC  )){

// if remainder is zero after 2 iterations (for 2 columns) and when $c > 0, end row and start a new row: 
if( ($c % 2) == 0 && $c != 0){
echo "</tr><tr>";
}

echo '<td width="50%"><input type="checkbox" name="category[]"  value="' . $info['subject_id'] . '" />&nbsp;&nbsp;' . $info['subjects'] . '</td>';

$c++;

} // while..
// in case you need to fill a last empty cell:
if ( ( $i % 2 ) != 0 ){

// str_repeat() will be handy when you want more than 2 columns
  echo str_repeat( "<td>&nbsp;</td>", ( 2 - ( $i % 2 ) ) );
}
echo "</tr></table>";
}
}
}
}

I have a while loop nested inside of another while loop to populate a drop-down select box for each result from the parent while loop. The inner loop only gets run once though... any ideas on how to fix this without it being extremely data heavy?

Hello all,

I am having trouble with a piece of code. I have used the same piece of code on a different server and I had no problems. Suddenly I do.
- I use this code to load info into a Flash website to browse through all rows in a table;
- Inside the table currently there is one record;
- NumLow is being passed through the url;
- echo "&aantalEvenementen=".$aantalEvenementen; shows 1 record just fine;
- the record doesn't get printed though... the error is somewhere in the while loop.

Hope someone can point me in the right direction!

Cheers,


Code: [Select]

// Connect to mySQL Server
$DBConn = mysql_connect($DBhost,$DBuser,$DBpass) or die("Error bij het verbinden met de MYSQL server: " . mysql_error());
// Select mySQL Database
mysql_select_db($DBName, $DBConn) or die("Error bij het verbinden met de MYSQL database: " . mysql_error());

//amount of rows that are shown at once
$numComments = 1;

//select the right table
$sql = "SELECT * FROM $table";

//loading events
$nieuweEvenementen = mysql_query($sql, $DBConn) or die("Error bij het ophalen van de concerten: " . mysql_error());

//amount of rows
$aantalEvenementen = mysql_num_rows($nieuweEvenementen);

//order rows
$sql .= ' ORDER BY `concertDatum` DESC LIMIT ' . $_GET['NumLow'] . ', ' . $numComments;

//loaded row
$geladenEvenement = mysql_query($sql, $DBConn) or die("Error bij het laden van het concert: " . mysql_error());

//echo amount of rows
echo "&aantalEvenementen=".$aantalEvenementen;

//if no records, display message, otherwise print row
if($aantalEvenementen == 0) {
    echo "&concertOmschrijving=Er zijn geen concerten. U kunt nieuwe concerten aanmaken via de concertenkalender.";
} else {
    while ($array = mysql_fetch_array($geladenEvenement)) {
   $concertNaam = mysql_result($geladenEvenement, $i, 'concertNaam');
   $concertArtiest = mysql_result($geladenEvenement, $i, 'concertArtiest');
   $concertDatum = mysql_result($geladenEvenement, $i, 'concertDatum');
   $concertTijd = mysql_result($geladenEvenement, $i, 'concertTijd');
   $concertOpen = mysql_result($geladenEvenement, $i, 'concertOpen');
   $concertOmschrijving = mysql_result($geladenEvenement, $i, 'concertOmschrijving');
   
   echo "&concertNaam=".$concertNaam;
   echo "&concertArtiest=".$concertArtiest;
   echo "&concertDatum=".$concertDatum;
   echo "&concertTijd=".$concertTijd;
   echo "&concertOpen=".$concertOpen;
   echo "&concertOmschrijving=".$concertOmschrijving;
   
   $i++;
   
   }
}
// if there are no more records (all are loaded), show message
if($_GET['NumLow'] > $aantalEvenementen) {
  echo "$eventOmschrijving=Alle concerten zijn reeds geladen.";
}

}

I have the following form the just has one field. 

Code: [Select]
<html>
    <head>
        <title>Post</title>
    </head>
    <body>
        <form action="worldpay_callback.php" method="post">
            <input type="text" name="username" id="username" />
            <input type="submit" name="submit" id="submit" value="send" />
        </form>
    </body>
</html>

I am then posting the form to the following page that is meant to loop through all of the post values and save them to a text file.  For some reason my foreach loop doesn't seem to be working as done of the post values are getting written to the text file.  Can anyone see anything I'm doing wrong?

Code: [Select]
$myFile ="notifications.txt";
$fh = fopen($myFile, 'w+') or die("can't open file");

foreach($_POST as $k=>$v)
{
   $data = 'POST: Key:'.$k.' - Value:'.$v ." \n";
   fwrite($fh, $data);
}
   
fclose($fh);

return "[OK]";

Thanks for any help

I have never used cURL before but I need to use it for developing a facebook application. What I am trying to do is create a status update scheduler. There are two tables in my database. One table has generic updates for each day of the week an the other had special events. My script checks the day, checks to see if there is a special event in the future on that day, and if there is reminds guests of the upcoming event. If there is no event it posts the generic status.

Code: [Select]
<?php 
include('config.php');

$result2 = mysql_query("select facebook_id,facebook_access_token from admin where username='users'");
$row = mysql_fetch_array($result2);
$facebook_id = $row['facebook_id'];
$facebook_access_token = $row['facebook_access_token'];

$day = date('N');

$result2 = mysql_query("select * from events where date > CURDATE() order by date ASC")
or die(mysql_error());

$num_rows = mysql_num_rows($result2);

if($num_rows == 0) {
$result2 = mysql_query("select * FROM alerts WHERE id='$day'")
or die(mysql_error());
$row1  = mysql_fetch_array($result2);
echo 'There are no events just alerts';
} else {
while($row = mysql_fetch_array($result2)){
if(date('N',strtotime($row[date])) == $day) {

$id = $row['id'];

$result1 = mysql_query("SELECT * FROM events WHERE id = $id")
or die(mysql_error());

$row1  = mysql_fetch_array($result1);

} else {
$result1 = mysql_query("SELECT * FROM alerts WHERE id = $day")
or die(mysql_error());
$row1  = mysql_fetch_array($result1);

}
}
}

$params = array('access_token' => $facebook_access_token, 
'message' => $row1[alert_message],
'name'=> $row1[alert_name],
'caption' => $row1[alert_caption],
'link' => $row1[alert_link],
'description' => $row1[alert_description],
'picture' => $row1[alert_picture]
);

$url = "https://graph.facebook.com/$facebook_id/feed";
$ch = curl_init();
curl_setopt_array($ch, array(
CURLOPT_URL => $url,
CURLOPT_POSTFIELDS => $params,
CURLOPT_RETURNTRANSFER => true,
CURLOPT_SSL_VERIFYPEER => false,
CURLOPT_VERBOSE => true
 ));

$result = curl_exec($ch);

?>
The problem seems to be occurring when the While loop is accessed. I have used 'echo' to follow the variables through the script and it all seems to be working. However if I try and execute the cURL and the While Loop has run then it does not seem to work. I know the cURL part works becuase if the variables cause the first IF statement default to ELSE then it runs fine.

Any help would be GREATLY appreciated.

I am trying to delete records across 3 tables but my code does not work.

Code: [Select]


$query = ("SELECT `propertyref` FROM `feed_property` WHERE `status` = 'Sold' ")or die(mysql_error());
   $result = mysql_query($query);
   
 if (isset($result)) {   
     while ($row = mysql_fetch_array($result)):
     $ref1 = mysql_real_escape_string($row['propertyref']);
 
   
$query1 = ("DELETE FROM `feed_property`, `feed_images`, `feed_characteristics`\n"
    . "USING `feed_property` INNER JOIN `feed_images` INNER JOIN `feed_characteristics`\n"
    . "WHERE feed_property.propertyref = '$ref1'\n"
    . " AND feed_images.propertyref = feed_property.propertyref\n"
    . " AND feed_characteristics.propertyref = feed_property.propertyref; ")or die(mysql_error());
   
   
   
   

echo $query1;
endwhile;


   
if(!mysql_query($query1)){
  echo '<h1 style="color: red;">Error</h1><p>', mysql_error(), '</p>';
}


else
{

  echo '<h1 style="color: red;">Properties have been removed from the database</h1>';
}
}


Query1 echos as:

Code: [Select]
DELETE FROM `feed_property`, `feed_images`, `feed_characteristics` USING `feed_property` INNER JOIN `feed_images` INNER JOIN `feed_characteristics` WHERE feed_property.propertyref = 'abc1' AND feed_images.propertyref = feed_property.propertyref AND feed_characteristics.propertyref = feed_property.propertyref;
DELETE FROM `feed_property`, `feed_images`, `feed_characteristics` USING `feed_property` INNER JOIN `feed_images` INNER JOIN `feed_characteristics` WHERE feed_property.propertyref = 'abc2' AND feed_images.propertyref = feed_property.propertyref AND feed_characteristics.propertyref = feed_property.propertyref;
The query completes without errors but does not delete the entries in the DB. If I run the query singly in PHP My Admin it functions correctly.

thanks for your help

Hello guys i used the eval function but it does not echo anything back in the while loop ..the $new_string function contains "preg_split("/\.\(.*\)\.\(.*\)/", $file);", same as $parts..i need some guidance, thanks!

<?php


  //"$DOCUMENT_ROOT"."new/"; 
  $current_dir = 'C:\xampp\htdocs\Audit_Reports';   //Put in second part, the directory - without a leading slash but with a trailing slash!
  $dir = opendir($current_dir);        // Open the sucker
  

$newArgument = $_POST[argument];
$newArgument1 = $_POST[argument1];
  
$string ='preg_split("/\.\(.*\)\.\(.*\)/", $file);';
$new_string = preg_replace("#\/\\\.\\\\\(\.\*\\\\\)#","/\.\\($newArgument\)",$string);
$new_string = preg_replace("#\\\.\\\\\(\.\*\\\\\)#","\.\\($newArgument1\)", $new_string);


       
  echo ("<p><h1>List of Audit Reports:</h1></p><hr><br />");
  while ($file = readdir($dir))            // while loop
  {
  
  $parts = preg_split("/\.\(CLIENT\)\.\(.*\)/", $file);
  // $part = eval($new_string);

  
        if (is_array($parts) && count($parts) > 1) {    // does the dissected array have more than one part
        $extension = reset($parts);        // set to we can see last file extension
        if ($extension == "Audit_Report" OR $extension == "audit_report")    // is extension ext or EXT ?
             echo "<a href=\"$file\" target=\"_blank\"> $file </a><br />";    // If so, echo it out else do nothing cos it's not what we want
        }
    }
  echo "<hr><br />";
  closedir($dir);        // Close the directory after we are done


?>




The below codes are done in a while loop

Result:ArrayArrayArrayArrayArrayArrayArrayArrayArrayArra yArrayArray
$parts = preg_split("/\.\(A\)\.\(A\)/", $file);
  echo $parts;

Result:No Output
 $part = eval($new_string);
 echo $part;

Hi brains... I must be missing some core concept here that I hope someone can set me straight on..

I have a database query that returns say 8 rows. Here's how I know...

$link6_result10 = mysql_query($link6_sql10) or die("Link6 SQL10 Failed: Function drawInventory: " . mysql_error());
        $link6_rows10 = mysql_num_rows($link6_result10);
        $link6_array10 = mysql_fetch_array($link6_result10, MYSQLI_ASSOC);
        echo "You have $link6_rows10 items in your inventory."; <<---- returns 8


So why in the world does this not work??? What is the flaw in my logic?

$srchStr = null;
    foreach ($link6_array10 as $sn) {
    $srchStr .= " SerialNumber = '$sn' OR";
     echo "SN is $sn ";
     }

The only echo output of the foreach function is "SN is 12345" Not the 8 rows of content that I would expect. isn't this how foreach loops should work? Why do I not see "SN is 12345 SN is 23456 SN is 34567 etc..."????? I'm confused.

Thanks guys for any help.

Hi guys

Probably a simple but trying to figure out why I cant get this while loop to work (at least I think its the loop)

Query works as it returns 1 row, but not all of them.

Any help would be great!

 $sql = "SELECT * FROM requests ORDER BY leave_after DESC";
  if ($result = mysql_query($sql)) {
    if (mysql_num_rows($result)) {

    
     while ($row = mysql_fetch_assoc($result))
        {      
echo '<div id="resultholder">';
echo "<p>Request ID:" . $row['id'] . ", User ID: " . $row['user_id'] . ", Departing From: " . $row['departing'] . ", Going To: " . $row['destination'] . " , Leaving After: " . $row['leave_after'] . " , but Arriving Befo " . $row['arrive_before'] ."</p></div>";
echo '</div>';
         }
    }
  }

Thanks!

I am doing some study on using time() and date() and i just wrote this simple for loop to add one day to each iteration with +$i and its echoing the unix timestamp as opposed to the correctly formated date as it should be based on my code. Anyone have any idea why this is not working as expected?

for($i=0; $i < 50; $i++)
{
echo $time = time()+$i . "<br />"; // add a day on each iteration
echo date('y-m-d', $time) . "<br />"; // should echo 10-12-02, 10-12-03, 10-12-04, etc..
}

what am i doing wrong here? arrgggg! maybe its too late for this s$%^#!

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=321230.0