Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
0% Quality Score
Upvotes Received
0
Posts with Upvotes
0
Upvoting Members
0
Downvotes Received
1
Posts with Downvotes
1
Downvoting Members
1
0 Endorsements
Ranked #4K
~6K People Reached
Favorite Tags

16 Posted Topics

Member Avatar for webguru07

As i know that we use "CREATE TABLE IF NOT EXISTS session_id ( attribute data type(size) CONSTRAINTS Constraints_Name CONSTRAINTS TYPE, attribute data type(size) CONSTRAINTS Constraints_Name CONSTRAINTS TYPE, attribute data type(size) CONSTRAINTS Constraints_Name CONSTRAINTS TYPE )"; Just Try with that SQL Query

Member Avatar for Vonzarovitzch
0
3K
Member Avatar for jiten702

You can reduce bounce rate of a site you use following rule....... 1.Good and original content. 2.Clear and proper navigation. 3.Good Quality links. 4.Comparing. 5.Analyze bounce rate.

Member Avatar for biztrendz
0
180
Member Avatar for lapunluyang

Social network is very beneficial.you have the personal attention of the customer and are even able to have a two way communication with them.your network increase.you build that togetherness.your online reputation is increase.

Member Avatar for biztrendz
0
154
Member Avatar for sandeepji1

what is article spinner and how can I use it. I have one already but it keeps creating really bad articles and article directories

Member Avatar for princehappy
0
125
Member Avatar for مصعب علي

hi, According to me you use mysql in place of mssql and I'll modify your error code with correct code on basis of mysql, [CODE]<?php //Generally we try to run php script at localhost. $myServer = "localhost"; $myUser = "root"; $myPass = " "; $myDB = "db1"; //connection to the …

Member Avatar for pritaeas
0
1K
Member Avatar for heena sharma

When you Create a database then you use Structured Query Language(DDL)and Syntex is [B][CODE=sql]"CREATE DATABASE Database_name";[/CODE][/B] Hi,I just try it, Because I have no Proper Idea [CODE=sql]"CREATE TABLE Table_name( name VARCHAR(20) NOT NULL, address VARCHAR(120) NOT NULL, telephone_no INT NOT NULL, email VARCHAR(20) NOT NULL, edu_qual VARCHAR(25) NOT NULL, college …

Member Avatar for rajarajan2017
0
144
Member Avatar for Awah Mohamed

Hi,MySql act as Database System Software which is an open source in nature means freely available.& we need " Structured Query Language " For Accessing it, Now, According to your Query, I First Create data base [B]"CREATE DATABASE Name_of_Database";[/B] Later you create a table [B] CREATE TABLE IF NOT EXISTS …

Member Avatar for rajarajan2017
0
129
Member Avatar for vijayamani

Hi, thanks pritaeas for sharing that info with all.But here I added some basic point that's makes that Query more understandable, 1)For Retriving data from database we use "Select * from table_name. 2)order by: by default, it's show result in ascending, or ORDER BY column_name ASC, But as we mention …

Member Avatar for vijayamani
0
105
Member Avatar for RalphAllan
Member Avatar for phaedrusGhost

Hi, I here mention just the point you need means how we perform the two operation together. <?php if(isset($_POST['posted'])=='true') { $connect=mysql_connect('localhost','root',''); $db=mysql_select_db('dir_db',$connect); /* fetch tha data like that $name=$_POST['dir_name']; / Now, We Perform Saving Operation. if(isset($_POST['dir_save']) == 'Save') { $query=mysql_query("INSERT INTO dir_registration(attribute1,attrrbute2) VALUES('$name','$value2')",$connect); } // Now We Perform Search Operation. …

Member Avatar for sandeepji1
0
211
Member Avatar for jaycastr
Member Avatar for Awah Mohamed
Re: code

Hi, You Just Try That Code that Help You <?php if(isset($_POST['posted'])=='true') { $connect=mysql_connect('localhost','root',''); $db=mysql_select_db('dir_db',$connect); $user_comment=$_POST['dir_usercomment']; // Now, We Perform Saving Operation. if(isset($_POST['dir_save']) == 'Save') { $query=mysql_query("INSERT INTO dir_registration(comment) VALUES('$user_comment')",$connect); } //Now We Perform Cancel operation. if(isset($_POST['dir_cancel']) == 'Cancel') { exit(); } // Now We Perform Reset operation. if(isset($_POST['dir_reset']) == 'Reset') …

Member Avatar for sandeepji1
0
89
Member Avatar for LRNPHP

Hi, here we mention code which solve your Login problem, Save index_dir.php that file in Root Folder, for that Problem We Use WAMP Window + Apache Server + MySql + PHP <?php if(isset($_POST['posted'])) { $name=$_POST['dir_username']; $pass=$_POST['dir_password']; $connect=mysql_connect('localhost','root',''); $db=mysql_select_db('dir_db',$connect); $query=mysql_query('SELECT * FROM dir_login',$connect); while($row=mysql_fetch_array($query)) { $column1=$row['username']; $column2=$row['password']; if($column1 == $name && …

Member Avatar for LRNPHP
0
477
Member Avatar for canadian_angel

As we know that [I]MySql act as Database System[/I] and we need " Structured Query Language " [I]For Accessing it[/I], and as you mention that not a single column be empty, when anyone insert data in them, fro that we use Constraints Concept,like [B]CREATE TABLE IF NOT EXISTS Table_Name(NAME VARCHAR(25) …

Member Avatar for sandeepji1
0
161
Member Avatar for Shaswat

Hi, According to me you want output like that form table "SELECT id,name,sname FROM Table_name"; But I have doubt in mention query, then please mention your query in proper way,Only then I'll Help you, with efficient way.

Member Avatar for sandeepji1
0
104
Member Avatar for asahmed

There is no doubt that, we use [B]Wild-character matching strategy[/B],Because in Structure Query Language for Pattern matching we use 'LIKE' command with two variation 1)% that's we use for Multiple character Matching. [B]1->(a)[/B] eg.'[U]s%[/U]' it Match all text which [B]start[/B] from 's character' [B]1->(b)[/B] eg.'[U]%s[/U]' it Match all text which …

Member Avatar for asahmed
0
148

The End.