print values returned from select..where in php/mysql

Question

I want to select rows from table "students" where username=name from php file. How I can print the rows returned ?? I used this but the values not printed (no results appears )

$result=mysql_query("select name from students where name=$name);


if($result){

while($row=mysql_fetch_array($result))
{
echo " $row['name'];
}
}

What PHP editor are you using? Can it color code/syntax highlight your code? — Salman A, Feb 06 '13 at 19:05
My problem is not in selecting the required rows. It selects them , but not printing them — Calm Sea, Feb 06 '13 at 19:18

score 3 · Answer 1 · answered Feb 06 '13 at 19:06

If $name is not numeric, MySQL will think it is a column and the column probably does not exist so you will get an error because of that. Put quotes around it like '$name'. You should also call mysql_real_escape_string on $name first, and you should check that the result of mysql_query is not false (if it is, check mysql_error).

You're also missing some quotes.

Even better, stop using ext/mysql and use PDO instead. Then you can write the query like

select name from students where name = ?

and the escaping and quote additions are done automatically for you.

+1 better answer than mine .. – NullPoiиteя Feb 06 '13 at 19:08 — NullPoiиteя, Feb 06 '13 at 19:08

score 1 · Answer 2 · edited May 23 '17 at 10:32

if you use string use quote other wise it will treat as column name

$result=mysql_query("select name from students where name='$name'");

Note

The entire ext/mysql PHP extension, which provides all functions named with the prefix mysql_, is officially deprecated as of PHP v5.5.0 and will be removed in the future. So use either PDO or MySQLi

Good read

score 0 · Answer 3 · answered Feb 06 '13 at 19:04

0

Try:

$result=mysql_query("select name from students where name='$name'");

And echo " $row['name']; should be echo $row['name'];

answered Feb 06 '13 at 19:04

SeanWM

16,789
7
51
83

Sorry ," $row['name'] I wrote this by accedent, also , '$name' with quetes did not work either – Calm Sea Feb 06 '13 at 19:17

score 0 · Accepted Answer · answered Feb 06 '13 at 19:04

0

$result = mysql_query("select name from students where name='$name'");


if($result){

  while($row = mysql_fetch_array($result))
  {
    echo $row['name'];
  }
}

answered Feb 06 '13 at 19:04

Mihai Matei

24,166
5
32
50

print values returned from select..where in php/mysql

4 Answers4

Note