Jump to content

Archived

This topic is now archived and is closed to further replies.

Yojance

Help with simple php script

Recommended Posts

Hello, I have started learning php a week ago and I'm trying to put something together and I was wondering how can I extract every single row from this script and show it.

[code]<?php
$db = "links";
$dbcon = mysql_connect("localhost", "user", "pass");
    mysql_select_db($db, $dbcon);
$url =             $_POST['url'];
$title =         $_POST['title'];

$addquery = "INSERT INTO links(title, url)
                    VALUES('$title', '$url') ";
if(isset($_POST['submit'])) {
    mysql_query($addquery);
}
?>[/code]

Thanks for reading and hope someone can help me.

Share this post


Link to post
Share on other sites
[code]
$sql = "select * from links";
$results = mysql_query($sql) or die (mysql_error());

while ($info = mysql_fetch_array($results)) {
   echo $info['title'] . " " . $info['url'] . "<br>";
}
[/code]
will output:

title url
title url
title url
.
.
.

Share this post


Link to post
Share on other sites
Thanks for your replay, I copy and pasted that into my editor and I played with the last line to make it look like a regular link using <a href="blahblah">title</a> .
The problem is that the title is correct, but for the url, it goes straight to the same page Im looking at the links.

Here is the code I used:
[code]echo "<a href=\"".$info['url']."\">".$info['title']."</a><br/>";
[/code]

So.. no matter how many links I have on that page, it's linking them all to the same page, called add_links.php
Any idea why this is happening?

Share this post


Link to post
Share on other sites
I fixed it now, a friend of mine helped me. Thank you all anyways.
Thank you Crayon for the help :)

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.