Query Result = ARRAY

kpowning

I have the following code that I'm using to query the database and the only result that I'm receiving back is text stating: ARRAY.. Why???

chdir('/home/kyle/public_html/forums/');
require "./global.php";
$link = mysql_connect("localhost", "username", "password"); 
mysql_select_db("database_name", $link); 
$sql=mysql_query("SELECT title FROM photos WHERE id='$photo'", $link);
$result = mysql_fetch_row($sql) or die(mysql_error()); 
$hdrtxt = "ShowPhoto $result";

The $hdrtxt is being used to echo out the text: ShowPhoto with the $result from the query.. So right now all I'm getting is: ShowPhoto Array.......... WHY???

Weedpacket

Because, as the manual takes pains to point out, [man]mysql_fetch_row[/man] returns an array. If you want any of the contents of the array you have to say so.

$hdrtxt = "ShowPhoto ".$result[0];

(using mysql_fetch_array() or mysql_fetch_assoc() would be easier, because then you could say

$hdrtxt = "ShowPhoto ".$result['title'];

kpowning

Thanks for the help.. One more question... Sorry man I'm still a newbie here.

Ok follow this:
http://www.gspotracing.com/4x4rigs/showphoto.php/photo/75/sort/1/size/medium/cat/516/page/1

The link above changes everytime i click on the next image on my page, the only thing that changes in this link is where the number 75 is right now to another number.. In the code it shows that number as being called $next_image.

How can I substitute this $next_image to query the database as well.

chdir('/home/kyle/public_html/forums/');
require "./global.php";
$link = mysql_connect("localhost", "kyle_gspot", "raceit"); 
mysql_select_db("kyle_gspot", $link); 
$sql=mysql_query("SELECT * FROM photos WHERE id='$photo'", $link);
$sql1=mysql_query("SELECT * FROM photos WHERE id='$next_image'", $link);
$result = mysql_fetch_assoc($sql);
$result1 = mysql_fetch_assoc($sql1);
if ($photo != ''){
$hdrtxt = "ShowPhoto ".$result['title'];
} else {
$hdrtxt = "ShowPhoto ".$result1['title'];
}

Would this work for a conditional statement?? Because no matter what, I can't get the query to run when the $next_image variable is changed to another number...

kpowning

Can anyone help me with this????

midget

The answer is already in previous posts...

just use

$hdrtxt = "ShowPhoto ".$result[0];

You will get the first element of the array... (looking at you query will be the title field)

Good luck

midget

TheAndrew

I would code it like this


chdir('/home/kyle/public_html/forums/'); 
require "./global.php"; 
$link = mysql_connect("localhost", "username", "password");  

mysql_select_db("database_name", $link);  

$sql=mysql_query("SELECT title FROM photos WHERE id='$photo'", $link); 
$result = mysql_fetch_row($sql) or die(mysql_error());  

extract($result);
$hdrtxt = "ShowPhoto $title";