Checking $_POST against records in table

[dc_jt]

Hi I have a table containg name, description, url which contains many records

 

When I submit a new form, I want it to check the url fields in the table and check it against what I have posted. Therefore something like

 

$check_table = function here to get all urls

 

if($_POST['url'] == $check_table) {

return false;

} else {

return true

}

 

However, how do I get all the urls and get it to check each one?

 

Thanks

[DanDaBeginner]

$query= mysql_query("SELECT url FROM TABLE WHERE url = $_POST['url'] ");

 

if (mysql_num_rows >= 1) {

  return false;

 

} else {

  return true;

}

 

[dc_jt]

Thanks I just realised how.

 

What about when I update instead of add. Because if it looks in table it will find the one im trying to update.

 

Shall I do a different query for update and do where id != $_POST[id] ??

 

Thanks

[DanDaBeginner]

yes, and also use mysql_real_escape_string to avoid sql injections...

[dc_jt]

Thanks for your help and tip but whats that?

 

These are my functions now

 

function validateAdd($from=NULL){
	$valid = true;
	if(!$_POST[name]){$_POST[errors][name] = "<li>Please enter a headline for the campaign</li><br>"; $valid = false;}
	if(!$_POST[content]){$_POST[errors][content] = "<li>Please enter some content for the campaign</li><br>"; $valid = false;}
	if(!$_POST[url]){$_POST[errors][no_url] = "<li>Please enter a URL for the campaign</li><br>"; $valid = false;}
	if($_POST[discount_level_id] == 0){
		$_POST[errors][discount_level_id] = "<li>Please enter a discount level</li><br>"; $valid = false;
	}
	if(!$_POST[code]){$_POST[errors][code] = "<li>Please enter a HEX code for the campaign</li><br>"; $valid = false;}
	if($_POST[url] != ''){
	$get_url = $this->getUrl($_POST[url]);
	if($get_url > 0){

	$_POST[errors][url] = "<li>This URL has already been taken. Please choose another.</li><br>"; $valid = false;
	}
	}
	return $valid;
}

function getUrl($iUrlId)
{
	$db = new RCDB;
	$query  = "SELECT COUNT(url) 
			 AS num 
			 FROM campaign 
			 WHERE url = '$_POST[url]' ";
	$db->query($query);
	$db->next_record();
	return $this->listSize = $db->get_field('num');
}

[/code][/code]