Where be the problem 'ere?

Anon

This is me query ... where's the parse error? I've tried loads of different things, but I'm just too dense:

$query = "SELECT * FROM benjobee_graffiti ORDER BY 'id' DESC";
$result = mysql_query($query);
while($row = mysql_fetch_array($result,1))
$crew=" . $row['crew'] . ";
{ echo "<p align=\"left\"><img src=\"images/jpeg.gif\"><a href=\"images/" . $row['filename'] . "\">" . $row['name'] . "</a> - a " . $row['type'] . " by " . $row['name'] . "";
if ($crew = 'crewless') {
echo " in <a href=\"crew.php?crew=crewless\">no</a> crew";
} else {
echo " in the <a href=\"crew.php?crew=" . $row['crew'] . "\">" . $row['crew'] . "</a> crew";
}

echo "</p>"; }

TIA 'jobee

thefury

I wouldnt no where to start!!
I see over 10 probs in it with out reading it.

For one this should not be in the while\'s ()

$crew=\" . $row[\'crew\'] . \";

and that should be...

$crew= $row[\'crew\'];

Anon

Nice work with this site... NOT stupid morons hey phpbuilder DO YOU KNOW WHAT STRIPSLASHES() IS???????????

WTF IS UP WITH THIS STUPID SITE!!!!!!!!!

oh and btw your post whatever your name was with the query error... jesus crist just stop programming in php pls

cordex

And the award for impatient and uncalled for anger goes to ...

Anon

So if could you just re-code that snippet, I would be very grateful.

benjobee

Anon

~thinks hmmmmm good idea~

The award for LEAST SUPPORTIVE TOWARDS NEWBIE CODERS goes to ...

Look, what are the forums here for? What may seem like a stupid question to you might not seem so stupid to some one who has been part-time learning php for a few weeks.

-Benjobee

PS: Bens' stick together ey =)

cordex

$query = "SELECT * FROM benjobee_graffiti ORDER BY 'id' DESC";
$result = mysql_query($query);
while($row = mysql_fetch_array($result,1))
{
$crew= $row['crew'];
echo "<p align=\"left\"><img src=\"images/jpeg.gif\"><a href=\"images/" . $row['filename'] . "\">" . $row['name'] . "</a> - a " . $row['type'] . " by " . $row['name'];
if ($crew = 'crewless')
{
echo " in <a href=\"crew.php?crew=crewless\">no</a> crew";
}
else
{
echo " in the <a href=\"crew.php?crew=" . $row['crew'] . "\">" . $row['crew'] . "</a> crew";
}
echo "</p>";
}

If you find this particular forum to be less then helpful, you might check out http://www.hvt-automation.nl/yapf/

cordex

Benjobee, you need to understand something about this particular situation. You and I are untermensch because we do not make it a habit to use "l33t $p33|<". "some d00d" is obviously superior because he cannot tell 0 from o.

Ignore him. Just learn from your mistakes and turn down "some d00d" when he applies as "l33t h@xor" in your IT department.

-Ben

PS. when using cockney code, I've found more "bloody 'ell! wots this now!?" errors then usual. Do you notice this problem? grin

Anon

lol

It wasn't cockney, it was Cornish!

-Benjobee

Anon

Muchos gracias ... that's Spain-ish ~proud~

thefury

$query = "SELECT * FROM benjobee_graffiti ORDER BY 'id' DESC";

should be

$query = "SELECT * FROM benjobee_graffiti ORDER BY id DESC";
Id isnt a php var, its a mysql col so '' are not needed

while($row = mysql_fetch_array($result,1))

should be

while($row = mysql_fetch_assoc($result))

heck

echo " in <a href=\"crew.php?crew=crewless\">no</a> crew";

should be

echo ' in <a href="crew.php?crew=crewless">no</a> crew';

Anon

jordan is right.
this is me just looking at the obvious mutilated "while" statement.

cordex

and
if($crew = 'crewless')
should be
if($crew == 'crewless')