[cfsr]

<?php




$query = "SELECT id, personnr, CONCAT(etternavn, ', ', fornavn) as navn, DATE_FORMAT(dato, '%d.%m.%Y') as d, DATE_FORMAT(dato2, '%d.%m.%Y') as d2, type, referanse, status, user_name, IF((UNIX_TIMESTAMP(dato)+'".$ny_søknad."') > UNIX_TIMESTAMP(NOW()), '1', '0') AS ny, utbetalt FROM soknader LEFT JOIN user ON userid = behandler ";


?>

Mod Edit: Please use code tags when posting your code. Code tags are used like so =>

Thanks,
PsychoCoder

This post has been edited by cfsr: 24 October 2008 - 03:20 PM

[PsychoCoder]

Are you receiving any errors? Does this code not work that way you intended it? When asking for help there are a couple items that are vital in order for someone to properly help you:

• Post the code you're having problems with (DONE)
  
• Post the exact error you're receiving, if you are receiving one
  
• If no error explain what the code is doing versus what you want it to do
  
• Post your question in the body of your post, not the description field

[cfsr]

error message;

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in ./.../...../index.php on line 273
Error Could not select database

on posted script line 201 $num_rows = mysql_num_rows($result)or die("Error Could not select database");


Problem solved!!!!!!!

Error on
$query = "SELECT id, personnr, .......

Had entered a wrong word on the line!

This post has been edited by cfsr: 24 October 2008 - 03:16 PM