Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Result page (mySQL)
Hello everyone, I made two pages (Search and Result). I've created a database with five tables (cities, categories, images, photographers and years). I used two parameters from search page (categoryID and photographerID). On the results page, I made the following query: SELECT cities.cityID... -
How to filter data (PHP)
Hello everyone, I have two tables (cities and images) table cities ----------- cityID cityName cityShow table images ------------ imageID imageName imagePath cityID cityID = 1 cityName = Paris cityShow = 'Y' cityID = 2 cityName = Berlin cityShow = 'Y' cityID = 3 cityName = New York cityShow... -
Build an advanced results page (PHP)
Hello, can You help me build an advanced results page in Dreamweaver? I have three tables (products, categories and vendor). Table products has the fields: productID, productName, categoryID, vendorID. Table category has the fields: categoryID, categoryName. Table vendor has the fields... -
#1109 - Unknown table 'c' in field list
Hello, I try use this query in localhost (XAMPP) and hi work, <code>SELECT C.categoryName, Count(P.prodname) as prodcount, c.categoryID FROM categories as C left join products as P on p.categoryID = c.categoryID WHERE P.prodShow = 'Y' GROUP BY c.categoryName</code> but when I put this code in... -
Swf - mySQL - PHP
How can I put the flash, music, videos into my database and call them from the database? -
Menu items
In web pages I found menu with this links example.php?category=web example.php?category=music example.php?category=game When I click menu button web (example.php?category=web) it opens this page in part of web page. Next buton (music) opens music page in same place of web page etc... What's... -
How to show category name
I have an table with this fields: cat_id, cat_parent_id and cat_name. I have vertical menu with this items! When I click menu items Audio I have "sample.php?c=1" etc... Example: cat_id cat_parent_id cat_name 1 0 audio 2 0 video 3... -
From ASP to PHP
How to translate this ASP code in PHP code? <% 'Get Poll Results using Filter Dim arrCount(1000) For i = 1 to 4 FilterParam = i rs_poll.Filter = "Choice = " & FilterParam 'Count results While NOT rs_poll.EOF arrCount(i) = arrCount(i) + 1 rs_poll.MoveNext() Wend Next %> -
Recordset Navigation - Pages List
How to make (Pages List) List of links like 1 | 2 | 3 | 4 | 5? -
Parent - Child relationship
I have two tables: categories and products. categories: categoryID, categoryName products: prodID, prodName, categoryID I tried with delete record server behaviors like below ("DELETE FROM categories WHERE categoryID=%s", GetSQLValueString($_GET['catID'], "int")); and that delete only... -
Categories and subcategories
How make this? http://www.solucija.com/forum/viewtopic.php?pid=8673 -
-
How to make counting of hits
How to make counting of hits about products? PHP-MySQL In detail page I need to write: This product have ... hits! -
Dinamic links
How make this in DW (PHP, MySQL)? Home > Forums > Programmers > Graphics & Web Tools When I click programmers link I will go to the programmers page. etc... I must make 4 pages (Home, Forums, Programmers and Graphics & Web Tools). What's next? -
Category Counting
How with Dreamweaver make category counting like Digital camera (5) Computers (3) Cars (0) .... I have two tables, categories and products categories: categoryID, categoryName products: prodID, prodName, categoryID
