Why is this not working?

[frankalbers]

Can somebody tell me why this does not put data in mySQL table?
<?php

$db = mysql_connect(&quot;db.cupbase.f2s.com:3306&quot;,&quot;username&quot;,&quot;password&quot
or die (&quot;Could not connect to database&quot;

mysql_select_db (&quot;nameofdatabase&quot;,$db);

$link = mysql_db_query (&quot;INSERT INTO bird (sales_id, bird_id, status, purchase_id, vet_id, weight_id, skingrade) values ('$textfield2', '$textfield3', '$textfield4', '$textfield5', '$textfield6', '$textfield7', '$textfield8')&quot;,$db);

mysql_close ($db);

?>

Thanx.
(Sory if this will appear twice.)

 

[devnull22]

what's the error message? devnull22

http://www.photoflux.com

http://www.clickEval.com

--
Apparently if you play the Windows NT CD backwards you hear satanic messages. If you think that's bad, play it forwards and it installs Windows NT !

 

[Cagliostro]

I think you didn;t select a database. Select it in first argment of mysql_connect Ion Filipski

filipski@excite.com

 

[ElgisRamon]

I think your concepts are a little confused:

Try:
[tt]
if( $Cx = mysql_connect( &quot;serverort&quot;, &quot;user&quot;, &quot;password&quot; ) )
{
// Cx is a connection pointer
mysql_select_db( &quot;database_name&quot; );
if( $Res = mysql_query( &quot;INSERT INTO TableName (col1, col2) VALUES ( 'TextValue1', 'TextValue2' )&quot;, $Cx ) )
{
// $Res is a result code and a resource pointer
echo( &quot;Values inserted&quot; );
}
else
{
echo( &quot;Values NOT inserted&quot; );
}
mysql_close( $Cx ); // Close the connection
}
[/tt]
I hope it works...
Unix was made by and for smart people.

 

[Cagliostro]

I use
$dc = mysql_connect(&quot;ServerName&quot;,&quot;userid&quot;,&quot;password&quot
or die (&quot;Could not connect to server&quot;
//without any orts
mysql_select_db(&quot;database name&quot
or die (&quot;Could not connect&quot;
Ion Filipski

filipski@excite.com