techker

Hey guys i have a query i would like to pass but i cant seem to get the if workorking? reg querry sellect all from Archives..(Row3) and the $info come from my pagination script to list all products. so there is basicly 2 querry's here. cause i have 2 tables ,one products and the other Archives.so when i sell a product it inserts in archives the product id and sold price. so basicly this page is listing all cars .when i sell the car i set the status to sold. so i want to show if the car was already archived.. so i set up a <? if ($row3['CARID'] == $info['ID']) { echo '<img src="icons/SyncCenter_1213_10_32x32x32.png" border="0" alt="" />');}?>[code=php:0]

oh ok..i will try it.thx!

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

thx true...lol

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!!

so i used $query = "(SELECT * FROM cars ) UNION (SELECT * FROM cars2 ) ORDER BY ID LIMIT 10; "; The used SELECT statements have a different number of columns

hey guys i have 2 databases that are exacly the same.but one is cars the other is cars2 i need to echo all of the contents of both togetter. inventory page. so i tryed looking up left join im struggeling with this .. SELECT * cars LEFT JOIN cars2 works but thable 1 cars only show the id's not the rest of the info and table 2 cars 2 show it all? both have the same fields(copy paste)

That is the point of my topic exacly what I need.thx. For the help

i have a form to fill out for credit application.legaly you need to print it and sign it then fax .. so i have it 2 ways basicly i store it in my databse for future references.but the clients forget to send it ..cause the press print and then close the browser..so that is why i want my print button to do 2 functions..

hey guys i have 2 buttons in my forms.print and the other send.. is it possible to make one that will print and send..

this works if(strstr($_SERVER['HTTP_USER_AGENT'],'iPhone') || strstr($_SERVER['HTTP_USER_AGENT'],'iPod')) { header('Location: http://Site/Mobile'); exit(); }

i need it to re direct to my mobile site?

hey guys i found this code on about.com and i cant get it to work to detect my iphone .. <? if ( stristr($ua, "Windows CE") or stristr($ua, "AvantGo") or stristr($ua,"Mazingo") or stristr($ua, "Mobile") or stristr($ua, "T68") or stristr($ua,"Syncalot") or stristr($ua,"Mac OS X") or ///this part i tryed.. stristr($ua, "Blazer") ) { $DEVICE_TYPE="MOBILE"; } if (isset($DEVICE_TYPE) and $DEVICE_TYPE=="MOBILE") { $location='Mobile/index.php'; header ('Location: '.$location); exit; } ?>

ok i think i got it. SELECT * FROM `cars` WHERE `Kill` BETWEEN 60000 AND 120000 LIMIT 0 , 30 is this good?

Hey guys im doing this car dealer ship script and im stuck on a query. so i have search criteria's like by make ,color.. i have some for killometres. 60 to 90 90 to 110 110 to 160.. how can i make a query that i will search my killometre colome for cars between 60 and 90 clicks..

thx for the help!i will try it out.

but what if there is a 1 0r 2?

but this example is for if the table is empty.now i have numbers

hey guys im doing a dealership script for my body and i have a user section.now when we creat a user i set levels. like 1 is full dealer price 2 is retail price 3 is retail - so now im wondering how can i do it that it can check the level(thats ok with a querry) $sql = "SELECT Level FROM $tbl_name WHERE ID = $ID"; $result = mysql_query($sql); now i have my php echo echo $info['Retail_price'] can i do something like //echo (empty($row['d'])? "empty": "not empty"); //result not empty but for level?

No mail server.i just have my simple servers.

hey guys is it possible to make a script that you can send an email to and it will insert the email details?or trigger ? like im doing a portal for managing ticket numbers.when im on the road i would like to send and email and it can insert in the database that that job is done..

no ...

hmm cant rename cause my insert is there to..so i quoted ` `Kill` it worked.but the query did not work..so im guessing that i have to `` all ??

table CREATE TABLE IF NOT EXISTS `cars` ( `ID` int(11) NOT NULL auto_increment, `Make` varchar(20) NOT NULL, `Model` varchar(20) NOT NULL, `Year` varchar(12) NOT NULL, `Transmission` varchar(20) NOT NULL, `Full` varchar(20) NOT NULL, `Kill` varchar(20) NOT NULL, `Color` varchar(20) NOT NULL, `Doors` varchar(20) NOT NULL, `Description_short` text NOT NULL, `Description_long` text NOT NULL, `Location` varchar(20) NOT NULL, `Status` varchar(20) NOT NULL, `Retail_price` varchar(20) NOT NULL, `Nego_Price` varchar(20) NOT NULL, `Cost_price` varchar(20) NOT NULL, `Image_main` varchar(50) NOT NULL, `Image_2` varchar(50) NOT NULL, `Image_3` varchar(50) NOT NULL, `Image_4` varchar(50) NOT NULL, `Date` date NOT NULL, `Body` varchar(25) NOT NULL, `Viewedcount` varchar(15) NOT NULL default '1', `Vin` varchar(25) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;

ya i forgot the die.. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Kill ='123456',Color ='', Doors ='2', Description_short='',Description_long ='',' at line 1