PHP - Php And Mysql No Results Message

Hello,

This is query in MySQL

Quote

mysql> LOAD DATA LOCAL INFILE '/var/www/html/numbers.csv' INTO TABLE details FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (number);
Query OK, 0 rows affected (0.00 sec)
Records: 2200 Deleted: 0 Skipped: 1200 Warnings: 0

Now, I am trying to run the same query in PHP and display the same results.... (i.e. Records, Deleted, Skipped)
Quote

<?php
$db=mysql_connect("localhost", "user", "1234") or die(mysql_error());
$dname="database";
mysql_select_db($dname)or die(mysql_error());
$sqlstatement="LOAD DATA LOCAL INFILE '/var/www/html/numbers.csv' INTO TABLE details FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (number)" ;
mysql_query($sqlstatement) or die(mysql_error());;
echo "it is done!";
?>


Tried mysql_fetch_array, row but could not get it to work... please help guys

I have a problem displaying the results of a table,

It shows them in one long list and I'd like them to show as 2 or 3.

I had a look around and the most favoured way to this I found was to split the results either by odd/even or using percentages but Im having trouble implementing it into my script.

How would I go about adding the odd/even way to this:

<?php
$query = mysql_query('SELECT * FROM users ORDER BY Username');
while ($row = mysql_fetch_array($query)) {
if ($row['UserID']) 
       ?>
<b>Username:</b> <span class=class1><a href="aeditprofile.php?username=<? echo $row['Username'] ?>"><? echo $row['Username'] ?></a></span><br>
<b>Group:</b> <? echo $row['Level'] ?></color><br /><hr>
<?php
}
?>


Essentially I'm after getting something like this:

Name                           Name                          Name
Group                          Group                         Group

and so on down the page....

What's the best way to format results from a MySQL table?  I've found very vague examples of PHP code utilizing html tables.  Below is my current PHP.  Thanks!

<?php
$con = mysql_connect("localhost","xxxxx","xxxxx") or die('Could not connect: ' . mysql_error());
mysql_select_db("addresses", $con);

$result = mysql_query("SELECT * FROM addresses");

while($row = mysql_fetch_array($result))
  {
  echo $row['first_name'] . " " . $row['last_name'] . " " . $row['extra_info'] . " " . $row['address'] . " " . $row['city'] . " " . $row['state'] . " " . $row['zip'];
  echo "<br />";
  }

mysql_close($con);
?>

Hey everyone.

So I am coding a badge system for my website usersystem. I am trying to think how I'll handle issues before actually starting to code it and one issue I just can't seem to figure out how to handle..

How would I limit the amount of MySQL results to show per line.
Eg. A user has 6 badges but I'd only like to show 2 per line. So in total it'd show 3 lines with 2 badges per line. If that makes any sense?

Is there any way possible to actually do this?

How can I limit the amount of time my while loop to only show the first 4 rows of my SQL table?   I am using this code to loop my whole table:  

while($row = $results->fetch(PDO::FETCH_ASSOC))
                        {
                        echo '
                        <li>Mileage: '.number_format($row["Mileage"]).'</li>
                        <li>Engine size: '.$row["EngineSize"].'cc</li>
                        ';} ?>

I only want to loop through the first 4 rows of my SQL table, I then want to duplicate the same code but start at the 5th row until the 8th row of the table, how can I do this?   Thanks, Nick

I'm working on a website that uses a database to display the employees from different states. Below is the code I'm using and everything works great, but I can't figure out why all the results are getting posted twice. I'm trying to isolate just one state so we can have a different contact page for each state. Thanks for any help! Please let me know if you need more information. (I'm attaching a screenshot of what's happening as well.)


Code: [Select]
<?
include "public/public_common.php";
//Open Database Connection
$db = open_db_connection();
$sql = "SELECT DISTINCT state_full = 'california' from users where active = 'Y' and show_on_contactus = 'Y'";
$results = mysql_query($sql, $db);
if(!mysql_num_rows($results) == FALSE)
{
        while($row = mysql_fetch_array($results, MYSQL_BOTH))
        {
           echo "<ul id=\"directors\">\n";
           $state_sql = "SELECT * from users where active = 'Y' and show_on_contactus = 'Y' and state_full = 'california' order by last_name";
   $state_results = mysql_query($state_sql, $db);
           if(!mysql_num_rows($results) == FALSE)
           {
              while($state_row = mysql_fetch_array($state_results, MYSQL_BOTH))
              {
                 echo "<li>\n";
                 echo "   <div class=\"fl dirimg\">\n";
                 if($state_row[photo] == "")
                 {
                    echo "<img border=\"0\" width=\"61\" height=\"85\" src=\"images/exe_placeholder.jpg\" alt=\"$state_row[first_name] $state_row[last_name]\" />\n";
                 }
                 else
                 {
                    echo "<img border=\"0\" width=\"61\" height=\"85\" src=\"n2team/pictures/$state_row[photo]\" alt=\"$state_row[firstname] $state_row[last_name]\" />\n";
                 }
                 echo "   </div>\n";
                 echo "   <span class=\"fr\">$state_row[first_name] $state_row[last_name]<br />\n";
                 echo "       $state_row[title]<br />\n";
                 echo "       $state_row[city], $state_row[state]<br />\n";
                 //echo "       <a href=\"mailto:$state_row[email]\">$state_row[email]</a></span></li>\n";
              }
           }
           echo "</ul>\n";
        }
}
?>

I am trying to display certain MySQL data based off of what link is clicked. For example.. I want to display all the entries from 2009 when a link for 2009 is clicked; maybe like..
<a href="http://website.com/page?yr=09">2009</a>
But I am having trouble doing so.. any help would be great!

P.S. The years are in my database with only the last two numbers.. 10, 09, 08, etc.

    $result = mysql_query("select setlist_id, month, day, year, name, venue, location, label1, set1, set2, set3, encore, notes, photos, recording, poster
        from $database_table order by setlist_id DESC, year, month, day",$db) 
        or die_now("Could not select setlists");

    while($row = mysql_fetch_array($result)) {
     $the_id = $row["setlist_id"];
        $the_month = $row["month"];
        $the_day = $row["day"];
        $the_year = $row["year"];
$the_name = $row["name"];
$the_venue = $row["venue"];
        $the_location = $row["location"];
        $the_label1 = $row["label1"];
$the_set1 = $row["set1"];
$the_set2 = $row["set2"];
$the_set3 = $row["set3"];
$the_encore = $row["encore"];
$the_notes = $row["notes"];
$the_photos = $row["photos"];
$the_recording = $row["recording"];
$the_poster = $row["poster"];

                echo("<div class='date' id='date' tabindex='0'>" . "$the_month" . "." . "$the_day" . "." . "$the_year" . " - ");
echo ($the_name != '') ? "" . "$the_name" . " - " : '';
echo("" . "$the_venue" . " - " . "$the_location" . "</div>");
                echo("<div class='set'>" . "$the_label1" . ":<br /></div><div class='list'>" . "$the_set1" . "<br /></div>");
                echo ($the_set2 != '') ? "<div class='set'>Set Two:<br /></div><div class='list'>" . "$the_set2" . "<br /></div>" : '';
echo ($the_set3 != '') ? "<div class='set'>Set Three:<br /></div><div class='list'>" . "$the_set3" . "<br /></div>" : '';
echo ($the_encore != '') ? "<div class='set'>Enco <br /></div><div class='list'>" . "$the_encore" . "<br /></sdiv>" : '';
                echo("<div class='line'></div>");
                echo nl2br("<div class='notes'>" . "$the_notes" . "</div>");
}

When I replace the $result line with...
    $result = mysql_query("SELECT * FROM `$database_table` WHERE `year` = '09' order by setlist_id DESC, year, month, day",$db) 
        or die_now("Could not select shows");... I get all the results from just 2009, which is what I want, but I want the results to depend on what link has been clicked. I hope I am making sense.

Hi

I have got results being displayed after clicking the search button in a form on my home page but it brings up all the results which is ok but how do I get onlt the results a user searches for for example a location or property type etc as its for a property website

The coding is below for the results page

Also sorry how do I add a background image to the php page, I tried using css but wouldn't work

Code: [Select]
<style type="text/css">
body {background-image:url('images/greybgone.png');}
</style>

<?php
 
mysql_connect ("2up2downhomes.com.mysql", "2up2downhomes_c","mD8GsJKQ")  or die (mysql_error());
mysql_select_db ("2up2downhomes_c");

echo $_POST['term'];

$sql = mysql_query("select * from properties where typeProperty like '%$term%' or location like '%$term%'");

while ($row = mysql_fetch_array($sql)){
    echo 'Type of Property: '.$row['typeProperty'];
    echo '<br/> Number of Bedrooms: '.$row['bedrooms'];
    echo '<br/> Number of Bathrooms: '.$row['bathrooms'];
echo '<br/> Garden: '.$row['garden'];
echo '<br/> Description: '.$row['description'];
echo '<br/> Price: '.$row['price'];
echo '<br/> Location: '.$row['location'];
echo '<br/> Image: '.$row['image'];
    echo '<br/><br/>';
    }
 
?>

Hi all,

In order to teach myself php I am developing a simple cms system to display my graphic design work. Basically I am working on developing a simple portfolio website powered by a custom made CMS.

So far, I can create new posts which are being stored in a MySQL db.

My index page runs a sql query to get the latest posts and sorts them by category.

Currently the results look like this:

Quote

Title1
Category A
Text

Title2
Category A
Text

Title3
Category B
Text

Title4
Category B
Text


The code to generate this looks like this:

$content = mysql_query("SELECT * FROM posts ORDER BY category, date DESC");

while($row = mysql_fetch_array($content))
  {
  echo '<h2 class="post_title">'.$row['title'].'</a></h2>';
  echo '<p class="cat">category: '.$row['category'].'</p>';
  echo '<p class="post_body">'.$row['body'].'</p>';
  echo '<p class="image">image: '.$row['image'].'</p>';
  echo '<p class="lowerlefttext_metainfo">by <span class="lowerlefttext_author">'.$row['author'].'</span> on '.$row['date'].'</p>';
  }

What I would like however is this:

Category A

Title 1
Text

Title 2
Text

Category B

Title 3
Text

Title4
Text

I am not sure how to do this elegantly without having to code an sql query per category, which I don't think is efficient?

Thank you!

I'm needing some direction in how to start this...  I have a page with the 50 U.S. states listed.  I have a column in my mysql database that holds each state's name called:  source

There's a few thousands rows in my database, so the state names vary in the record count. 

How can I query the database and have a little count by each one of my 50 states that shows how many results exist in the db for that state?  I know how to query for total rows and show that number... but confused on how I would do it for individual line items.

Thanks for any suggestions. 

Here is my HTML code:

Code: [Select]

<html>
<head>
<title>Simple Search Form</title>
</head>
<body>
   <form name="searchform" method="get" action="/search.php">

        Select Gender:
        <select name="gender">
                <option value="Male">Male</option>
                <option value="Female">Female</option>
        </select>

        Select City:
        <select name="gender">
                <option value="all">All Cities</option>
                <option value="newyork">New York</option>
                <option value="toronto">Toronto</option>
                <option value="london">London</option>
                <option value="paris">Paris</option>
        </select>

   <form>
</body>
</html>


Here is my PHP code:


<?php
 
// get the data from the search form 

# get the gender (male or female)
$gender = $_GET['gender']; 

# get the city
$city = $_GET['city'];

// connect to mysql and select db
mysql_connect('localhost', 'root', 'pass') or die(mysql_error());
mysql_select_db($test_db);

// send query
$query = mysql_query("SELECT * FROM `visitors_location` WHERE gender='$gender' AND city='$city'");
$count = mysql_num_rows($query);

// display data
while ( $show = mysql_fetch_assoc($query) ) {
 
          echo $gender . " " . $city;

}

?>


My script basically shows # of males or females in a specific city. How can I show all males in all cities? In other words, let's say I want to show # of Females from all those 4 cities combined. I don't know how to do that. Can someone please help me?

Been using a function I found here a while back for listing categories and sub categories and it works perfect.
Code: [Select]
function listSubcats ($parent, $level=0){
global $abc;
$sql = "SELECT id, title FROM Cat WHERE parent = $parent";
$res = mysqli_query($abc, $sql);
while (list($id, $title) = $res->fetch_row()) {
$indent = str_repeat('-', $level);
echo "<OPTION value='$id'>$indent $title</OPTION>\n";
listSubcats ($id, $level+1);                       
// list its subcats
}
}
But this is the first time I need change the way the results are displayed.
And that leads me to realizing I am a bit confused on how list really works.

The mysql table has the typical ID, CatName, parent

I need to have each Cat with all subcats related to it listed in its own div.
But whatever I try I cannot get the placements of the opening and closing divs in the right spots.

So can anyone tell if its even possible to do it with this function.

I did work it out using multiple queries but then read on alot of forums that queries inside while statements is not good.

Just looking for he best (Correct) way of geting the results laid out properly.
 like this
Code: [Select]

<div class="one-third column">
 Cat1
</div>
<div class="one-third column">
 Cat 2
</div>
<div class="one-third column">
 Cat 3
 - Subcat 1
 - Subcat 2
 -- Sub Subcat 1
</div>
<div class="one-third column">
Cat 4
</div>

Hope that makes sense... Thanks for any guidance.

I've got a page that displays all my blog entries on a single page. When you click on a specific entry, it pulls the post ID and loads the page specifically. From there, I wanted to have the option to click either onto the next or previous post by finding the next or previous ID in the database.. however, I know that sometimes posts are deleted, etc. so the ID's won't exactly be in order.

What direction should I take with this?

Hi guys,  Having problems sorting mysql results. I can easily order/sort table columns but would like to order the results by a variable.(Distance in Miles).
Havent much experience in PHP and really struggling with this. Basically a query echoing out car make and models and how far they are located from a postcode. Can get it to work no porblem, but not to order/sort by least distance.

Heres what i'm working with:
Code: [Select]
$res=mysql_query("SELECT * FROM cars");
while ($row = mysql_fetch_assoc($res)){

echo $row['Make'];
echo $row['Model'];

//variable will be determimed by user input form
$postcode="W12 3SR";

$start=$postcode;
$ends = array();

//finds value from database field
{
$ends[]=$row['Location'];
}

// Postcode entered by user via input form
$result=mysql_query("SELECT * FROM postcodes WHERE Pcode='$start'");
while($row=mysql_fetch_array($result)){
$gridn[0]=$row['Grid_N'];
$gride[0]=$row['Grid_E'];
}

foreach($ends as $fin){
// Postcodes within mysql table
$result=mysql_query("SELECT * FROM postcodes WHERE Pcode='$fin'");
while($row=mysql_fetch_array($result)){
$gridn[1]=$row['Grid_N'];
$gride[1]=$row['Grid_E'];
}

// TAKE GRID REFS FROM EACH OTHER TO WORK OUT DISTANCE.
$distance_n=$gridn[0]-$gridn[1];
$distance_e=$gride[0]-$gride[1];

// CALCULATE THE DISTANCE BETWEEN THE TWO POSTCODES AND DIVIDE BY 1.6 TO CONVERT KM TO MILES
$hypot=sqrt(($distance_n*$distance_n)+($distance_e*$distance_e))/1.609;

//VARIABLE FOR DISTANCE AND ROUNDED OF TO NEAREST WHOLE NUMBER.
$distance=''.round($hypot/1000,0).'';


  echo " $distance miles";
  echo "<br>";
}
}
?>
I wish i could just do something like this but isnt possible, is it ?
Code: [Select]
"Select * FROM cars ORDER BY $distance";
Thanks!

Hi guys, i'm trying to search from a form and use php to display the results of the FullText Search from a MySQL database, but I don't get any results from the query. This is the query:   $query="SELECT * FROM tutorials WHERE MATCH(title, tags) AGAINST ('$searchform')";  I think the query is right but it doesn't give me any results.... Does anyone know what could be wrong? I think it might be something wrong with my table (database).

my table should have 5 columns: id, title, category, content, tags

The form should search throught the title and tags columns to see if it finds anything matching the $searchform , but I don't think it is doing it.

Can anyone help please?