[jozin]

Hi,

I have an error,

Parse error: parse error, unexpected T_STRING in C:\web\Apds\proc_athlete.php on line 17



My pro_athlete.php script is,
<?php
include("Opendb.php");
echo $process;
if ($process=="add")
{
$SQL="INSERT INTO basic_info (StudNo, Lname, Fname, Mname, Birthdate)
VALUES ('".$studID."','".$Lastname."', '".$Firstname."', '".$Midname."', '".$bday."')";
}
elseif ($process=="edit")
{
$SQL = "UPDATE basic_info SET StudNo='$studID', Lname='$Lastname', Fname='$Firstname', Mname='$Midname', Birthdate='$bday' WHERE StudNo='$studID'";
}
elseif ($process=="del")
{
$SQL = "DELETE FROM basic_info WHERE StudNo='$studID';
}
mysql_select_db("apds") or die("Could not select database");
$result = mysql_query($SQL) or die("Query failed : " . mysql_error());
include("main.php");
?>


The line 17 is:
mysql_select_db("apds") or die("Could not select database");



My Opendb.php script is:
<?php
mysql_connect("localhost","root", "jojo");
$mySQLdb="apds";
?>

I just can’t find what is wrong with line 17. I’m using PHP 4.3.4, WinXP pro, MySQL 4.0.17

I have used this scripts in other projects and it worked.

I hope you will find time to give your comments.

Thanks a lot.

Jozin

[Wuiqed]

Try changing this:

PHP Code:

 $SQL = "DELETE FROM basic_info WHERE StudNo='$studID'; 

... to this:

PHP Code:

 $SQL = "DELETE FROM basic_info WHERE StudNo='$studID'"; 

[jozin]

Hi Wuiqed,

It worked! I sure am not yet very familiar with PHP syntax.

Thanks a lot and more power.

jozin

[Fr3dY]

Hi there I need your help...this is my problem. I created a simple.php page which contain the following codes:

<?php
include ("http://..../WebCalendar/index.php");

?>

When I entered the url onto the browser, "http://..../mambo/simple.php", this error appeared...
" Parse error: syntax error, unexpected T_STRING in http://....../WebCalendar/index.php on line 1 ".

The codes in the WebCalendar/index.php is:

<?php
include_once "includes/init.php";

// If not yet logged in, you will be redirected to login.php before
// we get to this point (by connect.php included above)

do_redirect ( empty ( $STARTVIEW ) ? "month.php" : "$STARTVIEW.php" );

?>

Any solution?? Help Please Thank you.....

[Sabu]

You cannot INCLUDE a url.

Use the file() or file_get_contents() functions to grab the contents of the remote file, but it will only be the *output* of the url.

So, in other words, rewie your INCLUDE function to grab the file locally, not remotely. Make it a relative file location if need be.