PHP - Colums And Rows

Hello I have a custom php cart working great, with product pages and shopping cart and checkout using points rather than money. My problem is that I cannot get the actual product pages to display in colums (I want 5 items per colum and 8 rows per page). Instead the whole thing is displayed as a row.

Here is the page that the products are shown on: http://www.theskinnyminnie.com/user/rent/ (I have removed the need to be signed on)

Here is the code I am using:

Code: [Select]
<?php 
// Run a select query to get myproducts

$dynamic List ="";
$sql = mysql_query("SELECT * FROM Products ORDERY BY date_added DESC");
$productCount = mysql_num_rows($sql)){
if(productCount > 0){
while($row = mysql_fetch_array($sql)){
        $id = $row["product_id"];
$product_name = $row["product_name"];
$price = $row["credits"];
$date_added = strftime("%b %d, %Y", strtotime($row["date_added"]));
$dynamicList .= '<tr>
<td><a href="product.php?id=' . $id . '"><img src="inventory_images/' . $id . '.jpg" alt="' . $product_name . '" width="77" height="102" border="1" /></a></td></tr>
<tr>
<td><a href="product.php?id=' . $id . '">' . $product_name . '</a></td>
 </tr>
 <tr>
<td>' . $price . 'pts</td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>';
}
} else {
$dynamicList = "We have no products listed in our store yet";
}
mysql_close();
?>
and then i echo dynamicList

I hope this entry finds everyone safe and healthy.

I am trying to extract table data and schema info from a database WITHOUT knowing the field names.

Essentially, I want to connect to the database and have the information for each table deposited into an HTML format (just like I'd see if I accessed the db directly).

I've found several methods online, but all use DEPRICATED coding that will no longer function.

Any code or links to assist in resolution would be appreciated. 

Stay safe, and thank you.

I am pulling some info from a mysql table, checking some logic, and displaying in on a page. The way this is written now it shows all of the items in a one column table, I simply want to break it up into multiple columns (ideally by specifying say 20 items per column). I know I need a counter and a loop but I'm just not sure how it all fits in with my existing program. Any help would be greatly appreciated.

Here is my code
Code: [Select]
$result2 = mysql_query("SELECT * FROM propertyids ORDER BY propertyname ASC");
while($row2 = mysql_fetch_array($result2)){
${'resp'.$row2['id']} = curl_multi_getcontent(${'ch'.$row2['id']});
${'status'.$row2['id']} = strpos(${'resp'.$row2['id']},$httpvar);
if(${'status'.$row2['id']} === false) {
echo "<tr><td>";
echo "<img src='images/down.png'> <a href='" . $row2['primaryurl'] . "' target='_blank'>" . $row2['propertyname'] . "</a>";
echo "</td></tr>";
}
else {
echo "<tr><td>";
echo "<img src='images/up.png'> <a href='" . $row2['primaryurl'] . "' target='_blank'>" . $row2['propertyname'] . "</a>";
echo "</td></tr>";
}
}
echo "</td></table>";

I am using the following code to generate a dynamic drop down menu from a column in table1(name) - and then inserting the selected option into table2.
What I am trying to do is, select data from 2 columns from table1(name,age) and then store and insert both of those values into table2

I am hoping someone can help me out or at least point me in the rigth direction. ..I would like to insert into table 2 the age that matches the person selected by the drop down menu from table1.

For example - if from the drop down menu I choose John - when the form is sumbitted i want to insert into table2 John's name and age (based on what is stored in table1, in this case John,22)

...Any ideas???

table1
id|name|age|score
01-john-22-1547
02-jane-22-1245

table2
id|county|name|age


the dynamic drop down is generated from table1 (name) with following code

Code: [Select]
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">

<table width="100%" border="0" cellpadding="5" cellspacing="0">

 

<?php

require_once('sql.php');

$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);



$query="SELECT name FROM table1  ORDER BY name ASC";

$result = mysqli_query ($dbc,$query) or die(mysqli_error());



$dropdown = "<select name='name'>";

while($row = mysqli_fetch_array($result)) {

$dropdown .= "\r\n<option value='{$row['name']}'>{$row['name']}</option>";

}

$dropdown .= "\r\n</select>";

echo $dropdown;

?>



      <tr>

          <td height="50" align="right">

                <label for="scheduled_time">Country</label><br/>

</td>

          <td align="left">

<input type="text" id="country" name="country" class="input" maxlength="30"" />

                </td>

      </table>

      <p></p>

    <input type="submit" value="Add Info" name="submit" />

</form>

I am inserting into table2 with the following code

Code: [Select]
<?php
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);

if (isset($_POST['submit'])) {

$county = mysqli_real_escape_string($dbc, trim($_POST['country']));

$name = mysqli_real_escape_string($dbc, trim($_POST['name']));

$query = "INSERT INTO table2 (country, name) VALUES ('$country', '$name'')";
$result = mysqli_query($dbc, $query);

if (!$result) {

printf("query error : <br/> %s\n", mysqli_error($dbc));

}



if ($result) {

echo 'Success';

}



      // close dbc

      mysqli_close($dbc);

      exit();

      }

?>

what Im basically trying to do is just like a phpmyadmin function... you select rows you want to update with a checkbox and then it takes you to a page where the rows that are clicked are shown in forms so that you can view and edit info in them... and then have 1 submit button to update them all at once.

I have 2 queries that I want to join together to make one row  

hirealimo.com.au/code1.php

this works as i want it:
Quote

SELECT * FROM price INNER JOIN vehicle USING (vehicleID) WHERE vehicle.passengers >= 1 AND price.townID = 1 AND price.eventID = 1



but apparelty selecting * is not a good thing????

but if I do this:
Quote

SELECT priceID, price FROM price INNER JOIN vehicle....etc


it works but i lose the info from the vehicle table.

but how do i make this work:
Quote

SELECT priceID, price, type, description, passengers FROM price INNER JOIN vehicle....etc


so that i am specifiying which colums from which tables to query??

thanks

$sql = "SELECT * from updates ORDER BY id DESC LIMIT 3";
$stmt = $link->prepare($sql);
$stmt->execute();
$result = $stmt->get_result(); 

if ($result->num_rows = '0') {

	echo "There haven't been any updates yet.";
  
} else {

	echo "There are news posts";
}

Gives me the error "Cannot write property in /home/evoarena/public_html/Dev/news.php:14 ", line 14 is the if statement. How can I fix it?
"

Im working on a site and particularly the photo gallery section. I want to display 9 images on 3 rows (3 per row).

And im stuck. Te only way i can get the images to show up not one on top of the other is by using a table. but how can i tell the table to only put 3 <td>'s then to <br>

Heres my code so far...
<?php
$sql_images = mysql_query("SELECT * FROM photos ORDER BY upload_date DESC LIMIT 9");

while($row = mysql_fetch_array($sql_images)){

$photo_id = $row["id"];
$location = $row["location"];

$display_pics .= '
<td width="125px">
<a href="image.php?id='. $album_id .'" class="black"><img src="images/uploads/thumbs/' . $location . '" /></a> 
</td>';
}
?>

Then to display it ...
Code: [Select]
    <table width="top" cellpadding="10" cellspacing="20">
        <tr>
            <?php echo $display_pics; ?>
            </tr>
        </table>

My goal is to do it as simple as possible!

Can anyone help?

If you don't think tables are the way to go im open to any suggestions.

I've thought about <divs> but then the images show up one on top of the other and not beside each other.

By the way all the images are a max of 100px heigh and 100px wide

Thanks for any help or suggestions!

"                                                                                        SELECT  event.*,
epr1.participantId AS team_1,
epr1.participantRoleId AS team_1_role,
epr2.participantId AS team_2,
epr2.participantRoleId AS team_2_role
  FROM  bb_EventParticipantRelation epr1,
   bb_EventParticipantRelation epr2,
bb_Event event
  WHERE 
   event.parentId='".$leage_type."' AND 
epr1.id != epr2.id AND
   epr1.parentParticipantId = '0' AND
epr2.parentParticipantId = '0' AND
epr1.eventId=event.id AND
epr2.eventId=event.id

ORDER BY epr1.participantRoleId ASC, event.startTime, team_1, team_2 ASC

"


This sql gets 2 rows and combines them as one, it does work but the issue is it seems to be taking too long in loading the page also I just need some advice on a better version


Thank you

Hi ive got this code which echos out all the rows from an SQL table.

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['subject1'] . "</td>";
  echo "<td>" . $row['subject2'] . "</td>";
  echo "<td>" . $row['subject3'] . "</td>";
  echo "<td>" . $row['subject4'] . "</td>";
  echo "<td>" . $row['email'] . "</td>";
  echo "</tr>";
  }
echo "</table>";


All i want to do is add all the 4 subject together and echo it out. simple but not sure how to do it. any ideas please?

Thanks Matt

Hello

I have a table that inserts a new row with data when a member views a page.

I wish to count all the rows for each member, and then be able to show what the cuurent members "position" is eg. what members has the highest row count.

Example. counting the rows for member_A returns 1000 rows, the number of rows for member_B returns 1500 rows.

How can I display for member_A that he is in "second" place?

How can I get the next four and previous four rows?

Here is what I have and it isn't working at at all.
$q1 = Mysql::query("SELECT id, file, dir FROM photos WHERE id > $id AND album = '$al' ORDER BY id ASC LIMIT 4");
$q2 = Mysql::query("SELECT id, file, dir FROM photos WHERE id < $id AND album = '$al' ORDER BY id DESC LIMIT 4");

Hi ,im face little problem in duplicating rows.

it's not easy task wht i need:

i got this rows right now

id----------position-------------A_Q_ID
1---------------1--------------------5-----
2---------------2--------------------5-----
3---------------3--------------------5-----
4---------------1--------------------6-----
5---------------2--------------------6-----
6---------------3--------------------6-----

what i need is to duplicat all the rows and have them inserted after the rows i allready have  like that:

id------------position-------------A_Q_ID
7-----------------1--------------------7-----
8-----------------2--------------------7-----
9-----------------3--------------------7-----
10---------------1--------------------8-----
11---------------2--------------------8-----
12---------------3--------------------8-----

i tryed few ways without success .
any idea how to do that please? i cannot get the logic on doing it

thanks

Hi everyone!
I've been looking for a solution, but i just can't find it anywhere...

Ok, so the problem is:
i have a database which looks something like this:

user_id product_id score
14 . 235 . 79
23 . 235 . 32
53 . 665 . 21
14 . 235 . 90
5 . 675 . 45


This is step-by-step of what i need to do:

1. Select user - user_id =343

2. For user_id =343 select all products that he gave score to:
product_id = 43 - score = 99
product_id = 12 - score = 56
product_id = 68 - score = 32
product_id = 124 - score = 67

3. Find all users that voted for the same products e.g.:
for product_id = 43:
user_id = 125 voted 93 points,
user_id = 23 voted 56 points.


4. Calculate the difference between the score of user, so:
for product_id = 43:
user_id = 125 voted 93 points (99 - 93 =6 points of diff.)
user_id = 23 voted 56 points (99 - 56 =43 points of diff.)
return the results....


That's basically what i need to do. I still don't know the number of the users, or product, but it doesn't really matter - i just need to make it work.
Ok, hope someone can help!