[solved. thanks]parse error ($_session[], select)

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
m2babaey
Forum Contributor
Posts: 364
Joined: Sun May 20, 2007 9:26 am

[solved. thanks]parse error ($_session[], select)

Post by m2babaey »

Hi
this code is sending this error:
Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in g:\programs(2)\easyphp1-8\www\ha\previous\new folder\another\htdocs\myarticles.php on line 5
code:

Code: Select all

<?php
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("articles") or die(mysql_error());
$result = mysql_query("SELECT * FROM articles WHERE username=$_SESSION['username'] ORDER BY id") or die(mysql_error());
echo ?> <p align=center> your articles: </p>  <?
while($row = mysql_fetch_array( $result )) {
echo $row['subject']."<br>".$row['title']."<br>".$row['text']."<br><br>";
}
mysql_close();
?>
Last edited by m2babaey on Tue Jul 03, 2007 11:50 am, edited 1 time in total.
User avatar
JayBird
Admin
Posts: 4524
Joined: Wed Aug 13, 2003 7:02 am
Location: York, UK
Contact:

Post by JayBird »

Code: Select all

echo ?> <p align=center> your articles: </p>  <?
Why the extra echo? get rid of it
User avatar
Gente
Forum Contributor
Posts: 252
Joined: Wed Jun 13, 2007 9:43 am
Location: Ukraine, Kharkov
Contact:

Post by Gente »

Here?

Code: Select all

echo ?> <p align=center> your articles: </p>  <?
while($row = mysql_fetch_array( $result ))
:wink:
m2babaey
Forum Contributor
Posts: 364
Joined: Sun May 20, 2007 9:26 am

Post by m2babaey »

I changed the code to:

Code: Select all

<?php
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("articles") or die(mysql_error());
$result = mysql_query("SELECT * FROM articles WHERE username=$_SESSION['username'] ORDER BY id") or die(mysql_error());?> <p align=center> your articles </p>  <?
while($row = mysql_fetch_array( $result )) {
echo $row['subject'] "<br>".$row['title']."<br>".$row['text']."<br><br>";
}
mysql_close();
?>
but the same error yet
User avatar
Jenk
DevNet Master
Posts: 3587
Joined: Mon Sep 19, 2005 6:24 am
Location: London

Post by Jenk »

Code: Select all

$result = mysql_query("SELECT * FROM articles WHERE username=$_SESSION['username'] ORDER BY id") or die(mysql_error());
to:

Code: Select all

$result = mysql_query("SELECT * FROM articles WHERE username={$_SESSION['username']} ORDER BY id") or die(mysql_error());
and use long tag: '<?php' not short tag: '<?'

May not 'fix' it, but process of elimination yada..
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

Code: Select all

<?php
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("articles") or die(mysql_error());
$result = mysql_query("SELECT * FROM articles WHERE username = {$_SESSION['username']} ORDER BY id") or die(mysql_error());
?>
<p align="center">your articles:</p>
<?php
while ($row = mysql_fetch_array( $result )) {
    echo $row['subject'] . '<br />' . $row['title'] . '<br />' . $row['text'] . '<br /><br />';
}
mysql_close();
?>
Post Reply