Jump to content


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


CREATE TABLE query added to a function

Recommended Posts

i need to add a "CREATE TABLE IF NOT EXISTS $picId" query in this. for some reason my attempts have failed - can this be done?

   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;

(also, $picID will have a .jpg extension which needs to be removed)

can anyone help me with this? thanks in advance


Share this post

Link to post
Share on other sites
$picId? Your table is called "stars".  I'm confused.

Share this post

Link to post
Share on other sites


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.