minor problem

[taylor7127]

Does anyone see anything wrong with this basic piece of code? I realize that I haven't completed the if/else part but when I run it, it returns the "not quite" script. The database exists and has data set up in it:

<?php
$linkID = mysql_connect("localhost","xxxxxxxx","xxxxxxxx");
$dbselect = mysql_select_db("xxxxxxxx", $linkID);
$messagephp = mysql_query("SELECT message from lunch where id = 1", $linkID);
$date1php = mysql_query("SELECT date from events where entrynumber = 1", $linkID);
$date2php = mysql_query("SELECT date from events where entrynumber = 2", $linkID);
$date3php = mysql_query("SELECT date from events where entrynumber = 3", $linkID);
$date4php = mysql_query("SELECT date from events where entrynumber = 4", $linkID);
$date5php = mysql_query("SELECT date from events where entrynumber = 5", $linkID);
$date6php = mysql_query("SELECT date from events where entrynumber = 6", $linkID);
$date7php = mysql_query("SELECT date from events where entrynumber = 7", $linkID);
$event1php = mysql_query("SELECT event from events where entrynumber = 1", $linkID);
$event2php = mysql_query("SELECT event from events where entrynumber = 2", $linkID);
$event3php = mysql_query("SELECT event from events where entrynumber = 3", $linkID);
$event4php = mysql_query("SELECT event from events where entrynumber = 4", $linkID);
$event5php = mysql_query("SELECT event from events where entrynumber = 5", $linkID);
$event6php = mysql_query("SELECT event from events where entrynumber = 6", $linkID);
$event7php = mysql_query("SELECT event from events where entrynumber = 7", $linkID);
$time1php = mysql_query("SELECT time from events where entrynumber = 1", $linkID);
$time2php = mysql_query("SELECT time from events where entrynumber = 2", $linkID);
$time3php = mysql_query("SELECT time from events where entrynumber = 3", $linkID);
$time4php = mysql_query("SELECT time from events where entrynumber = 4", $linkID);
$time5php = mysql_query("SELECT time from events where entrynumber = 5", $linkID);
$time6php = mysql_query("SELECT time from events where entrynumber = 6", $linkID);
$time7php = mysql_query("SELECT time from events where entrynumber = 7", $linkID);
$tutor1php = mysql_query("SELECT teacher from tutoring where day = 'monday'", $linkID);
$tutor2php = mysql_query("SELECT teacher from tutoring where day = 'tuesday'", $linkID);
$tutor3php = mysql_query("SELECT teacher from tutoring where day = 'wednesday'", $linkID);
$tutor4php = mysql_query("SELECT teacher from tutoring where day = 'thursday'", $linkID);
$lunch1php = mysql_query("SELECT menu from lunch where day = 'monday'", $linkID);
$lunch2php = mysql_query("SELECT menu from lunch where day = 'tuesday'", $linkID);
$lunch3php = mysql_query("SELECT menu from lunch where day = 'wednesday'", $linkID);
$lunch4php = mysql_query("SELECT menu from lunch where day = 'thursday'", $linkID);
$lunch5php = mysql_query("SELECT menu from lunch where day = 'friday'", $linkID);

if ($messagephp != FALSE)
{
print $messagephp;
}
else
{
print "Not quite";
}
?>

[RoadKingHD]

It looks like your code is working just the way it is written.

[MAN]mysql_query[/MAN] will return TRUE or FALSE, your query is working so the return is TRUE, or in the case of your If statement, != FALSE.

if ($messagephp != FALSE)
{
print $messagephp;
}
else
{
print "Not quite";
}

I would write this as

If(!$messagephp) {
//some code
} else {

//more code

}

but that's just me
🙂

[Jayson]

mysql_query returns a result identifier. You'll need to use mysql_fetch_array or one of the other fetch functions to get the values you want out of the result.

I would suggest you read up on those functions. Your code can also be reworked and improved by using arrays to store results and you can get away with much fewer queries. Your chunk of code is much bigger than it needs to be to do what it does.

[taylor7127]

Could you suggest a good book or web site dealing with arrays? I've purchased several books lately and none of them really deal with this subject well enough.

[klansman]

About paper-boot i cannot help you, but the php manual explains how to use them... the information is somehow scattered, but it's there.

[]

[RoadKingHD]

mysql_query does indeed return a resource id, but returns FALSE on fail. That is in the case of a SELECT statement.

MySQL - New Riders Publishing; ISBN: 0735709211

An excelent book. 35 bucks most places on-line or 50 at your local B&N.

Then on-line doc's at mysql.com come are also very good and free!