PHP with Mysql Probs

[leprechaun13]

Hi guys,
Just Bought "PHP with MySQL by Nat Macbride and I'm having a few Difficultys.

<? include 'sqlconnect.php' ; ?>
<? $select = "SELECT first_name, last_name
FROM customers
WHERE id = 1 ;
$result = mysql_query($link,$select);
$row = mysql_fetch_array($result) ;
$fn = $row['first_name'] ;
$ln = $row['last_name'] ;
echo"First Name: $fn 
<br/>
Last Name: $ln "
?>

Wrote this code from the book and am getting the following error:
Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in main.php on line 8
please could someone help me solve this issue as im getting really frustrated :angry:

[leprechaun13]

Ok Solved That Problem with this code

<? include 'sqlconnect.php' ; ?>
<? $select = "SELECT first_name, last_name
FROM customers
WHERE id = 1 ;
$result = mysql_query($link,$select);
$row = mysql_fetch_array($result) ;
$fn = $row ['first_name'];
$ln = $row ['last_name'];
echo"First Name $fn Last Name $ln "
?>

But i now get Parse Error unexpected T_STRING on line 14

[bfsog]

Hey.

When you include a file, the contents of that file will affect the line that you are told the error is on. Just so you now.

Your problem is that you are missing a closing " in your query. Try this:

<?php
  include 'sqlconnect.php';
$select = "SELECT first_name, last_name FROM customers WHERE id = 1";
$result = mysql_query($link,$select);
$row = mysql_fetch_array($result) ;
$fn = $row ['first_name'];
$ln = $row ['last_name'];
echo"First Name $fn Last Name $ln ";
?>

Works for me.

[leprechaun13]

Sorry about this noobish error

[leprechaun13]

Ok now solved all of the other issues including updating for latest PHP and MySQL versions with the following code:

<?php
include 'sqlconnect.php';
$select = "SELECT first_name, last_name FROM customers WHERE id = 1";
$result = "mysqli_query($link,$select)" ;
$row = "mysqli_fetch_array($result)" ;
$first = $row ['first_name'] ;
$last = $row ['last_name'] ;
echo"First Name $first Last Name $last ";
"mysqli_close($link)"
?>

and now get the following

First Name m Last Name m

yet in the database "id 1 is First Name Dave then Last Name Burton
any ideas
and also do i need double quotes (") around the variables that define where "first_name" and "last_name" go

[karinne]

What's the myslqi_... for ? Isn't it just mysql_...

Try

echo 'First Name '.$first.' Last Name '.$last; 

[leprechaun13]

This didnt work as im still getting the output

First Name m Last Name m

wheras I should be getting

First Name: Scott Last Name: Lumley

About hte mysqli_ its changed in the latest version of PHP

[karinne]

Ok... I hope you didn't put the BEGIN__VBULLETIN__CODE__SNIPPET .. not sure why that's there. Just the echo part that I wanted to show you.

[leprechaun13]

no i didnt put the BEGIN__VBULLETIN__CODE__SNIPPET as i didint get that in my browser

[filburt1]

Ok... I hope you didn't put the BEGIN__VBULLETIN__CODE__SNIPPET .. not sure why that's there. Just the echo part that I wanted to show you.

The software powering these forums tends to add that for no reason sometimes.