displaying data from a field

[tipton]

hello friends

I am trying to make a hyperlink and an image source reference my sql database.

Lets say the table I am using has 3 fields in it which would be "Name", "MyURL" and "MyImage" hopefully the names of the fields dont matter because I will prolly change them later but for now thats what they are.

Now I want my page to display the following code:

Code:
<a href="<?=$pageheaderurl?>"><img src="<?=$pageheaderimage?>" border="0"></a>

I will have MANY rows in this table for different images and urls but I need to be able to reference one single row and have the link url and image url for a specific name on the page I am working on. It doesnt have to be dynamic in the sense of automaking the pages for this.

For Example:
Name=John
MyURL=http://fakeurl.com/image.jpg
MyImage=http://f -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[raven]

Well, first off, the column names do matter, in as much as they can be case sensitive (not so on a Windows platform, usually, but on linux for sure) so referencing the column `name` and `Name` would be two different things.

Secondly, your query would fail because you haven't used quotes around the string you want to compare. In other words, you're looking for any records that have a `name` column where the value is 'John'. Because you've left the quotes out, the queries you've written are literally looking to compare a column `name` with a column `John` (which I'm assuming doesn't exist, so the query returns no result; in fact it should fail).

Third, your calls to mysql_result() reference columns that you haven't named in your query at all, specifically image_url (myimage) and link_url (myurl), and use a seemingly nonexistant variable $i for the row. These values need to be the actual value of columns you've referenced in the SELECT statement. Furthermore, -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --