multiple selects

[t-man]

I'm new to PHP and am trying to get two select statements to both run on one page. The results of both selects should be put into different arrays.

So far the code is:

$dbconn = mysql_connect("$server", "$db_user", "$db_pass");
mysql_select_db("$database", $dbconn);

$result = mysql_query("SELECT bodyContent, bodyTitle FROM tblBody WHERE bodyID=1 LIMIT 1");
$resultarray = mysql_fetch_array($result)

$newsresult = mysql_query("SELECT newsID, newsTitle FROM tblNews ORDER BY newsID DESC LIMIT 4");
$newsresultarray = mysql_fetch_array($newsresult)

This code doesn't seem to work for both selects. Any ideas would be good.

Secondly, the array from the second select statement needs to have the results looped through, adding html tags whilst outputting. I'm having no luck with that either so any ideas would be good again!

TIA, Tom

[comprock]

What do mean by that the queries don't work? Do you get any error messages from mysql?

Try this to get some errors reported.

if ( !$result )
{
$box_c = "<p>In \"$sql\",<br />MySQL says: \"";
$box_c .= mysql_error();
$box_c .= "\", code ";
$box_c .= mysql_errno();
$box_c .= ".</p>";
}

Regarding the loop.

1. Find newarray result size
2. Increment of result size, loop
   2.1. Get newarray results
   2.2. Build HTML portion

[t-man]

If I have both SQL statements executing then I get this error:

Parse error: parse error in C:\phpdev\www\blb\main.php on line 8

Line 8 being the second select statement,
$newsresult = mysql_query("SELECT newsID, newsTitle FROM tblNews ORDER BY newsID DESC LIMIT 4");

Do I need to execute the first one then execute the second one?

[buba]

;

There's a missing ; at the end of this line
$newsresultarray = mysql_fetch_array($newsresult)

[comprock]

Good catch buba,

Actually both mysql_fetch_array() lines are missing semicolons.