Basic If Statement Help

StevenF · 02-26-2008, 11:52 PM

Hi guys,

I have what I think is a very basic question: I have a form which inserts data into a database. When the form is submitted (when mysql_query($query) = true) I want to echo "A new row has been added".

Here's the code:

PHP Code:


			
//Creating a query that enters the data into a database

    $query = 'INSERT INTO products SET    cd_artist = "'.mysql_real_escape_string($cd_artist).'",

                                        cd_title = "'.mysql_real_escape_string($cd_title).'",

                                        cd_price = "'.mysql_real_escape_string($cd_price).'",

                                        cd_image_name = "'.mysql_real_escape_string($cd_image_name).'"';

    

    //execcute a query on a MySQL database

    mysql_query($query);

    

    //Message

    if (mysql_query($query) == 1 ) {

        echo ("A new row has been added to the database");



    }

I also tried:

PHP Code:


			
//Message

    if (mysql_query($query)) {

        echo ("A new row has been added to the database");



    }

No luck. I know this is something very basic, but I can't get it to work

Thanks,
Steven