insert ID in query

[techker]

Hey guys i have this pagination script that im using and i need to add a specific user to it.so it does not select every thing from the databse but only the user loggin.

 

SELECT COUNT(*) as num FROM $tbl_name WHERE Date = (SELECT MAX( date ) FROM $tbl_name

 

need to add `Dealer_ID`=$ID

 

thx!!

[taquitosensei]

If you had just thought about this for about 2 seconds longer you probably would have had it.

SELECT COUNT(*) as num FROM $tbl_name WHERE Date = (SELECT MAX( date ) FROM $tbl_name where `Dealer_ID`=$ID   

but you'll want to escape the $tbl_name and $ID  with mysql_real_escape_string

 

[techker]

thx true...lol

[techker]

funny cause now it says my fetch array is no good?

$sql = "SELECT * FROM $tbl_name WHERE Date = (SELECT MAX( date ) FROM $tbl_name) WHERE Dealer_ID='$_SESSION[user_id]' LIMIT $start, $limit";

$result = mysql_query($sql);

 

[/php

[taquitosensei]

you've got too many where's use an AND instead of your second WHERE

$sql = "SELECT * FROM $tbl_name WHERE Date = (SELECT MAX( date ) FROM $tbl_name) AND Dealer_ID='$_SESSION[user_id]' LIMIT $start, $limit";
   $result = mysql_query($sql);

[techker]

oh ok..i will try it.thx!