Doh! Code help neded...

Anon

Chek it:

Check it --

<?php

mysql_connect("localhost","1245","12345678") or die("Unable to connect");
@mysql_select_db("hot_dogs") or die("Unable to select database");
$result = mysql_query("SELECT * FROM url_store WHERE title, description, keywords, location, channel LIKE "%$searchterm%";
$matchcount =0;
while ($row = mysql_fetch_row($result)) {
$pattern=$searchterm;
if(preg_match("/$pattern/i", $row[6])) {
echo "$row[1], $row[2], $row[3], $row[4], $row[5]";
$matchcount++;
}
}
if($matchcount == 0) { echo "No matches"; }
?>

Nigga just dunn no work'n -- I have NO clue why?

Doh! - H.S.

Guido

Anon

Hi Guido,

Will this help you out?

Kind regards,
Gerry

<?php

mysql_connect("localhost","1245","12345678") or die("Unable to connect");
@mysql_select_db("hot_dogs") or die("Unable to select database");

$result = mysql_query("SELECT * FROM url_store WHERE title, description, keywords, location, channel LIKE '%$searchterm%');
$num = mysql_num_rows($result);

if ($num != "0") {

while ($row = mysql_fetch_row($result)) { 
	echo "$row[1], $row[2], $row[3], $row[4], $row[5]"; 
}

} else {
echo "No matches";
}
?>

Anon

Hi Gary:

Thanks for the help -- seems there is a parse error on line 10 -- so it tells me so.

I'm trying to debug it -- if you see the error, please let me know.

Guido

Anon

Try this, there is a parse error, closing the mysql_query forgot a double quote...

Copy paste this code... it should work

What kind of programm do you use to make your scripts? use editplus.

Then you see nicely where the parse error is.

Kind regards,
Gerry

<?php

mysql_connect("localhost","1245","12345678") or die("Unable to connect");
@mysql_select_db("hot_dogs") or die("Unable to select database");

$result = mysql_query("SELECT * FROM url_store WHERE title, description, keywords, location, channel LIKE '%$searchterm%'");
$num = mysql_num_rows($result);

if ($num != "0") {

while ($row = mysql_fetch_array($result)) { 
	echo "$row[1], $row[2], $row[3], $row[4], $row[5]"; 
}

} else {
echo "No matches";
}
?>

Anon

Two errors -- on line 8 and 12. I have Editplus 2 -- gets all crazy with colors. 🙂

Hmmm....

Guido