Retrieving row from entering phone number

[rfigley]

I'm trying to extract and display some fields from a row in a MySQL database by entering the phone number into a form. Here is the code I'm using but getting "query fail".

<?


 include('dbconnect.php');
 include('font_setting.htm');

$query = ("select * from tbl_members (phone) VALUES ('$phone')");

$result = mysql_query($query) or die("Query fail");

if (mysql_num_rows($result) == 0)
{

} else
{
    echo "<CENTER>";
    echo "<table border=1>";

  while($row = mysql_fetch_array($result))
    {
        echo "<tr><td> " . $row['name'] . "</td><td> " . $row['category'] . "</td><td> " . $row['business_name'] . "</td><td> " . $row['phone'] . "</td></tr>";
        echo "</font>";
    }

}

echo "</table>";


?>

[enterume]

Hi,

At first you should remove the 1st and last bracket in your $query.

I think you should edit your sql statement to :

$query = "select * from tbl_members (phone) VALUES ('".$phone."')";

as if you put like

$query = "select * from tbl_members (phone) VALUES ('$phone')";

MySQL will treat the $phone as string, instead of the $phone value.

Thanks
Louis

[rfigley]

OK, tried that. But same error.🙁

[enterume]

Hi,

I make a mistake here, your query should be:

"select * from tbl_members phone= '".$phone."'";

try to print out your sql statement after excuting, see you able to get the $phone value or not.

The earlier statement is for inserting statement like "INSERT INTO table (field1) values (value1);" Correct me if i am wrong.

Thanks
Louis

[rfigley]

OK, I've modified the query stament a bit and included echo statments as follows:

To get this back:
Phone: [phone]
query: select * from tbl_members phone= 954-435-9908
Query fail

<?


 include('dbconnect.php');
 include('font_setting.htm');

//$query = "select * from tbl_members phone= '".$phone."'";
  $query = "select * from tbl_members phone= ".$phone."";

  echo "Phone: ";
  echo ($phone);
echo "<BR>";
echo "query: ";
echo ($query);
echo "<BR>";

$result = mysql_query($query) or die("Query fail");

if (mysql_num_rows($result) == 0)
{

} else
{
    echo "<CENTER>";
    echo "<table border=1>";

  while($row = mysql_fetch_array($result))
    {
        echo "<tr><td> " . $row['name'] . "</td><td> " . $row['category'] . "</td><td> " . $row['business_name'] . "</td><td> " . $row['phone'] . "</td></tr>";
        echo "</font>";
    }

}

echo "</table>";


?>

[rfigley]

OK, I've modified the query stament a bit and included echo statments as follows:

To get this back:
Phone: [phone]
query: select * from tbl_members phone= 954-435-9908
Query fail

<?


 include('dbconnect.php');
 include('font_setting.htm');

//$query = "select * from tbl_members phone= '".$phone."'";
  $query = "select * from tbl_members phone= ".$phone."";

  echo "Phone: ";
  echo ($phone);
echo "<BR>";
echo "query: ";
echo ($query);
echo "<BR>";

$result = mysql_query($query) or die("Query fail");

if (mysql_num_rows($result) == 0)
{

} else
{
    echo "<CENTER>";
    echo "<table border=1>";

  while($row = mysql_fetch_array($result))
    {
        echo "<tr><td> " . $row['name'] . "</td><td> " . $row['category'] . "</td><td> " . $row['business_name'] . "</td><td> " . $row['phone'] . "</td></tr>";
        echo "</font>";
    }

}

echo "</table>";


?>

[rfigley]

Is this saying that it is not finding the phone number in the table?

[enterume]

Hi,

run this.

select * from users where wap_no= 954-435-9908

I forgot to put the WHERE at the statement. What a careless sql mistake i had made. Sorry. 😉

The idea way is you put wap_no= '954-435-9908', with a single quote. Just in case if the value with space or NULL, will generate sql error if you didn't quote the value.

Thanks
Louis

[rfigley]

OK I've adjusted to fit my parameters to make it:

$query = "select * from tbl_members where phone= ".$phone."";

Which now responds with:
Phone: [phone]
query: select * from tbl_members where phone= 954-435-9908

No error, but also not printing out the row data as I think this should be doing. I can try more echo statments.

[enterume]

what you can try is, copy the sql statement and run at PhpMyADMIN or your mysql server.

As what i said in my previous statement, try to put a single quote at the value.

Thanks
Louis

[pragma]

...has anyone thought to try...

$query = "select * from tbl_members where phone= \".$phone.\"";

or...

$query = "select * from tbl_members where phone= '.$phone.'";

[rfigley]

IN attempting all these queries in PhpMyADMIN in get a syntax error.

[enterume]

Hi Pragma,

for your question, both the query dont' require the dot(.) after the quote.

I never try both your query, but it doesn't seem like is a valid statement. Anything you put between "$value1" , or '$value1', it will be treated as string when you executing the statemnet. you can ignore the the quote, if your $value is without any space.

But if $value contain character like " or ' , you should use addslashes($value1), where the $value in in a ' ' or " " .

Thanks
Louis

[enterume]

Originally posted by rfigley
IN attempting all these queries in PhpMyADMIN in get a syntax error.

rfigley, are you saying the sql statement mentioned by pragma?

[rfigley]

What I'm not sure I understand is, when I use a given satement as previous where I was no longer getting and error reply form the page. I get a syntax error when trying it in phpMyAdmin. WHy is that?

[rfigley]

I'm saying all of them when I try in the phpMyAdmin, but I will try thme in the actual script I am tring to run.

[enterume]

Originally posted by rfigley
What I'm not sure I understand is, when I use a given satement as previous where I was no longer getting and error reply form the page. I get a syntax error when trying it in phpMyAdmin. WHy is that?

Please copy the whole error message return from PhpMyAdmin for me to check.

[rfigley]

OK, this is a query statement from a script that is working correctly that I ran in phpMySQL:

Error
SQL-query :

$query = ("select * from tbl_members where chapter='Aventura Lunch'")

MySQL said:

You have an error in your SQL syntax near '$query = ("select * from tbl_members where chapter='Aventura Lunch'")' at line 1

Back

[enterume]

when you run a sql statemnet in PhpMyAdmin, you should only write the sql query in phpMyAdmin as:

select * from tbl_members where chapter='Aventura Lunch'

The $query = "" is needed only when you ran in the mysql_fetch_array($query), or you can do like this mysql_fetch_array("select * from tbl_members where chapter='Aventura Lunch'")

[rfigley]

Ooops!!!!😃

I see what you mean. OK, will try them again there. Thnaks