[Hover script?]

Hi,

 

Im not sure if what im asking is PHP, but i wanted to know if anyone could help me get a navigation similar to the one here - www.thegamehub.co.uk. When it hovers some more links appear, i am looking for something like that.

 

Thanks for any help!

 

 

[[SOLVED] Insert Record Problems]

Its fine ive sorted it

 

Thanks

[[SOLVED] Insert Record Problems]

sorry

 

<form action="<?php echo $editFormAction; ?>" name="form1" method="POST">
	    <p>
	      <strong>Company Name:</strong>		      
	      <input name="name" type="text" id="name">
</p>
	    <p><strong>Logo:</strong> 
	      <input name="logo" type="text" id="logo">	
	    </p>
	    <p><strong>Phone:</strong> 
	      <input name="phone" type="text" id="phone">
	    </p>
	    <p><strong>Email: 
	      </strong>
	      <input name="email" type="text" id="email">
</p>
	    <p><strong>Description -</strong> Short one for category page: 
	      <textarea name="description" id="description"></textarea>
</p>
	    <p><strong>Long Description - </strong>Description for company page: 
	      <textarea name="longdescription" id="longdescription"></textarea>
</p>
	    <p><strong>E-Case - </strong>Short one for category page: 
	      <textarea name="ecase" id="ecase"></textarea>
	    </p>
	    <p><strong>Long E-Case</strong> - E-Case for company page: 
	      <textarea name="longecase" id="longecase"></textarea>
              <input type="hidden" name="MM_insert" value="form1">
	    </p>
	    <p>
	      <input type="submit" name="Submit" value="Submit">  
              </p>
	  </form>

[[SOLVED] Insert Record Problems]

Hi,

 

I have createdf a page on dreamweaver mx 2004 that enables me to use a form to insert data into a database, the problem i have is when i click submit i get 8 of the same recordd being inserted, does anyvody know why this might be??

 

Thanks

[Any errors here??]

		if($total_results >0){
	$rs = mysql_query($sql);
	$j =1;
	while($line = mysql_fetch_assoc($rs)){
			include('results_stub.tpl');
			$j++;
	}

	}
	else{
			 echo "Try searching again";

	}
	if($last != 1){
					 echo "Pages: ";
					 for($i=1;$i<($last+1);$i++){
					 		echo '<a href="?search_text='.$search_txt.'&pagenum='.$i.'">'.$i.'</a> | ';										 
					 }
	}


}

 

Can you see any errors here??

 

www.selectgreen.co.uk When you click go leaving the box empty you get this; Try searching againPages:

 

Im guessiong its a code error thats causing this. Any help appreciated thanks

[php include a gif image]

<img src="url_of_the_image" alt="">

 

Will this cache???

 

Thanks

[php include a gif image]

I was told on another forum that i could use a cache (php include) to stop my sliced images from photoshop from loading aafter every click

 

???

 

Thanks

[php include a gif image]

Hi,

 

I wanted to know how to php include a .gif image, when i do it like this

<?php include (images/index_01.gif); ?>

i get this error;

 

Parse error: syntax error, unexpected '/' in /home/price7/public_html/index.php on line 46

[Search form errors (code included)]

So i need to put a spacee after like?

 

Thanks

[Search form errors (code included)]

<code>Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/nextgen/public_html/search.php on line 236

 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/nextgen/public_html/search.php on line 248

Sorry, but we can not find an entry to match your query</code>

 

These are the erroes thats i get after searching i hope thats what you need

 

Thanks

 

Also what do you put to get code boxes on the forums

[Search form errors (code included)]

You need to search by using the link searcg company

 

and the lines are bolded in this thread

 

Thankjs

[Search form errors (code included)]

Sorry i think my servers down so cant view link

[Search form errors (code included)]

The code below is a search form, that i have found on the web, the bolded lines are producing errors,

 

www.selectgreen.co.uk/search.php Search for company.

 

Any help, im hoping its ok apart from those problems

 

Thanks

<?
//This is only displayed if they have submitted the form
if ($searching =="yes")
{
echo "<h2>Results</h2><p>";

//If they did not enter a search term we give them an error
if ($find == "")
{
echo "<p>You forgot to enter a search term";
exit;
}

// Otherwise we connect to our Database
mysql_connect("localhost", "user", "password") or die(mysql_error());
mysql_select_db("databse") or die(mysql_error());

// We preform a bit of filtering
$find = strtoupper($find);
$find = strip_tags($find);
$find = trim ($find);

//Now we search for our search term, in the field the user specified
$data = mysql_query("SELECT * FROM property WHERE upper($field) LIKE'%$find%'");

//And we display the results
<b>while($result = mysql_fetch_array( $data ))</b>
{
echo $result['fname'];
echo " ";
echo $result['lname'];
echo "<br>";
echo $result['info'];
echo "<br>";
echo "<br>";
}

//This counts the number or results - and if there wasn't any it gives them a little message explaining that
<b>$anymatches=mysql_num_rows($data);</b>
if ($anymatches == 0)
{
echo "Sorry, but we can not find an entry to match your query<br><br>";
}

//And we remind them what they searched for
echo "<b>Searched For:</b> " .$find;
}
?>

[Search 11 databases, with one search form]

yes i mean tables

 

sorry  :-\

[Search 11 databases, with one search form]

I want to search 11 databses so i suppose i need some kind of select from php code or something, but i want to search 11 databses, i dont know where to start.

[Search 11 databases, with one search form]

ive neverf posted anything about a search before

[Search 11 databases, with one search form]

I wanted to know where to go about making a site search page with a search form, I want it to display the results for the NAME field

in the database, for example if someone searches for selectgreen then selectgreen.co.uk will come up on a page similar to this. http://selectgreen.co.uk/travel.php. i want the logo of the company and description and ecase to also come up on the results.

 

I dont know where to start so help would be much appreciated

 

Thanks

[Random selection from a database.]

yea the pk is aut-incremetn, and the key distribution is even yes,

[Link page to another page]

<?php require_once('Connections/sgreen.php'); ?>
<?php
$maxRows_property = 10;
$pageNum_property = 0;
if (isset($_GET['pageNum_property'])) {
  $pageNum_property = $_GET['pageNum_property'];
}
$startRow_property = $pageNum_property * $maxRows_property;

mysql_select_db($database_sgreen, $sgreen);
$query_property = "SELECT * FROM property ORDER BY id DESC";
$query_limit_property = sprintf("%s LIMIT %d, %d", $query_property, $startRow_property, $maxRows_property);
$property = mysql_query($query_limit_property, $sgreen) or die(mysql_error());
$row_property = mysql_fetch_assoc($property);

if (isset($_GET['totalRows_property'])) {
  $totalRows_property = $_GET['totalRows_property'];
} else {
  $all_property = mysql_query($query_property);
  $totalRows_property = mysql_num_rows($all_property);
}
$totalPages_property = ceil($totalRows_property/$maxRows_property)-1;
?>

 

thats the noly bit i can think u woudl need

 

all the rest is tables images etc, nohing to do with dbs

[Link page to another page]

<a href="/viewproperty.php?id="><?php echo $row_property['name']; ?></a>

 

ive got that

 

what u meen by this $this = $_GET['this']

[Link page to another page]

http://www.selectgreen.co.uk/viewproperty.php?ID=

 

the ID isnt coming up either

[Link page to another page]

Ive just remembered and its /viewproperty.php?id=

 

now i need to know how to get the individual comppany details onto this one page so its different every time.

 

last time i did it it was something to do woth dynamic

[Link page to another page]

SelectGreen.co.uk has 11 different categories, in each there is a selection of companies, i want to link the 'Company Name' to another page called viewproperty.php. This is the page that will dispplay all companies using php db tags.

 

I cant remember the link its something like viewproperty.php=ID?

 

i have done it b4 but just cant remember

[Random selection from a database.]

please help fenway, 

[Random selection from a database.]

i could do with some help!