Re: It works but HUH!
| From: | Ignacio Vazquez-Abrams | Date: | Wed, 20 Dec 2000 18:17:51 +0000 |
| Subject: | Re: It works but HUH! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-31273@lists.php.net to get a copy of this message | ||
On Wed, 20 Dec 2000, Sefton wrote:
> Hello Everybody,
>
> This sort of works.
> A. It returns all the values
> B. it only writes the first row into a table the rest is all over the place
> C. The images that are there still just load the 1.gif image.
>
> What could I be doing wrong?
> Yes I am a dumb ass and cannot work it out, even with this part coming from
> a question i have already asked.
> Please HELP!
>
> It is supposed to return the information from a MySql Database. If the photo
> of the vehicle is there then it is display in the first cell of that row,
> but if the photo is not there it displays the 1.gif image.
> <?
> // My first lot of code goes here, I haven't displayed it. It is the problem
>
> while ($myrow = mysql_fetch_row($result)) {
>
> echo "<tr><td>$myrow[0]</td><td width=130>";
> if (file_exists("/si/$myrow[0].gif")) {
> echo "<img src=\"si/$myrow[0].gif\">";
> }
> else {
> echo "<img src=\"si/1.gif\"></td>";
>
> echo
> "<td>$myrow[1]</td><td>$myrow[2]</td><td>$myrow[3]</td>";
> echo
> "<td>$myrow[4]</td><td>$myrow[6]</td><td>$$myrow[9]</td></tr>\n";
> $myrow[0];
> echo "</table>\n";
> }
> }
> ?>
>
Try putting the arrays in quotes in braces:
"/si/{$myrow[0]}.gif"
"<td>{$myrow[1]}</td>..."
--
Ignacio Vazquez-Abrams <ignacio@openservices.net>