PHP print from database without 'while'

Question

I need to print one row from a table so a while loop isn't necessary, is there any other method?

RiaD · Accepted Answer · 2011-09-24 23:34:34Z

3

You need not while.

Just do your while condition outside while 1 time.

i.e

$a=mysql_fetch_row($sql); //use $a

instead of

while($a=mysql_fetch_row($sql)){ //use $a }

answered Sep 24, 2011 at 23:34

47.8k12 gold badges85 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Although you should be using PDO.

Brad Christie · Accepted Answer · 2011-09-24 23:35:23Z

if (($dbResult = mysql_query("SELECT ... FROM ... LIMIT 1")) !== false) { $row = mysql_fetch_array($dbResult); echo $row['Column_Name']; }

Just fetch one row, no need to always loop a retrieval.

Matt Montag · Accepted Answer · 2011-09-24 23:36:18Z

$results = mysql_query("SELECT * FROM my_table WHERE user_id = 1234"); $row = mysql_fetch_assoc($results); echo ($row['user_id']);

greg0ire · Accepted Answer · 2011-09-24 23:36:04Z

0

Do what you would have done inside the condition of your loop, and you'll be fine.

answered Sep 24, 2011 at 23:36

23.3k17 gold badges76 silver badges104 bronze badges