you might wanna use this instead: $result = mysql....; if (mysql_num_rows($result) { while .... } else { echo 'no articles'; }
$result will always hold an int value if the query does not contain any error. so doing a num_rows on it will be more accurate in telling you if records are been retrieved. Sascha Braun wrote: > $Query = "SELECT * FROM basket_db WHERE session_id = '$PHPSESSID'"; > $Result = mysql_query($Query, $connect); > if ($Result) { > while ($arrResult = mysql_fetch_array($Result, MYSQL_ASSOC)) { > echo '<tr bgcolor="#fffdd7" class="text01">'; > echo '<td>'.$arrResult['image_id'].'</td>'; > echo '<td>'.$arrResult['name'].'</td>'; > echo '<td><a class="text01" >href="'.$PHP_SELF.'?action=delete&id='.$arrResult['id'].'">delete</a></td>'; > echo '<td> Hier Preis'.$arrResult[''].'</td>'; > echo '<td> hier gesamt'.$arrResult[''].'</td>'; > echo '</tr>'; > } > } else { > echo '<tr bgcolor="#fffdd7" class="text01">'; > echo '<td colspan="5">There are no Artikles in Cart.</td>'; > echo '</tr>'; > } > > This script is not doing what I want it too! > > Ich want to see : There are no Artikles in Cart > > when there are no Artikels in Cart > > But it good damn doesn't work! > > Please tell me why > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php