Fetching the value from mysql array and match from the field

Question

I got stuck in minor error on which I am trying to fetch the value from mysql.

Array and matching the value from field, but I am getting an error.

Can you please check my code:

<?php

if(isset($_POST['newsletter'])){
$email=$_POST['email'];
$check=mysql_query("select email from newsletter");
while($row=mysql_fetch_array($query))
{
  if($row['email'])==$email){
    echo "<script> alert('You are already Subscribed');</script>";
 } else {
 $sql_news=mysql_query("insert into newsletter(email) values('$email')");
  echo "<script> alert('You are successfully Subscribed');</script>"; 
 }}} ?>

Thanks in advance!!!

Don't use `mysql_*` functions, they are deprecated as of PHP 5.5 and are removed altogether in PHP 7.0. Use [`mysqli`](http://php.net/manual/en/book.mysqli.php) or [`pdo`](http://php.net/manual/en/book.pdo.php) instead. [**And this is why you shouldn't use `mysql_*` functions**](https://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php). — Rajdeep Paul, Jul 03 '17 at 17:34
I understand thats an error but still i am not getting an proper result — Piyush Seofaceup, Jul 03 '17 at 17:44

score 1 · Accepted Answer · answered Jul 03 '17 at 17:49

1

update this line cause you use $check value so in mysql fetch use this

while($row=mysql_fetch_array($query))

to

while($row=mysql_fetch_array($check))

answered Jul 03 '17 at 17:49

Shafiqul Islam

5,570
2
34
43

its ok, carry on – Shafiqul Islam Jul 03 '17 at 18:36

Fetching the value from mysql array and match from the field

1 Answers1