•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 402,904 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,123 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 594 | Replies: 1
 |
•
•
Join Date: Dec 2006
Posts: 34
Reputation: 
Rep Power: 2
Solved Threads: 0
Light Poster
Searching all columns in a table Hi
I am trying to search the entire table (all the columns) for a search term. But am getting mysql error
$data = "SELECT * FROM songmaster WHERE songTitle like '".$find."' and mp3File like '".$find."'";
//And we display the results
while($result = mysql_fetch_array($data))
{
echo "<font face='Verdana' size='4' color=red>".$result['songTitle'];
echo "<br>";
echo "<font face='Verdana' size='4' color=red>".$result['mp3File'];
}
any help please?
I am trying to search the entire table (all the columns) for a search term. But am getting mysql error
$data = "SELECT * FROM songmaster WHERE songTitle like '".$find."' and mp3File like '".$find."'";
//And we display the results
while($result = mysql_fetch_array($data))
{
echo "<font face='Verdana' size='4' color=red>".$result['songTitle'];
echo "<br>";
echo "<font face='Verdana' size='4' color=red>".$result['mp3File'];
}
any help please?
•
•
Join Date: Jul 2004
Location: North East Indiana
Posts: 491
Reputation:
Rep Power: 5
Solved Threads: 20
Posting Pro in Training
What is your error message?
My psychic debugging skills are weak, but I'm getting a feeling you need to run mysql_query() before mysql_fetch_array().
My psychic debugging skills are weak, but I'm getting a feeling you need to run mysql_query() before mysql_fetch_array().
www.uncreativelabs.net
Old computers are getting to be a lost art. Here at Uncreative Labs, we still enjoy using the old computers. Sometimes we want to see how far a particular system can go, other times we use a stock system to remind ourselves of what we once had.
Old computers are getting to be a lost art. Here at Uncreative Labs, we still enjoy using the old computers. Sometimes we want to see how far a particular system can go, other times we use a stock system to remind ourselves of what we once had.
|
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Data from mysql in a 3 columns table (PHP)
- Create Table on SqlServer Through Asp.net coding (ASP.NET)
- Table Layout Pannels (C#)
- How to make the columns in a table resizable (JavaScript / DHTML / AJAX)
- Script stores data in wrong MySQL columns (MySQL)
Other Threads in the PHP Forum
- Previous Thread: Is there a conflict between Php 4.3.2 and Php4.2.3?
- Next Thread: new php programmer
