More effecient coding...

[novemberGrey]

Is there a more effecient way to do this??

// Retrieve all the data from the "example" table
$result1 = mysql_query("SELECT * FROM home WHERE id='1'");
$result2 = mysql_query("SELECT * FROM home WHERE id='2'");

// store the record of the "example" table into $row
$row1 = mysql_fetch_array( $result1);
$row2 = mysql_fetch_array( $result2);
// Print out the contents of the entry 

$id1 = $row1['id'];
$title1 = $row1['title'];
$content1 = $row1['content'];
$image1 = $row1['image'];

$id2 = $row2['id'];
$title2 = $row2['title'];
$content2 = $row2['content'];
$image2 = $row2['image'];
?> 

[gregorious]

I am not sure if this helps; but it would seem to make debug easier.

// Retrieve all the data from  table 1
$result1 = mysql_query("SELECT * FROM home WHERE id='1'");

$row1 = mysql_fetch_array( $result1); 
           $id1 = $row1['id']; 
        $title1 = $row1['title']; 
      $content1 = $row1['content']; 
        $image1 = $row1['image']; 
 


// Retrieve all the data from  table 2
$result2 = mysql_query("SELECT * FROM home WHERE id='2'"); 

$row2 = mysql_fetch_array( $result2); 
           $id2 = $row2['id']; 
        $title2 = $row2['title']; 
      $content2 = $row2['content']; 
        $image2 = $row2['image']; 

[ellisgl]

extract()

$result1 = mysql_query("SELECT * FROM `home` WHERE id='1'"); 
$row1    = mysql_fetch_assoc($result1);
extract($row1);
// do what you want with row 1

$result2 = mysql_query("SELECT * FROM `home `WHERE id='2'"); 
$row2    = mysql_fetch_assoc($result2);
extract($row2);
// do what you want with row 2 

Unless you are trying to compare stuff from the first and second... Then you can change the second extract to be extract($row2, EXTR_PREFIX_SAME, 'b')
so you vars for the second row would be $b_(column name)

[novemberGrey]

thankyou!!!

[ellisgl]

No problem!

[bokeh]

Is there a more effecient way to do this??

The real trouble is your code is static. You could do this with one query and a loop.

SELECT * FROM `home` WHERE `id`<0 ORDER BY `id` ASC LIMIT 2

[ellisgl]

Of course - the limit 2 may not be what he is after...

[bokeh]

Of course - the limit 2 may not be what he is after...

And then again it may be!