Jump to content

Need Help With A Query


monkeybidz

Recommended Posts

Here is the code I need help with.

 

$result2 = mysql_query("SELECT * FROM sponsored_ads WHERE keywords2 LIKE '$keyword'");

         for ($i = 0; $i <=3; $i++) {
		$in[] = $keys[$i];

	}
        foreach ($results2 as $_key => $_row) {

	$last_domain2 = $domain_name2;
	extract($_row);

    }

 

I just need it to return up to 3 results that match $keyword defined by user.

Link to comment
https://forums.phpfreaks.com/topic/197798-need-help-with-a-query/
Share on other sites

<?php
$result2 = mysql_query("SELECT * FROM sponsored_ads WHERE keywords2 LIKE '$keyword' LIMIT 3");
if(mysql_num_rows($result2) > 0) {
while($r = mysql_fetch_assoc($result2)) {
	//call the rows.
	$domain = $r['domain'];
}
}
else {
echo 'There are no rows to print to the page!';
}
   ?>

You got me on the right track. Here's what I did:

 

$result2 = mysql_query("SELECT link2, title2, description2, keywords2 FROM sponsored_ads WHERE keywords2 LIKE '$keywords' LIMIT 3");
        if(mysql_num_rows($result2) > 0) {	
           while($r = mysql_fetch_assoc($result2)) {		//call the rows.		
             $link2 = $r['link2'];	
}
    echo "$link2";
}
}

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.