Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
-
AlbinoJellyfish
- Forum Commoner
- Posts: 76
- Joined: Sun Apr 04, 2004 7:39 pm
Post
by AlbinoJellyfish »
This page wont display the "name". I cant figure out why.
Code: Select all
<?php
$db = mysql_connect("localhost","sevengfx","******");
mysql_select_db("sevengfx_com_-_hosted" , $db) or die("Couldn't open $db: ".mysql_error());
$query = "SELECT * FROM joe_preview ORDER BY id DESC";
$result=mysql_query($query);
while ($row = mysql_fetch_array($result)){
echo '<a href="deletep1.php?id=',$row['id'],'">';
echo $row['type'];
echo ' - ';
echo $row['name'];
echo '<br>';
echo '</a><br>';
}
?>
-
markl999
- DevNet Resident
- Posts: 1972
- Joined: Thu Oct 16, 2003 5:49 pm
- Location: Manchester (UK)
Post
by markl999 »
Do a var_dump($row); and see what's in there.
-
AlbinoJellyfish
- Forum Commoner
- Posts: 76
- Joined: Sun Apr 04, 2004 7:39 pm
Post
by AlbinoJellyfish »
ok, nevermind. it just started working for no apparent reason.