PHP - Mysql Select Problem W/php

I need to select all fields from two tables and echo that data.
Fields are the same in both tables but has different data.


<?PHP
include "dbconnect.php";

function pretvoriDatum($mysqlDatum)
{
$tmp=explode("-", $mysqlDatum);
$datum=$tmp[2] . "." . $tmp[1] . "." . $tmp[0];
return $datum;
}

$sql="SELECT * FROM novosti A, dogadanja B";
if (!$q=mysql_query($sql))
{
echo "Error" . mysql_query();
die();
}
if (mysql_num_rows($q)==0)
{
echo "No data</div>";
} else {
?>
<?PHP
while ($redak=mysql_fetch_array($q))
{
?>



<?php echo $redak["a.naslov"]; ?>

<?PHP echo $redak["a.slika"]; ?>

<?php echo $redak["b.tekst"]; ?>

<?php echo $redak["a.objavio"]; ?>

<?PHP echo pretvoriDatum($redak["b.datum"])?>


<?PHP
}
}
?>


Please help, I don't know how to do that

I have a MySQL database.  The table name is prodcat - it has 3 fields sku, category and codes.  Some of the categorys have multiple items in it which is seperated by /   for example:  Ceramics/Sale Items or just Ceramics   in the codes it looks like this:  ceramics,saleitems or just ceramics   Basically i want to loop through each sku in the prodcat table and every sku that is in ceramics I want it to echo an image.  And if that sku is in multiple categories it needs to show the image no matter what category you are in.  So if it is a ceramic item that is also on sale I want the image to appear in both those categories   I've tried this multiple ways and can get a partial result but can not get it completely the way I want it.  Basically I can get it to give me the result in one category but it won't give me the result in both categories.   Thanks for the help.

Hi guys I have a two tables in my mysql 

branch:

id       branchname     postcode


then a user table

id    username    password   branch1     branch2


so far I have a select form as below which populates the select form from mysql

    branch 1<select name='branch1'><p />
    
<?php
$branchdropdown=mysql_query("SELECT id ,branchname, postcode FROM branch");

while($row = mysql_fetch_array($branchdropdown))
{
// echo '<option value="' .$row['stationname']. '"></option>'  ;
echo "<option value=\"".$row['id']."\">".$row['branchname']."\n  ";
$postcodeone=$row['postcode'];

}


?>

and then this will be inserted in mysql as below 


 $submit = mysql_query("INSERT INTO users (branch1, branch2) VALUES ($postcodeone, $postcodetwo)");
     echo "This entry has been added to our database";

    </select>

but it only inserts the branch id and not the password, can you please tell me what im doing wrong?

What is this a. b. c. before the fields? I'm not understanding it. I know is about foreign key and reference, but why a. b. c. ??

Code: [Select]
<?php
$user_id='1'; // User table user_id value
$update_sql=mysql_query("SELECT a.username, a.email, b.update_id, b.update, b.time, b.vote_up, b.vote_down FROM users a, updates b, friends c WHERE b.user_id_fk = a.user_id AND c.friend_one = '$user_id' AND b.user_id_fk = c.friend_two ORDER BY b.update_id DESC LIMIT 15");
while($row=mysql_fetch_array($update_sql))
{
$username=$row['username'];
$email=$row['email'];
$update_id=$row['update_id'];
$update=$row['update'];
$time=$row['time'];
$up=$row['vote_up'];
$down=$row['vote_down'];

//Avatar
$lowercase = strtolower($email);
$image = md5($lowercase);
$avatar ='http://www.gravatar.com/avatar.php?gravatar_id='.$image;

//Update HTML tags filter
$htmldata = array ("<", ">");
$htmlreplace = array ("&lt;","&gt;");
$final_update = str_replace($htmldata, $htmlreplace, $update);


// Updates Results Display here

}
?>

I have the following sql which works fine


"SELECT AVG(ratings.score), articles.* FROM ratings, articles where ratings.article_number = articles.article_number group by article_number"


However I want to add to this statement to make sure that it only returns the results where the field avg(ratings.score) is between 3 and 4.  I tried the sql below but it came up with the error "invalid use of group function".


SELECT AVG(ratings.score), articles.* FROM ratings, articles where ratings.article_number = articles.article_number and AVG(ratings.score) < 4 group by article_number


Thanks for any help

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=350716.0

hello with tis button i generate some statistics from mysql


if(isset($_POST['sub1']))

                                {
           
                                    $result = mysql_query("SELECT servitoros1, COUNT(*) from history WHERE serv LIKE '%be%'  group by serv1");
                                   
                                    while($row = mysql_fetch_row($result))
                                                                           {
                                                                               


                                          echo "<tr>";
                                                                                 foreach($row as $cell)
                                                                           
                                                                            echo "<td ALIGN=\"center\">$cell<FONT></td>";   
                                                    
                                                                                    echo "</tr>\n";
                                                                               
                                                                           }
                                   
                                   
                                    mysql_free_result($result);
                 
                            }


               
                      but each record have datetime field!!


so how can i set this display betwean 2 selectable datetimes

e.g.

from 2/2/2011 15:45   to  3/2/2011 23:59

guys, please help

i need balance amount of fees all students has to pay. Following is the DB structure. `feepayid` is primary key for paymentstable and paymentregister & `studentid` is primary in studentstable. I have written a query for this, please evaluate the query.

paymentstable
feepayid classid paydate paymode feeamount remarks feediscount 32 8 2012-03-06 19:32:35 1 500 hgfhf 0 31 8 2012-03-04 19:32:35 1 800 hgfhf 0 30 8 2012-02-06 19:32:35 1 1200 hgfhf 0 29 8 2012-02-06 19:32:35 1 1100 hgfhf 0
paymentregister
feepayid payid totalfee studentid 32 3 1500 2 31 2 3500 2 30 1 4500 4 29 3 5500 4
studentstable
studentid studentname 2 john 4 mathew 5 peter 6 mary
Code: [Select]
SELECT d.`studentid`, SUM(a.`totalfee` - (SELECT SUM(`feeamount`) FROM `paymentstable`  WHERE a.`feepayid` = `feepayid`)) AS balancefee
FROM `studentstable` d
LEFT JOIN `paymentregister` a ON a.`studentid` = d.`studentid`
GROUP BY d.`studentid`;

I'm experimenting out premade codes and trying to make them some how work the way I want to. This is "my" image uploader. For the uploader is suppose to find the image AND the code stored in mysql, but it doesn't seem to find it. any problem?
<?php 
$link = mysql_connect("localhost", "mcd", "whatanicepassword");
mysql_select_db("mcd", $link);


if (!isset($_POST["code"])) 
{
die ("Error: Not all fields complete");
}

$limit_size=5120;
$target = "skin/"; 
$target = $target . basename( $_FILES['uploaded']['name']); 
$ok=1; 
$filelol = $_FILES['uploaded']['name'];
$file_size=$_FILES['uploaded']['size'];
$filecheck = "skin/".$filelol;

//This is our size condition 

 if ($file_size >= $limit_size)
{ 
echo "Your file is too large.<br>"; 
$ok=0; 
} 
 
if (file_exists($filecheck))
{

} else {echo $filelol." does not exist in the database. Please upload at the main site.<br>";
$ok=0;}

// username and password sent from Form
$uploaded=mysql_real_escape_string($_POST['uploaded']); 
$code=mysql_real_escape_string($_POST['code']); 
$checkquery = mysql_query("SELECT * FROM user_list WHERE uploaded = '$uploaded' AND code = '$code'") or die("Error : " . mysql_error());

$num_rows=mysql_num_rows($checkquery);
if ($num_rows < 1 ) { 
          echo 'File not found in MySQL<br><br><br>';
          $ok=0;
}    
else 
{echo 'YES!';}


//This is our limit file type condition 
if (($_FILES["uploaded"]["type"] != "image/png"))
{
echo "You may only upload PNG files.<br>";
$ok=0;
} 

if ($ok==0) 
 { 
 Echo "Sorry your file was not uploaded<br>"; 
 } 
 //If everything is ok we try to upload it 
 else 
 { 
 if(move_uploaded_file($_FILES['uploaded']['tmp_name'], $target)) 
 { 
 echo "The file ".$filelol." has been uploaded"; 
 } 
 else 
 { 
 echo "Sorry, there was a problem uploading your file."; 
 } 
 } 
 ?>

Hey guys I want to create a class containing a SELECT statment in order to make in re-usable though out my entire applicion. Any one no a good way to go about this?

This is the native way i have done it. I want to be able to make this into a class becuase i have more than one database with the same tables.
Code: [Select]
                                $articles = "SELECT * FROM blog_posts INNER JOIN users ON blog_posts.aurthor_id=users.user_id
INNER JOIN post_categories ON blog_posts.category_id=post_categories.id";
$articles_results = mysql_query($articles)or die(mysql_error());;

$var = @$_GET['q'] ;
$trimmed = trim($var);
$table = @$_GET['field'];
$query="SELECT * FROM contacts WHERE @'table' contains @'trimmed' order by id";
$result=mysql_query($query);
$num=mysql_numrows($result);


Why wont this work?

Zacron

i want to make a monthly report
  the user selects month from drop down and i must get the specified dates of that month from the DB
  I am using ajax to get the dates

Hi Guys

I don't know if this is possible but can someone point me in the right direction. I have a php function which takes two inputs and returns an output. for simplicity's sake let's say it's an addition function. What I want to do is use a mysql select statement to show all the rows from a database where field1 and field2 equal '3'. Here's the sort of thing I mean.

function addNumbers($one,$two) {
return $one + $two;
}

mysql_query("SELECT * FROM table WHERE 'addNumbers(field1,field2)' = '3'");

What I actually want to do is a lot more complex than this but I am trying to understand how to make the syntax work in simple terms first.

Can anybody help?

Many Thanks
Dan

How can i select the last 3 rows in a table and order it by ASC. When i use DESC it displays the results in the wrong order.

$query24 = mysql_query("SELECT * FROM notifications WHERE to_id='$session' AND state='1' ORDER BY id DESC LIMIT 3 ");

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=348309.0