Hi,
I have a small problem. I am doing a simple search statement.
I want get the results of a select statement to be displayed on screen.
if not than i want to have a kind of error message that this query has no results.
this is my code
$sql_query= "SELECT lastname, ogtekst, dossiernr, Movecoordinator, Movecoordemail FROM moves WHERE lastname='$username' AND dossiernr='$password' AND company='$compnaam'";
$result = mysql_query($sql_query, $vk);
if ($result 0) {
while ($row=mysql_fetch_row($result)) {printf ("....");}}
else
{ printf ("problem");}