Jump to content

Can select with any field but email


Pierre-André

Recommended Posts

Hi

 

I want to use the emal address (in french: adresse_courriel) in my select statement but MySQL returns me the following error:

 

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/lecof697/public_html/recherche.php on line 19

 

Is there anything specific with email addresses that forbid a normal select with them?

 

If I use any other field of my table, I get my answers as expected.

 

Here is my very simple code:

 

(I receive the value of the field adresse_courriel from a form on an html page)

 

<?php

$recherche = $_POST["adresse_courriel"];

echo $recherche;

$con = mysql_connect("","#######","#######");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

 

mysql_select_db("######", $con);

 

$result = mysql_query("SELECT * FROM inscrits WHERE adresse_courriel=$recherche");

 

while($row = mysql_fetch_array($result))

  {

  echo $row['no_inscrit'];

  echo $row['prenom'];

  echo $row['adresse_courriel'];

  echo $row['news_letter'];

  echo $row['forfait_alerte'];

  }

 

mysql_close($con);

?>

Link to comment
https://forums.phpfreaks.com/topic/247927-can-select-with-any-field-but-email/
Share on other sites

String values need to be quoted in the query string. You should also be validating/sanitizing/escaping your incoming form data before allowing it to be used in a database query.

 

 . . . WHERE adresse_courriel = '$recherche'" . . . 

Thanks a lot, it works. I was confused by the fact that it was working with other fields but those were numeric. I have tried with other alpha-numeric fields and they need the quotes. Everything works with the quotes anyway so I will always use them.

 

Thanks again!

 

Pierre-Andre

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.