Problem with a mysql_query

Question

panagosa 0 Newbie Poster

13 Years Ago

First of all i'd like to say hello to everybody.
I've been working upon a script and i seem to be facing a problem with a mysql_query.
Here it goes:
I have 2 tables on my data base and there are some html forms through which tha data is entered in the tables. Also i got one html script as a search, where there are some radio buttons, with the same name and different value that allows the user to pick for which field he's going to give the critiria of searching.
On the php script that handles thw date i have written the above:

<html>
<?PHP
$critiria=$_POST;
$search=$_POST;
$con=mysql_connect('localhost','root','');
mysql_select_db('test',$con);

if($critiria=="epitheto_iatrou"){
$sql="SELECT * FROM doctors WHERE epitheto='$critiria'";
$result=mysql_query($sql,$con) or die(mysql_error());
while ($newarray=mysql_fetch_array($result)){
echo "Epitheto: $newarray[epitheto] ";
echo "Eidikotita: $newarray[eidikotita] ";
echo "Misthos: $newarray[misthos] ";
}
}

else if($critiria=="eidikotita"){
$sql="SELECT * FROM doctors WHERE eidikotita='$eidikotita'";
$result=mysql_query($sql,$con) or die(mysql_error());
while ($newarray=mysql_fetch_array($result)){
echo "Epitheto: $newarray[epitheto] ";
echo "Eidikotita: $newarray[eidikotita] ";
echo "Misthos: $newarray[misthos] ";
}
}
else if($critiria=="epitheto_patient"){
$sql="SELECT * FROM patients WHERE epitheto='$critiria'";
$result=mysql_query($sql,$con) or die(mysql_error());
while ($newarray=mysql_fetch_array($result)){
echo "Epitheto: $newarray[epitheto] ";
echo "Onoma: $newarray[onoma] ";
echo "id_doctor: $newarray[id_doctor] ";
echo "date: $newarray[date] ";
echo "poli: $newarray[poli] ";
}
}
else if ($critiria='poli'){
$sql="SELECT * FROM patients WHERE poli='$critiria'";
$result=mysql_query($sql,$con) or die(mysql_error());
while ($newarray=mysql_fetch_array($result)){
echo "Epitheto: $newarray[epitheto] ";
echo "Onoma: $newarray[onoma] ";
echo "id_doctor: $newarray[id_doctor] ";
echo "date: $newarray[date] ";
echo "poli: $newarray[poli] ";
}
}
else if ($critiria='date'){
$sql="SELECT * FROM patients WHERE date='$critiria'";
$result=mysql_query($sql,$con) or die(mysql_error());
while ($newarray=mysql_fetch_array($result)){
echo "Epitheto: $newarray[epitheto] ";
echo "Onoma: $newarray[onoma] ";
echo "id_doctor: $newarray[id_doctor] ";
echo "date: $newarray[date] ";
echo "poli: $newarray[poli] ";
}
}

?>
</html>
this script returns a blanc page AND without the if sentences, within which the mysql_query if created, the query returns the correct data.

Can you help me out?????

Best regards

php

4 Contributors
5 Replies
131 Views
1 Day Discussion Span
Latest Post 13 Years Ago Latest Post by MindSter

All 5 Replies

diafol

13 Years Ago

USe [ CODE ] for code. This is difficult to read.

MindSter 1 Junior Poster in Training

13 Years Ago

you are missing double-equals on

else if ($critiria='poli'){

and on

else if ($critiria='date'){

as a start.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

lyrico 23 Junior Poster in Training · Answer 1 · 2011-01-17T06:30:44+00:00

Try this:
1. Why don't create a page where your sql connection is coded. For example, create a php script and save it as connection.php and here is the code for it.

<?php
    	error_reporting(0);

	$connection = Mysql_connect('localhost','root','');
	mysql_select_db('test'); //test is the name of your database.
?>

Now analyze the modification that I made in this code.

<?PHP
      error_reporting(0);
      session_start();
      include 'connection.php' // call the connection for your database.

$critiria=$_POST['critiria'];
$search=$_POST['search'];

if($critiria=="epitheto_iatrou"){
$sql=mysql_query("SELECT * FROM doctors WHERE epitheto='$critiria'");
while($newarray=mysql_fetch_array($sql)){
echo "Epitheto: $newarray['epitheto'] <br>";
echo "Eidikotita: $newarray['eidikotita']<br>";
echo "Misthos: $newarray['misthos']<br>";
}
}

else if($critiria=="eidikotita"){
$sql=mysql_query("SELECT * FROM doctors WHERE eidikotita='$eidikotita'");
while ($newarray=mysql_fetch_array($sql)){
echo "Epitheto: $newarray['epitheto'] <br>";
echo "Eidikotita: $newarray['eidikotita']<br>";
echo "Misthos: $newarray['misthos']<br>";
}
}
else if($critiria=="epitheto_patient"){
$sql=mysql_query("SELECT * FROM patients WHERE epitheto='$critiria'");
while ($newarray=mysql_fetch_array($sql)){
echo "Epitheto: $newarray['epitheto'] <br>";
echo "Onoma: $newarray['onoma']<br>";
echo "id_doctor: $newarray['id_doctor']<br>";
echo "date: $newarray['date']<br>";
echo "poli: $newarray['poli']<br>";
}
}
else if ($critiria=="poli")
{
$sql=mysql_query("SELECT * FROM patients WHERE poli='$critiria'");
while ($newarray=mysql_fetch_array($sql)){
echo "Epitheto: $newarray['epitheto'] <br>";
echo "Onoma: $newarray['onoma']<br>";
echo "id_doctor: $newarray['id_doctor']<br>";
echo "date: $newarray['date']<br>";
echo "poli: $newarray['poli']<br>";
}
}
else if ($critiria=="date"){
$sql=mysql_query("SELECT * FROM patients WHERE date='$critiria'");
while ($newarray=mysql_fetch_array($sql)){
echo "Epitheto: $newarray['epitheto'] <br>";
echo "Onoma: $newarray['onoma']<br>";
echo "id_doctor: $newarray['id_doctor']<br>";
echo "date: $newarray['date']<br>";
echo "poli: $newarray['poli']<br>";
}
}

?>

The above query should work, but if not, try to eliminate "else" on "else if". Just make

if($critiria=="something")
{
  //blah blah blah
}
if($critiria=="something")
{
   //blah blah blah
}

panagosa 0 Newbie Poster · Answer 2 · 2011-01-17T12:15:36+00:00

First of all thank you for your answers.
1. on my code there are double equals.
2. To lyrico => I have tried what you said and there was no data retrieved from the query. The problem seem to be when include the mysql_query within the {} of the if sentence. The query alone works properly.
Is there any incompatibility among the mysql code when used within an if sentence?

MindSter 1 Junior Poster in Training · Answer 3 · 2011-01-18T05:50:24+00:00

else if ($critiria='poli'){
$sql="SELECT * FROM patients WHERE poli='$critiria'";
$result=mysql_query($sql,$con) or die(mysql_error());
while ($newarray=mysql_fetch_array($result)){
echo "Epitheto: $newarray[epitheto] <br>";
echo "Onoma: $newarray[onoma]<br>";
echo "id_doctor: $newarray[id_doctor]<br>";
echo "date: $newarray[date]<br>";
echo "poli: $newarray[poli]<br>";
}
}
else if ($critiria='date'){
$sql="SELECT * FROM patients WHERE date='$critiria'";
$result=mysql_query($sql,$con) or die(mysql_error());
while ($newarray=mysql_fetch_array($result)){
echo "Epitheto: $newarray[epitheto] <br>";
echo "Onoma: $newarray[onoma]<br>";
echo "id_doctor: $newarray[id_doctor]<br>";
echo "date: $newarray[date]<br>";
echo "poli: $newarray[poli]<br>";
}

Those are NOT double equals.I guess.

Problem with a mysql_query

Recommended Answers Collapse Answers

All 5 Replies

Recommended Answers