PHP - Am I Creating More Code Than Needed ?

I have a mysql database. I have some PHP code that I can view the mysql data & add data to the mysql database. I've attached a photo to look at. You will see an "Edit" button at the end. I need to be able to click on the edit button & it will bring up another page so I can edit that particular record. I do have an ID field in the mysql database that is set to auto inrement so each record has it's own ID.  I have no clue where to start as I know very little about PHP. The mysql database name is flow & the table name is info. The fields in the database that you see in the photo is due_ge, due_ny, and due_rk. The page I go to view the data in the mysql database is named view.php & the file I use to enter a new record is named add.php. If I could click the "edit" button to somehow edit these date fields that would be great!! Could someone start me in the right direction?

I have 99% of the code written but I still need a line or two but can't figure it out. Due_Attny is a date field. This code looks at my MySQL database & if the due_attny field is between todays date & the trigger date it will send an email to the $email variable. There is also a field in my MySQL database named a_mail_sent that by default is set to 0 which means an email has not been sent.

I need to edit this code so it will look at the a_email_sent field & if the value is 0, it sends the email & updates the a_email_sent field to 1 which means the email has been sent. If the a_mail_sent field has a value of 1, I don't need the email to be sent.

Can somoeone help me out with this code? Thanks


Code: [Select]

<?php
include('connection.php'); // DB connection
// Constants
$number_of_days_before = 6;
$email = "emailaddress@mail.org";
$reminder_details = "";
$todays_date = date( "Ymd" );
echo $todays_date;
$year = substr($todays_date, 0, 4);
$month = substr($todays_date, 4, 2);
$date = substr($todays_date, 6, 2);
$trigger_date = date("Ymd", mktime(0,0,0,$month, $date+$number_of_days_before,$year));
$insertquery = "UPDATE psrinfo SET a_mail_sent=1 WHERE employee='Employee1'";
mysql_query($insertQuery) or die ('Error updating database'); 

echo $trigger_date;

$result = mysql_query( "SELECT a_mail_sent, due_attny, employee, pacts, dock, fname, lname FROM psrinfo WHERE employee='Employee1' AND due_attny BETWEEN $todays_date AND $trigger_date" );
$nr = mysql_num_rows( $result );

while( $row = mysql_fetch_array( $result ) )
{
$reminder_details .= "Name: ".$row["fname"]." ".$row["lname"]."\n";
$reminder_details .= "PACTS Number: ".$row["pacts"]."\n";
$reminder_details .= "Dock: ".$row["dock"]."\n";
$reminder_details .= "Due to Attny: ".$row["due_attny"]."\n\n\n";
}
mysql_free_result( $result );
if( !empty( $nr ) )
{
// Send reminder email
$mailheader = "From: Reminder System <$email>\nX-Mailer: Reminder\nContent-Type:text/plain";
mail("$email", "PSR Due Within 6 Days", "$reminder_details", "$mailheader");

}
?>

Hello,   I have a website called http://flappycreator.com/ where users can upload multiple images to create their own version of Flappy Bird.  As a result of this I created a PHP page that takes a GET param to create a preview image of their game to display in various locations on the website.   Here is an example: http://flappycreator...d=5305a9ad9dc30 http://flappycreator...d=5305a9ad9dc30 http://flappycreator...d=5305a9ad9dc30   My issue is, I have given my users the ability to upload PNGs or JPGs and trying to figure out reliable code to display the preview has become a huge hassle.  In the example above the Pac-Man character shows a white background but when you play the game, it is actually transparent.  In other situations I am getting extremely bad color distortion.  The code I have provided is my final attempt after a ton of trial-and-error and the PNG imagealphablending() and imagesavealpha() commands have shown me the best results, however I don't know what they do.   Please help!  Thanks.

<?php

$bird_picture = "default/bird.png";
$tube1_picture = "default/tube1.png";
$tube2_picture = "default/tube2.png";
$ground_picture = "default/ground.png";
$bg_picture = "default/bg.png";

// If an id is set, then reset values
if (isset ( $_GET ['id'] )) {

	require ('XXX.php');
	$db = new DBAccess ();

	$query = "SELECT * FROM XXX WHERE XXX = '{$_GET['id']}'";
	$result = $db->query ( $query );
	$num_results = $result->num_rows;
	$row = mysqli_fetch_array ( $result );

	if ($num_results != 0) {
		if ($row ['bird_picture'] != "") {
			$bird_picture = "instances/" . $row ['folder_dir'] . "/" . $row ['bird_picture'];
		}

		if ($row ['tube1_picture'] != "") {
			$tube1_picture = "instances/" .$row ['folder_dir'] . "/" . $row ['tube1_picture'];
		}

		if ($row ['tube2_picture'] != "") {
			$tube2_picture = "instances/" .$row ['folder_dir'] . "/" . $row ['tube2_picture'];
		}

		if ($row ['ground_picture'] != "") {
			$ground_picture = "instances/" . $row ['folder_dir'] . "/" . $row ['ground_picture'];
		}

		if ($row ['bg_picture'] != "") {
			$bg_picture = "instances/" . $row ['folder_dir'] . "/" . $row ['bg_picture'];
		}
	}
}

$temp = explode(".", $bg_picture);
$extension = end($temp);
if ($extension == "jpeg" || $extension == "jpg") {
	$background = imagecreatefromjpeg($bg_picture);
} else {
	$background = imagecreatefrompng($bg_picture);
	// Turn off alpha blending and set alpha flag
	imagealphablending($background, true);
	imagesavealpha($background, true);
}

$temp = explode(".", $ground_picture);
$extension = end($temp);
if ($extension == "jpeg" || $extension == "jpg") {
	$ground = imagecreatefromjpeg($ground_picture);
} else {
	$ground = imagecreatefrompng($ground_picture);
	// Turn off alpha blending and set alpha flag
	imagealphablending($ground, false);
	imagesavealpha($ground, true);
}

$temp = explode(".", $bird_picture);
$extension = end($temp);
if ($extension == "jpeg" || $extension == "jpg") {
	$bird = imagecreatefromjpeg($bird_picture);
} else {
	$bird = imagecreatefrompng($bird_picture);
	// Turn off alpha blending and set alpha flag
	imagealphablending($bird, false);
	imagesavealpha($bird, true);
}

$temp = explode(".", $tube1_picture);
$extension = end($temp);
if ($extension == "jpeg" || $extension == "jpg") {
	$tube1 = imagecreatefromjpeg($tube1_picture);
} else {
	$tube1 = imagecreatefrompng($tube1_picture);
	// Turn off alpha blending and set alpha flag
	imagealphablending($tube1, false);
	imagesavealpha($tube1, true);
	
}

$temp = explode(".", $tube2_picture);
$extension = end($temp);
if ($extension == "jpeg" || $extension == "jpg") {
	$tube2 = imagecreatefromjpeg($tube2_picture);
} else {
	$tube2 = imagecreatefrompng($tube2_picture);
	// Turn off alpha blending and set alpha flag
	imagealphablending($tube2, false);
	imagesavealpha($tube2, true);
}

imagecopymerge($background, $tube1, 200, -200, 0, 0, 52, 320, 100);
imagecopymerge($background, $tube2, 200, 200, 0, 0, 52, 320, 100);
imagecopymerge($background, $ground, 0, 320, 0, 0, 336, 112, 100);
imagecopymerge($background, $bird, 70, 190, 0, 0, 36, 26, 100);


header('Content-Type: image/png');
imagepng($background);

# Destroy
imagedestroy($background);
imagedestroy($ground);
imagedestroy($bird);
imagedestroy($tube1);
imagedestroy($tube2);

?>

Attached Files  preview.php   3.31KB   1 downloads

hey guys,
what i have done so far is got the link to a bbc video feed
so when you go to my site the php code will retrive the latest video from bbc and get the link.
so i now have $url as having the value of the video
but i now need to insert it into the html embed video code.
so how can i make this.
Code: [Select]
<object width="416" height="374" classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" id="ep"><param name="allowfullscreen" value="true" /><param name="allowscriptaccess" value="always" /><param name="wmode" value="transparent" /><param name="movie" value="http://i.cdn.turner.com/cnn/.element/apps/cvp/3.0/swf/cnn_416x234_embed.swf?context=embed_edition&videoId=world/2009/06/28/penhaul.lok.honduras.cnn" /><param name="bgcolor" value="#000000" /><embed src="http://i.cdn.turner.com/cnn/.element/apps/cvp/3.0/swf/cnn_416x234_embed.swf?context=embed_edition&videoId=world/2009/06/28/penhaul.lok.honduras.cnn" type="application/x-shockwave-flash" bgcolor="#000000" allowfullscreen="true" allowscriptaccess="always" width="416" wmode="transparent" height="374"></embed></object>

I hav a php page which takes data from the db.But the problem i am facing is for a particular fild in database ,i have long data,which i need to b displayed in a wordwrap way

eg my data is "    Description      need a site for school    gave order on 12-10-2010     work started on 12-10-2010   "
this shuld  be displayed as
"Description      need a site for school
                        gave order on 12-10-2010
                        work started on 12-10-2010"

Description is the field in the database and rest of them are the datas in it

I have a webpage where the candidates can attach their resumes  and send to the admin.These attachments are saved in the mysql db as blob datatype.In another webpage the admin needs to download all this resumes and see the content.
How will i code for that.

Hi,

Hi,

So i have HTML table which i'm attempting to turn into executable SQL code which i can then insert into a SQL database table.

I'm wondering if anyone has any good ideas for the best way to get this done?

I need to extract the data from each of the <tr bgcolor="#EEEEEE">, scrape the text within each <td></td> and then format it in sql.

so far i have removed the html not required and created an array by exploding "<tr bgcolor="#EEEEEE">", however, its creating an empty element in the first array index [0], to fix this i have tried $players = array_shift($players); however it removed everything from the array.

next i was thinking i would need to remove all html within each array element and add a comma to the end, then i would need to compress it all back together again?

would this be the best way to do this?

source html

<html>
<head>
<title><br/></title> 
<style type ="text/css">
body,td,th {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 12px;
}
th {
padding: 5px;
text-align: left;
}
td {
padding: 2px;
border-style: solid;
border-width: 1px
}
</style>
</head>
<body>
<center><B><br/>
</center></B>
<p>
<table bordercolor="#000000" width="90%" align="center">
<tr bgcolor="#EEEEEE">
	<th>UID</th>

	<th>Name</th>

	<th>Nat</th>

	<th>Position</th>

	<th>Best Pos</th>

	<th>Age</th>

	<th>DoB</th>

	<th>Height</th>

	<th>Weight</th>

	<th>Expires</th>

	<th>Wage</th>

	<th>Value</th>

	<th>Aer</th>

	<th>Cmd</th>

	<th>Com</th>

	<th>Ecc</th>

	<th>Han</th>

	<th>Kic</th>

	<th>1v1</th>

	<th>Pun</th>

	<th>Ref</th>

	<th>TRO</th>

	<th>Thr</th>

	<th>Cor</th>

	<th>Cro</th>

	<th>Dri</th>

	<th>Fin</th>

	<th>Fir</th>

	<th>Fre</th>

	<th>Hea</th>

	<th>Lon</th>

	<th>L Th</th>

	<th>Mar</th>

	<th>Pas</th>

	<th>Pen</th>

	<th>Tck</th>

	<th>Tec</th>

	<th>Agg</th>

	<th>Ant</th>

	<th>Bra</th>

	<th>Cmp</th>

	<th>Cnt</th>

	<th>Dec</th>

	<th>Det</th>

	<th>Fla</th>

	<th>Ldr</th>

	<th>OtB</th>

	<th>Pos</th>

	<th>Tea</th>

	<th>Vis</th>

	<th>Wor</th>

	<th>Acc</th>

	<th>Agi</th>

	<th>Bal</th>

	<th>Jum</th>

	<th>Nat</th>

	<th>Pac</th>

	<th>Sta</th>

	<th>Str</th>

</tr>
<tr bgcolor="#EEEEEE">
	<td>859596</td>

	<td>Tim Krul</td>

	<td>NED</td>

	<td>GK</td>

	<td>GK</td>

	<td>31</td>

	<td>3/4/1988 (31 years old)</td>

	<td>194 cm</td>

	<td>83 kg</td>

	<td>30/6/2022</td>

	<td>£25,000 p/w</td>

	<td>£12.75M</td>

	<td>15</td>

	<td>13</td>

	<td>14</td>

	<td>8</td>

	<td>13</td>

	<td>13</td>

	<td>15</td>

	<td>12</td>

	<td>16</td>

	<td>15</td>

	<td>12</td>

	<td>1</td>

	<td>2</td>

	<td>1</td>

	<td>3</td>

	<td>8</td>

	<td>4</td>

	<td>5</td>

	<td>3</td>

	<td>2</td>

	<td>2</td>

	<td>9</td>

	<td>4</td>

	<td>3</td>

	<td>8</td>

	<td>11</td>

	<td>12</td>

	<td>14</td>

	<td>13</td>

	<td>13</td>

	<td>12</td>

	<td>14</td>

	<td>2</td>

	<td>14</td>

	<td>2</td>

	<td>15</td>

	<td>10</td>

	<td>5</td>

	<td>13</td>

	<td>11</td>

	<td>13</td>

	<td>14</td>

	<td>17</td>

	<td>13</td>

	<td>8</td>

	<td>14</td>

	<td>10</td>

</tr>
<tr bgcolor="#EEEEEE">
	<td>5204730</td>

	<td>Michael McGovern</td>

	<td>NIR</td>

	<td>GK</td>

	<td>GK</td>

	<td>34</td>

	<td>12/7/1984 (34 years old)</td>

	<td>188 cm</td>

	<td>86 kg</td>

	<td>30/6/2021</td>

	<td>£8,000 p/w</td>

	<td>£875K</td>

	<td>12</td>

	<td>11</td>

	<td>10</td>

	<td>2</td>

	<td>12</td>

	<td>12</td>

	<td>12</td>

	<td>11</td>

	<td>13</td>

	<td>8</td>

	<td>10</td>

	<td>5</td>

	<td>2</td>

	<td>1</td>

	<td>3</td>

	<td>9</td>

	<td>7</td>

	<td>6</td>

	<td>3</td>

	<td>3</td>

	<td>2</td>

	<td>7</td>

	<td>1</td>

	<td>2</td>

	<td>5</td>

	<td>7</td>

	<td>12</td>

	<td>14</td>

	<td>13</td>

	<td>13</td>

	<td>11</td>

	<td>17</td>

	<td>1</td>

	<td>12</td>

	<td>7</td>

	<td>12</td>

	<td>15</td>

	<td>10</td>

	<td>15</td>

	<td>10</td>

	<td>13</td>

	<td>12</td>

	<td>12</td>

	<td>12</td>

	<td>8</td>

	<td>15</td>

	<td>14</td>

</tr>
</table>
<p>
<p align="center">
</body>
</html>

 

code i've created so far:

<?php
// Defining the basic scraping function
function scrape_between($data, $start, $end)
{
    $data = stristr($data, $start); // Stripping all data from before $start
    $data = substr($data, strlen($start));  // Stripping $start
    $stop = stripos($data, $end);   // Getting the position of the $end of the data to scrape
    $data = substr($data, 0, $stop);    // Stripping all data from after and including the $end of the data to scrape
    return $data;   // Returning the scraped data from the function
}

$myfile = fopen("source.html", "r") or die("Unable to open file!");
$page = fread($myfile,filesize("source.html"));

$page = scrape_between($page, '</tr>', '</table>');

$players = explode('<tr bgcolor="#EEEEEE">', $page);

echo '<pre>'; print_r($players); echo '</pre>';

fclose($myfile);
?>

 

Edited December 14, 2019 by seany1234

Hello Freaks!

  I am having problem with following code:

<?php simplexml_load_string ('?xml version="1.0" encoding="utf-8"?>'); php?>

 This code is giving me following error

Parse error: syntax error, unexpected '<' in public_html/wp-content/plugins/pluginnamehere/whatever.php on line 665


I know there is only a minor bracket problem that causing me this error. I would be helpful to you if you can modify it for me

Thanks

I have a small project. I have a control board that is connected to the parallel port.

It controls 8 strips of LED on the LPT1 port.

I can turn these on and off via the command prompt, using LPTOUT.exe   ie lptout 1  turns on the 1st LED

lptout 2  will turn off 1st LED and turn on 2nd,  lptout 4 turns on 3rd and 2nd off, etc
 1, 2, 4, 8, 16, 32, 64, 128.     and combinations ie lptout 3  turns on LEDS 1 and 2, and so on.

However lptout seems very unresponsive sometimes I have to do lptout 1  twice before LED 1 turns on.

Is there another command I can use to write to LPT1 port.

I need some PHP code to control the outputs.

I want to sequence the outputs ie  1on (1second) 2on (1 second) 3 on (1 second) 4 on  etc. to 8, then all off then repeat.

Can anyone help me.

THANK YOU.

Hi guys,

I am making a bot which only scrapes the source code of the site AFTER logging into the site.The script to login is :

Code: [Select]
<?php

    $username="xxx"; 
$password="iwonttellyou"; 
$url="http://internet.com/login.php"; 
$cookie="cookie.txt"; 

$postdata = "name=".$username."&password=".$password; 

$ch = curl_init(); 
curl_setopt ($ch, CURLOPT_URL, $url); 
curl_setopt ($ch, CURLOPT_SSL_VERIFYPEER, FALSE); 
curl_setopt ($ch, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725 Firefox/2.0.0.6"); 
curl_setopt ($ch, CURLOPT_TIMEOUT, 60); 
curl_setopt ($ch, CURLOPT_FOLLOWLOCATION, 0); 
curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1); 
curl_setopt ($ch, CURLOPT_COOKIEJAR, $cookie); 
curl_setopt ($ch, CURLOPT_REFERER, $url); 

curl_setopt ($ch, CURLOPT_POSTFIELDS, $postdata); 
curl_setopt ($ch, CURLOPT_POST, 1); 
$result = curl_exec ($ch); 

echo $result;  

?>

I can see different SESSION ID's in cookie.txt everytime i compile this code, which makes me believe its working.However what next?
How should i go to that site again, already logged in and scrape the data ? Some suggestions would be nice.

Please Help me on how to create a website using with code n a little bit explanation using PHP n phpmyadmin.
The mainthing that i need to do is using php create a simple site that logs on by connecting it to the phpmyadmin database such that i need to store the user details like name,mobile number,age,loaction,lattitude n longitude in database.Also i need to retrieve the database whenever required!!!
Can Any1 please help how to do this...It means a lot to me n i'm a new User n Beginner to learn these things!!!   

Thank u for reading this 

I am refactoring entire collective scattered SQL from my legacy codebase, and into separate classes, and looking for some structure to put it into.

Right now I have folders effectively called `DataFromDB` - contains classes that accepts whatever parameters are given, and returns pure data back to the user `DAO` - Data Access Object, which takes that raw data from DB and makes sense out of it and prepares it for consumption by the model/business logic layer objects. That is:

    - src (folder)
      |- DAO (folder)
        | - ProductADAO (classes - take data in, return consumable objects out)
        | - ProductBDAO
        | - ...
        | - ProductZDAO
      |- DataFromDB (folder)
        | - ProductAData (classes - contain methods to query pure result sets from DB)
        | - ProductBData
        | - ...
        | - ProductZData

Whenever I need to make a new SQL or refactor an old one I do this: What is this SQL doing?  Is it operating on `SomeObjectX`?  If yes, find/create class called `ObjectX`, and add a method to it, extracting pure data from DB, put it into `DataFromDB` folder. Write the `DAO` object if needed to transform data into a consumable object. Use the object as is in my code. Does this look like a good strategy?  Is there a better one?   My problem with this one is that before (now) all the SQL is tightly coupled and is included into the multiple business classes.  Using the above strategy will mean I am to be creating many many classes, a lot of classes, most likely one for every few SQL statements.    The pros is that it seems like I will achieve a level of code modularity that I wanted.

Hello Forum, please can someone help me solve this error in the code below, thanks

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\XAMPP\xampp\htdocs\testingSite\addtobasket.php on line 10

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\XAMPP\xampp\htdocs\testingSite\addtobasket.php on line 11

<?php
session_start();

require("db.php");
require("function.php");

$validid = pf_validate_number($_GET['id'], "redirect", $config_basedir);
$prodsql = "SELECT * FROM products WHERE id =" .$_GET['id'] . "'";
$prodres = mysql_query($prodsql);
$numrows = mysql_num_rows($prodres);
$prodrow = mysql_fetch_assoc($prodres);

if($numrows == 0)
   {
   header("Location: ". $config_basedir);
   }
   else
   {
   if($_POST['submit'])
   {
   if($_SESSION['SESS_ORDERNUM'])
   {
      $itemsql = "INSERT INTO orderitems(order_id, product_id, quantity) VALUES (" . $_SESSION['SESS_ORDERNUM'] . "," . $_GET['id'] . ","
      . $_POST['amountBox'] .")";
      mysql_query($itemsql);
   }
   else
   {
   if($_SESSION['SESSION_LOGGEDIN'])
   {
      $sql = "INSERT INTO orders(customer_id, registered, date) VALUES (" . $_SESSION['SESS_USERID'] . ", 1, NOW())";
      mysql_query($sql);
      session_register("SESS_ORDERNUM");
      $_SESSION['SESS_ORDERNUM'] = mysql_insert_id();
      
      $itemsql = "INSERT INTO orderitems(order_id, product_id, quantity) VALUES (" . $_SESSION['SESS_ORDERNUM'] .",". $_GET['id']
      . "," . $_POST['amountBox'] . ")";
      mysql_query($itemsql);
   }
   else
   {
   $sql = "INSERT INTO orders(registered, date, session) VALUES(" ."o, NOW(),'" . session_id() . "')";
   mysql_query($sql);
   session_registered("SESS_ORDERNUM");
   $_SESSION['SESS_ORDERNUM'] = mysql_insert_id();
   
   $itemsql = "INSERT INTO orderitems(order_id, product_id, quantity) VALUES(" . $_SESSION['SESS_ORDERNUM'] . "," .$_GET['id'] . ","
   . $_POST['amountBox'] . ")";
   
   mysql_query($itemsql);
   }
}

$totalprice = $prodrow['price'] * $_POST['amountBox'];

$updsql = "UPDATE orders SET total + ". $totalprice . " WHERE id = " . $_SESSION['SESS_ORDERNUM'] . ";";
mysql_query($updres);

header("Location: " . $config_basedir . "showcart.php");
}
   else
   {
   require("header.php");
   
   echo "<form action='addtobasket.php?id=" .$_GET['id'] . "' method='POST'>";
   echo "<table cellpadding='10'>";
   
   echo "<tr>";
   if(empty($prodrow['image'])) {
   echo "<td><img src='./images.dummy.jpg' width='50' alt='" . $prodrow['name'] . "'></td>";
   }
   else
   {
   echo "<td><img src=' ./images/" . $prodrow['image'] . "' width='50' alt='" . $prodrow['name'] . "'></td>";
}
   echo "<td>" . $prodrow['name'] ."</td>";
   echo "<td>Select Quantity <select name='amountBox'>";
   
   for($i=1;$i<=100;$i++)
   {
   echo "<option>" . $i . "</option>";
   }
   echo "</select></td>";
   echo "<td><strong>&pound;" . sprintf('%.2f', $prodrow['price']) . "</strong></td>";
   echo "<td><input type='submit' name='submit' value='Add to basket'></td>";
   echo "</tr>";
   echo "</table>";
   echo "<form>";
   }
   }
   require("footer.php");
   
?>

Here's my code snippet.
Code: [Select]
if(preg_match("/^[  a-zA-Z1-42]+/", $_POST['name'])){
  $name=$_POST['name'];
  $namer=$name;
  $result = mysql_query("select `resource` from resources where `resource_id` =" .$namer. "ORDER BY `resource_id` ASC ");
    echo "<br/>The following nations have " .$namer. " as a resource\n";

  //-query  the database table
  $sql="SELECT  id, nation_id, ruler, resource1, resource2 FROM TS1 WHERE resource1 LIKE '%" . $name .  "%' OR resource2 LIKE '%" . $name ."%'";
  //-run  the query against the mysql query function
  $result=mysql_query($sql);
  //-create  while loop and loop through result set
  while($row=mysql_fetch_array($result)){
          $ID=$row['id'];
  $Ruler=$row['ruler'];

  //-display the result of the array
  echo "<ul>\n";
  echo "<li>" . "<a  href=\"searcher.php?id=$ID\">" .$Ruler. "</a></li>\n";
  echo "</ul>";
  }
  }
  else{
  echo  "<p>Please enter a search query</p>";
  }
  }
  }
Basically I have a number that's posted from a form field from another page to this page. It displays correctly on the results page but what i'm trying to do now is get that number to change based on the query at the top ''  $result = mysql_query("select `resource` from resources where `resource_id` =" .$namer. "ORDER BY `resource_id` ASC "); "

So if the number 3 (which is in the `resource_id` column) was posted it will display a result (which is in the `resource` column).

But it just seems that the query isn't going through and it continues to display the 3 which was originally posted instead of changing 3 to a number in the database.

I was thinking of performing a while loop so it just just displays the result of the query.. something like this:

Code: [Select]
$name=$_POST['name'];
  $namer=$name;
  $result = mysql_query("select `resource` from resources where `resource_id` =" .$namer. "ORDER BY `resource_id` ASC ");
 while($row = mysql_fetch_array($result))
  {
    echo "<br/>The following nations have " . $row['resource'] . " as a resource\n";
  }But that seems to have more problems as it doesn't display anything at all, not even the original number I had.

I don't think it's a big problem.. Maybe something i've just overlooked?