Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted December 11, 20213 yr I had a script that went into my IPB Pages Database and brought back a list of records that met the query. I forget what version of IPB I upgraded to in the past that broke it. Anyone see what is wrong? Willing to pay to resolve. $con=mysqli_connect("localhost","database","password","username"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $result = mysqli_query($con,"SELECT `field_21`, `field_24`, `field_25` FROM `ibf_ccs_custom_database_5` WHERE `field_77`='s' AND `field_129`='' AND `record_approved`='1' ORDER BY `ibf_ccs_custom_database_5`.`field_21` ASC"); while($row = mysqli_fetch_array($result)) { echo $row['field_21'] . " " . $row['field_24']. " " . $row['field_25']; echo "<br>"; } mysqli_close($con); Results in...
December 11, 20213 yr Lots is wrong. Instead of trying to fix the script, why not state what the intention of the script is? Then someone might be able to help out with a better way of doing whatever it is. Edited December 11, 20213 yr by Nathan Explosion
December 11, 20213 yr Author On 12/11/2021 at 6:09 PM, Nathan Explosion said: Lots is wrong. Instead of trying to fix the script (which dates from the IPB 3.x days), why not state what the intention of the script is? Then someone might be able to help out. I have a magazine database, it contains many fields. Name, Month, Year, Status, etc I want my members to be able to go to specific pages and pull back predefined queries. Any example would be something like "Magazines from the USA that are missing cover scans" or "Magazines that are currently missing" At the present, if a user wants to find this information, they have to go page by page and record by record, I just want to have some predefined SQL queries, that users can go to that IPB page, and get back a list of records. [image] - Name - Month - Year - Country - Status - Hyperlink to Record [image] - Name - Month - Year - Country - Status - Hyperlink to Record [image] - Name - Month - Year - Country - Status - Hyperlink to Record [image] - Name - Month - Year - Country - Status - Hyperlink to Record Edited December 11, 20213 yr by Phillyman