If statement to verify MySQL Record

[Puppet Master]

The PHP script I write sends the data imputed from a form to a MySQL databse via the form post method.

I need an 'if' statement to verify and echo text saying 'The record has been added,'

Is it possible?

-Puppet Master

[Lamped]

PHP Code:

if (mysql_query('Some SQL')) {
  echo('The record has been added');
} 


[JohnDubya]

Lamped's solution will work great, but alternatively, especially if you are querying with a SELECT statement, you can assign the MySQL query to a variable, so you can use it later on in the script as well:

PHP Code:

//put query result into variable
$x = mysql_query('Some SQL');

if ($x) {
   echo 'The query succeeded.';
   //get result data, etc.
   $y = mysql_fetch_assoc($x);
   echo $y['field_name'];
} else {
   echo 'Query failed.';
} 


[Lamped]

To follow the theme of adapting code, it's fairly common to put the $x = something() actually *in* the if statement, like so:

PHP Code:

if ($x = mysql_query('Some SQL')) {
   echo 'The query succeeded.';
   //get result data, etc.
   $y = mysql_fetch_assoc($x);
   echo $y['field_name'];
} else {
   echo 'Query failed.';
} 


[Puppet Master]

All the codes worked like a charm. Thanks Guys.

-Puppet Master