MySQL

php mysql

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Oct 2009

Posts: 5

Reputation: jyotidagia is an unknown quantity at this point

Solved Threads: 0

jyotidagia jyotidagia is offline

Offline

Newbie Poster

php mysql

25 Days Ago

could someone point out the error in the followin php/mysql code

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$strSearchVal = $_GET['q'];
//database connection..
//...
 
$strSQL = "SELECT DISTINCT area FROM hospital where area like '%'+ $strSearchVal; ";
$result = mysql_query($strSQL);
 
while ($arrThisRow = mysql_fetch_array($result )) {
 echo '<li>' . $arrThisRow['area'] . '</li>';
$strSearchVal = $_GET['q'];
//database connection..
//...

$strSQL = "SELECT DISTINCT area FROM hospital where area like '%'+ $strSearchVal; ";
$result = mysql_query($strSQL);

while ($arrThisRow = mysql_fetch_array($result )) {
 echo '<li>' . $arrThisRow['area'] . '</li>';

Last edited by peter_budo; 25 Days Ago at 7:34 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)

•

Join Date: Jul 2006

Posts: 798

Reputation: pritaeas is on a distinguished road

Solved Threads: 130

pritaeas

Offline

Master Poster

25 Days Ago

Help with Code Tags

php Syntax (Toggle Plain Text)

$strSQL = "SELECT DISTINCT area FROM hospital where area like '%$strSearchVal' ";

"If it is NOT source, it is NOT software."
-- NASA

Quick Reply to Thread

Show Printable Version

Other Threads in the MySQL Forum

Previous Thread: SQL to return two of each value from table?
Next Thread: foreach tutorial

Thread Tools	Search this Thread
Show Printable Version Email this Page

DaniWeb Message

Cancel Changes