i have this script that i made only i try to also put in a if else for for some reason the script is not putting out the else echo. its not really a problem as the script works but it would be nice to have it work as i intended.
Code: [Select]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
-->
</style>
</head>
<body>
<?php
echo '<link href="path/custom/style.css" rel="stylesheet" type="text/css">';
$model = $_GET['id'];
$filename = (explode (":",$model));
$filename2 = (explode ("-",$filename[1]));
$space = " ";
$path = $filename2[0]. $space . $filename2[1];
$user_name = "";
$password = "";
$database = "";
$server = "";
$db_handle = mysql_connect($server, $user_name, $password);
$db_found = mysql_select_db($database, $db_handle);
$model = "SELECT * FROM ..... WHERE name='$path'";
$result = mysql_query($model);
while($rows=mysql_fetch_array($result)){
if ($rows['name'] == $path){
?></p>
<table width="100%" border="0" cellspacing="1" cellpadding="0" class="profile">
<tr>
<td width="25%" height="113" valign="top"><table width="100%" border="0" cellspacing="2" cellpadding="0">
<tr>
<td width="27%" bgcolor="#8DCEFA">Model</td>
<td width="5%" bgcolor="#003464"><div align="center"><span class="style1">:</span></div></td>
<td width="68%" bgcolor="#FAE4AB"><? echo $rows['name']?></td>
</tr>
<tr>
<td bgcolor="#8DCEFA">Age:</td>
<td bgcolor="#003464"><div align="center"><span class="style1">:</span></div></td>
<td bgcolor="#FAE4AB"><? echo $rows['age'] ?></td>
</tr>
<tr>
<td bgcolor="#8DCEFA">Country</td>
<td bgcolor="#003464"><div align="center"><span class="style1">:</span></div></td>
<td bgcolor="#FAE4AB"><? echo $rows['country'] ?></td>
</tr>
<tr>
<td bgcolor="#8DCEFA">City</td>
<td bgcolor="#003464"><div align="center"><span class="style1">:</span></div></td>
<td bgcolor="#FAE4AB"><? echo $rows['city'] ?></td>
</tr>
<tr>
<td bgcolor="#8DCEFA">Ethnic</td>
<td bgcolor="#003464"><div align="center"><span class="style1">:</span></div></td>
<td bgcolor="#FAE4AB"><? echo $rows['ethnic'] ?></td>
</tr>
</table></td>
<td width="19%" valign="top"><table width="100%" border="0" cellspacing="2" cellpadding="0">
<tr>
<td width="66" bgcolor="#8DCEFA">Eyes</td>
<td width="12" bgcolor="#003464"><div align="center"><span class="style1">:</span></div></td>
<td width="99" bgcolor="#FAE4AB"><? echo $rows['eyes'] ?></td>
</tr>
<tr>
<td bgcolor="#8DCEFA">Hair</td>
<td bgcolor="#003464"><div align="center"><span class="style1">:</span></div></td>
<td bgcolor="#FAE4AB"><? echo $rows['hair'] ?></td>
</tr>
<tr>
<td bgcolor="#8DCEFA">Height</td>
<td bgcolor="#003464"><div align="center"><span class="style1">:</span></div></td>
<td bgcolor="#FAE4AB"><? echo $rows['height'] ?></td>
</tr>
<tr>
<td bgcolor="#8DCEFA">Weight</td>
<td bgcolor="#003464"><div align="center"><span class="style1">:</span></div></td>
<td bgcolor="#FAE4AB"><? echo $rows['weight'] ?></td>
</tr>
<tr>
<td width="66" bgcolor="#8DCEFA">style</td>
<td bgcolor="#003464"><div align="center"><span class="style1">:</span></div></td>
<td bgcolor="#FAE4AB"><? echo $rows['style'] ?></td>
</tr>
</table></td>
<td width="56%" valign="top"><table width="100%" border="0" cellspacing="2" cellpadding="0">
<tr>
<td bgcolor="#8DCEFA">Biography</td>
</tr>
<tr>
<td bgcolor="#FAE4AB"><? echo $rows['bio'] ?></td>
</tr>
</table></td>
</tr>
</table>
<?
}else {
echo "it works";
}
}
mysql_close($db_handle);
?>
</p>
</body>
</html>
maybe sone help me figure out what i did wrong here
Help with explandable category tree
I have the below query: SELECT l1.id as lev1_id,l2.id as lev2_id,l3.id as lev3_id,l1.category AS lev1, l2.category as lev2, l3.category as lev3 FROM categories AS l1LEFT JOIN categories AS l2 ON
puting for loop in 1 value
hi ,how do i put this code in 1 value:Code: <?phpfor ($i=1; $i<=5; $i++) { echo $i ; }?>the output will be: 12345how do i put the result in one value ,some thing like :if the
PO Release Strategy Issue
Hi Experts,
Web Host List
Here is a list of web hosts that offer PHP and MySQL. It is no where near a full list, but it is most popular. I'm locking this so you can't reply. I am pulling this list from the most popular google
Syntax Help
I'm trying to make a form that edits a php file which contains config settings. I'm using strings that are defined by the user form inputs. This is what my file should look like when the form is
Dynamic Data + Sql Server 2005 Enterprise?
Hi! I have just started to learn ASP.NET, and it looks like it is quite a lot to learn. Im not really sure where I should begin, but I have watched the Dynamic Data
Remote Database Access
Hey guys!!OK, i'm used to only working with databases from the CPANEL, accessing phpMyAdmin after setting up a mysql database in the cpanel.I've been asked to setup a website and the client has set up
How to search for several parameters from objects in a database?
I have a database with lots of information about objects.Now I would like to search for 4 or 5 parameters at the same time (from a form) like this:I choose from a select-box one parameter and then
Casting Decimals in Oracle
This code worked as a query in DB2, but I am not sure what the syntax is for casting decimals in Oracle:
Convert array to string and write to csv file
I am looking to write a MySQL query to a csv file.At the minute I:check for the original file, and delete it;create a new (blank) file;run the MySQL query and pass it into an array;write it to the new