Jump to content


Staff Alumni
  • Content Count

  • Joined

  • Last visited

  • Days Won


jazzman1 last won the day on September 24 2014

jazzman1 had the most liked content!

Community Reputation

91 Excellent

About jazzman1

  • Rank
    Prolific Member
  • Birthday 03/06/1972

Profile Information

  • Gender
  • Location
    Mississauga, Canada
  1. jazzman1

    get score based on max week no

    Barand will kill me if he sees my previous reply. Try next (already tested) select u.firstname, u.surname, a.userID, X.week as 'Max Week', X.score as 'Gameweek' from POINTS a inner join (select userID, week, score from POINTS a1 where week = (select max(week) from POINTS a2 where a2.userID = a1.userID) group by userID) as X ON X.userID = a.userID and X.week = a.week inner join USERS u ON u.userID = X.userID I needed to use a subquery after the where clause or you could use another inner join inside the first join table instead!
  2. jazzman1

    get score based on max week no

    Try, SELECT u.firstname, u.surname, a.userID, max_week, gameweek FROM POINTS a inner join (select userID, max(week) as max_week, score as gameweek from POINTS group by userID) as b ON a.userID = b.userID and b.max_week = a.week inner join USERS u ON u.userID = b.userID
  3. jazzman1

    How do I run multiple queries in one query call

    Barry, I think he is looking for stored procedures or trigers. fastsol, stored procedures provide SQL enhancements supporting variables, comments, exceptions, conditional testing and looping as programming elements.
  4. jazzman1

    Login Page won't work, using pHPass

    You're trying to fetch some data without inserting it? Where is your inserting query? Re-read mac_gyver's reply few times!
  5. Try (second page): <!doctype html> <html> <head> <title>Test array attendence</title> </head> <body> <table border="1"> <?php if (!empty($_GET['member'])) { $data = $_GET['member']; foreach (array_chunk($data, 2) as $row): ?> <tr> <?php foreach ($row as $value): ?> <td><?php echo htmlentities($value); ?></td> <?php endforeach; ?> </tr> <?php endforeach; }else { echo "Fail to get data from previous"; } ?> </table> <table><tr><td><?php echo count($_GET['member']) . " are attending this meeting tonight." ?></td></tr></table> </body> </html>
  6. Infinity loop I see here: while ($row = array($rows)) { $data['Name'] = $row; }
  7. jazzman1

    php form mysql issue

    We have to see the whole content of the header and footer php files. You're finding too sexy to call JS via PHP, don't you?
  8. jazzman1

    php permission denied

    fucking linux
  9. jazzman1

    php permission denied

    Well, I have the same problem [newuser@centos-box ~]$ whoami newuser [newuser@centos-box ~]$ touch file.php [newuser@centos-box ~]$ ls -l file.php -rwxrwxr-x. 1 newuser newuser 0 Jun 16 07:55 file.php [newuser@centos-box ~]$ ./file.php bash: Permission denied
  10. jazzman1

    Call undefined function mysqli_connect()

    Try to run echo "Hello World"; onto your local machine and tell us what's going on. I am not sure how proper is you local setup config.
  11. jazzman1

    Call undefined function mysqli_connect()

    Yeap, you have a problem with your local setup. What happens if you're using mysl_connect instead mysqli_connect function?
  12. jazzman1

    kill Gwenview: how to do that?

    Use a "top" command to see all list of the current processes to this particular user then fetch the searching text using a "grep" command and kill the PID. [lxc@lxc-centos ~]$ top -u lxc | grep sshd 775 lxc 20 0 106m 2188 1520 S 0.0 0.0 0:00.13 sshd // kill the proccess id [lxc@lxc-centos ~]$ kill -9 775
  13. jazzman1

    Call undefined function mysqli_connect()

    Do you have any problem with some other php function or only with this one? Could you run this script and give us the output (should be mysqli_connect function is not available). Try also the old mysql_connect instead mysqli_connect. <?php if (function_exists('mysqli_connect')) { echo "mysqli_connect function is available.<br />\n"; } else { echo "mysqli_connect function is not available.<br />\n"; }
  14. jazzman1

    PHP exec with variables

    Without any additional arguments to the exeftool app and some redirect output files (using just for testing purposes) everything works fine to me. Here is an example using different php command-line apps (exec, eval and shell_exec). Try to set also an absolute path to exiftool. <?php $uploaddir = '/var/www/html/public_html/lxc/uploads/'; $uploadfile = $uploaddir . basename($_FILES['fileToUpload']['name']); if (move_uploaded_file($_FILES['fileToUpload']['tmp_name'], $uploadfile)) { //echo exec('/usr/local/bin/exiftool "'.$uploadfile.'"'); // Megapixels : 0.345 //eval('$array=' . `/usr/local/bin/exiftool -php -q $uploadfile`); //print_r($array); echo shell_exec('/usr/local/bin/exiftool "'.$uploadfile.'"'); } else { echo "Upload failed"; } Outputs:

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.