problem with code

elpis

<table align=center border=1><td><TABLE cellpadding=5 WIDTH=100%><tr><td>FORUM NAME </td><td>MODERATOR

</td><td>THREAD NUMBER</td>';

BEGIN THE SQL QEURY FOR THE INFORMATION

SHOW ALL THE CONTENTS

$result=mysql_db_query($base, "select messageboard.category_name, customer.username,count(thread.id)
from messageboard, customer, thread WHERE messageboard.category_id=thread.id_category
AND
messageboard.moderator = customer.id
group by thread.id_category",$link);

$result1=mysql_db_query($base, ""select count(thread.id) from messageboard)

if ($result > 0)
{
$num4=mysql_num_rows($result);
if($num4!=0)
{
$n=0;
while ( $n<$num4 )
{

call and show the ID

$category_name = mysql_result($result,$n,"messageboard.category_name");

call and show the MODARATOR

$customer=mysql_result($result,$n,"customer.username");

call and show the THREADS NUMBER

$post_id=mysql_result($result,$n,"thread.id");
$n++;

echo "<tr>";

echo "<TD bgcolor=$bgcolor><font size='+1'><b>$category_name</td>";

echo "<TD bgcolor=$bgcolor><font size='+1'><b>$customer</td>";

echo "<TD bgcolor=$bgcolor><font size='+1'><b>$post_id</td>";

echo "</tr>";
if($bgcolor == "#99CCFF") {
$bgcolor="#FF9999";
} else {
$bgcolor="#99CCFF";

}
}
}

echo "</table></table></body></html>";
}
?>

i get this when i run it please help

Parse error: parse error, unexpected T_STRING in U:\local-html\test.php on line 26

kevinsequeira

what is line 26, im guessing its this

$result1=mysql_db_query($base, ""select count(thread.id) from messageboard)

chagne it to

$result1=mysql_db_query($base, "select count(thread.id) from messageboard");

reg
kevin

elpis

PULL ADDITIONAL FILES

include_once ("./settings.php");

CONNECT TO THE MySQL SERVER

$link = mysql_connect($host,$user,$password);

SELECT THE DATABASE NEEDED

mysql_select_db("$base");

$bgcolor="#99CCFF";

START THE TABLE INFORMATION FOR THE RESULTING INFORMATION

echo '<html><body bgcolor="#FFFFC0"><BR><BR></center>
<table align=center border=1><td><TABLE cellpadding=5 WIDTH=100%><tr><td>FORUM NAME </td><td>MODERATOR

</td><td>THREAD NUMBER</td>';

BEGIN THE SQL QEURY FOR THE INFORMATION

SHOW ALL THE CONTENTS

$result1=mysql_db_query($base, ""select count(thread.id) from messageboard)

if ($result > 0)
{
$num4=mysql_num_rows($result);
if($num4!=0)
{
$n=0;
while ( $n<$num4 )
{

call and show the ID

$category_name = mysql_result($result,$n,"messageboard.category_name");

call and show the MODARATOR

$customer=mysql_result($result,$n,"customer.username");

call and show the THREADS NUMBER

$post_id=mysql_result($result,$n,"thread.id");
$n++;

echo "<tr>";

echo "<TD bgcolor=$bgcolor><font size='+1'><b>$category_name</td>";

echo "<TD bgcolor=$bgcolor><font size='+1'><b>$customer</td>";

echo "<TD bgcolor=$bgcolor><font size='+1'><b>$post_id</td>";

echo "</tr>";
if($bgcolor == "#99CCFF") {
$bgcolor="#FF9999";
} else {
$bgcolor="#99CCFF";

}
}
}

echo "</table></table></body></html>";
}
?>

weekender

ok mate a few hints first. If you post lots of irrelevant code, nobody will bother replying. Take out blocks of whitespace in code, and put the code in [ php ] [ / php ] tags to make it formatted.

also, if the error says "Parse error: parse error, unexpected T_STRING in U:\local-html\test.php on line 26", then count down to line 26, and post line 26 only.

now on top of what kevin said, i think that $result = mysql... line is causing problems by having it over so many lines. If you have to split it, do it like this

$sql = "select messageboard.category_name, customer."."username,count(thread.id) ".
"from messageboard, customer, thread WHERE messageboard.".
"category_id=thread.id_category ".
"AND ".
"messageboard.moderator = customer.id ".
"group by thread.id_category";

$result = mysql_query($base, $sql);

also nowhere in that code have you opened the link to mysql. i take it you have actually done this and just not shown it?

adam

weekender

ok change line 28 to

$result1=mysql_db_query($base, "select count(thread.id) from messageboard");

that should work better

elpis

[ php ]

$sql = "select messageboard.category_name, customer."."username,count(thread.id) ".
"from messageboard, customer, thread WHERE messageboard.".
"category_id=thread.id_category ".
"AND ".
"messageboard.moderator = customer.id ".
"group by thread.id_category";

$result = mysql_query($base, $sql);

[/php ]

i have change it and i get this

Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in U:\local-html\test.php on line 26

weekender

yeah that's because you havent opened a connection to mysql

oh, and the php code tags don't have spaces - i only put them in so they would show 🙂


//set up the vars for connecting to mysql - you need to fill these in
$mysql_host = "";
$mysql_user = "";
$mysql_password = "";
$mysql_database = "";

//open a connection to mysql
$link = mysql_connect($dbhost, $dbuser, $dbpass)
	or die("Cannot open database connection");
//select the database to work with
mysql_select_db($dbname, $link)
	or die("Cannot select database");

$sql = "SELECT * FROM mytable";
//then you have a link resource identifier - $link - you can now query. You can leave $link out if you only have one link, and you can still do multiple queries on one link
$result = mysql_query($link, $sql);

any more probs, let us know

ads

elpis

thank you very mutch for you help and your time