I gang

Update and Delete script for PHP/Mysql project

I need a php/mysql update and delete script for the following and I need this NOW>>.. today --- within HOURS... DO NOT BID if you can not do this NOW>

I have a form that inserts the rowed, location, subject, description, image, date summited, ip from where the form was submitted and a member_id I keep track of.

Table 1 - passon

_rowid_ - int primary key auto increment

location - varchar

subject - varchar

description - text

image - varchar

_submitted_ - date time

_fromaddress_ - varchar

member_id - int

Table 2 - passon_upload

_rowid_ - int

id - int

name - varchar

fdata - medium blob

Table 3 - passon_uploadsrefs

_rowid_ - int

id - int

fieldname - varchar

orgname - varchar

storedname - varchar

In my current test:

Table 1 _rowid_ is 6 in my test of data entered and the other two table “id” field has the same number 6 is the same as the other two tables and apparently is the relational field for all tables.

In other words

Table 1 _rowid_ is 6

Table 2 id is 6

Table 3 id is 6

So I am looking for a php delete script that will delete all the row of all the tables when Table 1 (passon) _rowid_ is submitted. This does not work:

$sql = "DELETE FROM passon WHERE _rowid_=$_rowid_; delete from passon_uploadsrefs WHERE id=$_rowid_; delete from passon_uploadrefs WHERE id=$_rowid_";

I also need an update script for my update page.

This is not working because it is not referencing the other two tables:

$query = "UPDATE passon SET _submitted_ = '$_submitted_', _rowid_ = '$_rowid_', location = '$location', subject = '$subject', description = '$description', member_id = '$member_id', image = '$image' WHERE _rowid_ = ‘$_rowid_'";

I also need the value for the image field.. as in…… this is my value field for location in the update form:

<input type="text" id="item1_text_1" maxlength="254" autocomplete="off" data-hint="" name="location" value="<?php echo $myrow["location"] ?>" required/>

I do not know how to reference all the data in all the tables and fields to update an image.

Evner: MySQL, PHP

Se mere: php autocomplete, c for int, how to delete, delete, sql update text, sql update field text, mysql number sql, php delete mysql row, delete mysql tables, update text sql, sql update text field, mysql update field, mysql date field, update field sql field field, sql update text text, mysql delete tables, php sql update, row text php, working auto script, query text mysql, script update mysql tables, php sql script project, delete sql php, php script echo, php sql image

Om arbejdsgiveren:
( 44 bedømmelser ) Port Charlotte, United States

Projekt ID: #6015463

2 freelancere byder i gennemsnit $23 på dette job


Hi ---------- I have good level of experience in Core PHP , OpenCart , Magento, Wordpress, Drupal ,Joomla, Codeigneter and more I am interested in offering my services. I provide 100% satisfaction guaranteed on all Flere

$20 USD på 1 dag
(273 bedømmelser)

Realseeds is very clear with the concept and way of work as freelancer @ Elance. We do not like to introduced ourselves with beautiful words. Our work will talk about us. Following are our Web Develpoment team's work i Flere

$25 USD in 0 dage
(35 bedømmelser)