Retrieving data from sql table

[MethoD]

I'm new to mySQL, so I need some help retrieiving the stored data in the table.

Ok I've got 5 columns: id, url, title, and descrip.

How can I retrieve the information for the columns from each row?

So that it does something like this:

while (there are still some rows to get information from){
echo ("<a href='$url[0]'>$title[0]</a><br><small>$descrip[0]</small><br><br>");
}

I found out that getting information from mySQL dbs is harder the sending information to mySQL dbs. In my opinion, anyways.

Thanks for the help.

Suggestions for different methods and flames are welcome!

[Kevin Yank]

That's 4 columns, by the way.

Everything you need is explained in my article here. Meanwhile, here's your code:

$result = mysql_query("SELECT * FROM tableName") or die("Error: " . mysql_error());
while ($row = mysql_fetch_array($result)) {
  $url = $row["url"];
  $title = $row["title"];
  $descrip = $row["descrip"];
  echo ("<a href='$url'>$title</a><br><small>$descrip</small><br><br>");
}

[EDIT: fixed a small bug]
<Edited by kyank on 12-15-2000 at 11:19 PM>

[MethoD]

Oh wow that's easy
Thanks

I tried that article, but I was sortof confused about what he ment at some parts. But now it's all clear. Thanks

[Kevin Yank]

He is me. If you have any lingering questions, ask away!

[MethoD]

Warning: Supplied argument is not a valid MySQL result resource in /home2/webdev/public_html/links.php on line 32


Hmmm
PHP isn't liking :

while ($row = mysql_fetch_array($resultSet)) {
  $id = $row["id"];
  $url = $row["url"];
  $title = $row["title"];
  $descrip = $row["descrip"];
  echo ("<a href='$url'>$title</a><br><small>$descrip<small><font color=gray>$id</font></small</small><br><br>");
}

My guess is the resultSet.. But then again I've never really used arrays much before..

[Kevin Yank]

Where is the code creating that $resultSet? It's the source of your problem. See my example above for the correct method.

[Kevin Yank]

We resolved this via email. Turns out the culprit was a typo in my code above, which I have since corrected.