Simple PHP/mySQL query? -

-

मेरे पास डेटाबेस है जो उपयोगकर्ता नाम, नंबर और वाहक को user नामक तालिका में संग्रहीत करता है ।

मुझे यह जानने की आवश्यकता है कि कैसे एक प्रश्न लिखना है कि यदि मेरा मान नाम के बराबर है - तो उस नाम से जुड़े संख्या और वाहक को मिलेगा मैं इसे php में लिख रहा हूं और यदि आवश्यक हो तो जावास्क्रिप्ट का उपयोग करेगा।

मुझे आपको "SELECT * से उपयोगकर्ता कहां नाम की तरह '{$ value}' का उपयोग करना चाहिए ' क्योंकि = का उपयोग सटीक मूल्य के लिए खोज करेगा उदाहरण के लिए: अगर डेटाबेस में मान है जॉन और यू को जॉन के लिए खोजा तो यह नतीजे प्रदर्शित नहीं करेगा, लेकिन अगर आप पसंद करते हैं तो यह सभी संबंधित परिणामों जैसे जॉन, जॉन, जॉन, जॉन आदि।

आपको धन्यवाद, मेघा

Comments

Post a Comment

Popular posts from this blog

mysql - BLOB/TEXT column 'value' used in key specification without a key length -

-
I have developed an extension which works up to 1.6 on Magren (I'm trying Enterprise Edition, And I think the community is the same problem, because it is the same code). In my install script, I see the $ installer-> gt; CreateEntityTables ($ this- & gt; getTable ('alphanum / info')); The installation is done until it is not in the _text unit table. It crashed there! It turns out that when I log in to SQL and run it via PHPmyadmin, then this error is: Blob / Text column 'value' is used without the key 'key' . I saw the code there, and this is what is trying to create an index on the value column: -> addIndex ($ this- & gt; getIdxName ($ eavTableName, array ( 'attribute_id array (' attribute_id ',' value ')) - & gt; addIndex ($ this- & gt; getIdxName ($ eavTableName, array (' entity_type_id ' , 'Value')), array ('entity_type_id', 'value')) If there is no if statement is n...
Read more

javascript - What is an alternative to using getElementByClass for hiding multiple elements? -

-
I have a page with some links that I would like to be able to toggle with two buttons. It works with a link using getElementById, but I need to toggle some of those groups. I started with it, but it failed to work. I've heard that GetElementByClass has worked with everything but IE, but I'm using Opera 11.5 and it still does not work. I've searched a bit, but I'm new to some JavaScript and most of the explanation is not understood. Does anyone help me with a simple option, or can I help me fix the problem I've made? This is a test page I was using. & lt; Head & gt; & Lt; Script type = "text / javascript" & gt; Function hideNames () {document.getElementByClass ("WebName"). Style.display = "none"; } Function ShowName () {document.getElementByClass ("WebName"). Style.display = "inline"; } & Lt; / Script & gt; & Lt; / Head & gt; & Lt; Body & gt; & Lt; P class = "web...
Read more

c - Selecting a file randomly from a file system -

-
This question is related. I need to work on files and directories randomly as a file logic, such as rename, write, read etc. What I was planning to do, was to list all the files and directories along with their paths randomly to choose from this list. But, as the files and directories are created and destroyed in the actual file system, the list should also be updated. I am able to update the list and keep it inadequate in this way and it should also be atom so that the operation can not access any file later that was removed from the previous operation. Can you suggest that there is a different way of choosing files..to somehow integrate it with the file system ... but how do we know about the files? Thanks I'm Michael J. Barber's answer has found something particularly interesting, but due to my dragon ignorance I can not follow it completely You do not want to try to keep a list of files, when the file system is ok you should be able to correct it from C. Mo...
Read more