Search the Community
Showing results for tags 'select query'.
Found 2 results
-
I need to convert the following select statement to a pdo->query but have no idea how to get it working: SELECT t.id FROM ( SELECT g.* FROM location AS g WHERE g.start <= 16785408 ORDER BY g.start DESC, g.end DESC LIMIT 1 ) AS t WHERE t.end >= 16785408; Here's the code I'm trying: <?php $php_scripts = '../../php/'; require $php_scripts . 'PDO_Connection_Select.php'; require $php_scripts . 'GetUserIpAddr.php'; function mydloader($l_filename=NULL) { $ip = GetUserIpAddr(); if (!$pdo = PDOConnect("foxclone_data")) { exit; } if( isset( $l_
-
I'm getting and Error 500 from my server. I'm not sure why... I think it might be my code. Can someone take a look please. localhost is currently unable to handle this request. HTTP ERROR 500 <?php include("common/common.php"); include("../common/db_connector.php"); $email_sent = $_POST["inputEmail"]; $password_sent = md5($_POST["inputPassword"]); // Check database for user credentials... $sql = "SELECT * FROM users WHERE email = '$email_sent'"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_asso
