what the...?

[brcolow]

Hey, line 23 of this script is this...

{
	echo $id;
}
else
{
(line 23)	echo "Sorry, this article doesnt exsist";
}
?>

and it give me this error and i have NO idea why

Parse error: parse error, unexpected T_STRING in D:\www[url]www.flashstand.com\articles\articledis.php[/url] on line 23
Thanks, Mike

[jeremuck]

you have mismatched braces or something somewhere.

Check to make sure all quotations and braces and semi-colons are placed appropriately.

The problem may actually originate several lines earlier.

[brcolow]

well i dont see it..

<?
 @ $db = mysql_pconnect("localhost", "mike", "notshown");
 if (!$db)
 {

 echo "<b>Could not connect to database, try again later.</b>";

 exit;

 }

 mysql_select_db("news");



$result = mysql_query("select * from articles WHERE ID='$id');
if(!mysql_num_rows($result)==0)	
{
	echo $id;
}
else
{
	echo "Sorry, this article doesnt exsist";
}
?>

[jeremuck]

your sql statement is missing the ending "....

result=mysql_query("error is where * quotes = 'must end' here");

[brcolow]

Ok its fixed, but now i have a problem, I go to www.flashstand.com/articles/article.php?id=1 And it says the article doesnt exsist when it does, how can i make sure my information is going intot he id and not just the 4 otbher coulmns in my table, and yes, i did set id as primary key..hmmmm?

[brcolow]

Also, i have phpmyadmin set up and everytime i add an article it says.. Cardinality 1 then i add one andf it say 2 and so on, but how come it isnt working when u go to www.flashstand.com/articles/articledis.php?id=whatever ?

[tha_mink]

Well...two things. First maybe $id isn't getting passed as $id but as $_GET['id']

I see in your sql statement the ID is capitalized...is that the way it appears in your table?

Second:
Kinda messy...try it like this

<?
 @ $db = mysql_pconnect("localhost", "mike", "notshown");
 if (!$db)
 {

 echo "<b>Could not connect to database, try again later.</b>";

 exit;

 }

 mysql_select_db("news");



$result = mysql_query("select * from articles WHERE ID='$id'") or die(mysql_error());
$numrows = mysql_num_rows($result);
if ($numrows > 0)  

{
    echo $id;
}
else
{
    echo "Sorry, this article doesnt exsist";
}
?>

[tha_mink]

Also...while on the subject try using the mysql_error() function more often...for example...save yourself some space by changing....

 @ $db = mysql_pconnect("localhost", "mike", "notshown");
 if (!$db)
 {

 echo "<b>Could not connect to database, try again later.</b>";

 exit;

 }

to

$db = mysql_pconnect("localhost", "mike", "notshown") or die("Could not connect to database...try later" . mysql_error());

That way you can see what mysql is spitting back at cha.

tha_mink

[brcolow]

ok, well i dont know, its giving me this error andf i did cahnge ID to id because id is the way it is in the table...

Notice: Undefined variable: id in D:\www[url]www.flashstand.com\articles\articledis.php[/url] on line 13

[tha_mink]

that means the php variable $id is undefined. Try the url with

..?id=1

on the end of it and add the line...

$id = $_GET['id'];

above the query line.

[brcolow]

it works 🙂 now one more question, all this is doing is displaying the id number opf course because i say echo id... but how can i get it to echo the things inside the id for example... in my table there are 4 coulmns, one is id (which is primary), one is title, one is about and the last one is source, so how can i get this to load the title, about and source varibles to the corresponding id? Thanks,
Brcolow

[tha_mink]

<?
$result = mysql_query("select * from articles WHERE ID='$id'") or die(mysql_error());
$numrows = mysql_num_rows($result);
if ($numrows > 0)  

{
    $row = mysql_fetch_object($result);
    print"<p>$row->id</p>";
    print"<p>$row->title</p>";
    print"<p>$row->source</p>";
    print"<p>$row->about</p>";
}
else
{
    echo "Sorry, this article doesnt exsist";
}
?>

?>

[brcolow]

Wow, thanks a ton, it all works great. Now I am on the final part of it. I want http://www.flashstand.com/articles/index.php to select from the table and take out the title and list it by id, like the 1st one will be last and the 2nd will be ahead of that and so on. So now, how do i make it so it prints like.. <a href="http://www.flashstand.com/articles/articledis.php?id=whatever id matches the title. Thanks a TON.
-Mike

[tha_mink]

Do you want me to serve it for you too????

<?
$result = mysql_query("select * from articles ORDER BY id DESC") or die(mysql_error());

while ($row = mysql_fetch_object($result)) {
       print"<p><a href=\"articledis.php?id=$row->id\">$row->title</a></p>";
}
?>

[brcolow]

wow man, thanks so much dude

[brcolow]

Ok, one little problem, i have this a varible called author inside the table and in my script..

print"<a href=\"articles\articledis.php?id=$row->id\">$row->title - $row->author</a><br>";

It seems to work but instead of doing author, it print the source vairble, i checked over all of my code and i just cant figure out why!?

EDIT: Not sure if this will help, but in phpmyadmin, i looked up the author varible... and its the same as the source one. I tired clearing the table many times and doing it over, but still the same thing...it makes the author varible the same as the source. So WHere do u think this problem may be in my code?

[tha_mink]

Age old programming quote.

garbage in -> garbage out.

Since you output code looks fine...it's probaby your input code. Check that and make sure you are putting the proper values in the proper columns when you add to the database.

[brcolow]

$sql ="INSERT INTO articles (title, about, source, author) VALUES ('$title', '$about', '$source', '$author')";

I dotn see anything wrong, do u?

[tha_mink]

Nope...but maybe your form fields?

gotta be somewhere man...I think you have the power to figure it out on your own.

good luck

[brcolow]

actually, i didnt figure it out 🙁 oh well...