Simple query not working

crash3909

Hi,

I just can't seem to get this query to work. It keeps coming up, "Couldn't get file list". I know there is a simple solution, but I just don't see it. $Samples is the name/value passed from the first page.

Please help. Thanks... Rich

$dbServer = "host"; 
$dbDatabase = "dbase"; 
$dbUser = "username"; 
$dbPass = "password"; 

$sConn = mysql_connect($dbServer, $dbUser, $dbPass) 
or die("Couldn't connect to database server"); 

$dConn = mysql_select_db($dbDatabase, $sConn) 
or die("Couldn't connect to database $dbDatabase"); 

$dbQuery = "SELECT File_Name, Header FROM table1 WHERE Sample_Name = ($Samples)"; 

$result = mysql_query($dbQuery) or die("Couldn't get file list");

while($row = mysql_fetch_array($result)){ 
}

<p align="center"> <strong><font size="5" face="Impact"><?php echo $row["Header"]; ?></strong></font></p>	  
		<p align="center"><img src="/samples/dave_samples/<?php echo $row["File_Name"]; ?> "></p>

nnichols

Change -

$result = mysql_query($dbQuery) or die("Couldn't get file list");

to -

$result = mysql_query($dbQuery)
	or die("Couldn't get file list.<br>MySQL error: ".mysql_error().'<br>Query: '.$dbQuery);

This will give you more meaningful errors.

Hope this helps 😉

crash3909

Thanks for the help. Now, I am not getting the error, but the JPG that I would like to print is an "X". Dead JPG. It's progess, however with no error. Also, the varaibale I call "Header" is not printing. Hmmmm.....

Thanks... Rich

nnichols

Try this -

<?

$dbServer = "host"; 
$dbDatabase = "dbase"; 
$dbUser = "username"; 
$dbPass = "password"; 

$sConn = mysql_connect($dbServer, $dbUser, $dbPass)
	or die("Couldn't connect to database server");

$dConn = mysql_select_db($dbDatabase, $sConn)
	or die("Couldn't connect to database $dbDatabase");

$dbQuery = "SELECT File_Name, Header FROM table1 WHERE Sample_Name = '$Samples'";

$result = mysql_query($dbQuery)
	or die("Couldn't get file list.<br>MySQL error: ".mysql_error().'<br>Query: '.$dbQuery);

while($row = mysql_fetch_array($result)){

echo '<p align="center"><strong><font size="5" face="Impact">'.$row['Header'].'</strong></font></p>';
echo '<p align="center"><img src="/samples/dave_samples/'.$row['File_Name'].'"></p>';
}

?>

crash3909

Success... Thank you