PBD817

Got it. Thanks...

Hi Everyone, Can anyone help with a line of code to set the 'Image ID' field in the Products table to 0 (zero)? Thanks

Thanks, I will check that out. I have seen several suggested solutions and lack the skill to implement them. Unless I gain more skill, it is a waste of time for people to try to help solve this. It is strictly a lack of experience and skill on my part. I can already tell that most intermediate PHP developers could throw this together in less than five minutes. I hope that a freelance does not try to price-gouge....

F1Fan, I can post the code or even the php pages. The error messages are displaying on the uploaded page and are obviously just syntax errors on my part. Seriously, I just need to hire someone to do this. I am neglecting my job trying to figure very basic issues. I dont want to turn into a code-baby trying to get others to do this work for me. I just simply do not have the time to sit and learn this trial by error.

Ok, I am getting close to a record on how long I can do code incorrectly. The database connection is in one file and the data is displaying in another page. I have tried each of the examples posted and am successfully getting a bunch of errors. Would it be better to upload the to pages and see what needs to be fixed?

Thanks again for your help. I am trying to understand the code and where it would be inserted into a php page (index.php or include.php) as well as the query command. I am out of my league.

I think I found the solution.... How much would I have to pay someone to do this type of ad hoc coding on the fly?

Thanks for your understanding F1Fan. You are right about being new. I had a website passed on to me and no php experience.

Oh, One other issue, now trying to count the unique countries in the Buyers table.

Thanks again for the other websites to use. As simple as this one is, I am struggling with syntax. Here is what I have so far: In the include.php file: $buyerct = query_mysql("SELECT count(*) FROM buyers");$buyerct = mysql_fetch_row( $buyerct ); $buyersCount = $buyerct[0]; $countryct = query_mysql("SELECT count(`Country`) FROM buyers");$countryct = mysql_fetch_row($countryct); $countryCount = $countryct[0]; $supplierct = query_mysql("SELECT count(*) FROM Suppliers");$supplierct = mysql_fetch_row($supplierct); $supplierCount = $supplierct[0]; $productct = query_mysql("SELECT count(*) FROM Products");$productct = mysql_fetch_row($productct); $productCount = $productct[0]; In the index.php there is this code: <table width="634" border="0"> <tr> <td width="75"># Buyers</td> <td width="100"><?php echo $buyersCount; ?></td> <td width="75"># Countries</td> <td width="100"><?php echo $countryCount; ?></td> <td width="75"># Suppliers</td> <td width="100"><?php echo $suppliersCount; ?></td> <td width="75"># Products</td> <td width="100"><?php echo $productsCount; ?></td> </tr> </table> I should change my user ID on these posts to Bad@php

Thanks for the responses. I do not want to be a burden in my code learning. Maybe someone can recommend a site for beginners to get help with code? The issue I am running into is that there is an include.php file that has the database connection so it is not necessary to put that in the index.php page. However, I am not getting the data to show.

Thanks for the help. I copied the code in and uploaded it. But it did not work. What am I missing. Is the table reference $buyersCount correct? The table name is Buyers. Sorry for my inexperience.

Yes, very new to php. I inherited a website and am trying to learn the code.

Ok, this is what I am trying to make it look like. Where do I insert the php code to show the counts? (I want to put them in the table next to the associated category. <table width="500" border="0"> <tr> <td width="62"># Buyers</td> <td width="110"> </td> <td width="93"># Suppliers</td> <td width="55"> </td> <td width="111"># Products</td> <td width="43"> </td> </tr> </table>

Hello again everyone, How do I show a count of information from three tables on my main web page? There are three data tables (buyers, suppliers, products.) I want to show the number of each on the page similar to this: # buyers = 13,000 # suppliers = 250 # products = 5,000 The point is to have these numbers go up as the quantity increases. Thanks in advance.