need help: get also the deleted items!

[jac.kock]

hi all,

 

i have a headlights table where only the items that arrend deleted should be displayed, but it shows also the deleted items!

 

i know that im doing something wrong but i can seem to figure out what

 

my code :

<?php
if(file_exists("../../support/connect.dat"))    // user,pass and database file
{
   include("../../support/connect.dat");			 // database connection file
}
//################ connect to database ##############
$link=mysql_connect($host, $user, $pass) or die(mysql_error());
mysql_select_db($data);

$sql="Select * from headlights where delete_tab='0'"; // get only the none deleted!
$res1=mysql_query($sql);
$row=mysql_num_rows($res1);

$item=rand('1',$row); // have multiple rows so random because every time the same is boring 

$sql="Select * from headlights where krant_id='$item'"; // select the none deleted
$res=mysql_query($sql);

$resl=mysql_fetch_array($res);
?>
<!-- show the selected one -->
<table width="100%">
 <tr>
   <td class="head-td" height="150px" valign="top" align="top">

<? echo $resl["krant_item"]; // show the none deleted item?>
</td>  
 </tr>
</table>

 

can someone say how to fix this ???

 

thnx,

[Jessica]

What?

 

The first query you have should be all you need, you don't need that second one. You also need to then loop through them instead of just showing one.

[jac.kock]

^{hi jessica,}

 

^{i have tryed everything i could think off and i dont know anymore!}

^{gan you please show me how to solf this please??}

 

^{thnx jessica}

[Jessica]

I have no idea what your question is. Please try to use proper spelling and grammar, and clearly state the problem. 

 

What datatype is the deleted column?

You shouldn't put numbers in quotes, especially in SQL. 

[jac.kock]

type of delete_tab = int(1) so it state 1 or 0, 1 = deleted!

 

i want to kown the proper code to solve this, sorry for my bad english

 

please edit my code so it will work jessica!??

 

thnx

[jac.kock]

type of delete_tab = int(1) so it state 1 or 0, 1 = deleted!

 

i want to kown the proper code to solve this, sorry for my bad english

 

please edit my code so it will work jessica!??

 

thnx

 

what i mean is i want to display 0ne and not all of the none deleted ones!!!

thats why i use rnd

 

how can i show only the selected one by rnd?

[Jessica]

You are getting the count of how many rows are not deleted, then picking a number at random from 1 to that count. That doesn't give you the ID of the non-deleted row, it gives you a number that is useless. 

 

You can either select one row and ORDER BY RAND() or you can select all the rows, put the ids in an array and use array_shuffle. 

[jac.kock]

oke i get what you mean but i have no idea how to do this will you edit my code to what youre saying?

 

thnx jessica!

[Jessica]

Sure, my hourly rate is $100 with a min of 5 hours.

[jac.kock]

like this jessica?

 

<?php
if(file_exists("../../support/connect.dat"))    // user,pass and database file
{
    include("../../support/connect.dat");				    // database connection file
}
//################ connect to database ##############
$link=mysql_connect($host, $user, $pass) or die(mysql_error());
mysql_select_db($data);

$sql="Select * from headlights where delete_tab='0'  ORDER BY RAND()"; // get only the none deleted!
$res1=mysql_query($sql);
$res=mysql_fetch_array($res1);
?>
<!-- show the selected one -->
<table width="100%">
 <tr>
    <td class="head-td" height="150px" valign="top" align="top">

<? echo $res["krant_item"]; // show the none deleted item?>
</td>  
 </tr>
</table>

 

or is this the wrong way?

 

thnx jassica

[Jessica]

Add a LIMIT 1 and it should be fine. 

 

Did it work?

[jac.kock]

yes it works fine jessica thnx a lot