SQL> SELECT I_NAME, substr(I_NAME,1,instr(I_NAME,'O')) "First part",
substr(I_NAME, INSTR(I_NAME,'O')+1) "Second part"
FROM Enrollment
WHERE I_NAME like '%O%';
2 3 4
I_NAME First part Second part
--------------------
LIOU LIO U
I am just not sure why it’s only pulling one name from the table.
Values disappear from my array :( HELP!
hey all, I have a lil mysql/php/apache script that queries a databaseand pulls put 5 integers.These 5 integers are then displayed in an HTML tableCode: [Select]<?php$i=0;global $Val_Store;while
Undefined Variable: PHP_SELF, pls help
Hi,Im a newbie on PHP / MySQL programming and Im running a script to search one field on my DB table. The results will show after I key in my search word but there's an error below that says:
Help with looping
I have a comma separated list of colors taken from a database ($ICo) and a directory of images named "color". The images are named the "color.jpg"I am attempting to loop through
Encrypt php code?
Is it possible to encrypt php code in files,so that it displays a load of unreadable characters rather than readable code that could be leeched.Thank you
Oracle Connectivity
Hi Every One,
mr8m - reverse document
Friends,
Reditecting pages based on logic
Newbie here, apologies in advance!I am trying to use the header function to forward one of any number of locations (taken from a db) based on the value of a response param:Quote<?php include
Looping Problem
I've got a client that has a database with about 200 events at any given time. I'm trying to loop through the dates based on a form and show the title of the event if the start date of the form
Amatuer requiring assistance
Beginner and amateur in need of assistanceMy Site - (Spare Parts for Domestic Appliances)I've gone as far as I can go on my own and need guidanceWhat I require is custom searches - I need to return
Problem with PHP code- simple contact form
I'm relativily new to PHP; I know HTML and CSS stuff but I have a problem- I have a contact form with PHP code in it- grabbed it from the sitemaster website. Unfortunately my form isn't sending any
