add query to a function
Posted: Sat Jul 08, 2006 12:42 pm
i'm trying to add a "create table if not exists $picId" query to this function,
and haven't had any luck - also need to remove the .jpg ext that would be on the end of "$picId" in the query.
can anyone please show me how this might be done?
thanks in advance
g
Code: Select all
function edituser $picId,$firstname,$lastname,$password,$aka,$email,$url,$website,$city,$state,$talent,$biography,$approved,$customerid) {
$sql = "update stars set picId='$picId',password='$password',email='$email',firstname='$firstname',lastname='$lastname',aka='$aka',website='$website',url='$url',city='$city',state='$state',talent='$talent',biography='$biography',approved='$approved' where customerid='$customerid'";
$results = $this->update($sql);
return $results;
}can anyone please show me how this might be done?
thanks in advance
g