Update Record And Get Affected ID
i have a table.
member_id, email, code
1000, abc@abc.com, 1
1001, def@def.com, 2
i am using below query:
UPDATE table SET email = 'xyz@xyz.com' where email ='abc@abc.com'
can i use above statement and let MYSQL return the member_id = 1000 as a recordset without using SELECT statement?
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Update Statement :: Affected Rows: 0
UPDATE `zipLocations` SET `z_zipCode` = '06001' WHERE `z_zipCode` =6001 LIMIT 1 ; Field Type Attributes Null Default Extra Action z_zipCode int(5) No 0 z_cityName varchar(50) No s_stateAbbr char(2) No z_countyName varchar(50) No z_areaCodes varchar(50) No I even went through phpmyadmin found the row clicked on the edit button for that row and updated it. and it still doesn't update.. im' thinking it has to do with the data type being INT... Why doesn't it update it ?.. It says it was successful. Affected rows: 0 (Query took 0.0002 sec)
View Replies !
View Related
Cant UPDATE The Record. Help
$connect=mysql_connect("localhost","root","") OR die('Coould not Connect to MySQL because <b>'.mysql_error().'</b>'); mysql_select_db("guestbook") OR die('Could not Connect to MySQL because <b>'.mysql_error().'</b>'); $query="UPDATE redorartiaga SET fname={$_POST['fname']},mi={$_POST['mi']},lname={$_POST['lname']},address={$_POST['address']},birthdate={$_['bday']},contact={$_POST['contact']},email={$_POST['email']},jobtitle={$_POST['jobtitle']},company={$_POST['company']} where id={$_GET['id']}"; mysql_query($query); mysql_close(); what seems to wrong to my syntax. i cant determine whats wrong, because mysql doesnt give me any error message but nothing updates to my record.
View Replies !
View Related
Record Update/Edit
I have a number of tables that are linked together. If a record record is created in the "main" table, atleast one record or more is created in the other tables. My users have requested a edit function and I was wondering which of the below methods would be best. 1. Delete the main record and all record relating to it in all the other tables. Then creating new records for the tables with the new data. OR 2. Check if the the data has changed, and if it has either create a new record if one does not already exist or update if it already exists. Or if data did exist and no longer does delete the record. For simplicity sake the first one was the option I would go with but I am not sure if it would create more headaches in the long run.
View Replies !
View Related
Update Same Table With More Than One Record
I have a forum table which I need to perform the following update 1) I have an original message which I need to change its online status into DISABLE 'D' in my "status" field as follow single command: UPDATE forum SET status = 'D' where message_id = 1 and parent_id is NULL; *the parent_id field is NULL because it is a parent thread... However, it has some child threads to this message...therefore I must force the all the child thread to change the status into 'D' also. So I did a second sql query as follow: UPDATE forum SET status = 'D' where parent_id = 1; *parent_id = 1 means it points to the parent message_id = 1 My question is DOES anyone know a good sql query that will combine these two queries into ONE single query?
View Replies !
View Related
UPDATE Record & Upload Image
Am creating a backend CMS and want to give users the ability to update an article and upload a new image if they wish or keep the original. Am not sure where to even start with this as have only ever used image upload with INSERT.
View Replies !
View Related
UPDATE Step Thru Every Record W/out Unique Id Field
How can I update every record of a given table one by one. I need to update a field (date) with a different, random date for each record. loop { generate random date; update one record with new date; goto new record } Problem. Table does not have a unique id field table (item, date) peaches - 2003-05-13 pears - 2003-11-24 peaches - 2004-01-04 the table is a given... meaning I have to work with it the way it is.
View Replies !
View Related
Affected Row
how to go about this: If I insert a row into my database.. eg. mysql_query("INSERT INTO l_teams VALUES ('','$_GET[id]','','','0','0','0','0','0','0','0')"); The first field is "id" which is an auto increment.. is there a way to simply then find out what the number is of that field. I orginally was just quering the last row and finding the id number, but if 2 rows are entered at same time by two different users this causes an error.
View Replies !
View Related
Obtain Affected Columns
Is there a way to obtain only the affected columns after an update query? After an update query, that involves 10 columns, I know that only 2 columns are really updated (because the values of the other cols don't change). I need to know the names of that changed cols, for logging purpose.
View Replies !
View Related
Performance Affected By Tables
I'm develloping a game which will have to store information about objects located in each square of a large grid. Since there can be many, or none, or a combination of different objects in any given square at a time, I figure I should create a table for each square on the grid containing the names of the objects in it. This may lead up to 1000-5000+ tables though, many of which could/will be empty, and I was wondering if that is the best approach I can take?
View Replies !
View Related
How Many Rows Were Affected By Query?
How do I retrieve the number of affected rows by an UPDATE query with SQL? The C API exposes mysql_affected_rows() but I can't find documentation of the SQL equivalent... I'm trying to find if an UPDATE had an effect within a stored procedure, so I can do an INSERT if there's no row to update. Doing it the other direction to generate an error to act on would be quite wasteful... one INSERT and millions of errors per day.
View Replies !
View Related
Start Transaction Blocks Rows Affected Return Value
I'm calling an update stored procedure from ASP.NET code via the .NET Connector v5.1.4.0, and Microsoft's Data Application Block v3.1.0.0 The actual code calls the procedure via the application block's ExecuteNonQuery method, which is supposed to return the 'rows affected' by the procedure code. Everything works fine, but if I wrap the mysql code in a Start Transaction; and a Commit; then ExecuteNonQuery returns 0 rows affected, eventhough that's not true. If I comment out the transaction statements then ExecuteNonQuery returns the actual number of rows affected.
View Replies !
View Related
Automatically Record Date Of Record Entry
I have my database table set up and I have an HTML form that is PHP driven that will add the information entered into the form into to my database table. I have a local buy-sell-trade Website. The way it has worked is that people fill out a form and the results emailed to me. I then take the information and enter it into a Web page. I only want the ads to be displayed for 30 days. I keep the ad for a total of 6 weeks (displays for 30 days and sits in limbo for 2 weeks afterwords) and if not renewed within that 2 week limbo period - I delete it. Entering all the ads and keeping up with the dates manually has become a burden. I've only recently began looking into databases. My hosting company provides me with phpmyadmin and mysql 5.0. I'm new to all of this but I have managed to set up a database table and a HTML form that is PHP driven that allows ads to be automatically added to the database table. There is a lot I need to do to make this ideal, but one step at a time. First, I need to know the date (March 02, 2006) the ad was created or added to the database table. I know that I need to add some piece of code to my php form to record this information, but what code and where do I put it? I know I will need to create an extra field in my database table to house the date - I can handle this. I've read the date and time information here http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html but there's a lot there and I don't know which is right for my needs. Plus, it doesn't tell me how or where to insert it into my php form (or does it?).
View Replies !
View Related
Getting Record Before Or After The Record That Meets The Criteria
In a query I want to get all the results and then order those results by last name, but then I want to filter those results down to only the record that comes before or after the record that has 'empno' = '1259'. I want to get all the results already ordered and then filter them down to one record either before or after (depending on what is needed) the record where 'empno' = '1259'.
View Replies !
View Related
How To Record The Current Record In A Table?
I'm looking at convert file formats to mysql. The original file format used an "ENTRY" conception to record the current record. But I cannot find a solution to emulate "ENTRY" conception in MySQL. After searching MySQL's tutorials, the AUTO-INCREMENT fields would only use "mysql_insert_id()" to obtain its value. But this value cannot identify the current record, Right? This value are only last record after inserting? Who can help me to find a better solution to emulate implementing what the "ENTRY" does. In other words, How to obtain the auto-increment value contains AUTO-INCREMENT columns in a record which generated by SELECT statement.
View Replies !
View Related
Record Creates Record
I have a table that holds inventory information...primary key'd with an asset#. I have another table that I hold certain information in that I don't want in the main inventory table. I would like the second table to key itself and automatically enter a record when a device is entered. For example, I enter a scanner in my main table, but I want the DB to then also enter that assetNumber into the second table for me.
View Replies !
View Related
Update Replication, Force Update
Recently an error in the db on my master caused the slave to fail. I noticed this after a few days when I looked at the status and it said "Slave_SQL_Running: No". After looking further I saw what the error was on the master. What is the best method of re-synching the databases? Is there a command to force a re-replication or synch of the dbs? Would you delete the slave's db and update over? In this case, is there a command to pull the data down from the master?
View Replies !
View Related
Complex Query - UPDATE Within UPDATE?
Edit: Before anyone leaves this thread, don't be put off by the regular expressions! They are not the problem, so please stay and read. OK, this query has got my head spinning. I am basically creating a query that goes through each product in a table to update the stock for that particular item with that particular size (i.e. I am talking about shoes - different models and each model has different sizes (uk kids 12 -> uk 11). With each shoe it does (or is meant to do) the following: 1. The PHP script that runs the query is looping through every size outside of the query 2. So for each of these sizes it checks to see whether the product it is currently on matches the size it is on 3. When it finds the size it is on, it then deducts the correct number of units from the stock table 4. The final WHERE clause makes sure this subquery inside the UPDATE only happens when the StockUpdated field of the Product table equals 0 (in other words, the stock hasn't been counted before) Basically what I need to do, is first to make sure what I currently have got does the above correctly but also I need the query to UPDATE the StockUpdated field to 1 only when it has been updated successfully. How could I do this? Unfortunately I cannot just add an extra update entry to the end of the query as this would update the StockUpdated field regardless of whether it has been properly counted or not. Here is the query I have so far (with a little simple PHP around it doing the loop): PHP $shoesizes = array(1 => 'ukk12','ukk13','uk1','uk2','uk3','uk4','uk5','uk6','uk7','uk8','uk9','uk10','uk11'); $numshoesizes = count($shoesizes); for($i = 1; $i < $numshoesizes; $i++) { $stockupdate = " UPDATE heelys_stock,items_ordered SET heelys_stock.size_".$shoesizes[$i]." = (SELECT CASE WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?( )?(Kids)?( )?( )?(UK)?( )?( )?(Kids)?( )?( )?[^0-9]12( )?(' -- if UK Kids 12 THEN heelys_stock.size_ukk12 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?( )?(Kids)?( )?( )?(UK)?( )?( )?(Kids)?( )?( )?[^0-9]13( )?(' -- if UK Kids 13 THEN heelys_stock.size_ukk13 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]1( )?(' -- if UK 1 THEN heelys_stock.size_uk1 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]2( )?(' -- if UK 2 THEN heelys_stock.size_uk2 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]3( )?(' -- if UK 3 THEN heelys_stock.size_uk3 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]4( )?(' -- if UK 4 THEN heelys_stock.size_uk4 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]5( )?(' -- if UK 5 THEN heelys_stock.size_uk5 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]6( )?(' -- if UK 6 THEN heelys_stock.size_uk6 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]7( )?(' -- if UK 7 THEN heelys_stock.size_uk7 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]8( )?(' -- if UK 8 THEN heelys_stock.size_uk8 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]9( )?(' -- if UK 9 THEN heelys_stock.size_uk9 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]10( )?(' -- if UK 10 THEN heelys_stock.size_uk10 - (items_ordered.Amount/items_ordered.Price) WHEN SUBSTRING_INDEX(items_ordered.Product,',',-1) REGEXP '( )?(UK)?( )?[^0-9]11( )?(' -- if UK 11 THEN heelys_stock.size_uk11 - (items_ordered.Amount/items_ordered.Price) FROM items_ordered WHERE items_ordered.StockUpdated = 0) WHERE (heelys_stock.id = (SELECT heelys_stock.id FROM heelys_stock,heelys_shoe WHERE SUBSTRING_INDEX(items_ordered.Product,',',1) = heelys_shoe.full_shoe_name)) , items_ordered.StockUpdated = 1" // at the moment this last update of the items_ordered table happens to every record!!! even if the other part of query fails // update stock for size $i mysql_query($stockupdate); } Hope someone can see how I can do this? I've been working on this query for 2 or 3 hours now and I've been making reasonable progress but now I am really stumped.
View Replies !
View Related
Update Queries Do Not Always Update
We are running a MySQL database using PHP to create html pages and forms to update and add information to the db. Sometimes the update query works, sometimes it doesn't - or at least, not permanently. A new record may be added, but five minutes later it has sometimes, but not always, mysteriously disappeared. Where should I look for a solution? Is there a cache that MySQL creates that may be being accessed unwittingly? We are using the standard php and MySQL versions that come as standard on a Mac OS X Tiger 10.4.7 server. The browser we are using is Firefox 2.0.4.
View Replies !
View Related
ON DUPLICATE KEY UPDATE - Don't Have A Key But Want To Update
This may seem like more of a PHP question but I will come onto the MySQL part in a minute. Basically I have a PHP script that lets users upload 2 different CSV files to different tables. The problem I have is that sometimes these CSV files are updated and then need to be reimported into the database through the script. I have made this script totally generic so that when you change the table that is being entered to the rest of the script will alter itself to import the correct CSV to that table. But a problem arises when I have a CSV file that contains each product sold and the shopper who bought the product (so the shopperID may appear in more than 1 row) - however this file does not have a unique id for each row meaning that when I use an INSERT INTO with a ON DUPLICATE KEY UPDATE... it will just insert more rows instead of updating rows because there is now key in the table. The format of the table is like this (with some example data to show you more clearly): +-----------+-------------+---------+------+--------+------+ | ShopperID | Product Code | Product | Price | Amount | Units | +-----------+-------------+---------+------+--------+------+ 546733 1315 prod 1 64.00 64.00 0 546733 1316 prod 2 43.99 43.99 0 OK just ignore the last 2 fields - that is a problem with the old system there was which does not add the units up right. Anyway basically I might have the same shopper ordering 2 things which will come up on different rows - I have 3 things I cannot do: 1. I can't make the ShopperID field the PRIMARY KEY because I have many times where there are 2 rows with the same shopper 2. And I cannot just do an UPDATE when it gets to a duplicate entry because it will overwrite every time it gets to a shopper that already exists. 3. I don't want to add a unique primary key to the CSV as this will mean that the system I am creating loses its ability of being automatic because the person (an admin) that uploads the file will have to make sure that it has that extra field which is auto incrementing. Does anyone have any ideas on how I can get round this? Here is my PHP function which contains the query: PHP // this function for insert data to csv function makeINSERTS($text, $table, $tablefields, $correctcsv){ $insert = array(); //make array for hold data insert $i = 0; $success = true; while(list($key, $val) = each($text)){ // Insert the data $insert[$i] = "INSERT INTO ".$table." VALUES('"; $insert[$i] .= implode("','", $val); $insert[$i] .= "') ON DUPLICATE KEY UPDATE "; foreach($tablefields as $k=>$field){ $insert[$i] .= "`$field`='{$val[$k]}',"; } $insert[$i] = substr($insert[$i],0,strlen($insert[$i])-1); // echo $insert[$i].'<p></p>' $result = mysql_query($insert[$i]); if(!$result) { echo 'FAILURE to insert/update any or all of the database form uploaded CSV!<br />' $success = false; die('Query failed: ' . mysql_error().'<br />'); } $i++; } if($success == true && $correctcsv == true){ echo 'SUCCESS in uploading the CSV file to the database!<br />' } else { } return $insert; }
View Replies !
View Related
Getting Record
I need to query my db and only display the record with the highest number or amount. Example Record 1 bob $250 Record 2 bill $350 Record 3 bud $500 Query would only show "bud $500" and not display the other 2. Once bob updates his record to $501 then it will display "bob $501".I have everything else I just need the query syntax.
View Replies !
View Related
Last Record
I want to find out what was the last record updated. If I wanted to know what the last record inserted I would use last_inserted(id). Would I use the same function?
View Replies !
View Related
A Record
I have a database of songs played on a particular radio station, along with the date and time they were played. As you can imagine each artist-songtitle pair are repeated quite a bit. I'd like to find a query that would leave me with the earliest dateplayed and timeplayed values for each uniqe artist-songtitle pair. I have a MYSQL table containing artist,songtitle,dateplayed,timeplayed. The dateplayed is a Mysql Date vatiable and the timeplayed is a mysql time variable, the other two are varchars.Essentially what I want in the end is to know the first time they played each particular song within the database.
View Replies !
View Related
Next Record
I want to compare the value in one field in a record to the value of the same field in the next record. This is something that is pretty easy in a spreadsheet, is it possible in mysql?
View Replies !
View Related
Certain Record
lets say i have 10 records in a table. i want to start at record 6 and select all records up to 10. how do i do this? i know i can select all where record equals 6 but that will only pull all the fields for that one records.. i need to pull all the fields for records 6 through 10.
View Replies !
View Related
Get Last Record
i have table "test1" those the field and records : ----------- close_price ----------- 01/15/2007 02/15/2007 03/15/2007 04/15/2007 05/15/2007 06/15/2007 07/15/2007 08/15/2007 ---------- i want to get date "06/15/2007" where close_price="07/15/2007"
View Replies !
View Related
How To Get Only One Record ?
Suppose there is many records return by sql script: select * from student where age='20'; However ,I only want to get just one record,that is to say, it is not necessary to query the whole database, just get the first record meeting with the condition and return it. This operation can save lots of time if the database is very large.
View Replies !
View Related
Getting The 1st Record From Many
I am trying to output data to a web page that will show me the latest (date) activity for a specific field: The source info would be as follows: id, date, username, notes 1, 1/1/07, bill, broken screen 2, 1/1/07, mary, format hd 3, 1/2/07, bill, returned 4, 1/3/07, jane, lost document 5, 1/5/07, mary, returned 6. 1/6/07, mary, lost document I want to get the latest activity for each username. I would like the output to be: 3, 1/2/07, bill, returned 4, 1/3/07, jane, lost document 6. 1/6/07, mary, lost document I have seen the distinct option but every example I have found shows it working on just 1 field.
View Replies !
View Related
Get Every X Record?
I have an application loading my db with a new record for each weather station every 30 seconds. For a graphing application, I need to extract every 10th record for a station. (2880 records per station per day, but I only need 288 records for a 24 hour graph). How can I write a query to do this? FWIW, I have a timestamp on every record,
View Replies !
View Related
Against Next Record
I want to run a query to see if one field is a subset of another field. Is there a way to check if one record's field is a subset of the next record's field's value. Specifically, I'm checking for duplicates in the database, and want to find (eg) Rob Smith == Robert Smith. So I'm going to make one field with last name + first name to get SmithRob and SmithRobert. Once I order them on that new field, SmithRob will be right before SmithRobert, and I want to flag the records where one record is a subset of the next record. Is this possible?
View Replies !
View Related
Getting Next Record From DB
I got a database with 2 fields. ID (autoincrement) name (carnames) let's set it up like this: ID name 1 porche 2 mercedes 3 BMW I want to search for mercedes, but instead of showing me the mercedes record, i want it to show me the record after that (the BMW record). what i got so far is: SELECT * FROM car_names WHERE name LIKE '". $car ."' this works perfect if i wanted to see the requested car, but i want to see the record of the car that comes after the $car. ($car = in this case the mercedes) anyone got any idea ?
View Replies !
View Related
Getting The Last Record
I need to generate my primary key from my application bcos my PK has a specific format(e.g. Cl2006-09). Now to do this I need to know the last record/primary key of the last row(or only one record if exists only one)so dat I can generate my new PK by adding up to this last value. By which query I can know only the last PK of my table (or only one PK if only one exists.)
View Replies !
View Related
How To Get The Right Record?
I have 2 tables - property_active, and property_inactive. Both tables are identical in structure. I have a record_id, relating to a record in one or both of my tables. I wish to do a select, whereby: If the record relating to the given ID exists ONLY in property_active, that will be returned. If the record exists ONLY in property_inactive, that will be returned. If the record exists in BOTH tables, the version from property_inactive will be returned. I have made various attempts involving UNION, COALESCE etc, but to no avail.
View Replies !
View Related
Finding The Record ID
I am using MS Access as a front end to a MySQL server on a windows platform. The problem is that when I add a new record to a list (continuous form) of records as soon as the cursor moves to another record the just entered data appears as #DELETED until I requery the form. The problem is that the record does not appear to get an ID until it is requeried so I cannot find the ID and then return to the record after it has been requeried. I need to do this because after creating a new record I want to open another form and insert the new ID into it. I have a timestamp field on the form.
View Replies !
View Related
PHP Checking For No Record
I am trying to check for '$date' & '$mileage' but when I give them a value that is not in the table $result = 2 & the 'if' statement fails to create the new record, or just print "create DMID" in this case. $result seems to always = 2. num_rows shows correct (0 or 1) & the DMID is printed if $date & $mileage are in the table. What am I doing wrong? ----------- $result = mysql_query("select DMID from DateMileage where date = '$date' and mil eage = '$mileage'"); printf("Rows = ".mysql_num_rows($result)); $data=mysql_fetch_object($result); printf(" data= $data->DMID"); printf("<BR>Result = $result, Mileage = $mileage, Date= $date"); printf("<BR>Year = $year, Make = $make, Model = $model"); printf("<BR>Category = $category"); code...
View Replies !
View Related
Retrieving New Record ID
I'm making a web-site thats backended by php-2-mysql. A common problem seems to be when processing form data, I use information early in the form to create a new record in a main table. I then immediately need the auto_incremented Key-ID of the new record to put other information in related tables. In the past i've gotten that ID by just doing a SELECT with a WHERE that matches all the values i've just INSERTED, but it seems a cumbersome method.
View Replies !
View Related
Delete Record
Is this a correct statement to delete a row in a table named "ad_data"? mysql_query("DELETE FROM ad_data WHERE id = $_SESSION['id']"); The connection is open. $_SESSION['id'] echo's as 220 which is correct. id is the primary auto indexed variable. I have written to ad_data many times but this is my first attempt to delete a row. I know the database is working. Is there a permission to delete that must be set. I could not find a means of setting permissions for the table.
View Replies !
View Related
Append To A Record
Is it possible to append text to the end of an existing record I know of UPDATE sysntax but i want to be able to add additional text to a record eg column text = "hello" amended ist time = "hello world" amended 2nd time "hello world - how are you?" etc etc
View Replies !
View Related
How To Find The Record No?
how to find the record no.. ie what is the location of the particular record in the database.. i dont hav any s.no column in my database.. if a particular record is retrived from the table i have to show its position in the database in my page. can anybody help me? is there any query for this?
View Replies !
View Related
Deleting The Whole Record
I am relatively new to mysql and I'm pretty sure this has to be a very easy question to answer. I've looked at the MySql reference manual but havent been able to find anything (its probably there but i just cant find it!) so thought I'd ask someone ... So ... I have discovered that a field in a particular table ... say 'foo' varchar(10) needs to be a width of 15 characters instead. And I also want to be able to change say a field called 'bar' with a value of 'Fred' to a value of 'Barney' and i want to be able to do both these things without having to delete anything and putting it all in again. Does that make sense. I do hope I am explaining this well enough.
View Replies !
View Related
|