[RESOLVED] Why is this not a valid SQL statement?

john1704

Why is the following SQL statement invalid in the PHP code below?

<?php
mysql_connect(localhost,john1704_manager,PASSWORD) or die("Unable to connect to SQL server"); 
@mysql_select_db('john1704_general') or die("Unable to select database"); 
$result=mysql_query("SELECT * FROM Images WHERE id=$id") or die("Can't perform Query"); 
$row=mysql_fetch_object($result); 
Header("Content-type: image/jpg"); 
echo $row->Image; 
?>

sheephat

$host = 'localhost';
$user = 'john1404_manager';
$pass = 'password';

mysql_connect($host,$user,$pass);

Not sure if that will make a change but i think that is a problem at the moment, your connect is not ''ed

alimadzi

Put single quotes around '$id' in your query.

john1704

Sorry, but your single quotes method didn't work this time.

sheephat

What error do you get?

john1704

sheephat wrote:
What error do you get?

The die() message, "Cannot perform query."

sheephat

try

mysql_query('SELECT * FROM Images WHERE id='.$id)

john1704

Sorry, still didn't work.

sheephat

Is the $id being retreaved correctly via from or url?

john1704

I think so, the code you saw is the entire thing.

The URL looks like:

http://www.johninteractive.net/photos/imagedisplay.php3?id=14

sheephat

<?php 
$idget = $_GET['id'];
mysql_connect(localhost,john1704_manager,PASSWORD) or die("Unable to connect to SQL server"); 
@mysql_select_db('john1704_general') or die("Unable to select database"); 
$result=mysql_query('SELECT * FROM Images WHERE id='.$idget) or die("Can't perform Query"); 
$row=mysql_fetch_object($result); 
Header("Content-type: image/jpg"); 
echo $row->Image; 
?>

Try That

sheephat

mysql_query("SELECT * FROM Images WHERE id=$idget") might be right"er"

john1704

Thanks everyone, I finally got what I was looking for! Thanks for everyone's help!

sheephat

Whats was your final script?

john1704

sheephat wrote:
Whats was your final script?

<?php 
$idget = $_GET['id'];
mysql_connect(localhost,john1704_manager,PASSWORD) or die("Unable to
 connect to SQL server"); 
@mysql_select_db('john1704_general') or die("Unable to select
 database"); 
$result=mysql_query('SELECT * FROM Member WHERE id='.$idget) or
 die("Can't perform Query"); 
$row=mysql_fetch_object($result); 
Header("Content-type: image/jpg"); 
echo $row->Image; 
?>

sheephat

Ahh good to see it worked for you.