qualitybrains

A clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table can have only one clustered index. The leaf nodes of a clustered index contain the data pages. Clustered index will be created by default when u create primary …

Seems to be a simple mistake : Add </option> at line 50 and 75 :) Vivi [B][I][COLOR="Red"]First, solve the problem. Then write the code.[/COLOR][/I][/B]

I hope following will help you ! [CODE]SELECT REPLACE('c:/olddirectory/subdirectory/filename.extension', 'olddirectory', 'newdirectory');[/CODE] Vivi

print_r(unpack("H*","The quick fox jumped over the lazy brown dog")) Array ( [1] => 54686520717569636b20666f78206a756d706564206f76657220746865206c617a792062726f776e20646f67 ) T = 0x54, h = 0x68, ... You can split the result into two-hex-character chunks if necessary. [URL="http://stackoverflow.com/questions/885597/string-to-byte-array-in-php"]Source[/URL]

Maybe you are looking for a SQL query which will select values from one table and insert into another: Following is an example where account no and name from customers table is being fetched and inserted into supplier table. [CODE]INSERT INTO suppliers (supplier_id, supplier_name) SELECT account_no, name FROM customers WHERE …

[QUOTE=marck_don;1230093]What is CakePHP and how to learn?[/QUOTE] CakePHP is a rapid development framework for PHP that provides an extensible architecture for developing, maintaining, and deploying applications. Using commonly known design patterns like MVC and ORM within the convention over configuration paradigm, CakePHP reduces development costs and helps developers write less …

remove [CODE]echo $sql;[/CODE] from line 18. it might help

Great !! Maybe you can post here what went wrong with the script so others can refer to it, if needed

Hey bubblellicious ! This E/R model is not incorrect. You just need to drill down a bit and understand it. This is the most simple form of E/R. You will need to define the primary/foreign keys on your own, based on the relations Model (1:1, 1:N etc). Thanks Vivi [First, …

Hey Dipiti ! "Primer" is not a concept or anything else. Relational Database Primer would mean the basic details and it's summary. For how it should be framed in words, you may refer to [URL="http://www.databaseprimer.com/"]http://www.databaseprimer.com/[/URL]. Thanks Vivi

Create cws.sql with following Lines : [CODE]drop database if exists cws; create database cws; use cws;[/CODE] Hope it helps !

Use : [CODE]SELECT * FROM events where published =1 and date(start_date) between date(now()) and date_add(date(now()),interval 30 day) ORDER BY start_date ASC [/CODE] Hope it helps !

Please elaborate your problem a bit more and please mention if you are getting any error