I have the following tables:
Table 1 [hosts]
host_id Primary, Auto Increment INT(11)
host_name VARCHAR(30)
host_url VARCHAR(255)
Table 2 [packages]
package_id Primary, Auto Increment INT(11)
host_id INT(11)
package_name VARCHAR(20)
package_cost INT(5)
package_features TEXT
and i wanna to add in these tables values? But i don't know the php code that do that?
I know i will start like
<?php
connect to database
$connect = mysql_pconnect("localhost", "cobra_search", "****") or die("Could not connect: ".mysql_error());
mysql_select_db("cobra_search", $connect) or die('Unusable database: '.mysql_error());
[code=php]
but then what do I?
i write sql="INSERt.....?
Thanks