# ASP|MYSQL Query Correct?

**URL:** <https://forum.kirupa.com/t/asp-mysql-query-correct/218255>\
**Category:** Uncategorized\
**Created:** [March 6, 2007, 5:33am UTC](https://forum.kirupa.com/t/asp-mysql-query-correct/218255 "2007-03-06T05:33:41Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Flash\_Man1](https://avatars.discourse-cdn.com/v4/letter/f/8797f3/32.png) [@Flash\_Man1](https://forum.kirupa.com/u/Flash_Man1)\
**Post date:** [March 6, 2007, 5:33am UTC](https://forum.kirupa.com/t/asp-mysql-query-correct/218255/1 "2007-03-06T05:33:41Z")

</div>

is this ASP query and insert correct (like in correct format and syntax)

i’m used to PHP not ASP so if anyone could help out and check it would be much appreciated,

and the connection is all part of the rs recordset so that’s all correct i’m just showing the query.

```php

rs.open "Select * from [sheet1] where = '" & recipientID & "'"
if recipientID = NULL then
"Insert Into [email], [FullName] VALUES ('"&email&"', '"&name&"')";
rs.close

```

Cheers all 😃