[deepdiver01]

Hi all.

I am looking for the correct syntax for updating a database using a mysql_query.

The following bit of code seems to be incorrect but I am not sure where I have gone wrong.

<?php
$con = mysql_connect("localhost","username","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }$sql = "INSERT INTO users
VALUE (online varchar (1))";
if (mysql_query($sql,$con))
  {
  echo "Update Done";
  }
else
  {
  echo "Error creating update: " . mysql_error();
  }
?>

What am I doing wrong this time.

Thanks.

Deep.

[Mudley]

are you trying to update or insert?

INSERT INTO tablename (colname, anothercolname) VALUES ('valueforcolname','valueforanothercolname') WHERE preferablyAprimaryKey = 69

UPDATE tablename SET colname='valueforcolname', anothercolname='anothervalue' WHERE 1=1

[deepdiver01]

Hi Mudley.

Sorry I didn't make it more clear.

I am trying to add a new column to an existing table.

[Mudley]

k, then you're looking for the ALTER TABLE syntax.

[MMJ]

Originally Posted by Mudley

k, then you're looking for the ALTER TABLE syntax.

Yep.

[00trav]

it seems like you already solved your problem, but this is a great resource
http://w3schools.com/sql/default.asp
their other tutorials are great refreshers for when you haven't used a language in awhile

[deepdiver01]

Thanks guys. Got it sorted.

Been out of internet range the past couple of weeks.

Thanks again for the help