Wolf wrote:
Richard Kurth wrote:
I am looping through a database of files that are numbers 1 through
10 if number 1 is in the database I what to print out the first
table below if it is not then print the else section below. Then loop
through the database to see if 2 through 10 are there and do the same
thing. Of course what I am doing does not work. Should I move it all
to an array and then loop through it. Or use a foreach loop.
Could you please give me an idea where to start looking
while($row=mysql_fetch_array($sql_result)){
if ($row["number"]==1) {
<tr>
<td> File 1</td>
<td>This is the file</td>
<td>Delete</td>
</tr>
}else{
<tr>
<td>File1</td>
<td></td>
<td>Add</td>
</tr>
}
}
What is the query being executed?
Seriously, this needs more information. On the upside, it LOOKS like
it should work, however...
Here's what I use to get 1 random quote from a table I have:
------------------------------------------
$query="select quote from quotes where id=$id";
$query_res = mysql_query($query) or die(mysql_error());
if (mysql_num_rows($query_res) < 1)
{ //print message
$display_block = "<P>Something blew up.</P>";
}
else
{ //get info and build Quote display
$Quote = mysql_fetch_array($query_res);
echo $Quote['quote'];
}
It could be as simple as the " not working where you really need '
but that depends on what/how you are doing things.
Wolf
This is the query being executed
$sql = "SELECT * FROM table WHERE members_id =" . $_SESSION["members_id"];
$sql_result = mysql_query($sql) or die(mysql_error());
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
