concatenation and field names and urls

siobhan

Two related questions:

In the code below, I am trying to select specific fields from specific tables. I can't quite remember what the right format is for doing this (this is the photoStory1.story1head bit)

Also, I have a database field with a url e.g. http:www.domain.com/images/front.jpg

I am not clear on the format I should use in the php to incorporate an img src into the php.

Any help would be wonderful

<?php
$db->select_db(george);
$query = "SELECT * FROM photoStory1, development";

$result = $db->query($query);
$num_results = $result->num_rows;
/*echo"<br />Number of locations: ".$num_results."</p>";*/
for ($i=0; $i <$num_results; $i++) {
//process results

$row = $result->fetch_assoc();

echo "<tr>
<td>".($row['development.building'])."</td>
<td>".($row['photoStory1.story1head'])."</td>
<td>"."<img src=\"".($row['story1link'])."\"/></td> 
</tr>";
}
?>

toxic_brain

$query = "SELECT FROM photoStory1, development";

u might need use JOINs to fetch from multiple tables. replace with proper fields for photoStory1.id and development.photostory_id

$query = "SELECT photoStory1.*, development.* FROM photoStory1 LEFT JOIN development ON photoStory1.id = development.photostory_id";

<td>".($row['development.building'])."</td>

can't use table names and u may not need parenthesis. instead use

<td>". $row['building'] ."</td>

siobhan

Thanks! I will give this a go...

Did you have any thoughts on what I should do about the image src bit?

toxic_brain

u r doing in the right way, another simple way is

echo sprintf('<tr>
<td>%s</td>
<td>%s</td>
<td><img src="%s"/></td>
</tr>',
$row['building'],
$row['story1head'],
$row['story1link']
)