-
Posts
7 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by Nismo240
-
-
Im sorry one second, now
mysql_connect($server, $dbuser, $dbpass) or die(mysql_error());mysql_select_db($database) or die(mysql_error());$data = mysql_query("SELECT * FROM `products` WHERE `type` = 'Desktop' AND `make` = 'apple' AND `viewable` = 'y'")or die(mysql_error());$num_rows = mysql_num_rows($data);echo "You have " . $num_rows . " number of rows...";
Seems to be outputting
Which is correct, thats weird it wasnt working a min ago now it is lol.. well i guess now to move on to the if/else statement..You have 0 number of rows... -
Ok i appreciate your post, but the code snipplet in my first post is just that a snipplet i have
error_reporting(E_ALL);
at the top of my page and im not seeing any errors.. also i believe that the
$num_rows = mysql_num_rows($data);
Isnt right because
mysql_connect($server, $dbuser, $dbpass) or die(mysql_error());mysql_select_db($database) or die(mysql_error());$data = mysql_query("SELECT * FROM `products` WHERE `type` = 'Desktop' AND `make` = 'apple' AND `viewable` = 'y'")or die(mysql_error());$num_rows = mysql_num_rows($data);echo "You have " . $num_rows . " number of rows...";
just puts out
If i dont mind asking what else could i give to help you guys out ?You have number of rows... -
When i mean it doesnt work i mean
$num_rows = mysql_num_rows($data);
either isnt grabbing the info or
if ($num_rows == 0) { if ($num_rows = 0) { if (!$num_rows) {
these dont work either. When i say they dont work its not showing
Print "<td align='center' valign='top' width='33%'>[box]Currently Out of This Make.[/box]</td>";
which you would understand if you read my first post.. but either way i dont get any errors codes either..
-
ok hmm i tried this
// Connects to your Databasemysql_connect($server, $dbuser, $dbpass) or die(mysql_error());mysql_select_db($database) or die(mysql_error());$data = mysql_query("SELECT * FROM `products` WHERE `type` = 'Desktop' AND `make` = 'apple' AND `viewable` = 'y'")or die(mysql_error());$x = "0";Print "<table summary='' width='100%' border='0' cellspacing='' cellpadding='10' align='center'>";Print "<tr>";while($info = mysql_fetch_array($data)){ extract($info); if ($x == "0"){ Print "</tr><tr>"; } $x++; if ($x == "3"){ $x = "0"; }// EMPTY ARRAY CHECK$num_rows = mysql_num_rows($data); if ($num_rows = 0) { Print "<td align='center' valign='top' width='33%'>[box]Currently Out of This Make.[/box]</td>"; } else {Print "<td align='center' valign='top' width='33%'>[box]<img class='aligncenter size-thumbnail wp-image-41' title='' src='http://cheaptronics.net/wordpress/wp-content/uploads/". $info['image'] . "' alt='' width='150' height='150' /><strong>". $info['make'] . " " . $info['model'] . " - $". $info['price'] . "</strong><BR>[tooltip text='<b>". $info['make'] . " " . $info['model'] . "</b><BR>". $info['desc'] . "'][More Info][/tooltip][/box]</td>"; } // END}Print "</tr>";Print "</table>";
didnt work also moved the
$num_rows = mysql_num_rows($data);
up under
$data = mysql_query("SELECT * FROM `products` WHERE `type` = 'Desktop' AND `make` = 'apple' AND `viewable` = 'y'")or die(mysql_error());
doesnt work :/
-
Hi i have the following code
// Connects to your Databasemysql_connect($server, $dbuser, $dbpass) or die(mysql_error());mysql_select_db($database) or die(mysql_error());$data = mysql_query("SELECT * FROM `products` WHERE `type` = 'Desktop' AND `make` = 'apple' AND `viewable` = 'y'")or die(mysql_error());$x = "0";Print "<table summary='' width='100%' border='0' cellspacing='' cellpadding='10' align='center'>";Print "<tr>";while($info = mysql_fetch_array($data)){ extract($info); if ($x == "0"){ Print "</tr><tr>"; } $x++; if ($x == "3"){ $x = "0"; } // EMPTY ARRAY CHECK if ($info) {Print "<td align='center' valign='top' width='33%'>[box]<img class='aligncenter size-thumbnail wp-image-41' title='' src='http://blahblah.net/wordpress/wp-content/uploads/". $info['image'] . "' alt='' width='150' height='150' /><strong>". $info['make'] . " " . $info['model'] . " - $". $info['price'] . "</strong><BR>[tooltip text='<b>". $info['make'] . " " . $info['model'] . "</b><BR>". $info['desc'] . "'][More Info][/tooltip][/box]</td>"; } elseif (empty($info)) { Print "<td align='center' valign='top' width='33%'>[box]Currently Out of This Make.[/box]</td>"; }// END}Print "</tr>";Print "</table>";
My code displays 3 items in a row then drops to a new row, etc.. How ever if my array is empty (Like if there are no Apple Desktops available) i would like it to display something like Sorry we are currently out of Apple Desktops right now. yada yada.. How would i go about doing this correctly.. Thanks.
-
I'm trying to make a custom display of 2 of the most recent news/blog post in my WordPress but i'm having issue getting the URL for the featured image i gave to each of my post's.. My code is as follows (note that the printed text isn't formatted yet, just wanted a simple layout for testing purposes)
<?php$args = array( 'numberposts' => '2', 'order' => 'DESC','post_status' => 'publish' );$recent_posts = wp_get_recent_posts( $args );foreach( $recent_posts as $recent ){$feat_image = wp_get_attachment_url( get_post_thumbnail_id($post->ID) );echo 'Post ID: '.$recent["ID"];echo '<BR>';echo 'Post URL: '.get_permalink($recent["ID"]);echo '<BR>';echo 'Post Title: '.$recent["post_title"];echo '<BR>';echo $feat_image; //Will display http://blablah.com/wordpress/blablahblah.jpg etc....echo '<BR>';echo 'Post Content: '.$recent["post_content"];echo '<BR>';echo '<BR>';}?>
It all works except for the featured image :/ Thanks in advance
If i have a empty sql array how do i make it show?
in PHP
Posted
Ok well nvm i figured it out
Works perfect.. if we dont have any Apple Desktops listed then it will show "Sorry we are currently out of stock etc etc.." and if we do have it in stock it will list them 3 per row thank you birbal and justsomeguy for pointing me in the direction of