glennn.php Posted July 8, 2006 Share Posted July 8, 2006 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 advanceg Quote Link to comment Share on other sites More sharing options...
fenway Posted July 8, 2006 Share Posted July 8, 2006 $picId? Your table is called "stars". I'm confused. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.