very basic PHP/MySQL problem

miraclewhipkey

I am just barely learning PHP. In this case, I built an application in ASP, and I am now trying to convert it.

Here's what I have on a particular page, that seems like it should work (according to all the refference material I've looked at) but it doesn't. Maybe someone can tell me what I've done wrong.

<? 
//CONNECTION
$mysql_link = mysql_connect ("localhost");
$db = mysql_select_db("azrc", $mysql_link);
?>

<? 
//RETRIEVE SHOW LIST FROM TABLE
$query = "SELECT event_title,event_description,time_start,venue ".
$query =." FROM cal_events C,cal_dates D WHERE C.event_id = D.event_id AND D.event_date = #".strftime("%m/%d/%Y").
$query =."# ORDER BY time_start asc");
$result = mysql_db_query($db,$sql);
?>

<? 
if ($row = mysql_fetch_array($result))       //this is line 22
{
do {
    print "<tr>";
    print "<td><p><span class=\"eventTitle\"><b>".$row["event_title"]."</b></span><br>";
    print "When:&nbsp;".$row["time_start"]."<br>";
    print "Where:&nbsp;".$row["venue"]."<br>";
    print "Details:&nbsp;".$row["event_description"]."<br></p></td>";
    print "</tr>";
    print "<tr>";
    print "<td><img src='images/spacer.gif' height=30></td>";
    print "</tr>";
} while($row = mysql_fetch_array($mysql_result));  

}
  else
{

  print "<tr>";
  print "<td>Sorry.  There are no shows listed for today.</td>";
  print "</tr>";
} 

?>

---------------

With this code, I get this error:
"Parse error: parse error in /var/www/html/azrc/rockCal_home.php on line 22"
(line 22 is marked above)

Any ideas?

Thanks

jburfield

On this line:
$mysql_link = mysql_connect ("localhost");

You really also need to supply a username and password:

$mysql_link = mysql_connect("localhost", "user", "pass");

Then, you have your $query, so that's good...I'm not exactly sure what the '#' is doing in there...but I'll skip that one for the moment...

On this line:
$result = mysql_db_query($db,$sql);

You actually should have this:
$result = mysql_query($query, $mysql_link);

Try that and see if you get any further.

-- Jason

miraclewhipkey

Thanks for your reply.

I actually noticed a few of those things too, after I continued to play with it. I fixed up the connection statement. The # symbols were left over from when it was connecting to an Access database (in the ASP version), which requires # symbols around dates. I cleaned that out, too. I also fixed the $sql thing.

I now have that particular page showing without any errors. Hopefully that means it is all good. If you didn't notice based on the select statement, it is supposed to pull out the events and their details from the db, that match today's date and display them. In my db, I don't have any events on today's date, so I'll have to come back to this page when I get some events in the db.

Thanks for your help.

p.s. I keeping finding that keeping my connection string in an include file does not seem to work very well. My pages only work if I write the connection string right above the SQL statement on the same page.

cahva

include this at the start of your pages.


<?php
function open_db () {
	global $dbase;
	$dbase = mysql_connect("localhost","user","pass");
	mysql_select_db("azrc",$dbase);
}



function close_db () {
	global $dbase;
	mysql_close($dbase);
}
?>

Then in yor page, just use open_db() at the start of the page and put close_db() at the end.

Works for me..