[Resolved] Im a complete noob, plz help!

TMoore

Hi i've just joined up, and im in need of lots of help using MySQL and Dreamweaver MX along with PHP.

I have 2 tables called Links and Link_ref.

Links contains the following fields:
'Link_id' - which is unique identifier,
'Link' - which is the Link it self

Link_ref contains the following fields:
Link_id - unique identifier
URI - Reference to file

I need to display a list of links for navigation, but only want certain links to have a file reference.

I would like the links to repeat for each record.

Say

Link 1
Link 2
Link 3
Link 4

If you want I can show you the data in the database.

Thanks 🙂

Tom

tomhath

You'll have to give a better explanation of what you're trying to do.

My wild guess is something like this:

SELECT Links.Link_id, 
       Links.Link,
       Link_ref.URI
FROM Links
LEFT JOIN Link_ref
ON Links.Link_id = Link_ref.Link_id

TMoore

Thanks for the reply ill explain what im trying to do!

Here is what I would like the navaigation to look like:

AS Level
A2 Level
[URL=http://#]HND Computing[/URL] - The link would be related to a field in another table which would contain the URI for the actual file.
[URL=http://#]FdSC Applied Computing[/URL]
AVCE
ACCESS
[URL=http://#]CLAIT[/URL]

The Link Names are stored in a table called Links
and the corresponding fields are :
Links_id and Link Name where Link_id is a integer
and Link Name is a text field containing the Subject.

The related table is link_rel, this table actually stores the url for the webpages. The fields in this one are :
Link_id and URI, Link_is a integer and URI is a text string containing the URI to the file.

As you can see i want the all the links to show but only 3 links to actually have a link attached to it.

Thanks again

Tom

tomhath

The query I posted should get the rows you want. Some of the rows will have the URI field null when there was no matching Link_id, others will have a value you can put in an href. Just check for a value in the php, something like this:

while ($row= mysql_fetch_array($result) ) {
...
  if ($row["Link_id"] ) {
    create the href here...
  }
...
}

TMoore

Thanks
it worked but now ive got another problem.
I would like to import URIs into MySQL,
and when i look at it in PHP/MyAdmin
it works, the problem is, it misses out the forward slashes or back slashes.

An example is :
INSERT INTO
Assignment
(ass_id,ass_uri)
VALUES
(1,"/HND/Assignments/Unit34of2");

and this is what it looks like

HNDAssignmentUnit34of2.

Im using a sql file to do it!

Please can you help

Thanks in advance

TMoore

I managed to resolve the problem.

I'll explain, i take it when u put urls into a database it take backslashes as a literal character marker, like in Java, and i found in the urls in the insert statement, backslashes.

I think on the server, the computer uses backslashes but when you deal with urls you use forward slashes.

All i did was do a quick find replace to replace the backslashes with a forward slash.

Anyway the problem is resolved

Thanks

Tom