MySQL Database Question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
TravisT6983
Forum Newbie
Posts: 19
Joined: Wed Jul 02, 2008 2:15 pm

MySQL Database Question

Post 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
User avatar
Jade
Forum Regular
Posts: 908
Joined: Sun Dec 29, 2002 5:40 pm
Location: VA

Re: MySQL Database Question

Post by Jade »

I'm not sure how this is a database question. Just change the URL you're pulling for the feed...
TravisT6983
Forum Newbie
Posts: 19
Joined: Wed Jul 02, 2008 2:15 pm

Re: MySQL Database Question

Post 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
User avatar
aceconcepts
DevNet Resident
Posts: 1424
Joined: Mon Feb 06, 2006 11:26 am
Location: London

Re: MySQL Database Question

Post by aceconcepts »

explode() or str_replace()
Post Reply