check if record name already exist[SOLVED]

[olumide]

Help please cant get this to work properly, all i am trying to do is check if name exist and if not add a new entry

Code: Select all

$query1 = "SELECT * FROM " . cms_db_prefix() . "module_Olu_Banner_banneradvert WHERE name = $q ";

     $dbresult1 = $db->Execute($query1);
     if (!$dbresult1)
    {  				
$banner_id= $db->GenID( cms_db_prefix () . "module_Olu_Banner_banneradvert_seq");

$query = "INSERT INTO ".cms_db_prefix()."module_Olu_Banner_banneradvert (id, name, alias, active, companyname, description, startdate, Expirydate, bannerimage, website, adverttext, created, modified) 
               VALUES ('$banner_id', '$q', '$q', '1', '$c', '', '$banner_start', '$banner_expires', '', '', '', ".$db->DBTimeStamp(time()).", ".$db->DBTimeStamp(time()).")";

$result = $db->Execute($query);


} 

[Jos]

Change

Code: Select all

if (!$dbresult1)

to

Code: Select all

if ( $dbresult && $dbresult->RecordCount() == 0 )

[olumide]

try that but still it doesn't work

[spcherub]

Instead of looking for an exception from the returned query, why not look for the count of data? So (in pseudo-code), something like this should work.

- select count(*) from table where name = $q
- If count is zero, insert new value in table

Hope this helps.
-S

[olumide]

Thanks that worked