tryingtofindout

joining tables

[CODE] 1. CREATE TABLE details ( 2. s_no int NOT NULL AUTO_INCREMENT PRIMARY KEY, 3. 4. content1sno varchar(50) NOT NULL, 5. 6. content1name varchar(50) NOT NULL 7. 8. content2sno varchar(50) NOT NULL, 9. 10. content2name varchar(50) NOT NULL, 11. 12. content3sno varchar(50) NOT NULL, 13. 14. content3name varchar(50) NOT NULL, …

help me!! [CODE]if ( $username == 'admin' and $password == 'ncr' ) { echo("Location: http://localhost/ncr/home"); } [/CODE] if username and password is correct, echo should takeme to specified link. This page ([url]http://localhost/ncr/home[/url]) should be displaced

[CODE]while ( $row = mysql_fetch_array($sql) ) { echo "<table>"; } [/CODE] if nothing is found in the database relating to the query i should get like this [CODE] while ( $row = mysql_fetch_array($sql) ) { [COLOR="red"]if nothing is found in the database[/COLOR] echo "<table no results found>"; } [/CODE]

[CODE]<option>location1</option> <option>location2</option> <option>location3</option> <option>engineer for location1</option> <option>engineer for location2</option> <option>engineer for location3</option>[/CODE] wen i choose a location the corresponding service engineer for that location should be added to d database in d user form ther will be no option for engineer for that location, by selecting the location, it should …