1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
$sql="SELECT item1 FROM user_uploads WHERE item1 LIKE '%$my_data%' UNION SELECT item2 FROM user_uploads WHERE item2 LIKE '%$my_data%'"; //they are all item1 now $result = mysqli_query($mysqli,$sql) or die(mysqli_error()); if($result) { while($row=mysqli_fetch_array($result)) { echo $row['item1']."\n"; // echo $row['item2']."\n"; } } |
Latest Snippets
- Firefox 133 Toolbars – Tabs on Bottom – Update Nov 24 29th November 2024
- Exclude category from blog while adding them to sitemap.xml 16th January 2024
- What Router can I use with Onestream Broadband? 28th June 2023
- Disable buying – Woocommerce 25th April 2023
- Windows Desktop Wallpaper Background for OCD users with shelves 13th April 2023
- Featured Image Admin Thumb – Working Plugin (WordPress 6.2) 6th April 2023
- Create a gallery in a Posts page 3rd March 2023
- Clickable elements too close together – Solved 21st February 2023
- Best ChatGPT Prompts 24th January 2023
- Make Elementor Accordion Closed by Default 13th January 2023
LINKS