Aaah cmon guys this really cant be that hard Can noone help me out? My coursework deadline for this is in 5 days, so a quick response would be appreciated!

Trac

Ok problem solved. Where this code was:


Code:

<?php

// Get the search variable from URL
$var = @$_GET['q'] ;
$trimmed = trim($var); //trim whitespace from the stored variable

// rows to return
$limit=10;

// check for an empty string and display a message.
if ($trimmed == ""
{
echo "<p> ;Please enter a search...</p >";
exit;
}

// check for a search parameter
if (!isset($var))
{
echo "<p> ;We dont seem to have a search parameter!</ p>";
exit;
}

//connect to your database ** EDIT REQUIRED HERE **
mysql_connect( "localhost "," **",&quo t;**"; //(host, username, password)

//specify database ** EDIT REQUIRED HERE **
mysql_select_db ("**&quo t or die("Unab le to select database"< img src=http://www. allsyntax.com/f orums/images/sm ilies/wink.gif border=0>; //select which database we're using

// Build SQL Query
$query = "select * FROM `contacts` WHERE `id` LIKE \"%$trim med%\"
order by id"; // EDIT HERE and specify your table and field names for the SQL query

$numresults=my sql_query($quer y);
$numrows=mysql _num_rows($numr esults);

$result = mysql_query ($query)
or die("Quer y error: ". mysql_error());

// If we have no results, offer a google search as an alternative

if ($numrows == 0)
{
echo "<h4&g t;Results</h 4>";
echo "<p> ;Sorry, your search: &quot;&quo t; . $trimmed . "&quo t; returned zero results</p&g t;";

// google
echo "<p> ;<a href=\"h ttp://www.googl e.com/search?q= "
. $trimmed . "\" ; target=\" ;_blank\" ; title=\" Look up
" . $trimmed . " on Google\" >Click here</a> to try the
search on google</p> ;";
}

// next determine if s has been passed to script, if not use 0
if (empty($s)) {
$s=0;
}

// get results
$query .= " limit $s,$limit" ;;
$result = mysql_query($qu ery) or die("Coul dn't execute query";

// display what the person searched for
echo "<p> ;You searched for: &quot;&quo t; . $var . "&quo t;</p>&q uot;;

// begin to show results set
echo "Results ";
$count = 1 + $s ;

//now you can display the results returned
while ($row= mysql_fetch_arr ay($result)) {
$title = $row["id "];
$title1 = $row["fir st"];
$title2 = $row["las t"];
$title3 = $row["pho ne"];
$title4 = $row["mob ile"];
$title5 = $row["fax "];
$title6 = $row["ema il"];
$title7 = $row["web "];
$title8 = $row["pic "];

echo "$count.) &nbsp;$titl e &nbsp $title1 &nbsp $title2 &nbsp $title3 &nbsp $title4 &nbsp $title5 &nbsp $title6 $title7 &nbsp $title8" ;
$count++ ;
}


$currPage = (($s/$limit) + 1);

//break before paging
echo "<br />";

// next we need to do the links to other results
if ($s>=1) { // bypass PREV link if s is 0
$prevs=($s-$lim it);
print "&nbs p;<a href=\"$ PHP_SELF?s=$pre vs&q=$var\ ">& ;lt;&lt;
Prev 10</a>&am p;nbsp&nbsp ;";
}

// calculate number of pages needing links
$pages=intval($ numrows/$limit) ;

// $pages now contains int of pages needed unless there is a remainder from division

if ($numrows%$limi t) {
// has remainder so add one page
$pages++;
}

// check to see if last page
if (!((($s+$limit) /$limit)==$page s) && $pages!=1) {

// not last page so give NEXT link
$news=$s+$limit ;

echo "&nbs p;<a href=\"$ PHP_SELF?s=$new s&q=$var\ ">Next 10 &gt;&gt ;</a>&qu ot;;
}

$a = $s + ($limit) ;
if ($a > $numrows) { $a = $numrows ; }
$b = $s + 1 ;
echo "<p> ;Showing results $b to $a of $numrows</p& gt;";

?>

So what about just using CSS to format? This way, you set it once in CSS, and it applies to all elements.

I will, but after I have got the information returned into a HTML table Simply, what Im asking is 'can you put this HMTL into the right place and make it match with the php'? Thanks, I know this probably seems petty but I havent learn php and have no time to do so at the moment :( So its all tutorials for me until my coursework is in...

Thanks again,

Trac

Well see, still don't understand the question I guess. Because the 2nd sample shows HTML + PHP.

Ok, dont worry, I've worked around this. Sorry I didnt explain very well, I was a bit confused as to what I was doing myself...

Thanks anyway. Oh, I have another question above this topic too

Ok, dont worry, I've worked around this. Sorry I didnt explain very well, I was a bit confused as to what I was doing myself...

Thanks anyway. Oh, I have another question above this topic too