Jump to content

PHP and MYSQL failed on executing sql_execute help please


Kind_Person

Recommended Posts

 

 

	//echo "<br>  line 22   sender_name  :  .$sender_name ";
// echo "<br>  line 23   sender_email  :  .$sender_email ";

//get  users depending on selected criteria
//   market_test_5_rows    or market_test_98   

//  (id,fname,lname,initial,code_type,email,teach,date,cellx,phonex) 

$sql_select = "select fname,lname,email FROM market " ;
if($region !="all")
{
    $sql_select .= " where code_type = '" . $region . "'";
}
if (strlen(trim($starting_id)) >0 && strlen(trim($id_range)) >0 )
{
    $sql_select .= " limit " . $starting_id . "," .$id_range  ;

}

// echo "<br>  line 38  sql_select  :  $sql_select  <br> ";
//copy uploaded file to the right directory
    $upload_dir = '';
    $upload_file = '';
    $file_size = '';
    $file_type ='';
    $file_name = '';

if(strlen($_FILES['attachement']['name'])!=0)
{
    $upload_dir = './attachement/';
    $upload_file = $upload_dir . basename($_FILES['attachement']['name']);
        $file_size = $_FILES['attachement']['size'];
        $file_type = $_FILES['attachement']['type'];
        $file_name = $_FILES['attachement']['name'];
    move_uploaded_file($_FILES['attachement']['tmp_name'], $upload_file)
    or die("Could not upload file.");
}

   $sql_select .= ";"; 
   
   $sql_select = "select * FROM market; " ;
   echo "<br>  line 59  sql_select  :  $sql_select  <br> ";
   
$result = sql_execute($sql_select);  <<<<<<<<<<<<<<< failing on this statement

while ($row = mysql_fetch_array($result))
{

 

Fatal error: Call to undefined function: sql_execute() in c:\program files\easyphp1-8\www\email_las_vegas_00\market_email\market_email_sender.php on line 65

 

can you help please?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.