Cant Work Out Correct Select Query For ..
mysql> select * from parent_cat;
+-------+----------+----------+
| catid | pname | psection |
+-------+----------+----------+
| 1 | Trainers | Men |
| 2 | Bags | Woman |
| 4 | Boots | Woman |
| 5 | Fragance | Men |
+-------+----------+----------+
4 rows in set (0.00 sec)
mysql> select * from categories;;
+-------+---------------------------+---------+------+
| catid | catname | section | pid |
+-------+---------------------------+---------+------+
| 1 | Nile | Men | 1 |
| 2 | Bags | Woman | 2 |
| 4 | Boots | Woman | 4 |
| 6 | Air Force I & II Trainers | Men | 1 |
| 7 | Adidas Trainers | Men | 1 |
| 8 | Timberland Trainers | Men | 1 |
| 9 | Lacoste Trainers | Men | 1 |
| 10 | Gucci & Hogen Trainers | Men | 1 |
| 11 | D&G Trainers | Men | 1 |
| 12 | Prada Trainers | Men | 1 |
| 13 | Chanel Trainers | Men | 1 |
+-------+---------------------------+---------+------+
and the following query:
$pid = $_GET['catid'];
$query = "SELECT categories.catid, categories.catname, categories.pid
FROM categories, parent_cat
WHERE categories.section = 'Men'
AND parent_cat.catid=categories.pid
AND categories.pid = '$pid'";
At the moment the query only returns all categories.catname when my categories.catid = 1, but returns nothing if it equals something else?
View Complete Forum Thread with Replies
Related Forum Messages:
Degrading Sub Select Query To Work In MySQL 4
I have the following query working as intended in MySQL 5. However, I had not realised that the target server is running 4.0.2 and it's not possible to upgrade. SELECT records.player_id, records.record_id, records.game_id, records.updated, game_modes.mode_title, records.record_time, players.firstname, players.lastname, players.nickname, players.country, teams.team_title, classes.class_title, tracks.track_title, games.game_title, games.version, record_types.type_title FROM games, records, classes, teams, tracks, record_types, players, game_modes WHERE records.record_time = ( SELECT MIN(record_time) FROM records WHERE records.player_id = players.player_id AND records.game_id = 1 AND records.mode_id = 1 AND records.track_id = 1 AND records.class_id = 5 AND records.type_id = 1 GROUP BY records.player_id) AND records.track_id=tracks.track_id AND record...................
View Replies !
Reformatting Email Address To Work On SELECT Query
This is probably basic, but so far I cant find any articles about this. I want to "SELECT * FROM dbase WHERE emailaddress = $email;" $email is a feed from PHP, and will contain a string like "some.one@someplace.com" Apparently with $email as a normal string, it gives an error saying: "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '@someplace.com)' at line 1" I reckon it's the dots and the @s that terminate the syntax and making it not work. How can i get out of this problem? Is there any function I can call to solve this? Or probably a little bit of more programming?
View Replies !
Correct Search Query
Can anyone help me out with this please. I am looking at searching among comma delimited id's stored inside "IDs", trying to figure out what the correct SQL query for that would be. I need to extract the ID where IDs contains the value 7. I know I can't use something like "WHERE IDs LIKE '%7%'" because the result would be inaccurate. So how do I go about it, please? Any directions would be appreciated, thanks! +------+-----------+ | ID | IDs | +------+-----------+ | 1 | 3,17,20 | +------+-----------+ | 2 | 1,7,9,12 | +------+-----------+
View Replies !
Query Of Gmdate Not Working... Is My Syntax Correct?
$query="SELECT distinct(id),subject,view, postdate FROM threads where gmdate(Y-m-d H:i:s, postdate + 3600) >= date_sub('".$current_date."', interval 7 day) order by view desc limit 0 , 5 "; I tried to get my postdate to compare with the current date in order to display the most view topic in last 7 days in my page... however, the above coding is not working...
View Replies !
SELECT `*` Not Work On New Server
I wrote some code a long time ago that used SELECT `*` from blah blah blah. I'm building a new server with a new installation on MySQL 4 and for some reason this piece of code wasn't working. I looked into it, and turns out only SELECT * not SELECT `*` works on this new server. Now I realise this is probably my crappy coding, but is there some variable I can turn on/that is different between the servers that makes this happen? I've used this code on loads of servers and never had a problem, and would rather not go through all my code fixing this error
View Replies !
Cannot Get Select Statement To Work
I can't for the life of me figure out why my select statement will not retrieve the data from MySql. it is a very simple statment; mysql_query ("SELECT pub_type, call_number, pub_author, pub_title, subtitle, edition, publisher, publication_year, physical_description, series, isbn, holdings, subjects FROM library WHERE id=" .$pub_id); but when I try to echo any of these variables I get nothing showing for results. the $pub_id displays because it is set by a GET function. echo "<b class='foo'>$pub_id $pub_author $series </b> "; I use a select statement on the page that calls for this page and it retrieves info from the database not problem... my includes for database connection, etc are all in tact.
View Replies !
Mysql 4.1 Inner Select Dosen't Work
I have in my home mysql 5 and in the server mysql 4.1 The follow select works fine in my computer but not on the server -------------------------------- SELECT id FROM table1 WHERE name in (SELECT name FROM table2) -------------------------------- when i type it in the server i get 1064 error and no explanation...
View Replies !
What Query Would Work For This?
I have two tables: say Yes and No. Yes(ID, YesEmail, EmailOwner); No(ID, NoEmail); Both YesEmail and NoEmail contain email addresses. What query can retrieve all the email addresses in Yes table that are not listed in No table? Thanks in advance.
View Replies !
Cannot Get MySQL Query To Work In .asp
I have a MySQL database and in the front-end software I am using to Run MySQL, I have created a query on the tables which runs in the front-end, similar to the MS Access query grid. I now wish to pull this query on-line using .asp, but I seem to have found out that I can only pull data from tables in MySQL? ....
View Replies !
Query Wont Work
PHP Code: if(mysql_query("UPDATE users SET referer_score=referer_score+1 WHERE userID='$frommysql_referer'")) { die(mysql_affected_rows()); im trying to figure out why refer_score isnt being iincremented as im expecting it to. i know that the value of $frommysql_referer is the right value that im expecting it to be. just it wont increment referer_score. and mysql_affected_rows() wont print anythnig to the screen
View Replies !
Query Doesn't Work With Mysql4
Can someone tell me what's wrong with the mysql query below? It does work on mysql 5 but gives me an error with mysql 4. SELECT rev_profile_indiv. * FROM rev_profile_indiv, rev_profile_kids_indiv WHERE 1 AND reviewing IN ( 1, 0 ) AND active IN ( 1 ) AND contract IN ( 1 ) AND UNIX_TIMESTAMP( DATE( rev_profile_kids_indiv.birthdate ) ) >= UNIX_TIMESTAMP( ��-12-15' ) AND UNIX_TIMESTAMP( DATE( rev_profile_kids_indiv.birthdate ) ) <= UNIX_TIMESTAMP( ��-12-15' ) GROUP BY rev_profile_indiv.username ORDER BY lastname LIMIT 0 , 30;
View Replies !
What Do I Need To Do To Make This Query Work?
I must've been working too long hours this week, as my flow of ideas has come to a complete stop. Its really quite simple: 2 tables - bookings , invoices These two counts gives me precisely what I want PHP $unpaid_bookings = mysql_result(mysql_query("SELECT COUNT(id) FROM bookings WHERE invoice_id = 0 AND client_id = $id AND status != Ɔ' AND finish <= '$time'"),0);$total_bookings = mysql_result(mysql_query("SELECT COUNT(id) FROM bookings WHERE client_id = $id AND status != Ɔ' AND finish <= '$time'"),0); so I present this in a ratio, $unpaid_bookings / $total_bookings... awesome now, when I try and flip the coin and show unpaid invoices over total invoices, it all falls apart once I have more than 1 booking per invoice. First i'll explain the table structure. Each booking has a column `invoice_id`, which is assigned to the primary `id` of the invoice table. So one invoice might be associated with x bookings. PHP $unpaid_invoices = @mysql_result(mysql_query("SELECT COUNT(i.id) FROM invoices i, bookings b WHERE i.id = b.invoice_id AND b.client_id = $id AND i.is_paid = Ɔ'"),0);$total_invoices = @mysql_result(mysql_query("SELECT COUNT(i.id) FROM invoices i, bookings b WHERE i.id = b.invoice_id AND b.client_id = $id"),0); Again so it works fine when 1 invoice is associated to 1 booking, but when 1 invoice is associated with say 2 bookings, the invoice count will return two instead of one. The worst part is, I know exactly why (because there are two bookings for the invoice), I just can't get around it! I've tried all sorts of joins, group by's, and i'm not having any luck. I'm trying not to be weak and add the client_id into the invoice table,
View Replies !
Query Does Not Work On Some Server Instances
query: Select * From Students Where C_Name = "XXXXXX" WHen I run this query on 2 of my computers, the result returns no rows. When I run this query on a remote machine hosted by 1and1, with a copy of the same database, the query returns the correct row. The syntax is identical.....
View Replies !
Query Which Gets Rows Based On A Radius, Lon And Lat Doesn't Work?
I have found this query which gets rows based on a radius. I need this for zip codes based on lon and lat's. $sql2 = "SELECT * FROM table as z WHERE (SQRT( (69.1 * (".$userLat." - z.lat)) * (69.1 * (".$userLat." - z.lat)) + (53.0 *(".$userLong." - z.lon)) * (53.0 *(".$userLong." - z.lon))) <= ".$userRadius." )"; return $sql2; $res = mysql_query($sql2, $connDB) or die(mysql_error()); $row = mysql_fetch_assoc($res); based on a test zip code gives a result like SELECT * FROM table as z WHERE (SQRT( (69.1 * (52.399834 - z.lat)) * (69.1 * (52.399834 - z.lat)) + (53.0 *(4.840762 - z.lon)) * (53.0 *(4.840762 - z.lon))) <= 100 ) the lat and lon of the test zip code are right. As you can see z.lat and z.lon don't get any value. And these would be every lat and lon in table. In my db table lon and lat are decimal(10,6) type with a default value of 0.000000
View Replies !
Min Returns Correct Min Value, But Not Correct Row
select min(time_to_sec(bests.time)) as aggregate_value, * from bests left join events on bests.event_id = events.id where fid = 13463 group by bests.event_id if i query that i get the correct min value as "aggregate_value" but everything else is for a random row (presumably the first row as ordered by id asc). is this the correct functionality of mysql?
View Replies !
How To Use Previous Select Query Results In New Select Query?
I have tested everything and it works OK in its current form. However, what I need help with is the part of the query highlighted in red. As it currently stands, the PHP while statement loops through the rows and echos out the html. The issue I have is that it echos out the same speaker name and subject type for each iteration. Now I know this is happening because I have set subject.event_id = 1, so what I need is to use the event_id of the current iteration as the clause and that is what I need help with....
View Replies !
Select Within Select Needed To Get This Query Going?
I'm not sure how to go about this, but I am thinking I need some sort of a select query within a select query to get this properly displayed... My table structure is as follows (simplified, of course): payment_id | member_id | completed | amount | trans_added and I am trying to get the following data out of the table - a daily sum of all the transactions that were 1) completed, 2) by a member who already has an existing completed transaction (completed = 1) on a different date (or members with a count of all completed transactions > 1 will be included only). so far I've got this query, but I don't know where/how to plug in the condition for the members/completed/etc: .....
View Replies !
Correct Syntax
I have a database of addresses where I am trying to remove rows that have a particular duplicate field. For example, say there are 15 rows in the table sales_info that have the value 'Mr. Smith' in the contact_name column. I've tried using the following command but received an error (1064 check you manual for the right syntax): UPDATE sales_info DELETE* FROM sales_info WHERE contact_name IS NOT UNIQUE; Can anybody help me with the right syntax to use?
View Replies !
Correct Results From Db
I have a column of type text, in this column I am adding in numbers that relate to another column in the table. For example the column in question could end up having the following data in it: 1, 2, 6, 9, etc The problem I am having is if I want to return all the results that relate to lets say the number 1 and if the column in question has more numbers in it than the number 1, I don't get anything returned. Is this an error with my ASP script or the way the data is stored in the dababase. Do I need to change the data type,
View Replies !
Getting The Correct Row With Unicode
I'm having some trouble getting the correct column from a unicode table: DATABASE: Server version: 4.1.15 MySQL charset: UTF-8 Unicode (utf8) TABLE: CREATE TABLE `domain` ( `id` mediumint(7) unsigned NOT NULL auto_increment, `name` varchar(70) character set utf8 NOT NULL default '', ) ENGINE=MyISAM DEFAULT CHARSET=latin1; INSERT INTO `domain` (`id`, `name`) VALUES (506418, 'vad'), (522014, 'vÃÂ¥d'); QUERY: SELECT * FROM `domain` WHERE `name` LIKE 'vÃÂ¥d' RESULTS: id name 506418 vad 522014 vÃÂ¥d QUESTION: How do I structure the select statement to correct get the row (ID 522014) that matches the unicode ...
View Replies !
Which Design Would Be Correct?
I have registered users, and these users can belong to a group. I'm trying to decide whether or not i should keep this group_id in the users table, or to create a cross referencing table and just keep the user_id and group_id in there. the cross reference table will allow for users to be associated with more than one group. and just keeping the group_id in my users table will allow me to avoid a few joins in some queries but only allow one user per group... any opinions on this matter? after typing this i feel as though creating the referencing table would be the better idea.. but i still would love to hear other opinions.
View Replies !
Which One Ini File Is The Correct One ?
I have install mysql in my windows machine.The confusion part here is that I find there 7 different ini files. The files are my.ini,my-huge.ini,my-innodb-heavy-4G.ini,my-large.ini,my-medium.ini,my-small.ini and my-template.ini. So which one is being used as the configuration files. I assume it is the my.ini one right ? So why is there so many other ini files? My another question is that in my.ini I dont find the option for the bin-log settings but ? Because I want to the option of binary log to be enable to allow me to trace back if there is any mistake ?
View Replies !
Correct Syntax For An Update
two databases, one has an out of date email field. I need the new table to update the email field on the old table. My query selects the rows with the wrong email address: select * FROM `oldtable` , `newtable` WHERE oldtable.memberid = newtable.memberid and oldtable.Email != newtable.email but how do I update it? update`oldtable`set oldtable.Email = newtable.email where oldtable.memberid = newtable.memberid My above query fails.
View Replies !
Percentage Correct Calculation
I"m not sure this is the right way to do things - but it's the web site database I do have now that I"m using. It's a pretty simple 'pick the winners' database Table - Picks userID gameID pickedteamID gameresults gameID winnerID What I need is a query that will return the total number of picks for a user as one column and a count of the correct picks...(ideally i want a percentage) - say i've picked 16 games and 8 correct...i would want the result to be jemagee 8 16 .5 (percentage correct) THe problem is of course I want to select ALL users and order descending by the percentage count so I can list a standings. Is this doable in mysql alone? Did it make sense.
View Replies !
Correct Import Command
i am having trouble importing a database into MySql 5.0 i have created a database and have the .sql file ready but when i type in my command i never get the next step. database name = bdatabank command I am trying to use from the mysql> prompt is below: -u username -p -s bdatabank < BDB-sql-2007-11-16.sql --after typing this and pressing enter i should be getting the 'Enter Passwor' prompt. but all it get is another blank line with a prompt of -> am i miss typing something?
View Replies !
Using Conditional And Limit But Not Correct
I am sure my mysql query syntax is correct but I got the latest rows by limits and conditions. My syntax is: select * from nltest where time_stamp < 20080529100225 and batch ="2000-10XX-MDM5-C limit 10; When I run it. I got the latest rows from the top,instead of rows from 20080529100225.
View Replies !
Correct Type For Numbers
One of the fields in the DB, is a field where the price for the property is added. What is the best suggested type for this field? I also need it so be searchable. My 1st mind was to set it as Numeric - Real but was not sure. Also, do I need to add the value as 395 000.00 or 395000.00?
View Replies !
Database Correct Setup
I'm trying to install a PHP and MYSQL web app which needs me to setup the correct fields. Server Name localhost Database Name mysql Database User Nameroot Database Password MyRootPassword I enter all of this information and I get an error back that says: 'unable to connect to the database server - verify settings and ensure database is running.' Does anyone know what I'm doing wrong??
View Replies !
Cannot Perform Correct Update.
i have 2 tables, orders(orderNumber, BuyerID, ...) and status(orderNumber, status). The first table works good when I want to check the orders. Now, I need to track the orders status. That's why I created the 2nd table. The problem is that when I update status (pending or delivered), ALL my orders get the same value. I mean, I cannot update the status for just one product. When one order status is updated to e.g "delivered", all orders status get the same value. Any ideas? Probably the problem is that I do not put any "WHERE orderNumber=..." but I don't know how to tell MySQL that the orderNumber for both tables is the SAME
View Replies !
Correct Wrong Spelling
Is it possible with mySQL to get results when the spelling is not exactly correct. E.g. a visitor fills out the field with Amstrdam (note that the "e" is missing). Is there a function for mySQL that also shows results similar to Amstrdam: -Amsterdam -Amsteldam
View Replies !
Correct Use Of MERGE Tables?
I have seen general MERGE table usage for logging where a table is created for a fixed period of time, e.g. a month. I am looking to do something different. I currently have a very large table, let's call it emails. There are say a million rows in here. The problem is queries running against this can be slow especially any queries against rows that are not indexed (not all of them can be). What I am thus thinking is to use MERGE tables. Any email that has not been opened in the last year would be moved into an acrhive table. Then what is now the emails table would be renamed so I have emails_archive and emails_current and create the MERGE table emails. Then, any searches would be run on emails_current unless a checkbox was clicked to run on *all* emails. Is this a correct way to use MERGE tables? Is moving rows from emails_current to emails_archive going to be a problem with indexes and unique keys? I believe I can insert rows into the MERGE table and they will by phyiscally put inside emails_current but will check the unique indexes on both the tables.
View Replies !
Correct Datatype Question
I'm trying to construct a database containing information that will eventually be brought into a flash movie. It's basically information to be used in a digital clothing catalogue slideshow. I need to include the following information for each clothing item: Style Number Description Colours Sizes I was just going to create 4 tables (haven't decided yet how these will be structured) but just wanted to ask a question about the description column. I was going to make this a text datatype even though information included in it would be be repeated. That is possible information could be a number of sleeve lengths, cuff types, fabric compositions, collar types etc. All of these could very well be placed in separate tables to avoide redundancy but I just wondered if, in this particular instance, it is really necessary to do so. I was going to create a simple CMS so that the client could enter new items, ie. style number, description, colours, sizes and then maybe have the ability to delete these items. So I guess my question is should I be using a text datatype for the description or be breaking the information up further?
View Replies !
Correct Join For DELETE
Whats is the correct syntax to delete from a table using joins to associate the id? I have sommin like: mysql_query("DELETE FROM gallery LEFT JOIN gallery_subcat as s ON s.subcat_id = g.subcat_id WHERE s.maincat_id='".NumValidate($_GET['maincat_id'])."'");
View Replies !
Picking The Correct Date
My client's art gallery site has a page that lists the current show and the upcoming show. Each show is a approx a month long, and the dates can overlap. Instead of making the gallery owner update the database with a checkbox indicating which show is current and which is upcoming, I'm trying to automate this page so that mysql will decide upon which show is current and upcoming and display the correct one. Unfortunately, this isn't working as planned. PHP CREATE TABLE `shows` ( `show_id` int(10) unsigned NOT NULL auto_increment, `show_name` varchar(30) default NULL, `show_text` text, `show_postcard_img` varchar(60) NOT NULL default '', `show_start_date` datetime default NULL, `show_end_date` datetime default NULL, PRIMARY KEY (`show_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `shows` -- INSERT INTO `shows` VALUES (1, 'Grand Opening', 'txt', 'postcard1.jpg', ��-09-08 16:52:08', ��-10-06 16:52:13'); INSERT INTO `shows` VALUES (2, 'Current Show', ' txt', 'postcard2.jpg', ��-10-13 17:18:00', ��-11-13 17:18:00'); INSERT INTO `shows` VALUES (3, 'Upcoming Show', 'txt', 'postcard3.jpg', ��-11-17 11:53:26', ��-12-14 11:53:34'); $query_current_show = " SELECT show_id,show_name, show_postcard_img FROM shows WHERE MONTH(show_start_date) = MONTH(NOW()) AND YEAR(show_start_date) = YEAR(NOW()) OR MONTH(show_end_date) = MONTH(NOW()) AND YEAR(show_end_date) = YEAR(NOW())"; $query_upcoming_show = " SELECT show_id,show_name, show_postcard_img FROM shows WHERE MONTH(show_start_date) > MONTH(NOW()) AND YEAR(show_start_date) = YEAR(NOW()) LIMIT 1"; As of yesterday, show 2 "Current Show" should be the current show, and show 3 "Upcoming Show" should be showing as the upcoming show. Instead, show 1 is still current and the upcoming show is show 3.
View Replies !
Is This Search Arranging Correct?
If I want to filter results from using a LIKE search if I ORDER it by the field it's searching will it return results based on the number of times what I am searching for occurs in the field?
View Replies !
Using Correct Data Type
Currently my database have 500,000 Records. hosted in 1AND1.com they only allow maximum 100MB / Database. so my current db size is around 40 MB. One of the table has a field call 'Region' and type VARCHAR(255) . up to date all 500,000 records does not have utilize more than 50 characters in this Region field. but today i had to add around 1000 records that has the data for the Region field and each contain more than 300 characters long. if i exend the varchar to higher than 255, the message 'Too big column length for column 'test' (max = 255). Use BLOB instead ' appear. i am not sure what is BLOB is. So now in the above circumstances, what type of data should be chosen for the Region filed. so i can put data that has the length around 500 charactors.
View Replies !
Text Editor To Correct Queries
In Oracle there is a way to correct any mistakes in a query, by simply entering the edit command. And from there, a text editor is opened, to allow the corrections to be made to the query. This eleminates having to retype the whole query. Is this possible in MySQL?
View Replies !
Transfer InnoDb In Correct Order ??
I want to transfer the structure of my InnoDb database to another mysql server 3.23. However, I don't seem to get this to work correctly as the tables are not transfered in the correct order such that I get a bunch a foreign key constraints. Even if I use the MysqlPhp admin tool, Mysql Manager, SqlYog, it doesn't work: they make an export of the db structure but the db structure, that consists of create table statements, isn't in the correct order, such that when I use the export script to make the new database somewhere else, the tables can't be created because of foreign key constraints. How can solve this, without putting the create statements in the correct order manually ? Isn't there a handy tool that first checks if other tables should be created, and if so, it does this, before adding the table itself ?
View Replies !
Transfer InnoDb In Correct Order ?
I want to transfer the structure of my InnoDb database to another mysql server 3.23. However, I don't seem to get this to work correctly as the tables are not transfered in the correct order such that I get a bunch a foreign key constraints. Even if I use the MysqlPhp admin tool, Mysql Manager, SqlYog, it doesn't work: they make an export of the db structure but the db structure, that consists of create table statements, isn't in the correct order, such that when I use the export script to make the new database somewhere else, the tables can't be created because of foreign key constraints. How can solve this, without putting the create statements in the correct order manually ? Isn't there a handy tool that first checks if other tables should be created, and if so, it does this, before adding the table itself?
View Replies !
UPDATE To Correct /n In Text Fields
Not sure if this can be done in MySQL or if I need do dump the database and correct it in a text editor. I have a text field in my database which got pulled off of another db somewhere in the transfer line breaks became /n and they are in the text as /n can I run an UPDATE which will actually check the text field for /n and convert it to a <return>. The db is not massive so I can always dump it and run it through bbEdit if need be
View Replies !
Selecting Correct Versions Of MySQL
I have searched this forum and google to try and get a comprehensive answer to this question but i haven't found anything yet. I am looking to select the correct versions of MySQL, Apache and Php so that they all work together. I notice that there are alot of issues with various different versions sets being chosen and there seem to be instances where it can be very problematic if the wrong one is chosen. I am looking to use InnoDB and would like to use the latest versions of everything as possible but it doesn't really outline anywhere what works with what best. There are lots of cases that outline what can be problematic but i'm trying to avoid this if possible and find what isn't problematic.
View Replies !
ERROR 1045 Using -u -p With Correct Password
I'm facing a strange problem on a freshly installed Debian. I defined passwords for root and several others users I created. When I try to connect using the command : mysql -u root -prootpassword I receive ERROR 1045 Access Denied for user root@localhost using password=YES but when connecting using mysql -u root -p and typing the password when asked for, it connects without any problem ... This is the same with mysqldump, so I can't automate backups .. The problem appears with each and every user, whatever their rights PHPMyAdmin works perfectly, if needed. Any idea ?
View Replies !
|
TRACKER
