I gang

Transfer Four Words To Altimage Field II

Transfer Four Words To Altimage Field II

GOAL

This project was posted last year and a service provider had delivered a script that worked. For some reason, it no longer works.... so create a script of your own or correct the existing script found below using the attached file called fix_this_page.php.

SELECTION PROCESS:

The first service provider that sends me back the php page with the corrected problem gets the job for $30.

ORIGINAL DETAILS OF JOB

I have a products table with an auto-increment column called productnumber. The next row is producttitle with varchar(55). This field generally contains 6-9 words. I want to transfer the producttitle's first 4 words into the altimage field with varchar(40) by use of a form submission at the address below. Both fields are in the same table...(see sample image)

FORM SUBMISSION - It already includes an operational webform, recordset and an update server behavior.

[url removed, login to view] -------->submits to

[url removed, login to view]

NOTE

I've been successful at trimming the data from producttitle into altimage by a simple form transfer thereby taking off the last 15 characters due to altimage's smaller field capacity. There is no logic to it because it splits words and somethings your left with 5 or 6 words.

Existing Script that doesn't work-----------------------------------------

$_pwr = array( );

$_pwr['title'] = $row_rsImages['producttitle'];

$_pwr['title'] = explode( " ", $_pwr['title'] );

$_pwr['altimage'] = "";

$_pwr['length'] = ( count( $_pwr['title'] ) < 4 ) ? count( $_pwr['title'] ): 4;

for( $_pwr['x'] = 0; $_pwr['x'] < 4; $_pwr['x']++ )

{

$_pwr['altimage'] .= $_pwr['title'][$_pwr['x']] . " ";

}

$_pwr['altimage'] = trim( $_pwr['altimage'] );

$_pwr['sql'] = "UPDATE `products`, `accounts` SET `products`.`altimage`='{$_pwr['altimage']}' WHERE `accounts`.`username` = '{$colname_rsImages}' AND `accounts`.`accountnumber` = `products`.`sellernumber` AND `products`.`productnumber`='{$row_rsImages['productnumber']}'";

mysql_query( $_pwr['sql'] )or die( mysql_error( ) . "<br />" . $_pwr['sql'] . "<br />" );

------------------------------------------------------------------------------------

DATABASE MySQL client version: [url removed, login to view] DB Type MyISAM

LANGUAGE PHP Version 5

--------------------------------------------------------------------------------------

INFORMATION PROVIDED:

Please base your bid on this but I will be happy to answer questions and exchange correspondence through this website's personal message board during the development of this work. Try to keep in mind of time zones differences if responses aren't immediate.

Færdigheder: Javascript, Linux, MySQL, PHP, SQL

Se mere: website development in simple words, update data base by form & php, selection problem, mind array, job transfer, it field, correct username, auto - exchange.script, auto - exchange . script, script words, type words, Trim, transfer, products transfer, no address to, logic x, ii, four, four page, file transfer, php file exchange, update images mysql database php, personal service provider, simple php message board, database note taking

Om arbejdsgiveren:
( 31 bedømmelser ) Antioch, United States

Projekt-ID: #969186

Tildelt til:

DrTech76

Hi! I'll be right back.

$30 USD in 0 dage
(343 bedømmelser)
6.8

4 freelancere byder i gennemsnit $30 for dette job

TheInnoVibes

Please Check Private message .

$30 USD in 0 dage
(135 bedømmelser)
7.3
eddie09

let me finish this. thanks

$30 USD in 0 dage
(22 bedømmelser)
5.4
cedricve

Hello, problem fixed. Please Query me for the solution. Regards, Cédric

$30 USD in 0 dage
(17 bedømmelser)
4.5