[SOLVED] Very Quick One

[herghost]

I have made a big mistake, I have had a pint and now can not work out why the flip this will not work, I know its simple, i have had it working before 

 

a href='http://www.ticketmaster.com/search?q=
<?php
$sql = "SELECT * FROM user WHERE userid = '$userid'";$result = mysql_query($sql) or die(mysql_error());while($row = mysql_fetch_array($result)){ {  echo $row['bandname'];   }}?>"
>Go!</a>

 

Its just meant to search for ticketmaster.com/search?q=bandname

[trq]

1 pint?

[Maq]

Your code is so obfuscated, if you properly formatted then you would probably see why it's not working...

 

Try this:

 

while($row = mysql_fetch_array($result))
{ 
   echo "Go!";
}
?>

 

1 pint?

 

I know right, you must way 50lbs...

[eRott]

Well now, if he's that drunk, we might as well spell out the whole sentence not just one of the words in it.

 

$query = "SELECT * FROM user WHERE userid = '$userid'";
$result = mysql_query($query) or die(mysql_error());

while($row = mysql_fetch_array($result)) {
   echo '<a href="ticketmaster.com/search?q='.$row['bandname'].'">Go!</a>';
}

[Maq]

Well now, if he's that drunk, we might as well spell out the whole sentence not just one of the words in it.

 

Lol.  herghost, you need to learn to properly indent and format your code, this will help with debugging.

 

The code you posted only looks like bits and pieces of the 'real' code.

[herghost]

ha ha, well I am at that age where I pint leaves you feeling quite tired if you tring to stare at code.

 

 

Thanks by the way!