fields are not working

javashackgirl

disclaimer: I did not create the database and php pages, I'm only modifying them.

In this site, there is an 'admin' section, in which you add the data that goes into the database and then gets distributed on the site.

I added some new fields or 'columns' to the database, then went into the admin section to modify them accordingly.

The trouble is, once in the admin section, as soon as I input data into any of these new fields and hit 'submit', the data doesn't 'stick'.

He has this so that there is a top.php which is the header and contains all the main 'stuff' about the db (i.e.: <?php $featured = $HTTP_POST_VARS['featured'];?>, those are edited accordingly.

Then in the form, in each of the fields, the <?php ?>has also been entered in accordingly.

I've double and triple checked everything and can't find anything that I missed. So I'm wondering if maybe it's something in the db or something else simple.

TIA

LordShryku

That's kinda vague...but did you edit the SQL that does the updates?

javashackgirl

what is the SQL that does the updates?

LordShryku

Well, these fields on the form....you fill them in with info...that info is used to build a SQL query. That SQL query updates the database....

Pig

SQL is what communicates to the database. It takes the form data and applies it to the database. We would need to see the portion of code that has the query in it. There should be a line that says something like:
$result = mysql_query($sql);
$result = safe_query($sql);
$result = db_query($sql);
$result = mysql_query("UPDATE table_name SET this='that'...etc");

That query, plus whatever goes before it would be nice.

drawmack

Originally posted by javashackgirl
what is the SQL that does the updates?

if you've gotta ask that question you're probably not qualified to be mucking around in this script.

javashackgirl

This is what I've got: (I found no $result, or even submit)

<?php
$db = mysql_connect('localhost', '', '') or die( "Unable to connect" );
mysql_select_db("test",$db);

if($addproperty == 'yes') {
$feature = '0';

if($featured == 'yes') {
$query = mysql_query("select max(featured) from properties");
$row = mysql_fetch_array($query);
$feature = $row[0] + 1;
}

$query = mysql_query("insert into properties
(location, listing_type, price, mls, prop_status, year_built, sq_ft, con_type, beds, baths, fam_rm, pantry, heating, cooling, garage, fenced_yd, hextra1, hextra2, hextra3, hextra4, hdescription,
lot_size, acres, surveyed, land_split, access, bpublic, irrigated, water_rights, land_water, well, power, phone, septic, fenced, landscaping, garden, livestock, lextra1, lextra2, lextra3, lextra4, pic1, pic2, pic3, pic4, pic5, pic6, featured)
values
('$location', '$listing_type', '$price', '$mls', '$prop_status', '$year_built', '$sq_ft', '$con_type', '$beds', '$baths', '$fam_rm', '$pantry', '$heating', '$cooling', '$garage', '$fenced_yd', '$hextra1', '$hextra2', '$hextra3', '$hextra4', '$hdescription', '$lot_size', '$acres', '$surveyed', '$land_split', '$access', '$bpublic', '$irrigated', '$water_rights', '$land_water', '$well', '$power', '$phone', '$septic', '$fenced', '$landscaping', '$garden', '$livestock', '$lextra1', '$lextra2', '$lextra3', '$lextra4', '$pic1', '$pic2', '$pic3', '$pic4', '$pic5', '$pic6', '$feature')
") or die (mysql_error());

}
?>

This is just the add.php page (used to add properties to the db). The edit.php page is similar (used to query the db and update):

<?php include 'top.php'; ?>

<?php
if($editproperty == 'yes') {$db = mysql_connect('localhost', '', '') or die( "Unable to connect" );
mysql_select_db("test",$db);

$feature = '0'; if($featured == 'yes') {$query = mysql_query("select featured from properties order by featured desc limit 1");
$row = mysql_fetch_array($query); $feature = $row[0] + 1;}

mysql_query("update properties set
location = '$location', listing_type = '$listing_type', price = '$price', mls = '$mls', prop_status = '$prop_status', year_built = '$year_built', sq_ft = '$sq_ft', con_type = '$con_type', beds = '$beds', baths = '$baths', fam_rm = '$fam_rm', pantry = '$pantry', heating = '$heating', cooling = '$cooling', garage = '$garage', fenced_yd = '$fenced_yd', hextra1 = '$hextra1', hextra2 = '$hextra2', hextra3 = '$hextra3', hextra4 = '$hextra4', hdescription = '$hdescription', lot_size = '$lot_size', acres = '$acres', surveyed = '$surveyed', land_split = '$land_split', access = '$access', bpublic = '$bpublic', irrigated = '$irrigated', water_rights = '$water_rights', land_water = '$land_water', well = '$well', power = '$power', phone = '$phone', septic = '$septic', fenced = '$fenced', landscaping = '$landscaping', garden = '$garden', livestock = '$livestock', lextra1 = '$lextra1', lextra2 = '$lextra2', lextra3 = '$lextra3', lextra4 = '$lextra4', pic1 = '$pic1', pic2 = '$pic2', pic3 = '$pic3', pic4 = '$pic4', pic5 = '$pic5', pic6 = '$pic6', featured = '$feature' where id = '$id'");
echo "<center><font color='red' size = '+1'>Update Successful</font></center>";
}?>

<?php
$db = mysql_connect('localhost', '', '') or die( "Unable to connect" );
mysql_select_db("test",$db);
$query = mysql_query("select * from properties where id = '$id'", $db);
$row = mysql_fetch_array($query);

$location = $row['location']; $listing_type = $row['listing_type']; $price = $row['price']; $mls = $row['mls']; $prop_status = $row['prop_status']; $year_built = $row['year_built']; $sq_ft = $row['sq_ft']; $con_type = $row['con_type']; $beds = $row['beds']; $baths = $row['baths']; $fam_rm = $row['fam_rm']; $pantry = $row['pantry']; $heating = $row['heating']; $cooling = $row['cooling']; $garage = $row['garage']; $fenced_yd = $row['fenced_yd']; $hextra1 = $row['$hextra1']; $hextra2 = $row['$hextra2']; $hextra3 = $row['$hextra3']; $hextra4 = $row['$hextra4']; $hdescription = $row['hdescription']; $lot_size = $row['lot_size']; $acres = $row['acres']; $surveyed = $row['surveyed']; $land_split = $row['land_split']; $access = $row['access']; $bpublic = $row['bpublic']; $irrigated = $row['irrigated'];
$water_rights = $row['water_rights']; $land_water = $row['land_water']; $well = $row['well']; $power = $row['power']; $phone = $row['phone']; $septic = $row['septic']; $fenced = $row['fenced']; $landscaping = $row['landscaping']; $garden = $row['garden']; $livestock = $row['livestock']; $lextra1 = $row['$lextra1']; $lextra2 = $row['$lextra2']; $lextra3 = $row['$lextra3']; $lextra4 = $row['$lextra4']; $pic1 = $row['pic1']; $pic2 = $row['pic2']; $pic3 = $row['pic3']; $pic4 = $row['pic4']; $pic5 = $row['pic5']; $pic6 = $row['pic6'];
?>

Hope that's what you needed. 🙂

javashackgirl

Btw, Drawmack, I WOULDN'T be mucking around in the script if my dang DATABASE GUY would DO HIS JOB!

Someone's gotta do it, and I guess that someone is me.

Pig

OK, so if I understand correctly, you have modified the form and the DB. The last piece is to modify the SQL query. On those to pages, where it says $query = mysql_query("..."); you need to add the database column names, and the form field names. The format is like this:

insert into properties (column_1, column_2) VALUES ( '$field_1', '$field_2' )

so, stick your new columns names at the end of the top part, and your new field names at the end of the VALUES () stuff. Make certain they are in the same order.

do that for both the queries.