How do I add 'image' to URL?

[dave204]

OK - I've pulled together 2 scripts - and come up with the following, but how do I then add the resulting $row['image']; into the URL I had previously, to use inside an Android app??

Previous URL:  http://www.padihamcars.com/file_display.php/?id=1

Quite obviously, id=1 no longer applies. So what do I add to this URL from echo $row['image'];  ??

Many thanks in advance!!

 

<?php
 include "file_constants.php";
  $link = mysql_connect("$host", "$user", "$pass")
     or die("Could not connect: " . mysql_error());
$sql = "SELECT image FROM test_image ORDER BY id DESC LIMIT 1";
  $result = mysql_query("$sql");
  $row = mysql_fetch_assoc($result);
  mysql_close($link);
  header("Content-type: image/jpeg");
  echo $row['image'];
?>

[benanamen]

 

echo "<img src=\"<?= {$row['image']} ?>\">";

[dave204]

Is it not http://www.padihamca...splay.php/image

?? I need it in the above format, to use inside the Android app..

[mac_gyver]

you need to stop creating new threads for this and read what has already been posted.

 

you were told in the first thread that the code that dynamically outputs the imaged based on the id in the link, isn't the code you need to change. you need to change the code that's producing the links so that it produces a link that contains the highest id.

[benanamen]

@mac_gyver, to the second part, the query he now has already gives him the the highest single id. He just needs to output the result.

SELECT image FROM test_image ORDER BY id DESC LIMIT 1

[benanamen]

Is it not http://www.padihamca...splay.php/image

?? I need it in the above format, to use inside the Android app..

 

No. Attach a zip of ALL your files and an sql dump of your DB so we can handle this once and for all. It doesnt matter about Android.

 

AND STOP MAKING NEW THREADS

Edited October 8, 2015 by benanamen

[dave204]

Looking like I'll have to work this one out myself, because no one on here can give me the correct php code to produce a link to the http inside the

Android app. echo row['image'] just won't cut it inside an Android app..

[benanamen]

Since you are not providing what I asked for, you are now on your own as far as I go. You come here asking  for FREE help and wont provide what is asked of you.