PHP - Union Troubles !

Hi

I'm trying to find the max value in 3 columns, new_date, reply_date and finalized_date in my table:

Code: [Select]
$test = safe_query("SELECT MAX(new_date) FROM (SELECT new_date AS new_date FROM ".PREFIX."cup_challenges UNION SELECT reply_date FROM ".PREFIX."cup_challenges UNION SELECT finalized_date FROM ".PREFIX."cup_challenges) AS maxval");
Did some research and have no idea what is wrong/if the above is correct?
The page breaks below this code.

$sql=mysql_query("SELECT * FROM `buds` WHERE `level`<='$user_level' UNION SELECT * FROM `buds`, `unlocked_buds` WHERE buds.`id` = unlocked_buds.`bud_id` ORDER BY buds.`id` ASC") or die("A MySQL error has occurred.<br />Your Query: " . $sql . "<br /> Error: (" . mysql_errno() . ") " . mysql_error());



I have been trying to learn about UNION select statements. I ran the query above and got this response:

Quote

Error: (1222) The used SELECT statements have a different number of columns



I think I know what the problem is, but not sure how to fix it.

There is two columns, one is "buds" which holds the flowers seeds info. The seconds is "unlocked_buds" which just links the "id" from buds to "user_id" to the user table.

Both buds and unlocked_buds are both 8 columns.

What do I need to learn?

This topic has been moved to MySQL Help.

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

i have this query and i'm trying to order all of the results by `created` ascending. I've tried putting the later query before the first but the single row from the first query(the way it is right now) gets stuck as the last row in the results. How can i order the results of both queries?

Code: [Select]
(
SELECT *
FROM Account_activity
WHERE DATE( created ) <  '2011-08-01'
AND username =  '40'
ORDER BY created DESC
LIMIT 1
)
UNION (
SELECT *
FROM Account_activity
WHERE MONTH( created ) =  '08'
AND YEAR( created ) =  '2011'
AND username =  '40'
ORDER BY created ASC
)

Is there a cleaner way to do this?

$query = "SELECT branches.Language FROM eua_users, branches WHERE eua_users.AssignedBranch = branches.country" ;
include("dbconnectlocal.php") ;
$result = mysql_query($query) ;

$row = mysql_fetch_object($result) ;

$usrlang = $row->Language ;

$query = "SELECT UserName, Email FROM eua_users WHERE UserName = '$user'" ;
include("dbconnectlocal.php") ;
$result = mysql_query($query) or die(mysql_error());

$row = mysql_fetch_object($result) ;

$branchmail = $row->Email ;

$query = "SELECT $usrlang FROM autoreplies WHERE ReplyID = '0'" ;
include("dbconnectlocal.php") ;
$result = mysql_query($query) or die(mysql_error()) ;

$row = mysql_fetch_object($result) ;

$message = $row->$usrlang ;

$query = "SELECT $usrlang FROM autoreplies WHERE ReplyID = '1'" ;
include("dbconnectlocal.php") ;
$result = mysql_query($query) or die(mysql_error()) ;

$row = mysql_fetch_object($result) ;

$url = $row->$usrlang ;

$query = "SELECT $usrlang FROM autoreplies WHERE ReplyID = '2'" ;
include("dbconnectlocal.php") ;
$result = mysql_query($query) or die(mysql_error()) ;

$row = mysql_fetch_object($result) ;

$subject = $row->$usrlang ;

This topic has been moved to MySQL Help.

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

Can't figure out why this is not working for me... please help! Thanks



<?php

$gamertag = 'l RaH l';

$url = "http://api.xboxleaders.com/user_api.php?gamertag=".rawurlencode($gamertag);


$output = file_get_contents($url);

// try to convert the response into a PHP object
$obj = json_decode($output);

if(!is_object($obj)) 
die("Error parsing JSON response\n");

//define variables
$avatar = ($obj->user->avatar);
$gold = ($obj->user->gold);

print $gold;
print $avatar;

?>

up until yesterday everything was fine, but now all of my icons are displaying at 10 times the size they originally are. This can only be fixed by defining width and height of them via css but i never had to do this before. Is this something to do with php? heres an eample line of code for an image i am using:

echo "<img src=\"{$site_root}/avatars/{$posts_info->user_avatar}\"/>";

any ideas why this is happening?
that image is just an example btw. the same thing happens with icons that are 7x7.

I have this PHP file that I intend to provide the answers to only four questions in a little quiz in a "Questions" table:
QuestionID, QuestionText

Questions:
1 Which is NOT part of the FAT TOM acronym?
2 Of the following choices, which has a better chance of creating a foodborne illness?
3 How should food NEVER be thawed?
4 Where should pesticides be stored?

The answers should go in the Answers table:
"QuestionID, OptionText, CorrectAnswer"

I have hundreds of questions and answers, but I need to get this small sample working first.

The following code runs without triggering an error but it doesn't insert any data.


<?php 
$link = mysql_connect('PathToMyData', 'myUsername', 'MyPassword');  // specifics removed for security

 if (!$link) { 
  die('Could not connect: ' . mysql_error()); 
} 

mysql_select_db('quiz');

$sql = "INSERT INTO ANSWERS (QuestionID,OptionText,CorrectAnswer)
// CorrectAnswer is type BOOL (Correct=1 Wrong Answer=0)

(VALUES (1,'food',0), 
(1,'alkalinity',1),
(1,'time',0),
(1,'temperature',0),
(1,'oxygen',0), 
(1,'moisture',0), 
(2,'celery sticks',0), 
(2,'beef jerky',0), 
(2,'cranberry juice',0), 
(2,'baked potato',1), 
(2,'saltine cracker',0),
(3,'in the refrigerator',0), 
(3,'in a pot in the kitchen at room temperator',1), 
(3,'as a part of the cooking process',0), 
(3,'under cool running water',0), 
(4,'close to the food preparation area for easy access',0), 
(4,'in a locked storage area away from food',1), 
(4,'in the dry storage area',0), 
(4,'in a bin or box under the sink',0);)";

$result = mysql_query($sql);  // executes the query

// close database
mysql_close($link);
?> 


Then I go back to the MySQL admin area at my host's site and query up "SELECT * FROM Answers;" and nothing!  It's still empty! As I said, no error was triggered, but nothing was inserted.  This is discouraging.

Hey all, I'm am stumped. I'm working with someone else's code and I find they are using serialized arrays a lot. unfortunately at present I am not to familiar with serialized arrays and how to work with them and Ive been searching for an answer for a bit but I am not doing so hot in my quest, so I thought I'd come here and give it a crack.

From what I gather the person that did this portion of the site I am working on pulled this as is from linkedin. From it I am trying to reconstruct it for the page I am putting into, this information is stored in hundreds of db entries so I cant really redo everything.

Is there a direct way of working with this or do I have to covert it to an array or what is the best way to handle data like below, or serialized arrays in general for that matter.

Example of what I am looking at:
Code: [Select]
{"@attributes":{"total":"1"},"position":{"id":"155477330","title":"Lead Architect","summary":{},"start-date":{"year":"2010","month":"10"},"is-current":"true","company":{"id":"209012","name":"Sprint Mobile Inc","type":"Privately Held","industry":"Internet"}}}
And another example:
Code: [Select]
{"@attributes":{"total":"3"},"position":[{"id":"161998487","title":"Senior UX\/UI Designer","summary":"Plan, Design, and Direct User Experience Design\/Development. Also in charge of sharing and spreading the UX philosophy company-wide.","start-date":{"year":"2011","month":"1"},"is-current":"true","company":{"id":"209012","name":"UpMo","type":"Privately Held","industry":"Internet"}},{"id":"149276847","title":"Owner \/ Creative Director","summary":"I'm 27 years old and born and raised in Charleston, South Carolina. \n\nAs a web designer and developer with nearly 14 years of experience, I've always found myself to be interested in business development. I started my first web business when I was 17 years old and watched it grow from a one man operation in a bedroom, to twelve employees working from two office locations. \n\nOver the years I have developed over 200 websites and assisted in the design\/development in as many more.\n\nBeing an entrepreneur, I've developed a sixth sense for quality assurance on web projects -- in other words, if I cannot give it a thumbs up for my own business, why would I give it to you?","start-date":{"year":"2010","month":"6"},"is-current":"true","company":{"id":"1487228","name":"Brandon Rivers Consulting, LLC.","industry":"Internet"}},{"id":"71905623","title":"Chairman \/ Chief Executive Officer","summary":"Brandon is responsible for setting strategy and overseeing the day-to-day business and operations of Campus Rhythm.\n\nIn this position, Brandon\u2019s core responsibility is not only facilitating business outside of Campus Rhythm, but balancing internal and external initiatives to build a sustainable corporation. \n\nCampus Rhythm is the FIRST and ONLY fully automated Student to Student textbook network that allows students all over the country to set their own prices, and be connected to other students to buy and sell textbooks.","start-date":{"year":"2007","month":"10"},"is-current":"true","company":{"name":"Campus Rhythm, LLC.","industry":"Internet"}}]}

Hello Community, good evening!


i am having troubles with starting PHP on linux - [running OpenSuse-Linux]



Could not open input file: -
suse-linux:/usr/perl # php -v
PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/lib/php5/extensions/readline.so' 
- libedit.so.0: cannot open shared object file: No such file or directory in Unknown on line 0
PHP 5.3.4-dev (cli) 
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
suse-linux:/usr/perl # 


well what is wrong here...?

I need to draw various font sizes onto a canvas to create a web service. Wanting to protect my HD assets, the intent is to use PHP to populate the image with the necessary text, and then scale down the image before presenting it to the user.

A similar service already exists, a tool to allow the public to make user generated content for a card game.

The problem ever, is that PHP does not seem to handle font sizes very well. I created this sample code to demonstrate my issue.
Here is a sample output from the code below
 

<?php
    $img = imagecreatetruecolor(750, 530);
    
    $black = imagecolorallocate($img, 0, 0, 0);
    $gray = imagecolorallocate($img, 125, 125, 125);
    $white = imagecolorallocate($img, 255, 255, 255);
    
    $font = realpath('../fonts/micross.ttf');
    
    $size = 12;
    $spacing = 20;
    
    for ($x = 0; $x <= 25; $x++) {
        $box = imageftbbox($size + $x/10, 0, $font, "The longer the phase the more apparent the size difference should be");
        $boxWidth = $box[2] - $box[0];
        
        imagefilledrectangle($img, 5, $x*$spacing+5, $boxWidth+5, ($x+1)*$spacing+5, $gray);
        
        imagefttext($img, $size + $x/10, 0, 5, $spacing*($x+1), $white, $font, "The longer the phase the more apparent the size difference should be Font Size ".($size+($x/10)));
    }
    
    imagejpeg($img);
    imagedestroy($img);
?>

You can see how despite the font size steadily increasing by 0.1, it sporadically jumps at what seem at first like random intervals, however if you increase the number of loops and log the data, you can see that it alternates between increasing every 0.7, and 0.8. Unfortunately that doesn't help me any, just some insight.

if($last != $boxWidth)
{
    $last = $boxWidth;
    echo $boxWidth." ".($size+($x/10))."<br>";
}

This outputs the current width and font size each time the text width changes.
I've compiled a sample output for you guys to look at here

Hopefully I've provided enough information to get some help, this has been very frustrating.

Hi all.

I'm trying to build a dynamic multiple tiered navigation menu that operates on the existence of directories.  So far, I have some code that will read through the document root, and one sub level of directories but I'm not sure how to get into the third level of directories.  Here's what I have so far...

The code:

      $docroot=scandir($_SERVER['DOCUMENT_ROOT']);

      unset($docroot[array_search('.',$docroot)]);

      unset($docroot[array_search('..',$docroot)]);

      unset($docroot[array_search('php',$docroot)]);

      unset($docroot[array_search('css',$docroot)]);

      unset($docroot[array_search('input_forms',$docroot)]);

      $docroot=array_values($docroot);

      

      //Build tier 1

      echo "<div class=\"tier\">";

      echo "<a href=\"/index.php\">Home</a>";

      foreach($docroot as $value1){

         if(is_dir($value1)){

            $t2=scandir($_SERVER['DOCUMENT_ROOT'] . "/" . $value1);

            unset($t2[array_search('.',$t2)]);

            unset($t2[array_search('..',$t2)]);

            $t2=array_values($t2);

            $t1[]=$t2;

            

            echo "<a href=\"/$value1/\">";

            $value1=str_replace("_"," ",$value1);

            $value1=ucwords($value1);

            echo $value1;

            echo "</a>";

         }

      }

      echo "</div>";


The output:
Code: [Select]
[it automatically builds the first tier of the menu with some stylesheet definitions and places it here.  I did this just for testing purposes.]
Array
(
    [0] => Array
        (
            [0] => bus_mgmt_context.pdf
            [1] => financial_management
            [2] => index.php
            [3] => nav.php
            [4] => service_level_management
            [5] => service_portfolio
            [6] => workforce_management
        )

    [1] => Array
        (
            [0] => element_inventory
            [1] => index.php
            [2] => mobile_administration
            [3] => monthly_bill_review
            [4] => nav.php
        )

    [2] => Array
        (
            [0] => business_it_requests
            [1] => change_management
            [2] => demand_management_context.pdf
            [3] => index.php
            [4] => nav.php
            [5] => project_management
            [6] => release_management
        )

    [3] => Array
        (
            [0] => availability_management
            [1] => capacity_management
            [2] => configuration_management
            [3] => index.php
            [4] => nav.php
            [5] => planning
            [6] => problem_management
            [7] => system_planning
        )

    [4] => Array
        (
            [0] => context
            [1] => input
            [2] => reports
            [3] => sop
            [4] => t3.php
            [5] => video
        )

    [5] => Array
        (
            [0] => executive_reports
            [1] => index.php
            [2] => kpi_index
            [3] => nav.php
        )

    [6] => Array
        (
            [0] => compliance
            [1] => hipaa_definitions.pdf
            [2] => index.php
            [3] => information_security
            [4] => nav.php
            [5] => risk_context.pdf
            [6] => service_continuity
            [7] => threat_management
        )

    [7] => Array
        (
            [0] => incident_management
            [1] => index.php
            [2] => nav.php
            [3] => release_management
            [4] => service_desk
            [5] => service_requests
            [6] => supplier_management
        )

)