Lowyat.NET: Latest topics by solemn_86

Dropdown Menu

solemn_86 — Thu, 21 Jul 2011 16:13:19 +0800

Hello guys, I have a small problem (hopefully).

I have a table like the one shown below:

id kereta plat_no
---- -------- --------
1 Saga WFG67
2 Viva WA557
3 Toyota WF788

Can someone help me: for example when I select Viva from the dropdown menu, it will only display the plat_no for Viva.

thanks in advance

Dynamic Checkbox using PHP only

solemn_86 — Mon, 09 May 2011 12:38:59 +0800

Hello guys, I have a simple problem (I hope) concerning dynamic checkboxes and since my English is not very strong I'll explain it using example. Below is my database:

-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 09, 2011 at 06:20 AM
-- Server version: 5.5.8
-- PHP Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `Things`
--

-- --------------------------------------------------------

--
-- Table structure for table `fruit`
--

CREATE TABLE IF NOT EXISTS `fruit` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`fruit_type` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `fruit`
--

INSERT INTO `fruit` (`id`, `fruit_type`) VALUES
(1, ' Apple'),
(2, ' Orange'),
(3, ' Banana'),
(4, ' Watermelon');

Currently I hard code these data into my HTML using example below:

<input type="checkbox" name="ckbx1" value="Apple">
<input type="checkbox" name="ckbx2" value="Orange">
<input type="checkbox" name="ckbx3" value="Banana">
<input type="checkbox" name="ckbx4" value="Watermelon">

But I want to display them dynamically straight from the database so that when I add new data to the database, the checkboxes will automatically change accordingly. Please help and thank you

Count data using mySQL

solemn_86 — Fri, 18 Mar 2011 10:13:36 +0800

Greetings

I have a small problem (hopefully) as shown in the SQL file below

-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 17, 2011 at 09:37 AM
-- Server version: 5.5.8
-- PHP Version: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `kenderaan`
--

-- --------------------------------------------------------

--
-- Table structure for table `kereta`
--

CREATE TABLE IF NOT EXISTS `kereta` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`jenis_kereta` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `kereta`
--

INSERT INTO `kereta` (`id`, `jenis_kereta`) VALUES
(1, 'Saga'),
(2, 'Iswara'),
(3, 'Wira'),
(4, 'Juara'),
(5, 'Arena'),
(6, 'Satria'),
(7, 'Kancil'),
(8, 'Rusa'),
(9, 'Kenari'),
(10, 'Kelisa'),
(11, 'Myvi'),
(12, 'Viva'),
(13, 'Alza');

I'm counting the above data using the following code:

SELECT jenis_kereta, count(jenis_kereta) FROM kereta GROUP BY jenis_kereta

but I want to count the data to obtain the output as shown below:

Proton Perodua
------- ----------

6 7

All help is appreciated thank you

Popup Code

solemn_86 — Thu, 25 Feb 2010 13:27:37 +0800

Hi guys, i just want to know if someone can provide me the code for this "1 new posts since last visit.Read latest post or hide this alert" . I mean the thing that automatically popup when there's a new post. I currently developing a program that whenever someone post a request, a popup like that will appear to notify the admin there's a new request to attend to. Any help is appreciated. Thx in advance