Adding rows or records using php3

Anon

I'm trying to find a function in php3 that is similiar to MS Access' AddNew function. Can any tell me what that is or the code I need to add rows or records to a table

Anon

If you use MySQL tables, you could execute a SQL query that does it, like this:

$sql = "INSERT INTO my_table (my_first_column, my_second_column) VALUES ('$value1', '$value2')";
mysql_query($sql);

Anon

That only works on the first row. I want to be able to add rows and insert records into other rows

Anon

or if you want to insert an entire row :

mysql_query("insert into your_table values('value_1','value_2',...");

Anon

I know there is a function for dbase called dbase_add_record. Why isn't there one for mysql?

Anon

Is that a blank row?

Anon

nope ... the values('v1','v2', ...) are inserted in the row ... but you have to take care at the variable type ... you can't insert a character in an integer column ...

Anon

That only works on the first row.
I want to be able to add rows and
insert records into other rows.

To ADD a row, use a INSERT query.

To modify fields in a row, use a UPDATE query.

To add a COLUMN in a table, use the ALTER table query.

Anon

I want to add colum values and set them as a subtotal (I am trying to create an invoice).

total row1+total row2+total row3=$subtotal?

Anon

if you want to insert a blank row ...then just make an insert statement with no walues ..

mysl_query("insert into your_table values('','','','')");

this example it's creating a new row where the row has 4 columns ... if your row has a different number of columns, just cut or add a new pair of simple quotes ... and make sure each pair is separated with - , - ... and take care about the columns delcared as "NOT NULL" which have to be filled with something.