need help with php image tag

[mikewooten]

can anyone please help me with this tag.
i am getting this error message

Parse error: parse error, expecting ','' or';'' in /home/username/public_html/php_cart2/admin/add4_5.php on line 215

can anyone please let me know whats wrong with this tag and how to fix it?

<a href=\"show_details.php?id=".$products["itemId"]">
//below is the image tag that i need help with, 
//i don't know where the error is?
<img src='images/".$products["itemImage"]."'alt='".$products["itemName"]"'/>

</a>

thanks

[drew010]

i think
<a href="show_details.php?id=".$products["itemId"]">
needs to be
<a href="show_details.php?id=".$products["itemId"].">

as well as
<img src='images/".$products["itemImage"]."'alt='".$products["itemName"]"'/>
to
<img src='images/".$products["itemImage"]."'alt='".$products["itemName"]."'/>

is this in an echo statement also? im not clear, its html mixed with php but no echo or print

[mikewooten]

yes this image tag is inside of an echo statement

[mikewooten]

the code you gave didn't work, it still gives the same error message? what else should i try?

thanks

[drew010]

do you mind posting the whole code snippet, echo included?

[mikewooten]

here's the code i'm using

echo "<table class='products' border='1'>";
while($products = mysql_fetch_array($results)){

echo "<tr>
<td class='products'>
<span class='title'>".$products["itemName"]."</span><br />		
<a href=\"show_details.php?id=".$products["itemId"]">
<img src='images/".$products["itemImage"]."alt='".$products["itemName"]"' />
</a>

</td>
</tr>
</table>";

}

[mtimdog]

You need to put the </table> outside of the loop and you missed 2 closing quotes

<?
echo '<table class="products" border="1">'; 
while($products = mysql_fetch_array($results)){ 

echo '<tr> 
<td class="products"> 
<span class="title">' . $products['itemName'] . '</span><br />         

<a href="show_details.php?id=' . $products['itemId'] . '"> 
<img src="images/' . $products['itemImage'] . '" alt="' . $products['itemName']. '" /> 
</a> 

</td> 
</tr>';
}
echo '</table>'; 


?>

[mikewooten]

thanks, the code you gave me did work, but now when i run the page again, i get this message

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/username/public_html/php_cart2/admin/add4_5.php on line 232

line 232 is the while statement that is above
while($products = mysql_fetch_array($results)){

it is regarding the same piece of code that has been posted above and that i am working with.

how should that error message be fixed?
can anyone please let me know whats wrong it and how to fix it?

thanks

[mikewooten]

?

[bike5]

That usally means something in your $results is invalid for the mysql_fetch_array() to execute;

[mikewooten]

so, what would i need to do to the code that i'm using in order for the page to work so the warning message won't show up?

[bike5]

post the code you put in the $results string.

[mikewooten]

in order for the page to work, would i have to use the $query_data[0] to query out the results? if not what code would I have to use for the results string?

[bike5]

Do you have something similar to:

$Query = "SELECT * FROM $TableName WHERE name='$user'";
$Result = mysql_db_query($DBName, $Query, $Link) or die(mysql_error());
while ($col_m = mysql_fetch_array ($Result))
{
echo whatever
}

[mikewooten]

yes

[bike5]

go over the text inside $Query (in my code) but in your code whatever you named that variable. Echo every variable and double check everything is spelled right, names match up in the database. The only time I ever get that error is when something is wrong with the text: SELECT * FROM $TableName WHERE name='$user', something inside there causes that error, at least in my experience. Either a variable is not set right, a name (table or column name in the database) doesn't match the ones in the database, your not connected to the database.

Pretty much break it down step by step from the start. Echo from the start (connecting to the D😎 everything in order that links the to the end result $results. Its annioing and sometimes takes a while but if your throughtly go through it like that you will find the problem.