[SOLVED] having trouble

[jakebur01]

I have two problems. The first is that if there is not a " WHERE $part LIKE '{$itemNum}%  " then I need to add one to the table. The second problem I am having is I need a better way to clean up my rows than to use array('', '$-', '0', '0.0', '0.00', '$ 0', '$ -', '$0.0', '$0.00', '-', ' ', '$', '$- ', '$-  '). I would like it if I could delete the rows where it does not have a numeric value above .01 .

 

 

while ($row = mysql_fetch_assoc($result)) {
    $itemNum = substr($row[$part], 0, -2);
    $update = "UPDATE {$tablename} SET $list = '{$row[$list]}', $dealer = '{$row[$dealer]}', $distributor = '{$row[$distributor]}', $sort = '{$row[$sort]}', $stdpack = '{$row[$stdpack]}' WHERE $part LIKE '{$itemNum}%'";
    mysql_query($update) or die(mysql_error());
}



$inArray = array('', '$-', '0', '0.0', '0.00', '$ 0', '$ -', '$0.0', '$0.00', '-', ' ', '$', '$- ', '$-  ');
$checkData = implode("', '", $inArray);

mysql_query("DELETE FROM {$tablename} WHERE $dealer IN({$checkData}) OR $distributor IN({$checkData}) OR $list IN({$checkData})");

 

 

[Mark Baker]

$checkData = "'".implode("', '", $inArray)."'";

 

[jakebur01]

What about this?

while ($row = mysql_fetch_assoc($result)) {
    $itemNum = substr($row[$part], 0, -2);
    $update = "UPDATE {$tablename} SET $list = '{$row[$list]}', $dealer = '{$row[$dealer]}', $distributor = '{$row[$distributor]}', $sort = '{$row[$sort]}', $stdpack = '{$row[$stdpack]}' WHERE $part LIKE '{$itemNum}%'";
    mysql_query($update) or die(mysql_error());
}

 

Is there a way I can add the item to the database if it doesn't find it doing an update. Also, I am unsure of how many columns are in the table. It is different every time. But, the only columns I need are the ones specified in the query above.

[jakebur01]

My first problem is fixed but not my second.

[jakebur01]

I know the else is incorrect. How can I do it correctly and insert values into the columns specified and NULL or 0 into the remaining columns?

 

<?php
$sql = "SELECT * FROM {$tablename} WHERE ($part LIKE '%-1' OR $part LIKE '%-2' OR $part LIKE '%-3' OR $part LIKE '%-0')";
$result = mysql_query($sql) OR DIE(mysql_error());

while ($row = mysql_fetch_assoc($result)) {
$itemNum = substr($row[$part], 0, -2);

	$sql2 = "SELECT * FROM {$tablename} WHERE $part = $itemNum";
		$result2 = mysql_query($sql2) OR DIE(mysql_error());
			$num_rows = mysql_num_rows($result2);

		if($num_rows>0) {

    $update = "UPDATE {$tablename} SET $list = '{$row[$list]}', $dealer = '{$row[$dealer]}', $distributor = '{$row[$distributor]}', $sort = '{$row[$sort]}', $stdpack = '{$row[$stdpack]}' WHERE $part LIKE '{$itemNum}%'";
    mysql_query($update) or die(mysql_error());

		}

			else {

				$insert = "INSERT INTO {$tablename} VALUES $part = $itemnum, $list = '{$row[$list]}', $dealer = '{$row[$dealer]}', $distributor = '{$row[$distributor]}', 				$sort = '{$row[$sort]}', $stdpack = '{$row[$stdpack]}'";
				mysql_query($update) or die(mysql_error());
			}
}
?>