0

Working on a function that prints out all database rows that end with _n where n is single digit number 1 - 9 first and then prints rows that do not end in _n. So far I have been trying to use this code

$theQuery="SELECT * FROM tableContent"
while($row=mysql_query($theQuery))
   {
      if(substr($row[0],-2,1)=="_")
         {
            //DO WHAT IT DOES FOR this_1, this_2, this_3 first
         }
   }
while($row=mysql_query($theQuery))
   {
      if(substr($row[0],-2,1)!="_")
         {
            //DO WHAT IT DOES FOR this, that, andWHatHaveYou afterwords
         }
   }

I don't know why the !="_" doesn't get done.

This is the exact code I have implemented but doesnt work 100%

$query="SELECT * FROM rt_content";
$contents=mysql_query($query);
if($contents)
	{
$baseSection = (substr($row[0],-2,-1)=="_")? substr($row[0],0,-2):$row[0];
echo "<table class=\"lined\" style=\"width:100%\"><tr><td class=\"lined\">options</td><td class=\"lined\">contentName</td><td class=\"lined\">en</td><td class=\"lined\">es</td></tr>\n";
while( $row=mysql_fetch_array($contents,MYSQL_NUM) )
		{
				if( substr($row[0],-2,1)=="_" )
						{
											echo "<tr><td class=\"lined\"><a href=\"admin.html?content=edit;".$baseSection."\">EDIT</a></td><td class=\"lined\"><a href=\"admin.html?content=view;".$baseSection."\">".$row[0]."</a></td><td class=\"lined\">".$row[1]."</td><td class=\"lined\">".$row[2]."</td></tr>\n";
									}
		}
while( $row=mysql_fetch_array($contents,MYSQL_NUM) )
		{
							if( substr($row[0],-2,1)!="_" )
						{
								echo "<tr><td class=\"lined\"><a href=\"admin.html?content=edit;".$baseSection."\">EDIT</a></td><td class=\"lined\"><a href=\"admin.html?content=view;".$baseSection."\">".$row[0]."</a></td><td class=\"lined\">".$row[1]."</td><td class=\"lined\">".$row[2]."</td></tr>\n";
						}
		}
			echo "</table>\n";
	}

Does anyone see anything wrong with this or can do it better?

3
Contributors
6
Replies
7
Views
9 Years
Discussion Span
Last Post by world_weapon
0

Take out the if condition and put some echos there to see what output you're getting.

I'm curious about the $baseSection = (substr($row[0],-2,-1)=="_") -1 here in line 5?

0

I put that on the wrong line. The array $row does not exist yet and I guess is equal to NULL and furthermore, that last minus 1 should just be one.
This will work anywhere within the while.

while( $row=mysql_fetch_array($whatever) ) //If not valid query fetch array should return null
{
$baseSection = (substr($row[0],-2,-1)=="_")? substr($row[0],0,-2):$row[0];
echo $baseSection;//This dumps first column contents.
}

I have also found another way to accomplish what I am talking about.
In this manner a new array is created, and populated with the elements for each element that does not meet the inital list. This is an example:

$theQuery="SELECT * FROM tableContent"
$singleElements=array();
   while($row=mysql_query($theQuery))
      {
         if( substr($row[0],-3,1)=="_" || !(substr($row[0],-2,1)=="_") )
           {
               array_push($singleElements,array($row[0],$row[1],$row[2]) );
           }
         if(substr($row[0],-2,1)=="_")
           {
      //DO WHAT IT DOES FOR this_1, this_2, this_3 first
           }
      }
      if($singleElements)
         {
          foreach($singleElements as $singleElement)
             {
       	         echo "";
             }
         }

This one will work with X_n first( Where X is any string and n is number 1-9 ) and then display X_nn (where nn is two digit numbers) or uniquely named elements.
What do you think?

0

I have read through a few articles about them
But I still haven't quite gotten the hang of them.

0

why dont you use if else if instead of checking the substring every time ?

if(substr($row[0],-2,1)=="_") { 
//$row[0] has only 1 digit after the underscore
} else if (substr($row[0],-3,1)=="_"){
      //$row[0] has 2 digits after the underscore
} else {
   // $row[0] doesnt have an underscore
}

This will work, i am sure.

0

Yeah, this works. A function could be made to perform the foreach statements instead of coding. Can this be made into a function that returns an array of the order of the elements.

return array($singleElements, $singleDigits, $doubleDigits);?

then the foreach statements could be made into a function that works on an array;

if(func_num_args()==0 || func_){
   foreach($func_get_arg(0) as $elements){
      foreach($elements as $singleElement){
         echo "List ".print_r($singleElement)."<br />";
      }
   }
}

Honestly I don't know if the above code would work, but below here does.
Thanks for the tips. Let me know what you think.

$theQuery="SELECT * FROM tableContent"
$singleElements=array();
$singleDigits=array();
$doubleDigits=array();
while( $row=mysql_query($theQuery) ){
   if(substr($row[0],-2,1)=="_"){
      array_push( $singleDigits, array($row[0],$row[1],$row[2]) );
   } else if( substr($row[0],-3,1)=="_" ){
      array_push( $doubleDigits, array($row[0],$row[1],$row[2]) );
   }
   else {
      array_push( $singleElements, array($row[0],$row[1],$row[2]) );
   }
}
foreach($singleElements as $singleElement){
      echo "List ".print_r($singleElement)."<br />";
}
foreach($singleDigits as $singleDigit){
      echo "List ".print_r($singleDigit)."<br />";
}
foreach($doubleDigits as $doubleDigit){
      echo "List ".print_r($doubleDigit)."<br />";
}
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.