alt image tags in MySQL

I have a general product MySQL Database running. Using datassist to add products to a mysql database, is there a way that if I made a new field for the alt image tags, that I can have it show up dynamically on the page?

The site is at: www.centurymachinery.com/default.php

Thanks!

yes, add the alt image column in your database, update the recordset that is used to populate the page to return the alt image tag column.

then update the image tag to use the reecordset biding in the alt attribute:

alt="<?php echo $row_recordsetName['ColumnName']; ?>"

Hey Jason,

I did it all, but when I update a product in the admin (products_update.php), the ImageAltText field in the products_detail.php page shows a 0. And when I put a mouse over the image on the web page, nothing shows.

Any thoughts?

See PM

what is the data type for the new column you added?

in the update page, did you add a form element for adding the alt text?

Did you update the update record behavior so it is storing the alt text?

yeah, looking ad the product_update page, the update record behavior has not been updated to bind the Alt text column to the alt text form element...

To answer your questions:

what is the data type for the new column you added? MediumText

in the update page, did you add a form element for adding the alt text?
<li class="formItem">
<div class="formGroup">
<div class="lineGroup">
<div class="fullColumnGroup"><label for="prodImageAltText" class="sublabel" >Product Image Alt Text:</label>
<div class="errorGroup">
<div class="fieldPair">
<div class="fieldGroup">
<span>
<input name="prodImageAltText" type="text" class="formTextfield_Medium" id="prodImageAltText" tabindex="11" title="Please enter a value." value="<?php echo((isset($_GET["invalid"])?ValidatedField("productsupdate","prodImageAltText"):"".$row_WADAproducts["prodImageAltText"]."")); ?>" size="100">
</span>
</div>
</div>
</div>
</div>
</div>
</div>
</li>

Did you update the update record behavior so it is storing the alt text? How?

no, i did not update it, you have to do this.

open the server behaviors panel and double click the update record behavior to make changes to bind the alt text column to the alt text form element.