Can you use the 'ID' field as an array?

[nawrik]

I'm probably missing something easy...all help welcomed.

I am currently creating an 'Images' page which displays a thumbnail (url), the image title, and the image caption.

These all live in a table called 'portfolio' - the the relevant fields:

imagethumb, imagetitle and imagecaption.

Here is where I get lost...

...there is also a PRIMARY Key, Integer, auto_increment set as 'id' - with the plan to increase as the rows in the database do.

I've thought about giving each field a UNIQUE name - imagethumb1 --> imagethumb21
ut as you can imagine the database would soon get 'messy'

Is there a way for me to access a particluar row by using the 'id' as the reference.

This is what I have so far:

<?php
@ require_once("db_connect.php");

$query = "SELECT id,imagethumb,imagetitle,imagecaption FROM portfolio";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
$id = mysql_result ( $result, 0, "id" );
$imagethumb = mysql_result ( $result, 0, "imagethumb" );
$imagetitle = mysql_result ( $result, 0, "imagetitle" );
$imagecaption = mysql_result ( $result, 0, "imagecaption" );

And to display the data:

Image Number: <?php echo ($imagethumb); ?>
Image Title: <?php echo($imagetitle); ?>
Image Thumbnail: <?php echo("<img src=\"../portfolio/".$imagethumb.".jpg\""); ?>
Image Caption:<?php echo($imagecaption); ?>

This as you can imagine works fine for the first row in the database....

...what I would I have to do to make the unique 'id' from each row change so I can call up whatever $variable I want.

I think I need to make the 'id' into an array - e.g: $imagethumb['12']

But I don't have a clue how to do this.

Any help?

[djjjozsi]

list.php

<?php
include_once("connect.php");
$sql="SELECT * FROM portfolio ORDER BY imagecaption ASC";
$result=mysql_query($sql);
while($rows=mysql_fetch_assoc($result))
{
print "<a href=\"details.php?site=listportfolio&id={$rows["id"]}\"> ".$rows["imagecaption"]."</a><br>\r";
}
?>

details.php

<?php
if($_GET["site"]=="listportfolio" AND isset($_GET["id"]))
{
include_once("connect.php");
$sql="SELECT * FROM portfolio WHERE id=".(int)$_GET["id"];
$result=mysql_query($sql);
if(mysql_num_rows($result)>0)
{
$rows=mysql_fetch_assoc($result);
print "imagecaption:".stripslashes($rows["imagecaption"])."<br>\r";
print "imagetitle:".stripslashes($rows["imagetitle"])."<br>\r";
print "imagethumb:".stripslashes($rows["imagethumb"])."<br>\r";

}
else
print "No data found";
}
?>

[nawrik]

djjjozsi,

Thankyou so much for the swift reply - it truly is appreciated.

Having just studied your reply, I think it makes sense.

In a nutshell, I'm able to show each 'row' on a seperate page using the 'id' field.

However do you know how I can call each variable wherever I want it on the same page?

I'm pulling up the first thumbnail and its details with the variables $imagetitle, $imagethumb, $imagecaption - the title and caption are in textarea's - with the foresight to type the new name and 'save to database' (like the General Tab).

I'm wanting to bring up all rows in the database and place under this first example.

The problem is that I am 'SELECT'ing the fields from the table and placing with the $variables. This works fine with the first row, but stumbles when wanting to show row 2,3,4 etc...

I'm guessing the only way to differentiate each row is with the 'id' field.

Is there a way for me to seperate each row using the 'id' without making unique table fields: $imagethumb2,$imagethumb3 etc...

Because the DB would be messy.

I maybe wrong but I think this is what Unique ID's are for, I just don't know how to manipulate them to display them.

My apologies for not explaining this correctly the first time around - however I have learnt how to shorten my code for the 'index.php?tabs=' in the above CMS!!

Again thankyou for your help!

[djjjozsi]

Hello,

I'm wanting to bring up all rows in the database and place under this first example.

maybe you think of this:
when you list the images, and create the textfield(s) for the update tasks,
as a textfield name you can use arrays, and its index is the id field's value.

        <td><input class="formlinkText" type="text" value="Image 001 Title" name="imagetitle[4]"></td>
      </tr>
      <tr>
        <td><img src="../portfolio/tn_001.jpg"</td>
        <td><input class="formlinkText" type="text" value="Image 001 Caption" name="imagecaption[5]"></td>

where 4 is the value of the id field.
on update php, you can use foreach function to get the value - key pairs to update with the new values.

Hello,
jjozsi.