Insert Date YYMM

cswales

Hi
I would like to query a table and insert values into a column which would be the dat but converted to a string to show YYMM

Can anyone help with this?

theeper

Cswales ... Every one of your posts is very non specific. You are asking people to write code for you without specifying any details or giving any code examples yourself.

Please RTFM and at least get a vague idea about what you are trying to do, then post the code that you tried.

Hi
I would like to query a table and insert values into a column which would be the dat but converted to a string to show YYMM

INSERT INTO table (field1,field2) VALUES ('data1','0507');

.. where field2 is a VARCHAR(4).

That's about all I can say based on your question.

cswales

Hi
An example of my code is:

<?php
// Make a MySQL Connection
mysql_connect("localhost", "user", "pass") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());

// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM table1")
or die(mysql_error());

echo "<table border='1'>";
echo "<tr> <th>Name</th></tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['invoiceyymm'].$row['agentid'];
}
echo "</table>";
mysql_close();
?>

I have printed the results into a table but I would like to insert these results into a different field in the table (fieldX).
Hope this gives a better idea.

theeper

Just do an INSERT query in your loop (if it's not too many rows).

while($row = mysql_fetch_array( $result )) { 
// Print out the contents of each row into a table 
echo "<tr><td>"; 
echo $row['invoiceyymm'].$row['agentid']; 

$sql = "INSERT INTO table1 (fieldx) VALUES ('" . $row['invoiceyymm'] . "');
$result = mysql_query($sql);

echo "</td></tr>";
}

Also, you forgot to close the TD and TR in your loop for each row.

cswales

Hi
I cannot get this to work. Can anyone try it to see if they have a problem. I just get and error on the last couple of lines.