Board index   FAQ   Search  
Register  Login
Board index php forum :: php coding PHP coding => General

New to php, need help with Code

Ask about general coding issues or problems here.

Moderators: macek, egami, gesf

New to php, need help with Code

Postby jocana » Wed Oct 10, 2012 6:15 pm

Hi, I'm trying to make a website but before I actually start it, I played around with php for a little bit. I know a little about coding from research I've done myself, but for some reason my code keeps getting a syntax error and I do not know why. Could anyone please help me?
Code: Select all
<?php
mysql_connect("localhost","root","password") or die("could not connect");
mysql_select_db("gamerz_ultd") or die("could not connect to db");
$output = '';
//collect
if(isset($POST['search'])) {
   $searchq = $_POST['search'];
   
   $query = mysql_quert("SELECT * FROM sign_up") or die ("could not search");
   $count = mysql_numb_rows($query);
   if($count == 0){
      $output = 'There was no search results';
   }else{
      while($row = mysql_fetch_array($query)) {
      $fname = $row['user_first_name'];
      $lname = $row['user_last_name'];
      $id = $row['id'];
      
      $output .= '<div> '.$fname.' '.lname.'</div>';
      }
}


?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Search</title>
</head>
<body>

<form action="index.php" method="post">
   <input type="text" name="search" placeholder="search">
   <input type="submit" value=">>">
</form>



</body>
</html>
jocana
New php-forum User
New php-forum User
 
Posts: 4
Joined: Tue Oct 09, 2012 9:21 pm

Re: New to php, need help with Code

Postby MeroD » Wed Oct 10, 2012 11:02 pm

$query = mysql_query("SELECT * FROM sign_up");
$count = mysql_num_rows($query);
MeroD
New php-forum User
New php-forum User
 
Posts: 53
Joined: Wed Oct 10, 2012 12:14 am

Re: New to php, need help with Code

Postby jocana » Fri Oct 12, 2012 7:22 am

Wow, I can't believe I didn't catch that, thank you! by the way would you also know why my website elements change when I log on to it? I am completely confused.
jocana
New php-forum User
New php-forum User
 
Posts: 4
Joined: Tue Oct 09, 2012 9:21 pm


Return to PHP coding => General

Who is online

Users browsing this forum: No registered users and 8 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron