Re: OT: PHP Query in Results

2005-05-31 Thread Simon Cornelius P . Umacob
Yatik daw la :( I again have trouble seeing small details such as these: > $data = mysql_fetch_object($pic); > echo "$pic->img_name "; > echo "img_name\" />"; CORRECTION: $pic->img_name should be $data->img_name > > or, using mysql_fetch_array(): > > $data = mysql_fetch_array($pic); > echo

Re: OT: PHP Query in Results

2005-05-31 Thread Simon Cornelius P . Umacob
Yatik daw la :( I again have trouble seeing small details such as these: > $data = mysql_fetch_object($pic) > echo "$pic->img_name "; > echo "img_name\" />"; CORRECTION: $pic->img_name should be $data->img_name > > or, using mysql_fetch_array(): > > $data = mysql_fetch_array($pic) > echo $p

Re: OT: PHP Query in Results

2005-05-31 Thread Simon Cornelius P . Umacob
Yatik daw la :( I again have trouble seeing small details such as these: > $data = mysql_fetch_object($pic); > echo "$pic->img_name "; > echo "img_name\" />"; CORRECTION: $pic->img_name should be $data->img_name > > or, using mysql_fetch_array(): > > $data = mysql_fetch_array($pic); > echo

Re: OT: PHP Query in Results

2005-05-31 Thread Simon Cornelius P . Umacob
I agree with Jochem that you can grab the exact data in one query. However, after seeing the problem from another perspective, your problem lies at the fact that you directly used $pic to print the image name: $pic = mysql_query("select img_name from pics WHERE rntID = 31"); echo "$pic "; echo

OT: PHP Query in Results

2005-05-31 Thread Jillian Koskie
Okay... I'm missing something obvious. I've got a PHP query, and based on the results of a query, I need to do another query for the image name. This would be very easy in ColdFusion and so I'm wondering how to do it in PHP. My code: "; echo "http://www.domain.com/reg/userlisting.php?fulllisti

Re: OT: PHP Query in Results

2005-05-31 Thread Jochem van Dieten
Jillian Koskie wrote: > Okay... I'm missing something obvious. > > I've got a PHP query, and based on the results of a query, I need to do > another query for the image name. This would be very easy in ColdFusion > and so I'm wondering how to do it in PHP. > > My code: > > $dbh=mysql_connec

OT: PHP Query in Results

2005-05-31 Thread Jillian Koskie
Okay... I'm missing something obvious. I've got a PHP query, and based on the results of a query, I need to do another query for the image name. This would be very easy in ColdFusion and so I'm wondering how to do it in PHP. My code: "; echo "http://www.regina4rent.com/reg/userlisting.php?f