returning the id in an echo

[An7hony]

How would i return the id in the echo of this post:

 

$query = "INSERT INTO jobs SET agent = '".mysql_real_escape_string($agent)."', title = '".mysql_real_escape_string($title)."', location = '".mysql_real_escape_string($location)."', salary_from = '".$salary_from."', salary_to = '".$salary_to."', frequency = '".$frequency."', jobtype='".$jobtype."', description='".$description."', email = '".$email."', created_at = '".$created_at."', closing_date ='".$closing_date."', categories = '".$categories."', sectors = '".$sectors."', ref='".$ref."'";
if(mysql_query($query)) {
echo "Job inserted!";
} else {
die(mysql_error());
}

 

Thanks for the help guys

[trq]

mysql_insert_id.

[An7hony]

so just to confirm i would write this

 

echo "Job inserted!", mysql_insert_id();

[trq]

The concatination operator is . not ,

 

Why don't you try some code instead of wasting your time wondering?

[PaulRyan]

@Thorpe

You can use , OR . to echo that string and MySQL id.

Infact using , is faster if you're just echo-ing the data and . is used if you are assigning the data to a variable to concatenate*

[An7hony]

cool thanks guys

 

echo "Job inserted!", mysql_insert_id();

 

worked fine

[trq]

@Thorpe

You can use , OR . to echo that string and MySQL id.

Infact using , is faster if you're just echo-ing the data and . is used if you are assigning the data to a variable to concatenate*

 

Indeed. I always forget echo accepts more than one argument.