[SOLVED] where did i go wrong? New to PHP

[ManOnScooter]

I get just 1 value for the select query...

I just want to display the returned value

Where did i go wrong ??

 

<?php

$con = mysql_connect("localhost","root","administrator");

if (!$con)

  {

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

  }

  mysql_select_db("test", $con);

  $result = mysql_query("SELECT details FROM test where first_name like "%Scooter%"");

  $row = mysql_fetch_row($result);

  echo $row;

  mysql_close($con);

?>

[adam291086]

i am also new to php. You have return the value correctly as far as i can see. Are you sure there is more than one record containing the characters 'scooter'.

 

[rajivgonsalves]

Please use

 

echo $row[0];

[ManOnScooter]

yes, there is only 1 record !!

[ManOnScooter]

Rajiv, did that.. same error

 

Could you give me a sample code, to try it?

[adam291086]

well thats why you only get one result back. Do you want to display all the information of any record that has scooter in it? What are you exactly wanting from the result?

[ManOnScooter]

adam, all i need to display is the data in the "details" column. The query returns only one row and I want to display only data from "details" column.

[adam291086]

if you just want everything from the details column with no search creteria just do

 

<?php

$con = mysql_connect("localhost","root","administrator");

if (!$con)

  {

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

  }

  mysql_select_db("test", $con);

  $result = mysql_query("SELECT details FROM test);

  $row = mysql_fetch_row($result);

  echo $row;

  mysql_close($con);

?>

 

i think that will return everything from the details column. I am not sure as i cant test it as i am at work

[ManOnScooter]

adam, that dint work..

 

This one worked

 

<?php

$con = mysql_connect("localhost","root","administrator");

if (!$con)

  {

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

  }

 

mysql_select_db("test", $con);

 

$result = mysql_query("SELECT details FROM test WHERE first_name LIKE '%scooter'");

 

while($row = mysql_fetch_array($result))

  {

 

  echo $row['details'];

 

  }

 

mysql_close($con);

?>

 

 

is there a way to do it without the while loop??

[adam291086]

like i said i am new to this. I dont this you can do it without the while loop. This is because the while loop is saying that while there is information in the table to be displayed echo it. All tutorials i have looked at always have the while loop.

[ManOnScooter]

ok, I guess i got it..

 

Thanks anyways...