Getting data from a mySQL query

Question

I'm having a fairly simple issue with MySQL. I just don't know the syntax well.

CODE:

$Rego_select = mysql_query(
  "SELECT VechicleRegistration FROM trucks WHERE TruckID = '$truckID'" ) 
  or die("Problem reading table: " . mysql_error());`

If i try to echo $Rego_select directly it outputs Resource Locater #. I am wondering what function I can use to get the data from that column.

I tried to use mysql_result(); but it requires a position number which makes life difficult because I am executing this query dynamically in a while statement and I would have to re write the whole loop structure if this is the only way to do it.

Cheers guys.

kba · Accepted Answer · 2010-12-02 11:47:07Z

2

You should be able to use mysql_result(). The position it requires is just the position in the result. When executing a query like that, there's only one result. mysql_result($Rego_select,0) should yield the result.

answered Dec 2, 2010 at 11:47

kba

19.5k6 gold badges65 silver badges90 bronze badges

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

1 Comment

Samuel Meddows Over a year ago

Thanks mate. Worked like a charm.

Dai · Accepted Answer · 2010-12-02 12:08:54Z

1

$query = mysql_query($query);

while($row = mysql_result($query)) {
    print_r($row);
}

But don't quote me on that, I've been using ADODB for so long now I can't remember the mysql_etc syntax.

answered Dec 2, 2010 at 12:08

Dai

1,5101 gold badge11 silver badges12 bronze badges

Comments

Pradeep Singh · Accepted Answer · 2010-12-02 12:24:15Z

0

<?php  
  $Rego_select = mysql_query(
      "SELECT VechicleRegistration FROM trucks WHERE TruckID = '$truckID'" ) ;

       if($Rego_select)
          {
              while($row=mysql_fetch_object($Rego_select))
                {
                if( $row->VechicleRegistration )
             echo   $valid= $row->VechicleRegistration ;
                }   
                }    

?>

answered Dec 2, 2010 at 12:24

Pradeep Singh

3,6323 gold badges33 silver badges42 bronze badges

Collectives™ on Stack Overflow

Getting data from a mySQL query

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related