Page 1 of 1

MySQL Database Question

Posted: Tue Nov 04, 2008 9:40 am
by TravisT6983
Ok not exactly sure if this is where i should ask this question but here goes

We get an IDX feed everynight which feeds our listing detail page and also picture urls like this one...
http://attach.realcomponline.com/?Path= ... 000&o=0&w=320&h=240

I would like to change the end of the string to be... http://attach.realcomponline.com/?Path= ... 000&o=0&w=800&h=600

to make the pictures bigger we have talked to our IDX feed and they will NOT change the string to have the bigger pictures but if you look at both urls the bigger pictures do look fine not pixelated

any help or suggestions would be great

thanks a million

Re: MySQL Database Question

Posted: Tue Nov 04, 2008 3:38 pm
by Jade
I'm not sure how this is a database question. Just change the URL you're pulling for the feed...

Re: MySQL Database Question

Posted: Wed Nov 05, 2008 8:08 am
by TravisT6983
it is a database question becuase it comes from a MySQL database heres some more info

Shown in red below is where we bring the photo into the page... i tried using...

<div id="PhotoArea" name="PhotoArea"> <img src="<?php echo $firstphoto; ?>" name="ImageFull" border="1" width="800" height="600" />

i tried using...

<div id="PhotoArea" name="PhotoArea">
<img src="<?php
$str = '$photoURL';

$a = explode('&', $str);
$a[8] = "w=800";
$a[9] = "h=600";

$str = join('&', $a);

echo $str;

?>" name="ImageFull" border="1" width="800" height="600" />

I am so not a php guy so any more help you can give me would be great

thanks so much

T

Re: MySQL Database Question

Posted: Wed Nov 05, 2008 8:23 am
by aceconcepts
explode() or str_replace()