[SOLVED] echo problem.

[jmac2501]

Sorry for starting a new thread bout the same thing but i simplified my script to see if i could get an answer easier this way.

 

I am pulling info from a field in my database called "reo" I need to echo this results into a http string but i am having no luck. I have marked in red the $reo that i need echoed

<?php
error_reporting(E_ALL ^ E_NOTICE);

$link = mysql_connect('mysql6.*****.com', '******', '*****')
    or die('Could not connect: ' . mysql_error());
mysql_select_db('dcremax') or die('Could not select database');
$query="SELECT * FROM Listings";
$result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();


$i=0;
while ($i < $num) {

[color=red]$reo[/color]=mysql_result($result,$i,"reo");

require_once("class_http.php");

$h = new http();

$h->dir = "/home/foo/bar/"; 

if (!$h->fetch("http://metrolistmls.com/cgi-bin/GetOneR.cfm?County=SA&iRow=0&nJL=7&MLSNum=[color=red]$reo[/color];")) {

  echo "<h2>There is a problem with the http request!</h2>";
  echo $h->log;
  exit();
}

if($beg = strpos($h->body, "http://mlsmedia.metrolistmls.com/bigphoto/", 0 ))
{$end = strpos($h->body, ".jpg", $beg );
$pic = substr($h->body, $beg, ($end + 4) - $beg );
echo("$pic");
echo("<br />");
}

$i++;
}

?>

 

If i manuly add the "reo" info it works fine. but if i try to use the $reo query it times out. Any helf would be great.

 

Thanks

[pdkv2]

You have closed the connection with mysql an trying to fetch the results from db

 

mysql_close();

 

is used before

 

mysql_result($result,$i,"reo");

 

 

Rgds

[jmac2501]

Where should i put it? I tried puting it below $reo=mysql_result($result,$i,"reo"); but i get a

 

Warrning: mysql_closed ().  error

 

 

[mmarif4u]

Mostly ppl put it at the end of code before closing php tag.

[jmac2501]

ok so i did that and I don't get that error anymore. So I guess my question is How do i echo $reo=mysql_result($result,$i,"reo"); into here

 

if (!$h->fetch("http://metrolistmls.com/cgi-bin/GetOneR.cfm?County=SA&iRow=0&nJL=7&MLSNum=$reo;")) {

 

 

[pdkv2]

ok so i did that and I don't get that error anymore. So I guess my question is How do i echo $reo=mysql_result($result,$i,"reo"); into here

 

if (!$h->fetch("http://metrolistmls.com/cgi-bin/GetOneR.cfm?County=SA&iRow=0&nJL=7&MLSNum=$reo;")) {

 

 

 

 

ya do it like this

 

if (!$h->fetch("http://metrolistmls.com/cgi-bin/GetOneR.cfm?County=SA&iRow=0&nJL=7&MLSNum=".$reo)) {

 

[jmac2501]

Thanks that work. You are the man