echo from database

[almightyegg]

I have a persons profile page and they have an option of 3 custom fields, and this sees if they have filled anything in or not etc:
[code=php:0]
<? if($profile['customt1'] == 0){}else{ ?>
<tr><td valign="top"><b><? echo "$profile[customt1]"; ?></b> </td>
<td valign="top"><? echo "<p>$profile[customtext1]</p>"; ?></td></tr>

<? } if($profile['customt2'] == 0){}else{ ?>
<tr><td valign="top"><b><? echo "$profile[customt2]"; ?></b></td>
<td valign="top"><? echo "<p>$profile[customtext2]</p>"; ?></td></tr>

<? } if($profile['customt3'] == 0){}else{ ?>
<tr><td valign="top"><b><? echo "$profile[customt3]"; ?></b> </td>
<td valign="top"><? echo "<p>$profile[customtext3]</p>"; ?></td></tr>
<? } ?>
</table>
[/code]

hellllppp!!  ???

[paul2463]

what are you checking for???
what do you need???

I dont understand what you want

[almightyegg]

well, I want it to echo out those 3 custom bits which are in my database, and they are not equal to 0 so they should show, except they don't show anything

[simcoweb]

For it to 'echo' you need to run a query. Do you have a query code established?

[almightyegg]

what, you mean a query for it to recognise $profile and associated in that row??

well yes I've used alsorts of $profile[?] stuff on this page

[simcoweb]

I mean a query to the database. You have to summon the data first then echo the data in the page. Post your MySQL query code so we can take a look at it.

[almightyegg]

This?

[code=php:0]
$GET = $id;
$first = "SELECT * FROM users WHERE id = '$GET'";
$second = mysql_query($first);
$profile = mysql_fetch_assoc($second);
[/code]

[simcoweb]

I believe that should be written like this:

$id = $_GET['id];

$first = "SELECT * FROM users WHERE id='$id'";

The $_GET snags the id from the url assuming you're passing the id in the url like this:

http://www.yoursitename.com/somefile.php?id=XXXXX

[almightyegg]

no change in anything  ??? everything is exactly the same...it's an error in this i think:
[code=php:0]
<? if($profile['customt1'] == 0){echo gah;}else{ ?>
<tr><td valign="top"><b><? echo "$profile[customt1]"; ?></b> </td>
<td valign="top"><? echo "<p>$profile[customtext1]</p>"; ?></td></tr>

<? } if($profile['customt2'] == 0){echo gah;}else{ ?>
<tr><td valign="top"><b><? echo "$profile[customt2]"; ?></b></td>
<td valign="top"><? echo "<p>$profile[customtext2]</p>"; ?></td></tr>

<? } if($profile['customt3'] == 0){echo gah;}else{ ?>
<tr><td valign="top"><b><? echo "$profile[customt3]"; ?></b> </td>
<td valign="top"><? echo "<p>$profile[customtext3]</p>"; ?></td></tr>
<? } ?>
[/code]

[almightyegg]

I thought it may be to do with layout of it so i changed it to this:
[code=php:0]
<?
if($profile['customt1']==0){
echo "gah";
}else{
?>
<tr><td valign="top"><b><? echo "$profile[customt1]"; ?></b> </td>
<td valign="top"><? echo "<p>$profile[customtext1]</p>"; ?></td></tr>

<?
}
if($profile['customt2']==0){
echo "gah";
}else{
?>
<tr><td valign="top"><b><? echo "$profile[customt2]"; ?></b></td>
<td valign="top"><? echo "<p>$profile[customtext2]</p>"; ?></td></tr>

<?
}
if($profile['customt3']==0){
echo "gah";
}else{
?>
<tr><td valign="top"><b><? echo "$profile[customt3]"; ?></b> </td>
<td valign="top"><? echo "<p>$profile[customtext3]</p>"; ?></td></tr>
<? } ?>
[/code]

[almightyegg]

anyone?